Questions tagged [quoted-identifier]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
64 views

UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER' in Agent job

In brief, I added a computed column to a table and then Agent jobs began failing and reporting the error: UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'...
0
votes
0answers
16 views

Why can't I access some tables in postgresql [duplicate]

I am running into some strange problem in PostgreSQL $ sudo -u postgres psql Blogging psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1)) Type "help" for help. Blogging=# \dt List of ...
0
votes
1answer
21 views

Correct table quoting

I want to generically use any SQL database(I'm using jdbc, it works if the driver and the URL are provided). It seems, that different DBMS use different quoting for table names. For example, I have ...
0
votes
1answer
63 views

Where to put single quotes?

I am trying to execute the below statement which creates a database called service2019: DECLARE @dbname VARCHAR(50); SET @dbname = 'service' + CAST(YEAR(GETDATE()) AS VARCHAR(4)); EXEC ( 'CREATE ...
2
votes
0answers
56 views

Catching QUOTED_IDENTIFIER Errors in Trigger without aborting transaction

Is there a way to catch a QUOTED_IDENTIFIER error without failing the transaction? I have assembled a minimal test case here. The trigger must have SET QUOTED_IDENTIFIER ON because it uses XML data ...
0
votes
1answer
120 views

Postgresql arbitrary queries [duplicate]

I have pgAdmin 4 and PostgreSQL 10. I can't execute a query without quote marks i.e. I want to excute this select * from table but it only works if I use select * from databasename."table" How ...
11
votes
1answer
50k views

Postgres : Relation does not exist error

I used pg_restore to load my postgres db with a dump file. I connected to my db with my user : sudo -u arajguru psql dump select current_user; current_user -------------- arajguru Now I was able ...