[GENERAL] Inheritance in 7.1

2001-04-26 Thread Alastair D'Silva
Is there any way around having to own the table you are inheriting from in PostgreSQL 7.1? -- Alastair D'Silva (mob: 0413 485 733) Networking Consultant New Millennium Networking (web: http://www.newmillennium.net.au) ---(end of broadcast)--

[GENERAL] PostgreSQL 7.1 and Sequences

2001-04-22 Thread Alastair D'Silva
T INTO blah (info) VALUES ('foo'); I get the following error: blah_id_seq.nextval: you don't have permissions to set sequence blah_id_seq Short of actually creating the sequence as "nmnuser", is there any way to make this work? Cheers, -- Alastair D'Silva (

[GENERAL] Inheritance and referential integritry in 7.0.3

2001-04-07 Thread Alastair D'Silva
* products a syntax error, and creating a view as the REFERENCES target is not allowed. Short of creating another table which stores all product ids, is there a simple way to make this work? Cheers, -- Alastair D'Silva (mob: 0413 485 733) Networking Consultant New Millennium Networking (web: http://www.newmillennium.net.au) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster