On Wed, 28 Jun 2000, Andrés Mauricio Marín Restrepo wrote:
>
> HELLO!
>
> I'm making one trigger (plpgsql) and in the function i use CURSOR for to
>
> bring an elements and to take them to a variable but no me it does not
> work, WHY?????????????
>
> The script is:
>
> DROP TRIGGER miTrig on otro;
> DROP FUNCTION miFunc();
> DROP TABLE otro;
> DROP TABLE cual;
>
> CREATE TABLE otro (
> cuenta integer;
> );
>
> CREATE TABLE cual (
> cuenta1 integer;
> cuenta2 integer;
> );
>
> CREATE FUNCTION miFunc () RETURNS OPAQUE AS '
> DECLARE
> Cuenta_t INT4;
> BEGIN
> begin work;
Can't have nested transactions. Can't use BEGIN/COMMIT within a trigger.
--
Robert B. Easter
