Re: [GENERAL] faking writable views as tables

2005-06-29 Thread David Fetter
On Wed, Jun 29, 2005 at 01:56:04PM +0200, Enrico Weigelt wrote: > > Hi folks, > > > I'm using several writable views (-> update & insert rules) > and got trouble with pgadmin - it refuses to insert/edit > values since it sees the table as a view and believes views > are never writable. That

[GENERAL] faking writable views as tables

2005-06-29 Thread Enrico Weigelt
Hi folks, I'm using several writable views (-> update & insert rules) and got trouble with pgadmin - it refuses to insert/edit values since it sees the table as a view and believes views are never writable. So i've just set the reltype in pg_class to 'r'. The frontends now see it as a writeb