> -----Original Message----- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 16 July 2003 11:47 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: FW: [pgadmin-support] pgAdmin3: adding comments > to existing tables > > > Dave Page wrote: > > >Hi Andreas, > > > >This is a little worrying - I just tried it here and when > trying to set > >a comment on a table, what it actually executed was: > > > >ALTER TABLE fig.test ADD COLUMN fooCol fig.foo_domain; > >ALTER TABLE fig.test ADD COLUMN myFatCol int4[]; > >ALTER TABLE fig.test DROP COLUMN "fooCol"; > >ALTER TABLE fig.test DROP COLUMN "myFatCol"; > > > OK, took quite a while until I understood what's going on. > qtIdent was > missing on the column name, and fooCol is not the same as "fooCol" so > the mechanism to determine if a column definition is already present > didn't hit.
Looks OK now, though the definition pane needs a refresh to see the changes. > >Also, selecting a column and clicking Change does nothing. > > > Not implemented... OK. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
