Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Insert into view

From: Theo Kramer <theo(at)flame(dot)co(dot)za>
To: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Insert into view
Date: 1999-11-30 15:34:12
Message-ID: 3843EE74.AA2E0AB2@flame.co.za (view raw or flat)
Thread:
Lists: pgsql-hackers
"Ansley, Michael" wrote:
> 
> I think this was covered a little while back, but it runs something like
> this:  a view is a relation, with a select rule (which is the view query).
> When you insert into the view (which, like I said, is just another relation,
> it actually inserts into the view relation.  However, when you select from
> it, of course, the select rule fires, and you don't see any of the
> information.  I suppose you could set up a nice insert rule to insert into
> the base tables of the query if you wanted.  I normally do this through
> stored procs, but this would be essentially the same thing, just nicer
> client-side SQL.

Hmm, interesting.

> I suppose that views could be made so that a tuple insert would fail, but
> you should know your db better ;-)

That I do, just thought a message might assist those that don't :)

--------
Regards
Theo

In response to

pgsql-hackers by date

Next:From: Oleg BartunovDate: 1999-11-30 16:03:00
Subject: Re: [ADMIN] When postgres will be faster?
Previous:From: sk.listDate: 1999-11-30 15:11:36
Subject: Re: [ADMIN] When postgres will be faster?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group