Re: ERROR: relation "employees" does not exist

On 11 March 2013 07:39, Csanyi Pal <csanyipal(at)gmail(dot)com> wrote:

> 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?
>

You have a foreign key reference (employee_id) to a table (employees) that
can't be found in your search_path.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.