From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Treat <xzilla@users.sourceforge.net>
Cc: gearond@cvc.net, Josh Berkus <josh@agliodbs.com>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] rewriting values with before trigger
Date: Thu, 24 Apr 2003 18:02:21 -0400
Message-ID: <24274.1051221741@sss.pgh.pa.us> (raw)
In-Reply-To: <1051213745.4752.572.camel@camel>
References: <1051201544.4753.522.camel@camel>
<200304240939.54070.josh@agliodbs.com>
<1051209495.7747.544.camel@camel>
<3EA836AF.8060704@cvc.net>
<1051212144.4752.558.camel@camel>
<3EA83C95.8070404@cvc.net>
<1051213745.4752.572.camel@camel>
Robert Treat <xzilla@users.sourceforge.net> writes:
> yeah, I've thought of some other crazy ways to get around this, but the
> problem is due to a bug in the application side. I was hoping I could
> write a quick hack (like adding a rule/trigger) to get around this until
> the app was fixed, but I'm not going to make my side a kludge when it
> isn't one now.
The only way I can see to do it is to make a view that has 'text'
datatypes in place of real ones, with an ON INSERT rule that invokes
your conversion functions and then inserts the result to the real table.
Dunno if that's too high on your kluge meter.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, xzilla@users.sourceforge.net, josh@agliodbs.com, pgsql-general@postgresql.org
Subject: Re: [SQL] rewriting values with before trigger
In-Reply-To: <24274.1051221741@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox