Bug when special table names meet autoincrement field !!!!

Started by Constantin Teodorescuabout 27 years ago1 messages

I have discovered today an interesting bug , when creating table name
containing spaces and one of the fields are auto_increment-able.
See the example below :

showroom=> create sequence student_id;
CREATE
showroom=> create table students (id int4 default
nextval('student_id'),name text);
CREATE
showroom=> drop table students;
DROP
showroom=> create table "my students" (id int4 default
nextval('student_id'), name text);
ERROR: my: Table does not exist.

Please CC: me directly the answer.

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA