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