I see something related with Deferrable and Initially deferrable that seems
like something could avoid constraints when dumping and restore, but it has
to modify the table or re-create all of them to have such option (maybe is
what you referraled table definitions). Is it what it can be use for to
test_str t;
I am getting error like this.
ERROR: column t.name does not exist
--- On Wed, 24/2/10, Net Tree Inc. nettree...@gmail.com wrote:
From: Net Tree Inc. nettree...@gmail.com
Subject: Re: [GENERAL] how do I do dump and restore without bugging with
constraint?
To: pgsql-ad
Hi all,
I am dumping both schema and data from old database to new one. The new
database schema is somehow contain slightly different schema then the old
one. When I do restore it shown alot errors related with constraints. How
can I dump and to restore from old to new without dealing with
Net Tree Inc. wrote:
Hi all,
I am dumping both schema and data from old database to new one. The
new database schema is somehow contain slightly different schema then
the old one. When I do restore it shown alot errors related with
constraints. How can I dump and to restore from old to new
Ok, I am just trying to find the proper way to back and restore database
that contain restriction.
The other way to ask. If I have two 99% schema similar databases. The old
one might contain few columns that does not exist in the new one and contain
constrains that the new DB does not have. In
On Mon, Feb 22, 2010 at 11:39 PM, Net Tree Inc. nettree...@gmail.com wrote:
Ok, I am just trying to find the proper way to back and restore database
that contain restriction.
The other way to ask. If I have two 99% schema similar databases. The old
one might contain few columns that does not