Skip site navigation (1) Skip section navigation (2)

connection status and lo

From: Volkan YAZICI <volkan(dot)yazici(at)gmail(dot)com>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: connection status and lo
Date: 2005-04-30 21:07:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

I've some questions about the relation between connection status and
large objects.

1) What'd be the effects of closing the connection before closing an
opened lo? (Would it cause any data corruption?)

2) You know, lo commans are placed within transaction blocks. And in a
transaction block, when the connection is lost, it's rolled back. So
this means, if I lost the connection before committing lo changes,
they'll all be rolled back, right?

3) And also, if I'd establish the connection again, will I be able to
use same file descriptior to access opened lo or will I need to call
lo_open() again?

Best regards.

pgsql-novice by date

Next:From: Ennio-SrDate: 2005-05-01 01:30:45
Subject: psql: Is it possible to run a query from a *sql file?
Previous:From: Tom LaneDate: 2005-04-30 16:52:43
Subject: Re: Problem with DirectFunctionCall3(array_in,...)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group