Re: pg_dump/PgAdmin problem? - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump/PgAdmin problem?
Date
Msg-id 17627.1012342310@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump/PgAdmin problem?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: pg_dump/PgAdmin problem?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> My guess is the problem is that the views use column(func(params))
> which get output by pg_dump as func(params).column.

Um.  Looks like you're right: I see
    pgadmin_get_sequence(c.oid).sequence_last_value
and some similar bogosities in the sample views.

> I can replicate in
> 7.2beta4 with a simpler case, but haven't looked any further.

Er, what version do you have, again?  I tweaked the backend to fix that
problem awhile ago --- according to the CVS logs the fix is in 7.2beta4:

http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/ruleutils.c

            regards, tom lane

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: pg_dump/PgAdmin problem?
Next
From: Stephan Szabo
Date:
Subject: Re: pg_dump/PgAdmin problem?