ERROR: relation "employees" does not exist

Поиск
Список
Период
Сортировка
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?

--
Regards from Pal

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: selecting for type cast failures
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: ERROR: relation "employees" does not exist