Reputation: 69
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.
Upvotes: 2
Views: 1391
Reputation: 36
Try doing this:
SET lc_messages = 'C'
and then DROP TABLE table_name
Upvotes: 2