Re: [GENERAL] Alter table possibility

1999-11-09 Thread Alain TESIO
--- Edouard DESSIOUX <[EMAIL PROTECTED]> wrote: > I've just seen that alter allow to add a column > But how can I do if I want to delete a column ? Scroll down a bit on the same page in the manual and you'll read that this feature (alter table drop column) is not yet supported. Alain _

Re: [GENERAL] how to insert from sequence

1999-10-27 Thread Alain TESIO
> Hi all, > > I need help in inserting a value from sequence. My > code goes like this (from Java). I do face a syntax > level problem. > > statement.execute("insert into T_name (id) values (" + > nextval('s_name') + ")"); > > Thanks in advance for the help. nextval is a sql function, not ja

Re: [GENERAL] Installation simplicity

1999-10-21 Thread Alain TESIO
--- Duncan Kinder <[EMAIL PROTECTED]> wrote: > There appears to be some difference between the RPM Postgres > distribution > and what you would expect from compiling the binaries. > > I don't know what the problem was, but rather than try to figure > the thing > out, I finally removed the RPM's d