On Wed, Sep 7, 2011 at 11:32 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Dave Cramer p...@fastcrypt.com writes:
Well the problem is that buildfarm can't build HEAD on OS X 10.7.1
HEAD builds fine on my 10.7.1 laptop. If you're referring to orangutan,
it's not failing on that, it's failing here
I have a need to test timeouts in JDBC, is there a query that is
guaranteed not to return ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
the client encoding is unicode.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Mon, Apr 18, 2011 at 11:14 AM, Mike Fowler m...@mlfowler.com wrote:
On 18/04/11 15:57, Tom Lane wrote:
Bernd Helmlemaili...@oopsware.de writes:
If i am reading it correct, it reads UTF8 from the backend, while
expecting UNICODE only. Not sure what change has caused this,
though.
I am
On Mon, Apr 18, 2011 at 11:24 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Dave Cramer p...@fastcrypt.com writes:
On Mon, Apr 18, 2011 at 10:57 AM, Tom Lane t...@sss.pgh.pa.us wrote:
I wasn't aware that JDBC would fail on that. It's pretty annoying that
it does, but maybe we should grin and bear
Marc,
Please just send a cvs context diff from HEAD to the JDBC list.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
2011/5/17 Marc-André Laverdière marc-an...@atc.tcs.com:
Hello developers,
My project had a requirement to use certificate authentication to the PG
On 16 January 2015 at 01:33, Noah Misch n...@leadboat.com wrote:
On Thu, Jan 15, 2015 at 09:24:01AM -0500, Robert Haas wrote:
On Thu, Jan 15, 2015 at 1:04 AM, Noah Misch n...@leadboat.com wrote:
On Wed, Jan 14, 2015 at 04:48:53PM -0500, Peter Eisentraut wrote:
What I'm seeing now is that
Not sure what the point of this is: as you indicated the ship has sailed so
to speak
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 15 May 2015 at 15:14, Bruno Harbulot br...@distributedmatter.net wrote:
Hello,
I've been trying to use the new JSONB format using JDBC
On 15 May 2015 at 16:41, Robert Haas robertmh...@gmail.com wrote:
On Fri, May 15, 2015 at 4:38 PM, Dave Cramer p...@fastcrypt.com wrote:
I don't really want to take a violently strong position on this
without understanding what's really going on here.
Well our solution was to use
On 15 May 2015 at 16:21, Robert Haas robertmh...@gmail.com wrote:
On Fri, May 15, 2015 at 4:13 PM, Dave Cramer p...@fastcrypt.com wrote:
Not sure what the point of this is: as you indicated the ship has sailed
so
to speak
Well, if we were to agree this was a problem, we could introduce
On 15 May 2015 at 16:35, Robert Haas robertmh...@gmail.com wrote:
On Fri, May 15, 2015 at 4:23 PM, Dave Cramer p...@fastcrypt.com wrote:
Well, if we were to agree this was a problem, we could introduce new,
less-problematic operator names and then eventually deprecate the old
ones
On 15 May 2015 at 16:44, Dave Cramer p...@fastcrypt.com wrote:
On 15 May 2015 at 16:41, Robert Haas robertmh...@gmail.com wrote:
On Fri, May 15, 2015 at 4:38 PM, Dave Cramer p...@fastcrypt.com wrote:
I don't really want to take a violently strong position on this
without understanding
custom
operators is a separate discussion.
David J.
It would seem that choosing ? for operators was ill advised; I'm not
convinced that deprecating them is a bad idea. If we start now, in 5 years
they should be all but gone
Agreed a patch would be the first place to start
Dave Cramer
be faster than what's there now (when the option was not
set). Some operators would look a little funny in Java string
literals, but that's not so bad.
Perhaps reviewing https://github.com/pgjdbc/pgjdbc/pull/187 might help
understand why we chose ??
Dave Cramer
dave.cramer(at)credativ(dot)ca
http
noticed this one thought was to create duplicate operators
specifically for the use of the JDBC driver.
I had dismissed this at the time, now I'm not so sure
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 19 May 2015 at 13:15, Mike Blackwell mike.blackw...@rrd.com wrote:
A Google search suggests Oracle 9.x supports a unary '?' operator (fuzzy
match), so the use of '?' in an operator name is not without precedent
connector expected to follow both?
Currently pull requests are the easiest to deal with so most discussion is
on github.
I guess updating the JDBC web page would be in order.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 19 May 2015 at 15:02, Tom Lane t...@sss.pgh.pa.us wrote:
Greg Sabino Mullane g...@turnstep.com writes:
Dave Cramer opined:
It would seem that choosing ? for operators was ill advised; I'm not
convinced that deprecating them is a bad idea. If we start now, in 5
years
they should
Add
DriverManager.setLogWriter(new PrintWriter(System.out));
below the setLogLevel and it will
I'll fix this though
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 October 2015 at 22:35, Tatsuo Ishii <is...@postgresql.org> wrote:
> Unfortunately it doesn't work (no de
No, I need to provide you with a 41 version.
I just happened to have java 1.8 on my machine.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 October 2015 at 21:31, Tatsuo Ishii <is...@postgresql.org> wrote:
> Dave,
>
> Thanks for the quick response. Unfortunately
This should work better
https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc41-SNAPSHOT/
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 October 2015 at 21:32, Dave Cramer <p...@fastcrypt.com> wrote:
> No, I need to pr
Tatsuo,
Can you confirm it is fixed in this snapshot
https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc42-SNAPSHOT/
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 October 2015 at 19:00, Dave Cramer <p...@fastcrypt.com>
Tatsuo,
posting to jdbc list
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 October 2015 at 18:28, Tatsuo Ishii <is...@postgresql.org> wrote:
> It seems
> org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does
> not work anymore in the newer JDBC dri
We have an interesting problem, and the reporter has been kind enough to
provide logs for which we can't explain.
I'd be interested to hear any plausible explanations for a prepared plan
suddenly going from 2ms to 60ms for the same input values ?
Dave Cramer
da...@postgresintl.com
Hi Marko,
Interesting so why would it choose a worse plan at that point ? Why would
it change at all if the current plan is working well ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 12 January 2016 at 07:15, Marko Tiikkaja <ma...@joh.to> wrote:
> On 12/01/16 13:00, Da
here.
There is an impedance mismatch between the java ecosystem and distros.
We have moved to maven as have most other java projects.
As Craig said, if you want to build it, patch it out, and create a
ant/Makefile to make the jar.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
Getting lots of POSTGRESQL_TRACE_... undefined.
Any hints ?
Dave Cramer
to turn this question around. Are there good reasons to use -ng
over pgjdbc ?
As to your question, you may be interested to know that pgjdbc is more
performant than ng.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 3 April 2016 at 15:35, Stephen Frost <sfr...@snowman.net> wrote:
> * Dave Cramer (p...@fastcrypt.com) wrote:
> > On 9 March 2016 at 20:49, Craig Ringer <cr...@2ndquadrant.com> wrote:
> >
> > > On 10 March 2016 at 00:41, Igal @ Lucee.org <i...@lucee.org&g
On 3 April 2016 at 12:18, Igal @ Lucee.org <i...@lucee.org> wrote:
> On 4/3/2016 8:21 AM, Dave Cramer wrote:
>
>
> On 9 March 2016 at 20:49, Craig Ringer <cr...@2ndquadrant.com> wrote:
>
>> On 3/8/2016 5:12 PM, Craig Ringer wrote:
>>
>>>
>>
On 3 April 2016 at 21:56, Stephen Frost <sfr...@snowman.net> wrote:
> Dave,
>
> * Dave Cramer (p...@fastcrypt.com) wrote:
> > On 3 April 2016 at 15:35, Stephen Frost <sfr...@snowman.net> wrote:
> > > Not generally much of a JDBC user myself, but the inabili
On 3 April 2016 at 22:20, Stephen Frost <sfr...@snowman.net> wrote:
> * Craig Ringer (cr...@2ndquadrant.com) wrote:
> > On 4 April 2016 at 10:13, Dave Cramer <p...@fastcrypt.com> wrote:
> > > Async notification is the easier part, I wasn't aware that the ssl
&g
ON with no inserted whitespace.
>
> As I mentioned to Sehrope on IRC, at least for my 2c, if you want a
> compact JSON format to reduce the amount of traffic over the wire or to
> do things with on the client side, we should probably come up with a
> binary format, rather than just ha
Does anyone else have a Windows 7 installation we can test this on ?
This
https://github.com/postgres-plr/plr/files/191013/plr-8.3.0.16-pg9.5-win32.zip
is actually a 64 bit version built on windows 10. I've had one confirmation
that it works.
Dave
Dave Cramer
da...@postgresintl.com
tests every time a PR is created on github, but I don't
think there are any animals running the JDBC test suite
We can add tests, what exactly do we want to test. Then setting up an
animal to run the tests would be fairly straight forward.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
u're doing
> something very different - not necessarily wrong - and not attempt to
> impose your ideas on everyone as if it's the only true way to write a db
> driver.
>
A number of other drivers default to this behaviour, including at least
MS-SQL and Oracle. psqlODBC
; calling jvm from sql or vice-versa is not really possible.
I do like the idea of the background worker and shared memory though.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
> 3) Add build badge to the readme (link to travis ci build) for simplified
> navigation to test results.
>
> Here's the commit: https://github.com/vlsi/postgres/commit/
> 4841f8bc00b7c6717d91f51c98979ce84b4f7df3
> Here's how test results look like: https://travis-ci.org/vlsi/postgres
>
>
Nice work +!
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
that both JDBC and ODBC are not exclusively
PostgreSQL drivers and as such we sometimes have to jump through hoops to
provide the semantics requested by the API.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
The travis job https://travis-ci.org/pgjdbc/pgjdbc/jobs/192517342 is seeing
a segfault when we are testing against HEAD with REPLICATION turned on.
Logs can be found here
https://drive.google.com/drive/folders/0B-Heg5ZYCWbreEE4Uk5LdnJ5eWM?usp=sharing
Regards,
Dave Cramer
Not sure you can get the exec. We are working on producing the BT from
Travis-CI or I will build and run the test locally and get the trace
Dave Cramer
On 19 January 2017 at 15:31, Craig Ringer <craig.rin...@2ndquadrant.com>
wrote:
>
>
> On 20 Jan. 2017 04:13, "Ro
I'll try to get the stack trace from the core dump, have to build master
first
Dave Cramer
On 19 January 2017 at 12:01, Jorge Solórzano <jor...@gmail.com> wrote:
> Robert, the logs I get from postgres (at least the section that matters)
> is here:
> If you need somethin
= 140728909791233, hash = 0x7ffe96960d58,
match = 0x16da2d1, keycopy = 0x7ffe96960d58, alloc = 0x1703af0,
hcxt = 0x16da2d0, hctl = 0x0}
max_table_size = 117899280
requestSize =
found = 0 '\000'
Dave Cramer
On 19 January 2017 at 12:05, Dave Cramer <dave
bc, npgsql CCed).
>
> Currently PGPASS is in the users home directory Many JDBC applications are
in much larger apps such as tomcat, etal
this concept is a bit foreign to JDBC. That being said I don't think it's
difficult to implement. Just somewhat harder to specify
for us. psql is rather limited being a command line app which is *usually*
evoked directly from the command line.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
ight not have been the best thing to do in
> a green field, but given the precedent ...
>
> regards, tom lane
>
>
> seems to me that it should report 10 for the major and whatever comes
after the . for the minor ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
"inner" and "outer" dimensions? I wonder
> if that would be easier to read, if it was written in a recursive-style,
> rather than iterative with stacks for the dimensions.
>
> Yes, it is fairly convoluted.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 27 September 2016 at 14:58, Heikki Linnakangas <hlinn...@iki.fi> wrote:
> On 09/27/2016 02:04 PM, Dave Cramer wrote:
>
>> On 26 September 2016 at 14:52, Dave Cramer <p...@fastcrypt.com> wrote:
>>
>>> This crashes with arrays with non-default lower bou
On 18 September 2016 at 09:27, Dave Cramer <p...@fastcrypt.com> wrote:
>
> On 10 August 2016 at 01:53, Pavel Stehule <pavel.steh...@gmail.com> wrote:
>
>> Hi
>>
>> 2016-08-03 13:54 GMT+02:00 Alexey Grishchenko <agrishche...@pivotal.io>:
>>
>
Pavel,
I will pick these up.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
t; I am sending review of this patch:
>
> 1. The implemented functionality is clearly benefit - passing MD arrays,
> pretty faster passing bigger arrays
> 2. I was able to use this patch cleanly without any errors or warnings
> 3. There is no any error or warning
> 4. All tests passed - I tested Python 2.7 and Python 3.5
> 5. The code is well commented and clean
> 6. For this new functionality the documentation is not necessary
>
> 7. I invite more regress tests for both directions (Python <-> Postgres)
> for more than two dimensions
>
> My only one objection is not enough regress tests - after fixing this
> patch will be ready for commiters.
>
> Good work, Alexey
>
> Thank you
>
> Regards
>
> Pavel
>
>
>> --
>> Best regards,
>> Alexey Grishchenko
>>
>
>
Pavel,
I will pick this up.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
Yes, this should be closed as it is contained in
https://commitfest.postgresql.org/10/697/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 26 September 2016 at 14:52, Dave Cramer <p...@fastcrypt.com> wrote:
>
>
>
>>
>> This crashes with arrays with non-default lower bounds:
>>
>> postgres=# SELECT * FROM test_type_conversion_array_int
>> 4('[2:4]={1,2,3}');
>> INFO: ([1, 2
and they see no problems.
Please speak up now if you foresee any issues with this idea.
FYI, 42 was more or less chosen at random. But it is large enough to avoid
any future conflicts with the server, and greater than 9 to avoid issues
with maven requesting things like > 9
Dave Cramer
On 27 November 2016 at 11:29, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Dave Cramer <davecra...@gmail.com> writes:
> > We are proposing changing the JDBC version from
> > 9.4. to 42.x.x
>
> > We have two issues we are trying to address here.
>
> &g
t think it would be too painful to adjust existing
>> application.
>>
>> We could continue to accept a Python list for a plain composite type,
>> this would only affect arrays of composite types.
>>
>> I don't use PL/python much myself, so I don't feel qualified to make the
>> call, though. Any 3rd opinions?
>
>
Can't you determine the correct output based on the function output
definition ?
For instance if the function output was an array type then we would return
the list as an array
if the function output was a set of then we return tuples ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
That will teach me to copy and paste a config from somewhere ...
Thanks
Dave Cramer
On 9 December 2016 at 10:43, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Dave Cramer <davecra...@gmail.com> writes:
> > Looking at src/port/pg_strong_random.c this would be a bug in autoconf
&
--with-libraries=/usr/local/opt/openssl/lib
--with-includes=/usr/local/opt/openssl/include/ --no-create --no-recursion
I am using openssl-1.0.2j
Regards,
Dave Cramer
with, and ultimately outlast, venture-funded startups.
>
Thanks for your hard work. PostgreSQL has come a long way since then!
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
You have to turn it on using the autosave parameter. it's not on by
default, and apparently not documented
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 7 March 2017 at 17:15, legrand legrand <legrand_legr...@hotmail.com>
wrote:
> Thanks !
>
> that's a very good
llback-explained.html
>
> JDBC has it since 9.4.1210 (2016-09-07), unless I am mistaken:
>
> https://github.com/pgjdbc/pgjdbc/commit/adc08d57d2a9726309ea80d574b1db
> 835396c1c8
I thought he meant we have to play with savepoints.
Yes, we do it for you now
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
869>
Thanks,
Dave Cramer
log
when log_replication_commands is enabled. Passing database as the value
instructs walsender to connect to the database specified in the dbname
parameter, which will allow the connection to be used for logical
replication from that database.
Dave Cramer
encourage them to do so.
>>>>>
>>>>
>>>> I have added this as an open item because we will have to wait to see
>>>> where we are with driver support as the release gets closer.
>>>>
>>>
>>> With the release near, I'm promo
Too late I just stumbled over this as well!
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 20 September 2017 at 14:34, Tom Lane <t...@sss.pgh.pa.us> wrote:
> It seems to install some libraries that depend on
> /usr/lib/system/libsystem_darwin.dylib, which doesn't exist
Tom,
Did you ever find a solution to this without updating ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 21 September 2017 at 13:01, Dave Cramer <p...@fastcrypt.com> wrote:
> Too late I just stumbled over this as well!
>
> Dave Cramer
>
> d
301 - 365 of 365 matches
Mail list logo
