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