Re: When the Session ends in PGSQL?

From: Vincent de Phily
Subject: Re: When the Session ends in PGSQL?
Date: ,
Msg-id: 1666708.qiXTFOCEF3@moltowork
(view: Whole thread, Raw)
In response to: Re: When the Session ends in PGSQL?  (Durumdara)
List: pgsql-general

Tree view

When the Session ends in PGSQL?  (Durumdara, )
 Re: When the Session ends in PGSQL?  (Andrew Sullivan, )
 Re: When the Session ends in PGSQL?  (Bill Moran, )
  Re: When the Session ends in PGSQL?  (Durumdara, )
   Re: When the Session ends in PGSQL?  (Bill Moran, )
    Re: When the Session ends in PGSQL?  (Durumdara, )
     Re: When the Session ends in PGSQL?  (Vincent de Phily, )
      Re: When the Session ends in PGSQL?  (Durumdara, )
       Re: When the Session ends in PGSQL?  (Vincent de Phily, )
        Re: When the Session ends in PGSQL?  (Durumdara, )
         Re: When the Session ends in PGSQL?  (Vincent de Phily, )
         Re: When the Session ends in PGSQL?  (Craig Ringer, )
          Re: When the Session ends in PGSQL?  (Durumdara, )
           Re: When the Session ends in PGSQL?  (Durumdara, )

On Monday 04 July 2011 13:50:46 Durumdara wrote:
> > The running query will be rolled back when the session ends. Note that
> > "when the session ends" must be understood from the server's point of
> > view, not the client's.
>
> As I understand you then running Queries forced to abort on the end of
> Session and no more Query running over the session's ending point (or
> after TCP connection broken).

Yes.

> > Stored procedures will remain. Note that "stored procedures" in postgres
> > are a bit different from what you may be used to in other dbs; while I
> > assure you it's for the better, you might want to RTFM to avoid
> > surprises.
>
> Please explain a little this (Just 1-2 sentence please).
> Or suggest me some info, if possible... :-) (Prayer) :-)
> I want to know about differences.

Sorry it's a vast subject, and what you would be surprised by depends on what
you expect. Start here :
http://www.postgresql.org/docs/9.0/static/xfunc.html
The postgres docs are well written; read them at your leisure like a book,
follow the links where curiosity leads you, it can actually be entertaining :)

--
Vincent de Phily


pgsql-general by date:

From: Michael Gould
Date:
Subject: How do I manually delete the odbc, oledb and .net drivers
From: "Jonathan Brinkman"
Date:
Subject: cannot "make USE_PGXS=1" b/c no pgxs.mk exists