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

Re: [pgadmin-support] Creating functions with pgAdmin III

2003-12-07 Thread Ian Freislich
Andreas Pflug wrote: > Ian Freislich wrote: > > >I can't find the pseudo-type RECORD in the drop-down list of return > >types so it is impossible to create functions like "CREATE OR REPLACE > >FUNCTION foo (TEXT) RETURNS SET OF RECORD AS..." using the

[pgadmin-support] Creating functions with pgAdmin III

2003-12-05 Thread Ian Freislich
Hi I don't know if anyone has encountered this problem before. I couldn't find any reference to this on the list archives or FAQ. I can't find the pseudo-type RECORD in the drop-down list of return types so it is impossible to create functions like "CREATE OR REPLACE FUNCTION foo (TEXT) RETURNS