Re: Moving from Sybase to Postgres - Stored Procedures

From: Jaime Casanova <systemguards(at)yahoo(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Moving from Sybase to Postgres - Stored Procedures
Date: 2005-01-28 20:51:12
Message-ID: 20050128205112.28333.qmail@web50004.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- "Frank D. Engel, Jr." <fde101(at)fjrhome(dot)net>
escribió:
> a.
>
http://www.postgresql.org/docs/8.0/interactive/plpgsql-
>
> declarations.html
> b. (same page)
> c. ?
> d.
>
http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-
>
> structures.html#PLPGSQL-RECORDS-ITERATING
>
>
> This brings about a new question: Doesn't a PL/PGSQL
> function always
> execute within the context of a transaction? I'd
> think you can't
> create a transaction within one then, correct?
>
AFAIK.

But in pg8 you can use EXCEPTION blocks that are
implemented on the subtransaction mechanism, IIRC.

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message guegue 2005-01-28 21:28:25 upgrading to postgresql 8
Previous Message Joshua D. Drake 2005-01-28 20:44:31 Re: Moving from Sybase to Postgres - Stored Procedures