Re: Bug #619: Not possible to specify foreign key name

On Fri, 15 Mar 2002 pgsql-bugs@postgresql.org wrote:

> Dirk Jacobs (dirk.jacobs@tuple.be) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> Not possible to specify foreign key name
>
> Long Description
> It is not possible to specify a foreign key name.
> Version 7.2 on redhat 7.2
>

Need more information, works for me:

create table b(a int constraint foo references a(a));
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
CREATE
sszabo=# insert into b values(1);
ERROR:  foo referential integrity violation - key referenced from b not
found in a