Re: [HACKERS] PSA: don't be in a hurry to update to XCode 9.0

2017-11-12 Thread Dave Cramer
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 wrote: > Too late I just stumbled over this as well! > > Dave Cramer > > da...@postgresintl.com > www.postgres

Re: [HACKERS] PSA: don't be in a hurry to update to XCode 9.0

2017-09-21 Thread Dave Cramer
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 wrote: > It seems to install some libraries that depend on > /usr/lib/system/libsystem_darwin.dylib, which doesn't exist. > Googling sugge

Re: [HACKERS] SCRAM in the PG 10 release notes

2017-09-14 Thread Dave Cramer
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 promotin

[HACKERS] JDBC 42.1.4 released

2017-08-01 Thread Dave Cramer
869> Thanks, Dave Cramer

[HACKERS] question about replication docs

2017-05-29 Thread 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

Re: [HACKERS] Statement-level rollback

2017-03-07 Thread Dave Cramer
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 wrote: > Thanks ! > > that's a very good new ! > > > I&

Re: [HACKERS] Statement-level rollback

2017-03-07 Thread Dave Cramer
gt; 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

Re: [JDBC] [HACKERS] PGSERVICEFILE as a connection string parameter

2017-02-27 Thread Dave Cramer
; 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

Re: [HACKERS] [JDBC] SEGFAULT in HEAD with replication

2017-01-19 Thread 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 wrote: > > > On 20 Jan. 2017 04:13, "Robert Haas" wrote: > > On Thu, Jan 1

Re: [HACKERS] [JDBC] SEGFAULT in HEAD with replication

2017-01-19 Thread Dave Cramer
= 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 Cra

Re: [HACKERS] [JDBC] SEGFAULT in HEAD with replication

2017-01-19 Thread Dave Cramer
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 wrote: > Robert, the logs I get from postgres (at least the section that matters) > is here: > If you need something else just ask... > &

[HACKERS] SEGFAULT in HEAD with replication

2017-01-19 Thread Dave Cramer
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

Re: [HACKERS] Retiring from the Core Team

2017-01-12 Thread Dave Cramer
tely 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

Re: [HACKERS] building HEAD on macos fails with #error no source of random numbers configured

2016-12-09 Thread Dave Cramer
That will teach me to copy and paste a config from somewhere ... Thanks Dave Cramer On 9 December 2016 at 10:43, Tom Lane wrote: > Dave Cramer writes: > > Looking at src/port/pg_strong_random.c this would be a bug in autoconf > > It looks more like self-inflicted d

[HACKERS] building HEAD on macos fails with #error no source of random numbers configured

2016-12-09 Thread Dave Cramer
--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

Re: [HACKERS] RFC Changing the version number for JDBC

2016-11-27 Thread Dave Cramer
On 27 November 2016 at 11:29, Tom Lane wrote: > Dave Cramer 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. > > > 1) we do not want to be tied to the server release sched

[HACKERS] RFC Changing the version number for JDBC

2016-11-27 Thread Dave Cramer
s 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

Re: [HACKERS] PL/Python adding support for multi-dimensional arrays

2016-10-10 Thread Dave Cramer
djust 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

Re: [HACKERS] PL/Python adding support for multi-dimensional arrays

2016-09-29 Thread Dave Cramer
On 27 September 2016 at 14:58, Heikki Linnakangas wrote: > On 09/27/2016 02:04 PM, Dave Cramer wrote: > >> On 26 September 2016 at 14:52, Dave Cramer wrote: >> >>> This crashes with arrays with non-default lower bounds: >>>> >>>> postgres=#

Re: [HACKERS] PL/Python adding support for multi-dimensional arrays

2016-09-27 Thread Dave Cramer
On 26 September 2016 at 14:52, Dave Cramer 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, ], ) >> serve

Re: [HACKERS] PL/Python adding support for multi-dimensional arrays

2016-09-26 Thread Dave Cramer
e > the comments there mixing up the "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

Re: [HACKERS] PL/Python adding support for multi-dimensional arrays

2016-09-21 Thread Dave Cramer
On 18 September 2016 at 09:27, Dave Cramer wrote: > > On 10 August 2016 at 01:53, Pavel Stehule wrote: > >> Hi >> >> 2016-08-03 13:54 GMT+02:00 Alexey Grishchenko : >> >>> On Wed, Aug 3, 2016 at 12:49 PM, Alexey Grishchenko < >>> agrishc

Re: [HACKERS] Fix for PL/Python slow input arrays traversal issue

2016-09-19 Thread Dave Cramer
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

Re: [HACKERS] PL/Python adding support for multi-dimensional arrays

2016-09-18 Thread Dave Cramer
is 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

Re: [HACKERS] Fix for PL/Python slow input arrays traversal issue

2016-09-18 Thread Dave Cramer
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

Re: [HACKERS] [PATCH] Send numeric version to clients

2016-08-29 Thread Dave Cramer
t 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

Re: [HACKERS] Slowness of extended protocol

2016-08-15 Thread Dave Cramer
ing to keep in mind is 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

Re: [HACKERS] Slowness of extended protocol

2016-08-13 Thread Dave Cramer
7;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 a

Re: [HACKERS] No longer possible to query catalogs for index capabilities?

2016-08-08 Thread Dave Cramer
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

Re: [HACKERS] regression test for extended query protocol

2016-08-03 Thread Dave Cramer
reated 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

Re: [HACKERS] One process per session lack of sharing

2016-07-18 Thread Dave Cramer
ng 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

Re: [HACKERS] SPI_exec ERROR in pl/r of R 3.2.4 on PostgreSQL on Windows 7

2016-05-03 Thread Dave Cramer
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...@postgresint

Re: [HACKERS] Add jsonb_compact(...) for whitespace-free jsonb to text

2016-04-27 Thread Dave Cramer
tioned 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 hack out the whitespace. It's not like > representing numbers using ASCII characters is terribly efficient > either. > > +1 Dave Cramer da...@postgresintl.com www.postgresintl.com

Re: [HACKERS] Proposal: RETURNING primary_key()

2016-04-03 Thread Dave Cramer
On 3 April 2016 at 22:20, Stephen Frost wrote: > * Craig Ringer (cr...@2ndquadrant.com) wrote: > > On 4 April 2016 at 10:13, Dave Cramer wrote: > > > Async notification is the easier part, I wasn't aware that the ssl > library > > > had this problem though &

Re: [HACKERS] Proposal: RETURNING primary_key()

2016-04-03 Thread Dave Cramer
On 3 April 2016 at 21:56, Stephen Frost wrote: > Dave, > > * Dave Cramer (p...@fastcrypt.com) wrote: > > On 3 April 2016 at 15:35, Stephen Frost wrote: > > > Not generally much of a JDBC user myself, but the inability to avoid > > > polling for LISTEN notifi

Re: [HACKERS] Proposal: RETURNING primary_key()

2016-04-03 Thread Dave Cramer
On 3 April 2016 at 12:18, Igal @ Lucee.org wrote: > On 4/3/2016 8:21 AM, Dave Cramer wrote: > > > On 9 March 2016 at 20:49, Craig Ringer wrote: > >> On 3/8/2016 5:12 PM, Craig Ringer wrote: >> >>> >>> Are there good reasons to use pgjdbc over pgj

Re: [HACKERS] Proposal: RETURNING primary_key()

2016-04-03 Thread Dave Cramer
On 3 April 2016 at 15:35, Stephen Frost wrote: > * Dave Cramer (p...@fastcrypt.com) wrote: > > On 9 March 2016 at 20:49, Craig Ringer wrote: > > > > > On 10 March 2016 at 00:41, Igal @ Lucee.org wrote: > > > > > >> On 3/8/2016 5:12 PM, Craig

Re: [HACKERS] Proposal: RETURNING primary_key()

2016-04-03 Thread Dave Cramer
gt;> >> > Maturity, support for older versions (-ng just punts on support for > anything except new releases) and older JDBC specs, completeness of support > for some extensions. TBH I haven't done a ton with -ng yet. > > I'd like to turn this question around.

[HACKERS] building on windows using VC 2008

2016-03-12 Thread Dave Cramer
Getting lots of POSTGRESQL_TRACE_... undefined. Any hints ? Dave Cramer

Re: [HACKERS] Packaging of postgresql-jdbc

2016-02-16 Thread Dave Cramer
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

Re: [HACKERS] Fwd: [JDBC] Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102

2016-01-12 Thread Dave Cramer
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 wrote: > On 12/01/16 13:00, Dave Cramer wr

[HACKERS] Fwd: [JDBC] Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102

2016-01-12 Thread Dave Cramer
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...@postgr

Re: [HACKERS] JDBC driver debug out?

2015-10-24 Thread Dave Cramer
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 wrote: > Unfortunately it doesn't work (no debug trace). >

Re: [HACKERS] JDBC driver debug out?

2015-10-23 Thread Dave Cramer
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 wrote: > No, I need to provide you with a 41 version. &g

Re: [HACKERS] JDBC driver debug out?

2015-10-23 Thread Dave Cramer
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 wrote: > Dave, > > Thanks for the quick response. Unfortunately now I'm getting error &

Re: [HACKERS] JDBC driver debug out?

2015-10-23 Thread Dave Cramer
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 wrote: > Tatsuo, > > p

Re: [HACKERS] JDBC driver debug out?

2015-10-23 Thread Dave Cramer
Tatsuo, posting to jdbc list Dave Cramer da...@postgresintl.com www.postgresintl.com On 23 October 2015 at 18:28, Tatsuo Ishii wrote: > It seems > org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does > not work anymore in the newer JDBC driver. > > As far as I k

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

2015-05-20 Thread Dave Cramer
w. But I was probably > (hopefully?) wrong. > > jan > > > Using anything other than ? in JDBC is a non-starter you might as well just stop supporting java entirely. Back to the issue at hand. Does anyone have a recommendation for a replacement operator besides ? When I first noticed thi

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

2015-05-19 Thread Dave Cramer
list and > what discussion belongs on github? Is someone interested in > participating in the discussions leading to decisions about our > JDBC 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

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

2015-05-19 Thread Dave Cramer
On 19 May 2015 at 15:02, Tom Lane wrote: > "Greg Sabino Mullane" 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 > ye

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

2015-05-19 Thread Dave Cramer
Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On 19 May 2015 at 13:15, Mike Blackwell 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. >

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

2015-05-19 Thread Dave Cramer
ould be to add support for {?} as the escape for a > question mark, and a connection option to supplement that with > support for the legacy \? escape. I would bet a lot of money that > even with an "if" test for that option, the curly brace escape > would be faster th

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

2015-05-19 Thread Dave Cramer
rward at all that patch would have to be accepted. Such > a patch is likely to see considerable bike-shedding. We then at least > provide an official way to avoid "?" operators that shops can make use of > at their discretion. Removing the existing operators or forbidding 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 dave.cramer(at)credativ(dot)ca http://www.credativ.ca

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

2015-05-15 Thread Dave Cramer
On 15 May 2015 at 16:44, Dave Cramer wrote: > > > On 15 May 2015 at 16:41, Robert Haas wrote: > >> On Fri, May 15, 2015 at 4:38 PM, Dave Cramer wrote: >> >> I don't really want to take a violently strong position on this >> >> without understandi

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

2015-05-15 Thread Dave Cramer
On 15 May 2015 at 16:41, Robert Haas wrote: > On Fri, May 15, 2015 at 4:38 PM, Dave Cramer wrote: > >> I don't really want to take a violently strong position on this > >> without understanding what's really going on here. > >> > > Well our soluti

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

2015-05-15 Thread Dave Cramer
On 15 May 2015 at 16:35, Robert Haas wrote: > On Fri, May 15, 2015 at 4:23 PM, Dave Cramer 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. Pers

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

2015-05-15 Thread Dave Cramer
On 15 May 2015 at 16:21, Robert Haas wrote: > On Fri, May 15, 2015 at 4:13 PM, Dave Cramer 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 new, >

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

2015-05-15 Thread Dave Cramer
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 wrote: > Hello, > > I've been trying to use the new JSONB format using JDBC, and ran

Re: [HACKERS] orangutan seizes up during isolation-check

2015-01-16 Thread Dave Cramer
On 16 January 2015 at 01:33, Noah Misch 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 wrote: > > > On Wed, Jan 14, 2015 at 04:48:53PM -0500, Peter Eisentraut wrote: > > >> What I'm seeing now is that the unaccent regression

Re: [HACKERS] orangutan seizes up during isolation-check

2015-01-01 Thread Dave Cramer
So at this point removing the --enable-nls from my config will solve the build problem. Everyone knows there is an issue so there is no point in continuing to have it fail. On 31 December 2014 at 13:52, Noah Misch wrote: > On Sun, Dec 28, 2014 at 07:20:04PM -0500, Andrew Dunstan wrote: > > On

Re: [HACKERS] Alias hstore's ? to ~ so that it works with JDBC

2013-02-13 Thread Dave Cramer
Since we already do escape processing much like c that might not be so complex. However I haven't looked at the code, so I could be way off base. The question I would pose is how palatable is it to use ? In other words is it worth pursuing ? Dave Cramer dave.cramer(at)credativ(dot)ca

Re: [HACKERS] Alias hstore's ? to ~ so that it works with JDBC

2013-02-08 Thread Dave Cramer
That would seem to be the implication. JDBC wouldn't really know anything about hstore. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Fri, Feb 8, 2013 at 12:51 PM, Andrew Dunstan wrote: > > On 02/08/2013 12:41 PM, Kris Jurka wrote: > >> >>

Re: [HACKERS] Alias hstore's ? to ~ so that it works with JDBC

2013-02-08 Thread Dave Cramer
ou > might hope because the escape processing currently happens prior to bind > parameter detection so I'm not sure what a good patch would really look > like, but given the feedback provided here, it's worth investigating. > > Kris Jurka > > Would this be an postgresql sp

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-10 Thread Dave Cramer
On Tue, Apr 10, 2012 at 11:25 AM, Tom Lane wrote: > Merlin Moncure writes: >> ...  We have to invoke java and there >> are two basic ways to tie into the java runtime:  one is to jump >> through SPI via the SQL executor. The other is JNI into the pl/java >> jvm which I think you were hinting was

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-09 Thread Dave Cramer
On Mon, Apr 9, 2012 at 12:45 PM, Andrew Dunstan wrote: > > > On 04/09/2012 12:14 PM, Dave Cramer wrote: >> >> >> So I'm confused, once they link a file to an FDW can't you just read >> it with an normal select ? >> >> What additional function

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-09 Thread Dave Cramer
On Mon, Apr 9, 2012 at 11:55 AM, Merlin Moncure wrote: > On Mon, Apr 9, 2012 at 10:47 AM, Dave Cramer wrote: >> How will the user access this? Will it be a normal query through the >> existing API ? Will it be a private postgresql API ? >> >> How will they set it up

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-09 Thread Dave Cramer
How will the user access this? Will it be a normal query through the existing API ? Will it be a private postgresql API ? How will they set it up ? It appears complicated as you have to setup PL/Java as well Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Mon, Apr 9

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-08 Thread Dave Cramer
Hi Atri, Is there some JDBC API that supports this in newer versions of the API ? Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Sat, Apr 7, 2012 at 7:07 AM, Atri Sharma wrote: > Hi All, > > > > I submitted a GSoc application yesterday. Please review it

[HACKERS] who's familiar with the GSOC application process

2012-03-25 Thread Dave Cramer
Someone has approached the JDBC list to do some work on the driver as a GSOC project. I need to know what is involved in mentoring and how to get the project approved Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] pgsphere

2012-01-10 Thread Dave Cramer
ter still has some benefits > in some workload, so we are interesting in development. > > > Regards, > Oleg So where do we go from here ? Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca > > > On Fri, 6 Jan 2012, Andrew Dunstan wrote: > >> &

Re: [HACKERS] pgsphere

2012-01-07 Thread Dave Cramer
Well I've sent Teodor a personal email asking him if he was interested and so far no response, so I interpret that as he no longer has interest in the project. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Fri, Jan 6, 2012 at 12:40 PM, Andrew Dunstan wrote: > &

[HACKERS] pgsphere

2012-01-06 Thread Dave Cramer
I've been asked by someone to support pgshpere. It would appear that the two project owners are MIA. If anyone knows different can they let me know ? Does anyone have any objection to me taking over the project? Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca -- Sen

[HACKERS] pgsphere

2012-01-06 Thread Dave Cramer
I've been asked by someone to support pgshpere. It would appear that the two project owners are MIA. If anyone knows different can they let me know ? Does anyone have any objection to me taking over the project? Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca -- Sen

[HACKERS] Generating a query that never returns

2011-09-19 Thread Dave Cramer
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

Re: [HACKERS] error building head on OS X 10.7.1

2011-09-07 Thread Dave Cramer
On Wed, Sep 7, 2011 at 11:32 AM, Tom Lane wrote: > Dave Cramer 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 fail

Re: [HACKERS] error building head on OS X 10.7.1

2011-09-07 Thread Dave Cramer
On Wed, Sep 7, 2011 at 11:16 AM, Tom Lane wrote: > Dave Cramer writes: >> Get the following error >> configure:3274: ccache gcc -V >&5 >> llvm-gcc-4.2: argument to `-V' is missing > >> should be >> ccache gcc -v >&5 > > That's

[HACKERS] error building head on OS X 10.7.1

2011-09-07 Thread Dave Cramer
Get the following error configure:3274: ccache gcc -V >&5 llvm-gcc-4.2: argument to `-V' is missing should be ccache gcc -v >&5 Dave Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To m

Re: [HACKERS] Why doesn't psql use the information schema to get ACL description ?

2011-08-25 Thread Dave Cramer
can't). I'll have to have a look at this when I get a moment, sounds promising. Will be even better if we get all clients using it. 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

[HACKERS] Why doesn't psql use the information schema to get ACL description ?

2011-08-23 Thread Dave Cramer
data from the information_schema ? 2) If so why doesn't psql use these tables ? Ultimately my ulterior motive is to make sure the information schema is actually useful and ensure that it maintains that status. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca -- Sent via

Re: [HACKERS] Support for cert auth in JDBC

2011-05-17 Thread Dave Cramer
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 : > Hello developers, > > My project had a requirement to use certificate authentication to the PG >

Re: [JDBC] [HACKERS] JDBC connections to 9.1

2011-04-18 Thread Dave Cramer
On Mon, Apr 18, 2011 at 11:24 AM, Tom Lane wrote: > Dave Cramer writes: >> On Mon, Apr 18, 2011 at 10:57 AM, Tom Lane 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 it, ie

Re: [JDBC] [HACKERS] JDBC connections to 9.1

2011-04-18 Thread Dave Cramer
On Mon, Apr 18, 2011 at 11:14 AM, Mike Fowler wrote: > On 18/04/11 15:57, Tom Lane wrote: >> >> Bernd Helmle  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 --- when I re

Re: [JDBC] [HACKERS] JDBC connections to 9.1

2011-04-18 Thread Dave Cramer
t; Older drivers will fail for sure. We can fix newer drivers, but if we leave it we will see a slew of bug reports. The reason the driver does this is to guarantee 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

Re: [HACKERS] create tablespace fails silently, or succeeds improperly

2010-10-18 Thread Dave Cramer
On Mon, Oct 18, 2010 at 2:39 PM, Bruce Momjian wrote: > Dave Cramer wrote: >> On Mon, Oct 18, 2010 at 2:20 PM, Bruce Momjian wrote: >> > Alvaro Herrera wrote: >> >> Hi Dave, >> >> >> >> Excerpts from Dave Cramer's message of lun oct 18 1

Re: [HACKERS] create tablespace fails silently, or succeeds improperly

2010-10-18 Thread Dave Cramer
On Mon, Oct 18, 2010 at 2:20 PM, Bruce Momjian wrote: > Alvaro Herrera wrote: >> Hi Dave, >> >> Excerpts from Dave Cramer's message of lun oct 18 12:23:40 -0300 2010: >> > as seen below create tablespace does not throw an error or appear to >> > do anything other than register the tablespace. >> >

Re: [HACKERS] create tablespace fails silently, or succeeds improperly

2010-10-18 Thread Dave Cramer
On Mon, Oct 18, 2010 at 11:37 AM, Tom Lane wrote: > Dave Cramer writes: >> as seen below create tablespace does not throw an error or appear to >> do anything other than register the tablespace. > > I suspect this behavior is partially intentional, because tablespace >

[HACKERS] create tablespace fails silently, or succeeds improperly

2010-10-18 Thread Dave Cramer
as seen below create tablespace does not throw an error or appear to do anything other than register the tablespace. postg...@db01:~> less /opt/pg/data/jnj_indexes/PG_VERSION 8.4 postg...@db01:~> /opt/pg91/bin/psql -p 5433 psql (9.0.1) Type "help" for help. postgres=# select version();

Re: [HACKERS] pgstatindex still throws ERROR: value "3220078592" is out of range for type integer

2010-06-09 Thread Dave Cramer
On Mon, Jun 7, 2010 at 8:30 PM, Takahiro Itagaki wrote: > > Dave Cramer wrote: > >> I noted on line 169 that max_avail is still an int ? Where else would >> it be having problems ? > > It should not a problem because the local variable only stores byte > size in a

[HACKERS] pgstatindex still throws ERROR: value "3220078592" is out of range for type integer

2010-06-07 Thread Dave Cramer
I noted on line 169 that max_avail is still an int ? Where else would it be having problems ? Dave -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] OpenSSL key renegotiation with patched openssl

2009-11-30 Thread Dave Cramer
On Fri, Nov 27, 2009 at 4:58 PM, Tom Lane wrote: > Stefan Kaltenbrunner writes: >> Tom Lane wrote: >>> The discussion I saw suggested that you need such a patch at both ends. > >> and likely requires a restart of both postgresql and slony afterwards... > > Actually, after looking through the avai

Re: [HACKERS] OpenSSL key renegotiation with patched openssl

2009-11-30 Thread Dave Cramer
Tom Lane wrote: > Dave Cramer writes: > >> Recently openssl has been patched to not renegotiate keys. >> http://www.links.org/?p=780 >> After a certain amount of data has gone through a postgresql connection >> the server will attempt to switch session keys. >

Re: [HACKERS] OpenSSL key renegotiation with patched openssl

2009-11-27 Thread Dave Cramer
Tom Lane wrote: > Dave Cramer writes: > >> Recently openssl has been patched to not renegotiate keys. >> http://www.links.org/?p=780 >> After a certain amount of data has gone through a postgresql connection >> the server will attempt to switch session keys. >

[HACKERS] OpenSSL key renegotiation with patched openssl

2009-11-27 Thread Dave Cramer
Recently openssl has been patched to not renegotiate keys. http://www.links.org/?p=780 After a certain amount of data has gone through a postgresql connection the server will attempt to switch session keys. What is the workaround (if any ) to avoid this in postgresql ? Dave -- Sent via pgsql

Re: [HACKERS] pg_standby could not open wal file after selecting new timeline

2008-11-05 Thread Dave Cramer
On 5-Nov-08, at 1:00 PM, Tom Lane wrote: I wrote: Huh, is it possible that Linux rejects O_SYNC for a file on ramdisk? I found this in the Fedora 9 manpage for open(2): O_DIRECT support was added under Linux in kernel version 2.4.10. Older Linux kernels simply ignore this fla

Re: [HACKERS] pg_standby could not open wal file after selecting new timeline

2008-11-05 Thread Dave Cramer
Tom, On 5-Nov-08, at 12:21 PM, Tom Lane wrote: nvalid argument"?? On the platforms I have handy, the only documented reason for open(2) to fail with EINVAL is illegal value of the flags argument, which should be impossible. What platform is this and what wal_sync_method are you using? Red

[HACKERS] pg_standby could not open wal file after selecting new timeline

2008-11-05 Thread Dave Cramer
I am trying to move a db from one machine to another. pg_standby applies all the logs fine, then I trigger it and this happens ??? 2008-11-05 11:43:45 EST [14853] LOG: restored log file "000316ED007E" from archive 2008-11-05 11:43:45 EST [14853] LOG: selected new timeline I

Re: [HACKERS] pg_ctl less than useful error message on windows when privileges wrong for postgres

2008-10-21 Thread Dave Cramer
On 21-Oct-08, at 5:24 PM, Tom Lane wrote: Dave Cramer <[EMAIL PROTECTED]> writes: I have a client who mistakenly gave the postgres user on a windows machine admin privileges. This mistake results in the service being unable to start up due to postgres refusing to start with

[HACKERS] pg_ctl less than useful error message on windows when privileges wrong for postgres

2008-10-21 Thread Dave Cramer
I have a client who mistakenly gave the postgres user on a windows machine admin privileges. This mistake results in the service being unable to start up due to postgres refusing to start with admin privileges. The error message from pg_ctl start -D bindir is PG_CTL.."could not locate mat

[HACKERS] log shipping pg_standby

2008-10-14 Thread Dave Cramer
After terminating recovery mode by creating a trigger file postgres starts up and complains about missing WAL files in pg_xlog; The last two which were replayed. Is this normal ? Dave -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] can't stop autovacuum by HUP'ing the server

2008-08-26 Thread Dave Cramer
On Tue, Aug 26, 2008 at 1:45 PM, Alvaro Herrera <[EMAIL PROTECTED]>wrote: > Dave Cramer wrote: > > On Tue, Aug 26, 2008 at 1:33 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > > > > Could we first see a cycle of autovac log output with > > > log_autovacuum_m

  1   2   3   4   >