From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | Ben Trewern <ben(dot)trewern(at)_nospam_mowlem(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Treatment of views with associated rules - |
Date: | 2006-11-28 10:35:24 |
Message-ID: | 456C10EC.10706@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Ben Trewern wrote:
> All,
>
> I've just been trying to setup some updateable views using standard views
> and associated rules. Is there any possibility of when you open a view in
> the SQL editor the SQL for the associated rules also show up. It would seem
> to make sense. When a view is dropped the rules are silently dropped also
> so if you're not careful you loose them. (Happened once! :-()
>
> Thanks for your attention.
>
Hi Ben,
I intend to look at handling updateable views, but for the moment want
to hold off until we see some real code (hopefully) in 8.3-dev. I'm not
keen to have to do the work twice if PostgreSQL's view implementation
ends up changing drastically from what we currently have.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | kenp | 2006-11-28 16:45:45 | pgAdmin Funciton Code |
Previous Message | Dave Page | 2006-11-28 09:37:02 | Re: Constraint or index or both? |