Re: [GENERAL] 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 [EMAIL PROTECTED] 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 // ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
[GENERAL] 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 [EMAIL PROTECTED] 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 // ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
