Re: Treatment of views with associated rules -

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.

In response to

Browse pgadmin-support by date

  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?