Re: how to switch a view easily?

[prev] [thread] [next] [Date index for 2005/04/20]

>>>>> "Brad" == Brad Bowman <bsb@xxxxxx.xxx> writes:

>> Certainly I can't be the first one to need this. :)

Brad> You're not.

Brad> I never solve it though, sorry to disappoint. :)

Brad> One idea I had but never delved deeply into was
Brad> dynamically changing the postgres schema search path.
Brad> Does that sound like a possible solution?

No, but hear me out... I think I have a solution.

I can override "transform_sql" to look for "booking"
and change it to
"(select * from booking where cancelled_date is not null) as booking".

This seems to work, even when I have funky natural joins and stuff
around it.

Has anyone tried overriding transform_sql?  Am I crazy?

        -- 
        Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@xxxxxxxxxx.xxx> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!