Re: [HACKERS] pg_dump error

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'