Re: [SQL] Database Synchronization

2007-07-24 Thread Jyoti Seth
Hello, Thanks Andrew for the solution. I have successfully installed following rpm postgresql-slony1-engine-1.1.5-1_PG8.1.4.i686.rpm available at http://main.slony.info/downloads/1.1/rpm/. But when I am trying to set a cluster its throwing a following error: stdin:4: PGRES_FATAL_ERROR load

[SQL] is there a 'table' data type in pg?

2007-07-24 Thread Louis-David Mitterrand
Hello, In my forum app a new post can be related to several types of objects: person, location, event, simple text subject, etc. so in my 'forum' table I plan to add an id_subject column which can contain a reference to any number of different tables (location, person, etc.). What I need to

Re: [SQL] is there a 'table' data type in pg?

2007-07-24 Thread Louis-David Mitterrand
On Tue, Jul 24, 2007 at 03:10:44PM +0100, Gregory Stark wrote: Louis-David Mitterrand [EMAIL PROTECTED] writes: Can I use a another column to store the type of the id_subject (ie: the tabled it belongs to) ? Then I would be able to query that table for additional info to print alongside

Re: [SQL] is there a 'table' data type in pg?

2007-07-24 Thread Peter Childs
On 24/07/07, Louis-David Mitterrand [EMAIL PROTECTED] wrote: On Tue, Jul 24, 2007 at 03:10:44PM +0100, Gregory Stark wrote: Louis-David Mitterrand [EMAIL PROTECTED] writes: Can I use a another column to store the type of the id_subject (ie: the tabled it belongs to) ? Then I would be able

[SQL] inheriting a rule or a trigger?

2007-07-24 Thread Louis-David Mitterrand
Hi, I'm trying to protect created_by and created_on columns from accidental update. Most of my tables inherit from a 'source' table that has those columns, so I was thinking of creating a rule or trigger that does nothing on update to these columns. But apparently rules and triggers don't