Re: Re: [BUG?] tgconstrrelid doesn't survive a dump/restore

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(at)Yahoo(dot)com #

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