Re: Bug in pg_get_constraintdef (for deferrable constraints) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug in pg_get_constraintdef (for deferrable constraints)
Date
Msg-id 8141.1041453980@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in pg_get_constraintdef (for deferrable constraints)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Bug in pg_get_constraintdef (for deferrable constraints)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I see the values being stored on constriant creation, but not being used
> anywhere:

I believe the values that actually get inspected at runtime are the
tgdeferrable and tginitdeferred fields in pg_trigger.  The columns in
pg_constraint are just copies of these.

It is not real clear to me whether it should be allowed to alter the
deferrability status of a foreign-key constraint --- is that in the spec?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Bug in pg_get_constraintdef (for deferrable constraints)
Next
From: Bruce Momjian
Date:
Subject: Re: Bug in pg_get_constraintdef (for deferrable constraints)