[HACKERS] Error handling in transactions

2017-03-16 Thread Peter van Hardenberg
ew default to a potentially destructive setting is problematic. Still, I do believe that the current state of affairs is painful and problematic and this is a problem worth solving. -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt."—Kurt Vonnegut

[HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive

2017-03-15 Thread Peter van Hardenberg
th this change, I'll provide a patch for the current commitfest. -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt."—Kurt Vonnegut

Re: [HACKERS] SQL/JSON in PostgreSQL

2017-03-09 Thread Peter van Hardenberg
- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt."—Kurt Vonnegut

Re: [HACKERS] SQL/JSON in PostgreSQL

2017-03-08 Thread Peter van Hardenberg
integers have no > quotations marks around them). > > Regards, > Sven > > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt."—Kurt Vonnegut

Re: [HACKERS] GSoC 2017

2017-01-27 Thread Peter van Hardenberg
ess here, users continue to get bad advice about using the existing MONEY type such as here: http://stackoverflow.com/questions/15726535/postgresql-which-datatype-should-be-used-for-currency -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt."—Kurt Vonnegut

Re: [HACKERS] GSoC 2017

2017-01-23 Thread Peter van Hardenberg
On Mon, Jan 23, 2017 at 4:12 PM, Jim Nasby <jim.na...@bluetreble.com> wrote: > On 1/23/17 3:45 PM, Peter van Hardenberg wrote: > >> A new currency type would be nice, and if kept small in scope, might be >> manageable. >> > > I'd be rather nervous about this.

Re: [HACKERS] GSoC 2017

2017-01-23 Thread Peter van Hardenberg
in the day... That's still a gap in community Postgres. On Mon, Jan 16, 2017 at 6:43 PM, Jim Nasby <jim.na...@bluetreble.com> wrote: > On 1/13/17 3:09 PM, Peter van Hardenberg wrote: > >> A new data type, and/or a new index type could both be nicely scoped >> bits of work.

Re: [HACKERS] GSoC 2017

2017-01-13 Thread Peter van Hardenberg
reble.com >> 855-TREBLE2 (855-873-2532) >> >> >> -- >> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-hackers >> > > -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt."—Kurt Vonnegut

Re: [HACKERS] Patch: Implement failover on libpq connect level.

2016-10-19 Thread Peter van Hardenberg
On Wed, Oct 19, 2016 at 3:08 PM, Robert Haas wrote: > On Mon, Oct 26, 2015 at 4:25 PM, Peter Eisentraut wrote: > > On 10/14/15 6:41 AM, Victor Wagner wrote: > All in all, I'm still feeling pretty good about trying to support the > same syntax that our

Re: [HACKERS] \timing interval

2016-09-01 Thread Peter van Hardenberg
43920001.200 ms (12:12:00.001) > Time: 176460001.200 ms (2 01:01:00.001) > Time: 216720001.200 ms (2 12:12:00.001) > Time: 8816460001.200 ms (102 01:01:00.001) > Time: 8856720001.200 ms (102 12:12:00.001) > > Barring objections I'll commit this soon. > >

Re: [HACKERS] PoC: Make it possible to disallow WHERE-less UPDATE and DELETE

2016-07-27 Thread Peter van Hardenberg
On Tue, Jul 26, 2016 at 6:15 PM, Peter Eisentraut < peter.eisentr...@2ndquadrant.com> wrote: > On 7/26/16 6:14 PM, Vik Fearing wrote: > > As mentioned elsewhere in the thread, you can just do WHERE true to get > > around it, so why on Earth have it PGC_SUSET? > > I'm not sure whether it's

Re: [HACKERS] JSON[B] arrays are second-class citizens

2016-05-31 Thread Peter van Hardenberg
m to be lacking any easy way to take a json array and > attempt to convert it directly into a PostgreSQL array. Just a conversion > is not always going to succeed though the capability seems worthwhile if as > yet unasked for. The each->convert->array_agg pattern works but is likely > inefficient for homogeneous json array cases. > > David J. > -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt."—Kurt Vonnegut

Re: [HACKERS] Calling json_* functions with JSONB data

2016-05-23 Thread Peter van Hardenberg
I'll look into it, thanks for the explanation. On Mon, May 23, 2016 at 1:37 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Peter van Hardenberg <p...@pvh.ca> writes: > > Great question, Marko. If you can point me towards an example I'll take a > > look, but I'

Re: [HACKERS] Calling json_* functions with JSONB data

2016-05-23 Thread Peter van Hardenberg
Great question, Marko. If you can point me towards an example I'll take a look, but I'll proceed with the current understanding and suggestions and see what people have to say. On Mon, May 23, 2016 at 10:47 AM, Marko Tiikkaja <ma...@joh.to> wrote: > On 2016-05-23 18:55, Peter van H

[HACKERS] Calling json_* functions with JSONB data

2016-05-23 Thread Peter van Hardenberg
or suggestions? -p -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt."—Kurt Vonnegut

Re: [HACKERS] Prepared statements fail after schema changes with surprising error

2013-01-25 Thread Peter van Hardenberg
. No objections here. Thanks Tom and everyone else for setting this straight. -- Peter van Hardenberg San Francisco, California Everything was beautiful, and nothing hurt. -- Kurt Vonnegut

[HACKERS] Prepared statements fail after schema changes with surprising error

2013-01-21 Thread Peter van Hardenberg
. A better solution might be to attempt to re-prepare the statement before throwing an error. -pvh -- Peter van Hardenberg San Francisco, California Everything was beautiful, and nothing hurt. -- Kurt Vonnegut

Re: [HACKERS] Prepared statements fail after schema changes with surprising error

2013-01-21 Thread Peter van Hardenberg
out. I don't plan to speculate about causes without a concrete test case. regards, tom lane -- Peter van Hardenberg San Francisco, California Everything was beautiful, and nothing hurt. -- Kurt Vonnegut

Re: [HACKERS] Prepared statements fail after schema changes with surprising error

2013-01-21 Thread Peter van Hardenberg
sz1; select 'selecting from z1 to prove it exists'; select * from z1; On Mon, Jan 21, 2013 at 10:45 PM, Peter van Hardenberg p...@pvh.ca wrote: Hm - I'm still able to recreate the test the user's running using pg_dump/pg_restore. I'm still working to see if I can minimize the test-case

Re: [HACKERS] Synchronous commit not... synchronous?

2012-11-04 Thread Peter van Hardenberg
On Fri, Nov 2, 2012 at 11:16 AM, Peter Eisentraut pe...@eisentraut.orgwrote: Did the inserted row also arrive at the standby? No, as there was no standby. -- Peter van Hardenberg San Francisco, California Everything was beautiful, and nothing hurt. -- Kurt Vonnegut

[HACKERS] Synchronous commit not... synchronous?

2012-10-31 Thread Peter van Hardenberg
: there is no transaction in progress ROLLBACK d5r5fdj6u5ieml= -- Peter van Hardenberg San Francisco, California Everything was beautiful, and nothing hurt. -- Kurt Vonnegut

Re: [HACKERS] psql \i tab completion initialization problem on HEAD

2012-02-26 Thread Peter van Hardenberg
suspect you weren't actually testing it. Note that the thing called /usr/lib/libreadline.dylib is not GNU readline, it's only a symlink to libedit. I am indeed running Lion. Thanks for helping me track down the cause. -- Peter van Hardenberg San Francisco, California Everything was beautiful

Re: [HACKERS] psql \i tab completion initialization problem on HEAD

2012-02-24 Thread Peter van Hardenberg
On Thu, Feb 23, 2012 at 4:15 PM, Tom Lane t...@sss.pgh.pa.us wrote: Here's a reliable reproduction on my OS X laptop. OS X?  Are you using GNU readline, or Apple's libedit? I reproduced it with both, but if that news is surprising to you, I can certainly re-test. -- Peter van Hardenberg San

[HACKERS] psql \i tab completion initialization problem on HEAD

2012-02-23 Thread Peter van Hardenberg
=# \i I don't see this regression with the 9.1 client I have here, so I suspect it has something to do with whatever patch introduced the relative paths by default. -p -- Peter van Hardenberg San Francisco, California Everything was beautiful, and nothing hurt. -- Kurt Vonnegut -- Sent via pgsql

Re: [HACKERS] Inline Extension

2012-01-27 Thread Peter van Hardenberg
user. On our service we do not restrict our users access to superuser out of spite, but to reduce the available surface area for self-destruction. -- Peter van Hardenberg San Francisco, California Everything was beautiful, and nothing hurt. -- Kurt Vonnegut -- Sent via pgsql-hackers mailing list

Re: [HACKERS] WIP: URI connection string support for libpq

2011-12-13 Thread Peter van Hardenberg
On Mon, Dec 12, 2011 at 5:05 PM, David E. Wheeler da...@justatheory.com wrote: On Dec 12, 2011, at 3:55 PM, Peter van Hardenberg wrote: only a nearly insurmountable mailing list thread prevents it. What happened to SexQL? Case in point. -- Peter van Hardenberg San Francisco, California

Re: [HACKERS] JSON for PG 9.2

2011-12-13 Thread Peter van Hardenberg
On Mon, Dec 12, 2011 at 9:25 PM, Peter Eisentraut pete...@gmx.net wrote: On mån, 2011-12-12 at 16:51 -0800, Peter van Hardenberg wrote: You don't need a new PL to do that.  The existing PLs can also parse JSON.  So that's not nearly enough of a reason to consider adding this new PL. PL/V8

Re: [HACKERS] WIP: URI connection string support for libpq

2011-12-12 Thread Peter van Hardenberg
somewhere between 250,000 and 500,000 URLs which begin with postgres:// in our care. -- Peter van Hardenberg San Francisco, California Everything was beautiful, and nothing hurt. -- Kurt Vonnegut -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] JSON for PG 9.2

2011-12-12 Thread Peter van Hardenberg
-- Peter van Hardenberg San Francisco, California Everything was beautiful, and nothing hurt. -- Kurt Vonnegut -- 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] Policy on pulling in code from other projects?

2011-08-09 Thread Peter van Hardenberg
will be personally dealing with fires caused by this for years to come regardless of the outcome of this thread. Best, -pvh -- Peter van Hardenberg Department of Data Heroku Everything was beautiful, and nothing hurt. -- Kurt Vonnegut

Re: [HACKERS] Extension Packaging

2011-05-17 Thread Peter van Hardenberg
the versions of extensions that they need in some kind of a control file or in a database migration script such that they can then install those extensions on various new systems in a reliable and reproducible way. David, if you do what you propose, haven't I already lost? --- Peter van Hardenberg Heroku