Re: A generic trigger? - Mailing list pgsql-sql

From ow
Subject Re: A generic trigger?
Date
Msg-id 20030914102851.82497.qmail@web21403.mail.yahoo.com
Whole thread Raw
In response to Re: A generic trigger?  (Peter Childs <Blue.Dragon@blueyonder.co.uk>)
List pgsql-sql
--- Peter Childs <Blue.Dragon@blueyonder.co.uk> wrote:
>     Yes it is possible and I've done it. The reason I'm not using it is because
> I 
> wrote it in Pl/Python and if you attach the same trigger to more than one 
> table in the same transaction pg/python (actually the entire server crashes 
> but thats not the point) crashes. Well it did when I last tested it in early 
> versions. I'm still thinking of getting around to rewriting it in a language 
> without this bug, since nobody sounds like they are going to fix it. C might 
> be best!

[snip]

Hi,

In my case, "company" and "company_backup" tables have the *same* structure, so
I was hoping for a simpler solution using just plpgsql.

Any ideas? Thanks






__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com


pgsql-sql by date:

Previous
From: Peter Childs
Date:
Subject: Re: A generic trigger?
Next
From: "Rudi Starcevic"
Date:
Subject: Linked Lists example.