Re: executing a procedure withing a procedure?

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: ben sewell <mosherben(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: executing a procedure withing a procedure?
Date: 2006-08-11 23:40:11
Message-ID: 20060811234011.30977.qmail@web31813.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

--- ben sewell <mosherben(at)gmail(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2006-08-11 23:44:49 Re: Unable to connect to PostgreSQL 8 from PGAdmin III
Previous Message Andrej Ricnik-Bay 2006-08-11 20:27:46 Re: Minimising disk writes