Questions tagged [quoted-identifier]
The quoted-identifier tag has no usage guidance.
7
questions
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 ...
