Re: [HACKERS] pg_dump error

Поиск
Список
Период
Сортировка
Искать

Re: [HACKERS] pg_dump error

От:
"Jose' Soares Da Silva" <sferac@bo.nettuno.it>
Дата:
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'
FAQ