Re: [HACKERS] pg_dump error
От | Jose' Soares Da Silva |
---|---|
Тема | Re: [HACKERS] pg_dump error |
Дата | |
Msg-id | Pine.LNX.3.96.980616111419.7015A-100000@proxy обсуждение исходный текст |
Список | 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'
В списке pgsql-general по дате отправления: