-----BEGIN PGP SIGNED MESSAGE-----
On Sat, 26 Mar 2005, Devrim GUNDUZ wrote:
>> Hmph. Those should be 'i' references to the foreign key constraint,
>> not 'a' references to the relations. I suspect this database was
>> carried forward from an ancient (pre-7.3) dump that defined the triggers
>> by "CREATE CONSTRAINT TRIGGER" instead of "ALTER ADD FOREIGN KEY".
> I haven't coded the application but AFAIKit was developed using 7.4 and
> 7.5(CVS); and we installed database on 8.0.1... This is a new app.
Ok, sorry for the wrong info. I learned that they had begun coding the app
on 7.2, then moved to 7.3->7.4->8.0... You are right.
>> Have you ever run contrib/adddepend to update the definitions to be
>> proper constraints?
Ok, running adddepend solved our problem (in fact it produced some erros
related to perl but we ran the queries inside psql and fixed the problem).
Now we can run pg_dump.
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
-----END PGP SIGNATURE-----
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2005-03-27 19:39:17|
|Subject: _RollbackFunc : dead code?|
|Previous:||From: Magnus Hagander||Date: 2005-03-27 18:11:48|
|Subject: Re: Patch for collation using ICU|