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

Re: [HACKERS] Requirement for pgAdmin browser.

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: jm(dot)poure(at)freesurf(dot)fr
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [HACKERS] Requirement for pgAdmin browser.
Date: 2001-12-15 18:06:24
Message-ID: 200112151806.fBFI6OC09388@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-cygwinpgsql-hackers
> Le Vendredi 14 D?cembre 2001 14:04, vous avez ?crit :
> > 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.
> 
> PostgreSQL does not allow table modification. The community have been waiting 
> for an ALTER TABLE DROP COLUMN and type PROMOTION / DEMOTION, for a long 
> time. Same as for Views and triggers : it is impossible to alter them... The 
> politics of PostgreSQL is to offer advanced features before basic ones.
> 
> Is anyone working seriously on those issues?

Agreed.  We couldn't decide the best way to do it, so we did nothing.  I
have hopes for 7.3.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-cygwin by date

Next:From: Dave PageDate: 2001-12-15 19:32:56
Subject: Re: [HACKERS] Requirement for pgAdmin browser.
Previous:From: Jean-Michel POUREDate: 2001-12-15 15:00:03
Subject: Re: Requirement for pgAdmin browser.

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2001-12-15 18:08:22
Subject: Re: Problem compiling postgres sql --with-tcl
Previous:From: Jean-Michel POUREDate: 2001-12-15 14:56:23
Subject: Re: Requirement for pgAdmin browser.

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