Re: Statement-level rollback

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Statement-level rollback
Date: 2017-03-08 00:02:48
Message-ID: DB5PR03MB1029B8E6B9841C6672938778902E0@DB5PR03MB1029.eurprd03.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

There was a mistake in my driver definition,

this works fine with autosave=always (but not with autoSave ...)

Thanks Again

________________________________
De : Vladimir Sitnikov [via PostgreSQL] <ml-node+s1045698n5948059h0(at)n3(dot)nabble(dot)com>
Envoyé : mardi 7 mars 2017 22:32:27
À : legrand legrand
Objet : Re: Statement-level rollback

Please disregard my previous message.
pgjdbc is already doing upcase conversion, so I would like to see a test case that reproduces the error.

Alternatively, could you please capture and share TRACE log? ( https://jdbc.postgresql.org/documentation/head/logging.html#configuration )

Vladimir

ср, 8 мар. 2017 г. в 1:26, Vladimir Sitnikov <[hidden email]</user/SendEmail.jtp?type=node&node=5948059&i=0>>:
legrand>when usingversion 42.0.0 with
legrand> jdbc:postgresql://localhost:5432/postgres?autosave=always

The pitfall there is the value should be written with upper case like autosave=ALWAYS.

I've filed https://github.com/pgjdbc/pgjdbc/issues/769 to improve that at some point.

Vladimir

________________________________
If you reply to this email, your message will be added to the discussion below:
http://www.postgresql-archive.org/Statement-level-rollback-tp5946725p5948059.html
To unsubscribe from Statement-level rollback, click here<http://www.postgresql-archive.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5946725&code=bGVncmFuZF9sZWdyYW5kQGhvdG1haWwuY29tfDU5NDY3MjV8MjA2NDQ0Mjc1MA==>.
NAML<http://www.postgresql-archive.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

--
View this message in context: http://www.postgresql-archive.org/Statement-level-rollback-tp5946725p5948076.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2017-03-08 00:14:07 Re: WIP: Faster Expression Processing v4
Previous Message Tom Lane 2017-03-08 00:02:04 Re: Bizarre choice of case for RELKIND_PARTITIONED_TABLE

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vladimir Sitnikov 2017-03-08 17:28:01 [pgjdbc/pgjdbc] 9c80ad: fix: make sure org.postgresql.Driver is loaded whe...
Previous Message Vladimir Sitnikov 2017-03-07 22:31:26 Re: [HACKERS] Statement-level rollback