From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Rajesh Kumar Mallah. <mallah@trade-india.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Cascading deletions does not seem to work inside PL/PGSQL
Date: Tue, 16 Jul 2002 09:11:13 -0700 (PDT)
Message-ID: <20020716090915.M50015-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <200207161655.14794.mallah@trade-india.com>
On Tue, 16 Jul 2002, Rajesh Kumar Mallah. wrote:
> Hi folks,
>
> This problem has been troubling me for quite sometime and
> I would be very thankful for your help.
>
> I have included the complete commented script to recreate the problem in
> question.
>
> The problem is inside a plpgsql function i do not see the records in the slave tables
> getting deleted when i delete the corresponing referenced record from the master table.
>
> But things as expected inside a Transaction at the PSQL prompt.
It should get deleted, but it won't be deleted until the end of the
user's sql statement (ie, not until after the function has finished).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, mallah@trade-india.com
Subject: Re: Cascading deletions does not seem to work inside PL/PGSQL
In-Reply-To: <20020716090915.M50015-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox