Re: [GENERAL] access public relation from a private database

2008-09-29 Thread A. Kretschmer
am Mon, dem 29.09.2008, um 17:43:21 +0530 mailte Joey K. folgendes: > > When I try to create a table in database nowhere that references public.foo > table, > > CREATE DATABASE nowhere; > \c nowhere; > CREATE TABLE bar (bar integer REFERENCES public.foo(fooid)); > > I get, ERROR: relation "pub

Re: [GENERAL] access public relation from a private database

2008-09-29 Thread Tino Wildenhain
Joey K. wrote: Hello, I've created a table in public schema, CREATE TABLE public.foo (fooid SERIAL); When I try to create a table in database nowhere that references public.foo table, CREATE DATABASE nowhere; \c nowhere; CREATE TABLE bar (bar integer REFERENCES public.foo(fooid)); I get,

[GENERAL] access public relation from a private database

2008-09-29 Thread Joey K.
Hello, I've created a table in public schema, CREATE TABLE public.foo (fooid SERIAL); When I try to create a table in database nowhere that references public.foo table, CREATE DATABASE nowhere; \c nowhere; CREATE TABLE bar (bar integer REFERENCES public.foo(fooid)); I get, ERROR: relation "pu