Re: [pgadmin-hackers] altering table properties

2005-09-23 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Miha Radej > Sent: 23 September 2005 13:14 > To: PgAdmin Hackers > Subject: [pgadmin-hackers] altering table properties > > hi! > > thank you for fixing the sql query

Re: [pgadmin-hackers] altering table properties

2005-09-23 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Miha Radej > Sent: 23 September 2005 13:27 > To: PgAdmin Hackers > Subject: Re: [pgadmin-hackers] altering table properties > > i tried fiddling with the code (never touche

Re: [pgadmin-hackers] altering table properties

2005-09-23 Thread Miha Radej
hi again! Miha Radej wrote: also, i wanted to remove a constraint (primary key) and add a new one and pgadmin produced thie following code: CONSTRAINT ALTER TABLE budget_type DROP CONSTRAINT pkey_budgettype; ALTER TABLE budget_type ADDpkey_budget_type PRIMARY KEY (id); there is an unneccesa

[pgadmin-hackers] altering table properties

2005-09-23 Thread Miha Radej
hi! thank you for fixing the sql query order in svn. i have, however, noticed some other things which might be annoying: when wanting to change a table name and a column name at the same time, pgadmin produces this (this is all done via the properties option from the context menu): ALTER T