Support for Alter table only add primary key constraint - pg_restore to YSQL DB.

[lakshman-battini]

Jira Link: DB-2164
Hello, I am trying to migrate the Postgres database to YSQL DB. Created dump of postgres db using pg_dump and trying to restore in YSQL DB using pg_restore.

pg_dump creates the create table script without any constraints, add the constraints using Alter table scripts. But in YSQL DB 'ALTER TABLE ONLY ADD CONSTRAINT PRIMARY KEY' is not yet supported.

pg_restore: error: could not execute query: ERROR: This ALTER TABLE command is not yet supported.
Command was: ALTER TABLE ONLY

ADD CONSTRAINT PRIMARY KEY (field);

[ddorian]

@lakshman-battini can you try with ysql_dump ? It should be able to create the primary key inside create table statement.

[ddorian]

Closing as duplicate of #1104
The same recommendation for ysql_dump is mentioned there too.

[ndeodhar]

Re-opening. This request is specifically to track an enhancement to pg_restore to create PKs inline (independently of ysql_dump).

[fizaaluthra]

ADD PRIMARY KEY is supported (#1104)