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

Fri, 06 Nov 1998 14:17:47 +0000
Constantin Teodorescu <teo@flex.ro>
Bug when special table names meet autoincrement field !!!!