Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches
I will try to apply it within the next 48 hours. It also will be backpatched. --------------------------------------------------------------------------- Stephan Szabo wrote: > > On Wed, 1 Jan 2003, Bruce Momjian wrote: > > > Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> 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? > > > > The big problem is that while pg_dump's dump_trigger() looks at > > tginitdeferred and dumps accordingly, pg_get_constraintdef doesn't look > > at tginitdeferred, and therefore doesn't record the requirement as part > > of ALTER TABLE ADD CONSTRAINT. > > pg_get_constraintdef should probably be looking at condeferrable > and condeferred in the pg_constraint row it's looking at. Maybe something > like the attached. Content-Description: [ Attachment, skipping... ] -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org