Csanyi Pal <csanyipal@xxxxxxxxx> wrote: > Hi, > > I just installed Postgresql 9.2 on my Debian Wheezy system. > > I want to study and learn about new data type, the range type. > > I'm following the tutorial: > https://wiki.postgresql.org/images/7/73/Range-types-pgopen-2012.pdf > > but when I run the command: > CREATE TABLE employee_schedule ( > id serial, > employee_id integer REFERENCES employees(id), > start_time timestamptz, > end_time timestamptz > ); > > I get an error message: > > NOTICE: CREATE TABLE will create implicit sequence > "employee_schedule_id_seq" for serial column "employee_schedule.id" > ERROR: relation "employees" does not exist > > So how can I solve this problem? Create a simple table first: create table employees (id int primary key, ...) or omit the REFERENCES employees(id). Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
