Transaction with in function

--_000_46AC8D44F3AE1F4888F137837D0DF635072561999FINHYWEXMB2i nf_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable


I know that postgresql does not support nested transactions,

I looking for solution for commit, rollback with in function. May be using =
the save point.

I were to use save point in function , when it would get commit.?



Thanks in advance .

Regards
Ravi Katkar





--_000_46AC8D44F3AE1F4888F137837D0DF635072561999FINHYWEXMB2i nf_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

hemas-microsoft-com:office:word" xmlns:st1=3D"urn:schemas-microsoft-com:off=
ice:smarttags" xmlns=3D"http://www.w3.org/TR/REC-html40">




name=3D"place"/>

Re: Transaction with in function

Ravi Katkar wrote:

> I know that postgresql does not support nested transactions,
>
> I looking for solution for commit, rollback with in function. May
> be using the save point.

That is essentially the same as nested transactions, isn't it? Just
using SQL standard syntax?

> I were to use save point in function , when it would get commit.?

Each savepoint creates a subtransaction which will be included in
the top level transaction unless it or an intermediate savepoint is
rolled back. Nothing from the top level transaction is visible to
other transactions until the commit of the top level transaction.

If this and the docs don't make it clear, please post again:

http://www.postgresql.org/docs/8.4/interactive/sql-savepoint .html

If you do post again, please include your PostgreSQL version and an
explanation of what problem you're trying to solve. More specific
questions tend to elicit more useful responses:

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Oracle"s Long data type equivalent data type in Postgresql ?

--_000_46AC8D44F3AE1F4888F137837D0DF63507256199A3INHYWEXMB2i nf_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi ,

What is the Oracle's Long data type equivalent data type in Postgresql ?

Regards,
Ravi katkar




--_000_46AC8D44F3AE1F4888F137837D0DF63507256199A3INHYWEXMB2i nf_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

hemas-microsoft-com:office:word" xmlns:st1=3D"urn:schemas-microsoft-com:off=
ice:smarttags" xmlns=3D"http://www.w3.org/TR/REC-html40">




name=3D"place"/>

Re: Oracle"s Long data type equivalent data type in Postgresql ?

zqPPhM65z4IgRnJpZGF5IDI4IE1heSAyMDEwIDExOjQ1OjE3IM6/L863IFJh
dmkgS2F0a2FyIM6tzrPPgc6xz4jOtToKPiBIaSAsCj4gCj4gV2hhdCBpcyB0
aGUgIE9yYWNsZSdzICBMb25nIGRhdGEgdHlwZSBlcXVpdmFsZW50IGRhdGEg
dHlwZSAgaW4gUG9zdGdyZXNxbCA/Cj4gCgppbnQ4IGkgZ3Vlc3MKCj4gUmVn
YXJkcywKPiBSYXZpIGthdGthcgo+IAo+IAo+IAo+IAoKCgotLSAKQWNoaWxs
ZWFzIE1hbnR6aW9zCgotLSAKU2VudCB2aWEgcGdzcWwtYWRtaW4gbWFpbGlu
ZyBsaXN0IChwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZykKVG8gbWFrZSBj
aGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3LnBvc3Rn
cmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLWFkbWluCg==

Re: Oracle"s Long data type equivalent data type in Postgresql ?

=20

> -----Original Message-----
> From: Achilleas Mantzios [mailto:achill@matrix.gatewaynet.com]=20
> Sent: Friday, May 28, 2010 5:03 AM
> To: pgsql-admin@postgresql.org
> Subject: Re: Oracle's Long data type equivalent data type in=20
> Postgresql ?
>=20
> Óôéò Friday 28 May 2010 11:45:17 =EF/=E7 Ravi Katkar Ýãñá=
øå:
> > Hi ,
> >=20
> > What is the Oracle's Long data type equivalent data type
> in Postgresql ?
> >=20
>=20
> int8 i guess
>=20
> > Regards,
> > Ravi katkar
> >=20
> >=20
> >=20
> >=20
>=20
>=20
>=20
> --
> Achilleas Mantzios
>=20

No, it's bytea (and not int8).

Igor Neyman

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin