Re: ERROR: relation "employees" does not exist

Csanyi Pal <csanyipal(at)gmail(dot)com> 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°