Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

• Re: Bug in pg_get_constraintdef (for deferrable constraints) at 2003-01-01 20:10:02 from Bruce Momjian

Responses

• Re: Bug in pg_get_constraintdef (for deferrable constraints) at 2003-01-01 21:15:53 from Bruce Momjian

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 2003-01-01 21:15:53
	Subject: Re: Bug in pg_get_constraintdef (for deferrable constraints)
Previous:	From: Bruce Momjian	Date: 2003-01-01 20:10:02
	Subject: Re: Bug in pg_get_constraintdef (for deferrable constraints)