ERROR: relation "employees" does not exist

From: Csanyi Pal <csanyipal(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: relation "employees" does not exist
Date: 2013-03-11 06:39:26
Message-ID: 87obeq5tk1.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2013-03-11 06:53:34 Re: ERROR: relation "employees" does not exist
Previous Message Adrian Klaver 2013-03-10 18:51:58 Re: selecting for type cast failures