Thread: 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

Csanyi Pal <csanyipal@gmail.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°

On 11 March 2013 07:39, Csanyi Pal <csanyipal@gmail.com> wrote:
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.