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

Jan Wieck <janwieck@yahoo.com>

From: Jan Wieck <JanWieck@Yahoo.com>
To: PostgreSQL HACKERS <pgsql-hackers@postgreSQL.org>
Date: 2001-04-20T16:29:10Z
Lists: 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