Subject | backup/restore primary key contraints |
---|---|
Author | Erik S. LaBianca |
Post date | 2003-05-28T20:29:40Z |
Hi All,
I somehow managed to add a primary key constraint to a table, without
actually filling in the primary key values. I remember distinctly doing
this by hand, but for whatever reason, the values are not there in the
backup.
I recently needed to restore from backup, and to my chagrin i discovered
that my backup file is trying to restore the table with the primary key
constraint intact, but is rejecting all the rows in the table that have
null values for the primary key.
Using gbak -O allows the rest of the data to be loaded properly, and I
had hoped that using the -I or -N options would turn off the constraints
as well, but it doesn't.
Is there any way for me to restore this table without the primary key
constraint in place, so I can get the data back out?
Thanks
--erik
I somehow managed to add a primary key constraint to a table, without
actually filling in the primary key values. I remember distinctly doing
this by hand, but for whatever reason, the values are not there in the
backup.
I recently needed to restore from backup, and to my chagrin i discovered
that my backup file is trying to restore the table with the primary key
constraint intact, but is rejecting all the rows in the table that have
null values for the primary key.
Using gbak -O allows the rest of the data to be loaded properly, and I
had hoped that using the -I or -N options would turn off the constraints
as well, but it doesn't.
Is there any way for me to restore this table without the primary key
constraint in place, so I can get the data back out?
Thanks
--erik