Re: data doesnt get saved in the database / idle in transaction

On Mon, Mar 20, 2006 at 08:03:14PM +0800, Qingqing Zhou wrote:
>
> ""Ksenia Marasanova"" <ksenia.marasanova@gmail.com> wrote
> >
> > The application uses persistant database connection, and when i check
> > the status of the connection, it shows: "idle in transaction".  I am
> > pretty sure that every insert is being committed with explicit
> > "commit()" . It always worked before.... weird.
> >
>
> Try to use the following command to see what commands reach the server:
>
>     set log_statement = "all";

I'd bet that the commits aren't making it over.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461