Re: Uppercase to lowercase trigger? - Mailing list pgsql-general
What if you created separate tables with the fields in uppercase, either with different names or better yet the same names and a different schema? It seems you could put triggers on those tables, and have your trigger translate the field names and make the updates to the real tables instead.
Seems like a lot of work, though, that could be avoided if you could get your app to drop the quoting of field names, and have it automatically fold to lower case...
--
On Thu, May 3, 2012 at 12:41 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hello
2012/5/3 Chrishelring <christianhelring@gmail.com>:> Maybe I should clarify what I mean.no, this is not possible. But you can write simple functions that
>
> I have a db (postgresql 8.4.1 with a postGIS spatial extension) with about
> 200+ tables in it. Some of them is supposed to be updated using an
> application what requres that some of the columns are in uppercase (a
> leftover from Oracle I suppose) but the main application that uses these
> tables requres that the columns are in lowercase. I had an idea that using a
> trigger I could chance the columns from lowercase to uppercase before
> updating /changing the tables and after the update chance them back to
> lowercase. Is that possible and how do I do that?
verifies names and you can call this function manually when you do
some changes, or you can call this function from cron.
Regards
Pavel Stehule
>
> Christian
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Uppercase-to-lowercase-trigger-tp5680384p5682473.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
AGENCY Software
A data system that puts you in control
(253) 245-3801
pgsql-general by date: