Re: [HACKERS] Error message for FK referencing deferrable unique/PK

2009-08-12 Thread Tom Lane
Dean Rasheed writes: > I spotted another error message which could use improvement: > ... > The attached patch to transformFkeyCheckAttrs() makes the former case > generate a similar error to the latter. Ah, you caught me being lazy ;-). I had actually considered doing this while reviewing the d

[HACKERS] Error message for FK referencing deferrable unique/PK

2009-08-12 Thread Dean Rasheed
While looking at this report http://archives.postgresql.org/pgsql-bugs/2009-08/msg00083.php I spotted another error message which could use improvement: CREATE TABLE foo(a int PRIMARY KEY DEFERRABLE); CREATE TABLE bar(a int REFERENCES foo(a)); ERROR: there is no unique constraint matching give