On Fri, 15 Mar 2002 [EMAIL PROTECTED] wrote: > Dirk Jacobs ([EMAIL PROTECTED]) 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
