Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] pg_dump error

From: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: hackers postgres <pgsql-hackers(at)PostgreSQL(dot)org>, bugs postgres <pgsql-bugs(at)PostgreSQL(dot)org>, general postgres <pgsql-general(at)PostgreSQL(dot)org>
Subject: Re: [HACKERS] pg_dump error
Date: 1998-06-16 11:18:16
Message-ID: Pine.LNX.3.96.980616111419.7015A-100000@proxy (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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'


In response to

pgsql-hackers by date

Next:From: Andreas ZeugswetterDate: 1998-06-16 11:56:26
Subject: AW: [HACKERS] Re: [QUESTIONS] How to use memory instead of hd?
Previous:From: Jose' Soares Da SilvaDate: 1998-06-16 11:00:05
Subject: Re: [HACKERS] User authentification failed

pgsql-general by date

Next:From: Bruce TongDate: 1998-06-16 11:59:31
Subject: Re: [GENERAL] libq++ and security help
Previous:From: Peter MountDate: 1998-06-16 05:50:12
Subject: Re: [GENERAL] libq++ and security help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group