PostgreSQL Drop Table Invalid Argument

Question

I would also like to delete a table in PostgreSQL.

I can delete the table I just opened, but when I want to delete a previously opened table I get the following error:

DROP TABLE "ABTestCreateTable4";

DROP TABLE "ABTestCreateTable4"

ERROR: vsnprintf failed: Invalid argument

DROP TABLE "ABTestCreateTable4" CASCADE;

DROP TABLE "ABTestCreateTable4" CASCADE

ERROR: vsnprintf failed: Invalid argument

I tried two options but I got the same error.

I've searched for this problem, but I can't find any solution.

I'm using Navicat Premium.

Thanks for your help.

looks strange. I cannot to repeat it on current versions of PostgreSQL. Please, try update your Postgres. — Pavel Stehule
– Pavel Stehule, Commented Nov 13, 2018 at 9:03
That is valid SQL. The error message looks strange though. Maybe Navicat can't cope with those dreaded quoted identifiers. — user330315
– user330315, Commented Nov 13, 2018 at 9:09
What happens when you drop the table using the psql client? — user330315
– user330315, Commented Nov 13, 2018 at 9:22

Melih Sinan Doğrul · Accepted Answer · 2018-12-16 08:48:10Z

2

Try doing this:

SET lc_messages = 'C'

and then DROP TABLE table_name

answered Dec 16, 2018 at 8:48

364 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thanks for your solution. Why did this happen? Do you have any information?