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'