| From: | Darren Duncan <darren(at)darrenduncan(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Chrishelring <christianhelring(at)gmail(dot)com> |
| Subject: | Re: Uppercase to lowercase trigger? |
| Date: | 2012-05-03 17:21:27 |
| Message-ID: | 4FA2BE97.9090109@darrenduncan.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Chrishelring wrote:
> Hmm.. Haden´t thought about making a view. It should work because the
> application that uses the data is read-only (yet!).
>
> I´ll give that a try. Thanks!
Well a view is a much more natural solution than the other proposal, about
constantly doing data definition / changing the schemas for each access like
this proposal. In fact, what you talk about sounds like an ideal case for
views; you could have 2 complete schemas, one per application, where each
corresponds to the other but one is lowercase and one is uppercase, and one is a
view. -- Darren Duncan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gauthier, Dave | 2012-05-03 18:14:25 | privs drop after alter table |
| Previous Message | Martijn van Oosterhout | 2012-05-03 16:32:53 | Re: pqlib garbage collection |