Re: [pgadmin-support] Cannot add an column of type serial

2003-12-10 Thread Andreas Pflug
David Sigeti wrote: At 12:21 PM 12/10/2003 +0100, Andreas Pflug wrote: David Sigeti wrote: I am using pgadminIII 1.0.2 with PostgreSQL 7.4 under W2K SP4 and Cygwin (current as of 2 or 3 weeks ago). The server is running locally. If I attempt to add an column of type serial or bigserial to a

Re: [pgadmin-support] Cannot add an column of type serial or

2003-12-10 Thread David Sigeti
At 12:21 PM 12/10/2003 +0100, Andreas Pflug wrote: David Sigeti wrote: I am using pgadminIII 1.0.2 with PostgreSQL 7.4 under W2K SP4 and Cygwin (current as of 2 or 3 weeks ago). The server is running locally. If I attempt to add an column of type serial or bigserial to a table, the operation

[pgadmin-support] Snake/CVS Downtime

2003-12-10 Thread Dave Page
I'll include the message this time... At 3:30PM GMT 10 Dec 2003 both snake.pgadmin.org and cvs.pgadmin.org will be shutdown whilst some electrical work is undertaken. We expect them to be available again by 5PM. Apologies for any inconvenience. Regards, Dave ---(end of

[pgadmin-support] Snake/CVS downtime

2003-12-10 Thread Dave Page
---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [pgadmin-support] Cannot add an column of type serial or bigserial

2003-12-10 Thread Andreas Pflug
Christopher Kings-Lynne wrote: serial isn't a true datatype but a keyword that can be used only at creation time. Still, pgAdmin3 should create the commands necessary for this to make life easier; I added this as a TODO item. The problem will be recording the dependency properly in pg_depend..

Re: [pgadmin-support] Cannot add an column of type serial or bigserial

2003-12-10 Thread Christopher Kings-Lynne
serial isn't a true datatype but a keyword that can be used only at creation time. Still, pgAdmin3 should create the commands necessary for this to make life easier; I added this as a TODO item. The problem will be recording the dependency properly in pg_depend... Chris

Re: [pgadmin-support] Cannot add an column of type serial or bigserial

2003-12-10 Thread Andreas Pflug
David Sigeti wrote: Dear Pgadmin Folks, I am using pgadminIII 1.0.2 with PostgreSQL 7.4 under W2K SP4 and Cygwin (current as of 2 or 3 weeks ago). The server is running locally. If I attempt to add an column of type serial or bigserial to a table, the operation fails with a message telling me

Re: [pgadmin-support] database properties don't pop up

2003-12-10 Thread Andreas Pflug
Michael Shapiro wrote: I downloaded the latest snapshot (20031209) for win32. When you right click on a database and ask for the properties, the dialog that normally appears (that would allow you to edit variable and security) does not appear. My recent GetDatabase() refactoring missed this

Re: [pgadmin-support] mouse-free PgadminIII usage

2003-12-10 Thread Andreas Pflug
Miernik wrote: Adding a server is possible without the mouse. But if I want to select a server from the servers list, it's impossible. The "Servers (1)" text is highlited, but pressing arrows or Tab doesn't do anything, there is no way to move the higlight down to a specific server. Is there

Re: [pgadmin-support] Cannot add an column of type serial or bigserial

2003-12-10 Thread Ian Freislich
Christopher Kings-Lynne wrote: > You cannot add a serial column after table creation time in PostgreSQL. But you can do the following from the query editor: ALTER TABLE table ADD column INTEGER; CREATE SEQUENCE table_column_seq; ALTER TABLE table ALTER column SET DEFAULT nextval('"table_column_se