From: | Rod Taylor <rbt(at)rbt(dot)ca> |
---|---|
To: | snpe <snpe(at)snpe(dot)co(dot)yu> |
Cc: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: problem with new autocommit config parameter and jdbc |
Date: | 2002-09-11 12:38:44 |
Message-ID: | 1031747925.90974.35.camel@jester |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
> > > Why rollback.This is error (typing error).Nothing happen.
> > > I think that we need clear set : what is start transaction ?
> > > I think that transaction start with change data in database
> > > (what don't change data this start not transaction.
> >
> > Another interesting case for a select is, what about
> > select func(x) from table;
> > Does func() have any side effects that might change data?
> > At what point do we decide that the statement needs a
> > transaction?
> Function in select list mustn't change any data.
> What if function change data in from clause ?
Why can't the function change data? I've done this one a number of
times through views to log the user pulling out information from the
system, and what it was at the time (time sensitive data).
--
Rod Taylor
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-09-11 12:43:03 | Re: problem with new autocommit config parameter and jdbc |
Previous Message | Manfred Koizar | 2002-09-11 09:35:55 | Re: Proposal: Solving the "Return proper effected tuple count from complex commands [return]" issue |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-09-11 12:43:03 | Re: problem with new autocommit config parameter and jdbc |
Previous Message | Teofilis Martisius | 2002-09-11 09:57:35 | new String(byte[]) performance |