Re: Cross-schema inheritence problem

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(at)magproductions(dot)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 //