Facing error while Altering table in PostgreSQL

Question

I was creating tables in PostgreSQL. Then I had to use an column as foreign key so I altered my table to define that column as foreign key. But I got an error at "WITH",

ALTER TABLE Account  WITH NOCHECK ADD  CONSTRAINT FK_Account_AccountCPCMapping FOREIGN KEY(nAccountCPCMappingID)
REFERENCES AccountCPCMapping (nAccountCPCMappingID);

I am getting error like,

ERROR:  syntax error at or near "WITH"
LINE 1: ALTER TABLE Account  WITH NOCHECK ADD  CONSTRAINT FK_Account...

Please suggest any corrections.

Where in the manual did you find with nocheck? What do you expect it to do? — user330315
– user330315, Commented Dec 29, 2017 at 9:50
I'm assuming you are looking for NOT VALID; it goes at the very end of your query and will prevent PostgreSQL from checking existing rows against this constraint. — Łukasz Kamiński
– Łukasz Kamiński, Commented Dec 29, 2017 at 10:01

Vao Tsun · Accepted Answer · 2017-12-29 10:43:08Z

2

you try to use Microsoft sql server syntax https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql

while Postgres syntax https://www.postgresql.org/docs/current/static/sql-altertable.html is

...ADD table_constraint [ NOT VALID ]

answered Dec 29, 2017 at 10:43

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

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

Collectives™ on Stack Overflow

Facing error while Altering table in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest