Re: executing a procedure withing a procedure? - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: executing a procedure withing a procedure?
Date
Msg-id 20060811234011.30977.qmail@web31813.mail.mud.yahoo.com
Whole thread Raw
In response to Re: executing a procedure withing a procedure?  ("ben sewell" <mosherben@gmail.com>)
List pgsql-novice

--- ben sewell <mosherben@gmail.com> wrote:

> Hi Keith,
> thanks for your reply.
>
> What about inserting and deleting data? what do I need on the database
> server?
>

With pass-throught queries you can send the inserts or deletes.

or you can bind your form directly to an "updateable/insertable/deleteable" view using the rule
system.  Rules on the view will handle all of the processing for you.  There is a little bit of
set-up required however:

http://www.postgresql.org/docs/8.1/interactive/rules-update.html

Regards,

Richard Broersma Jr.

pgsql-novice by date:

Previous
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Minimising disk writes
Next
From: Richard Broersma Jr
Date:
Subject: Re: Unable to connect to PostgreSQL 8 from PGAdmin III