Re: [BUGS] Bug #616: Alter table add foreign key

2002-03-15 Thread Stefano Reksten
At 07.24 15/03/02 -0500, you wrote: >I tried to execute following SQL alter table PRICEGROUP add FOREIGN >KEY ("PARENT") REFERENCES "PRICEGROUP" ON DELETE CASCADE > >this gives an error ALTER TABLE: column "PARENT" referenced in foreign key >constraint does not exist (7) while I'm sure that the

[BUGS] Bug on CHARACTER(n) ?

2005-11-28 Thread Stefano Reksten
Hello list, maybe I am missing something. Look at this: CREATE TABLE test (name character(10)); INSERT INTO test VALUES ('test'); SELECT '<' || name || '>' FROM test; ?column? -- SELECT length(name), name from test; length |name + 4 | test Should no