Re: ALTER TABLE & COLUMN

Hi Cagil,

--On Montag, 2. Dezember 2002 09:13 +0200 Çagil Seker
<cagils(at)biznet(dot)com(dot)tr> wrote:

>> -----Original Message-----
>> From: Christoph Dalitz [mailto:christoph(dot)dalitz(at)hs-niederrhein(dot)de]
>>
>> Date: 29 Nov 2002 15:22:06 -0500
>> From: Neil Conway <neilc(at)samurai(dot)com>
>> >
>> > > I am surprised by the fact that altering tables and columns is so
>> > > limited in PostgreSQL, this powerful DBMS! Changing
>> column types and
>> > > droping columns are missing important features I think.
>> >
>> Actually this seems to be one of the rare areas where MySQL is better.
>> PG 7.3 improves a lot though.

Without triggers and referential integrity, changing columns is a
lot easyer ;)

> I've started a new project a few weeks ago. I had to make a choice
> between these two dbs. Just because table and column administration is
> difficult on PG, I chose MySQL (although I'd found PG better on all other
> areas). Then at that time PG 7.3 comes out and solves at least some of
> the problems! What a coincedence! Now I will switch to PG.

... *snip* ...

> That's a huge problem really, not a syntactic sugar, otherwise more of a
> syntactic salt :) I want some of my users (not all are db admin) to be
> able to alter tables with pgAdmin. How can I expect them to achieve those
> N-step voodoo as it will be seen to them?

I dont think its wise to make regular changes to your table structure.
Let alone these changes are made by untrained people.

Regards
Tino