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

Requirement for pgAdmin browser.

From: Anil Jangam <anilj(at)indts(dot)com>
To: "'Dave Page'" <dpage(at)vale-housing(dot)co(dot)uk>, "'pgsql-cygwin(at)postgresql(dot)org'" <pgsql-cygwin(at)postgresql(dot)org>
Subject: Requirement for pgAdmin browser.
Date: 2001-12-14 13:04:06
Message-ID: F73B646FCC01D5118F530002B32C337263B24E@INDTS_FS (view raw or flat)
Thread:
Lists: pgsql-cygwinpgsql-hackers
Hi Dave,

It is observed that while creating table, once we define the attributes and
their properties, we can not change the attribute type. e.g. If we have
defined an attribute of type int. Now if one want to change it to numeric,
it is not allowed thorugh the pgAdmin GUI. However we have the option of
further addition of the attribute to the table. Also it is not possible to
remove the present attribute(s) in the table.

Is this a valid to have this kind of restriction if one want to do similar
change?? I think either we have to go to the psql prompt and use some
command, or refine the whole table after dropping the old one. 

Is there any solution to this through GUI, as it is easy to do it.

-anil.



Responses

pgsql-cygwin by date

Next:From: Dave PageDate: 2001-12-14 13:16:22
Subject: Re: Properties of 'Relationships' in FK definiton.
Previous:From: Anil JangamDate: 2001-12-14 12:33:02
Subject: Properties of 'Relationships' in FK definiton.

pgsql-hackers by date

Next:From: Oleg BartunovDate: 2001-12-14 14:23:39
Subject: 7.2 cvs: explain analyze instabilities
Previous:From: Luis AmigoDate: 2001-12-14 12:32:11
Subject: Re: can someone explain that?

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