Re: [HACKERS] pg_dump error
jose' soares <sferac@bo.nettuno.it>
From: "Jose' Soares Da Silva" <sferac@bo.nettuno.it>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: hackers postgres <pgsql-hackers@PostgreSQL.org>, bugs postgres <pgsql-bugs@PostgreSQL.org>, general postgres <pgsql-general@PostgreSQL.org>
Date: 1998-06-16T11:18:16Z
Lists: pgsql-hackers, pgsql-general
On Mon, 15 Jun 1998, Bruce Momjian wrote:
> >
> > Hi all,
> >
> > I think there's an error on pg_dump,
> > my environment is:
> > Lynux 2.0.33
> > PostgreSQL 6.3
> >
> > 1) ----VARCHAR(-50)------------------------------------------
> >
> > I created a table as:
> > CREATE TABLE utente (
> > intestazione_azienda varchar,
> > indirizzo varchar
> > );
> >
> > using pg_dump -d mydatabase > file
> >
> > file is like:
> > \connect - postgres
> > CREATE TABLE utente (intestazione_azienda varchar(-5), indirizzo varchar(-5));
>
> Basically, something major is wrong in your installation. I have never
> heard a report like this, and people use pg_dump all the time.
>
I have three bugs Bruce:
1) VARCHAR(-5)
2) CONSTRAINTs wrong syntax
3) no VIEWs ??
hygea=> create table prova (var varchar, bp bpchar check (bp='zero'));
CREATE
hygea=> create view wprova as select var from prova;
CREATE
pg_dump hygea -s prova
\connect - postgres
CREATE TABLE prova (var varchar(-5), bp char(-5)) CONSTRAINT prova_bp CHECK bp
=COPY prova FROM stdin;
\.
Jose'