Re: Renaming unnamed FK constraints - Mailing list pgsql-novice

From Tom Lane
Subject Re: Renaming unnamed FK constraints
Date
Msg-id 2343.1145294773@sss.pgh.pa.us
Whole thread Raw
In response to Re: Renaming unnamed FK constraints  (Vincent Frison <turman@ohmforce.com>)
Responses Re: Renaming unnamed FK constraints  (Vincent Frison <turman@ohmforce.com>)
List pgsql-novice
Vincent Frison <turman@ohmforce.com> writes:
> Le Lundi 2006 Avril 17 18:12, Tom Lane a �crit�:
>> You could try contrib/adddepend instead of
>> doing this by hand.

> What do you mean by contrib/adddepend?

There's a Perl script in contrib that will help with this, as well as
with some other things that are good to do when updating from pre-7.3
to 7.3.  Apparently you didn't see the 7.3 release note suggesting you
run it?

It's possible that this script is not in the Debian postgresql-contrib
package, but if nothing else you could get it from our CVS server:
http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/adddepend/

> BTW a lot of people should have the same problem (i.e. tables creation with
> unamed constraints on PG < 7.3) shouldn't they?

Most people fixed this some time ago ...

            regards, tom lane

pgsql-novice by date:

Previous
From: Brant Fitzsimmons
Date:
Subject: Re: PostgreSQL a slow DB?
Next
From: "Relaxin"
Date:
Subject: Re: PostgreSQL a slow DB?