From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: faking writable views as tables |
Date: | 2005-06-29 14:36:29 |
Message-ID: | 20050629143629.GA12689@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
From | Date | Subject | |
---|---|---|---|
Next Message | ketan shah | 2005-06-29 14:48:00 | how to use pg_dump and then restored onto development server |
Previous Message | Douglas McNaught | 2005-06-29 14:35:01 | Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users |