pg_dump of regression db?

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: pgsql-hackers(at)hub(dot)org
Subject: pg_dump of regression db?
Date: 2000-09-13 16:55:15
Message-ID: 3.0.5.32.20000914025515.02a9c8a0@mail.rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I thought I would test the latest changes to pg_dump on the regression db,
and got the following output for an aggregate:

CREATE AGGREGATE newcnt (BASETYPE = opaque, SFUNC = int4inc, STYPE =
int4, INITCOND = '0' );

Unfortunately, the backend produces the following error when this statement
is executed:

ERROR: AggregateCreate: Type 'opaque' undefined

I vaguely recall seeing something about pg_dump not working of the
regression db, but would be interested to know if this is the known
problem, and if there is any value in trying to fix it.

psql shows the following:

regression=# \da newcnt
List of aggregates
Name | Type | Description
--------+-------------+-------------
newcnt | (all types) |
(1 row)

whereas in 7.0.2, it shows int4, so my guess is that this is a problem with
pg_dump and the new function manager.

Any suggestions would be appreciated.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mikheev, Vadim 2000-09-13 17:29:37 RE: Status of new relation file naming
Previous Message Tom Lane 2000-09-13 16:34:07 Re: pg_dump of regression db?