Обсуждение: Cross-schema inheritence problem

Hello all,

I'm trying to inherit a table from the public schema as a table with the
same name in a user-specific schema, but I can't get it to work.

Say I have:
CREATE TABLE test (test_id serial PRIMARY KEY, name text NOT NULL);

CREATE SCHEMA alban AUTHORIZATION alban;

ALTER USER alban SET search_path TO alban;

CREATE TABLE alban.test () INHERITS (public.test);
ERROR:  must be owner of relation test

Is there some way around this?

I would appreciate this to work, as I need to seperate data of two
applications where the 2nd application extends the data of the 1st.

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //

Alban Hertroys wrote:
> Hello all,
>
> I'm trying to inherit a table from the public schema as a table with the
> same name in a user-specific schema, but I can't get it to work.
>
> Say I have:
> CREATE TABLE test (test_id serial PRIMARY KEY, name text NOT NULL);
>
> CREATE SCHEMA alban AUTHORIZATION alban;
>
> ALTER USER alban SET search_path TO alban;
>
> CREATE TABLE alban.test () INHERITS (public.test);
> ERROR:  must be owner of relation test
>
> Is there some way around this?

Oh never mind, that works the wrong way around anyway. I need VIEWs.

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //