Re: [BUGS] contrib/adddepend does not properly re-create multi-column foreign keys.

2002-12-01 Thread Adam Buraczewski
On Sun, Dec 01, 2002 at 02:06:31PM -0500, Tom Lane wrote: > Adam Buraczewski <[EMAIL PROTECTED]> writes: > > I already notified the author of the program and attached patches to > > both original upgrade.pl and contrib/adddepend scripts. > Rod, do you concur that this is a correct patch? The patch

Re: [BUGS] contrib/adddepend does not properly re-create multi-column foreign keys.

2002-12-01 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > It makes sense, but I've not tested it yet. Okay, I'll hold off applying until you check it. It's not urgent, but I'd like to have it fixed in 7.3.1, which we'll doubtless be wanting to roll out in a few weeks. regards, tom lane -

Re: [BUGS] contrib/adddepend does not properly re-create multi-column foreign keys.

2002-12-01 Thread Tom Lane
Adam Buraczewski <[EMAIL PROTECTED]> writes: > Simply: the program takes column names from the wrong end of the array > :) > I already notified the author of the program and attached patches to > both original upgrade.pl and contrib/adddepend scripts. Rod, do you concur that this is a correct pat

[BUGS] contrib/adddepend does not properly re-create multi-column foreign keys.

2002-12-01 Thread Adam Buraczewski
Hallo, I've used contrib/adddepend script (written in Perl) to move my databases from PostgreSQL 7.2 to 7.3-style foreign key syntax, in order to use new dependency information and get rid of those "create constraint trigger" commands generated by pg_dump. The script does a very good job indeed.