"Kyle F. Downey" <[EMAIL PROTECTED]> writes:
> In 7.1rc2, this same DDL results in this error:
> ERROR: UNIQUE constraint matching given keys for referenced table
> "incidents" not found
7.1 enforces the requirement that the referenced column be marked UNIQUE
(or PRIMARY KEY, which implies UNI
> I am not sure whether this is a bug or a tightening-up of a previous
> loose SQL definition.
> Previously, I was able to define constraints that refer to the same
> table within the table itself,
> like so:
>
> CREATE SEQUENCE incidents_id_seq;
> GRANT ALL ON incidents_id_seq TO its;
> CREAT
- Postgresql 7.1RC2
- installed from the RPM on Red Hat 7.0 on x86
- fresh databases built (initdb)
- error happens connecting with psql on UNIX domain sockets,
but there's no evidence it's exclusive to that interface
I am not sure whether this is a bug or a tightening-up of a previous
loose SQL
