Re: Re: [BUG?] tgconstrrelid doesn't survive a dump/restore - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: Re: [BUG?] tgconstrrelid doesn't survive a dump/restore
Date
Msg-id 200104201629.LAA01566@jupiter.jw.home
Whole thread Raw
Responses Re: Re: [BUG?] tgconstrrelid doesn't survive a dump/restore  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
Philip Warner wrote:
> At 08:42 19/04/01 -0500, Jan Wieck wrote:
> [...]
> >    and  the required
> >    feature to correctly restore the tgconstrrelid is already  in
> >    the  backend,  so  pg_dump  should make use of it
>
> No problem there - just tell me how...
   Add  a  "FROM <opposite-relname>" after the "ON <relname>" to   the CREATE CONSTRAINT TRIGGER statements. That's
it.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: RFC: planner statistics in 7.2
Next
From: Philip Warner
Date:
Subject: Re: Re: [BUG?] tgconstrrelid doesn't survive a dump/restore