Re: [GENERAL] bug on ALTER TABLE

2008-05-14 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of Martin Marques > Sent: Wednesday, May 14, 2008 4:35 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] bug on ALTER TABLE > > Please, can someone expla

Re: [GENERAL] bug on ALTER TABLE

2008-05-14 Thread Joey K.
On Wed, May 14, 2008 at 4:35 PM, Martin Marques <[EMAIL PROTECTED]> wrote: > Please, can someone explain how is it posible for ALTER TABLE to add a > primary key column to a table without some intruction that would make it a > real PK (NOT NULL and UNIQUE). > > prueba=> CREATE TABLE nopk ( > prueb

[GENERAL] bug on ALTER TABLE

2008-05-14 Thread Martin Marques
Please, can someone explain how is it posible for ALTER TABLE to add a primary key column to a table without some intruction that would make it a real PK (NOT NULL and UNIQUE). prueba=> CREATE TABLE nopk ( prueba(> textito varchar prueba(> ); CREATE TABLE prueba=> INSERT INTO nopk VALUES ('algo