Re: faking writable views as tables

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 would be a pgadmin bug.  Please report it to them.

> So i've just set the reltype in pg_class to 'r'. The frontends
> now see it as a writeble table again, but when dropping the
> table, i've got a warning, that some file (seems to be
> <oid-of-schema>/<oid-of-table>) could not be deleted.
> Is this the table storage file, which simply doesn't exist
> on views ?
>
> Are my changes to pg_class dangerous in any way ?

Yes.

The current way to do writeable VIEWs is through the RULE system, not
with TRIGGERs :)

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!