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