Re: Uppercase to lowercase trigger? - Mailing list pgsql-general

From Ken Tanzer
Subject Re: Uppercase to lowercase trigger?
Date
Msg-id CAD3a31WqQC0zKFjh_HzHrOUiNDBy3n_5s_-fAVeAJ-MMgeD5xw@mail.gmail.com
Whole thread Raw
In response to Re: Uppercase to lowercase trigger?  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Uppercase to lowercase trigger?
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.
>
> 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?

no, this is not possible. But you can write simple functions 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:

Previous
From: Pavel Stehule
Date:
Subject: Re: Uppercase to lowercase trigger?
Next
From: John R Pierce
Date:
Subject: Re: Uppercase to lowercase trigger?