regression in CVS HEAD

From: nconway(at)klamath(dot)dyndns(dot)org (Neil Conway)
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: regression in CVS HEAD
Date: 2002-07-24 22:52:44
Message-ID: 20020724225244.GA17331@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I see this using the latest CVS code:

$ make installcheck
[ all tests pass ]
$ pg_dump regression > /tmp/regression.dump
$ psql template1
template1=# drop database regression;
DROP DATABASE
template1=# create database regression;
CREATE DATABASE
template1=# \c regression
You are now connected to database regression.
regression=# \i /tmp/peter-dump

The restoration of the dump products a number of errors, including
the following: (I've only included the first few)

395: WARNING: ProcedureCreate: type widget is not yet defined
411: ERROR: parser: parse error at or near ","
467: ERROR: parser: parse error at or near ","
475: ERROR: parser: parse error at or near ","
483: ERROR: parser: parse error at or near ","

The corresponds lines from the dump file are:

CREATE FUNCTION "widget_in"(opaque) RETURNS widget AS
'/home/nconway/pgsql/src/test/regress/regress.so', 'widget_in' LANGUAGE
"c";

CREATE TYPE "widget" ( internallength = 24, input = widget_in, output =
widget_out, , alignment = double, storage = plain);

CREATE TYPE "city_budget" ( internallength = 16, input = int44in, output
= int44out, , element = integer, delimiter = ',', alignment = int4,
storage = plain);

CREATE TYPE "int42" ( internallength = 4, input = int4in, output =
int4out, , default = '42', alignment = int4, storage = plain,
passedbyvalue);

CREATE TYPE "text_w_default" ( internallength = variable, input =
textin, output = textout, , default = 'zippo', alignment = int4, storage
= plain);

The problem appears to be the spurious comma in the dumped CREATE TYPE
statement, and I think it was introduced by Peter E.'s recent checkin.

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Yuva Chandolu 2002-07-24 23:24:59 savepoint and rollback queries in postgres
Previous Message Neil Conway 2002-07-24 22:32:00 Re: bug in COPY