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

wrong quoted column types in "types"

From: Martin Sarsale <runa(at)gotvertigo(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: wrong quoted column types in "types"
Date: 2004-09-13 15:00:45
Message-ID: 1095087645.1710.6.camel@kadaif (view raw or flat)
Thread:
Lists: pgadmin-support
Dear All: 
Im using pgadmin debian ver 1.1.0-0.0+cvs.20040908.1 and I found this
little bug:

I wanted to duplicate a "type", so I went to the types item on the tree,
and I choosed the origin type. When the code used to create this type
appeared on the right pane, I copy the sql and pasted it as a new query
but I found that the column types (varchar, and time) where quoted (and
they should not):

-- Type: xxx

-- DROP TYPE xxx;

CREATE TYPE xxx AS
   (id int4,
    xxx "varchar"(200),
    xxx float8,
    xxx "time"(0),
    xxx int4,
    xxx int4,
    xxx "varchar"(150),
    xxx text,
    xxx "varchar"(200));

Thanks in advance :)



pgadmin-support by date

Next:From: Dave PageDate: 2004-09-13 15:33:20
Subject: Re: Missing file MSVCR71.dll, libssl32.dll
Previous:From: derrickDate: 2004-09-13 14:52:00
Subject: Missing file MSVCR71.dll, libssl32.dll

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