On Sun, May 17, 2015 at 6:30 AM, Peter Geoghegan p...@heroku.com wrote:
Attached patch makes minor tweaks to pg_audit docs.
Applied, thanks.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On 17/05/15 16:04, Andrew Dunstan wrote:
On 05/16/2015 10:56 PM, Peter Geoghegan wrote:
Another thing that I noticed about the new jsonb stuff is that the
concatenate operator is based on the hstore one. This works as
expected:
postgres=# select '{a:1}'::jsonb || '{a:2}';
?column?
--
Robert == Robert Haas robertmh...@gmail.com writes:
Robert I think grouping_planner() is badly in need of some refactoring
Robert just to make it shorter. It's over 1000 lines of code, which
Robert IMHO is a fairly ridiculous length for a single function.
If there's interest, we could do
Andrew Gierth and...@tao11.riddles.org.uk writes:
Robert == Robert Haas robertmh...@gmail.com writes:
Robert I think grouping_planner() is badly in need of some refactoring
Robert just to make it shorter. It's over 1000 lines of code, which
Robert IMHO is a fairly ridiculous length for a
Tom == Tom Lane t...@sss.pgh.pa.us writes:
If there's interest, we could do that specific task as part of
adding hashagg support for grouping sets (which would otherwise make
it even longer), or as preparatory work for that.
Tom I think that refactoring without changing anything about
=?windows-1252?Q?Jos=E9_Luis_Tall=F3n?= jltal...@adv-solutions.net writes:
On the other hand, ISTM that what we all intend to achieve is some
Postgres equivalent of the SUID bit... so why not just do something
equivalent?
---
LOGIN-- as user with the appropriate role membership
Andrew Gierth and...@tao11.riddles.org.uk writes:
Tom == Tom Lane t...@sss.pgh.pa.us writes:
Tom So I'm all for refactoring, but I think it will happen as a natural
Tom byproduct of path-ification, and otherwise would be rather forced.
Hrm, ok. So for the near future, we should leave it
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Andrew Dunstan wrote:
FTR, Perl's DBD::Pg lets you do this:
$dbh-{pg_placeholder_dollaronly} = 1; # disable ? placeholders
You can also simply escape placeholders in DBD::Pg with a backslash:
$dbh-prepare(q{SELECT * FROM mytable WHERE lseg1
On 05/13/2015 06:03 AM, Alvaro Herrera wrote:
Craig Ringer wrote:
For some time I've wanted a way to SET SESSION AUTHORISATION or SET
ROLE in a way that cannot simply be RESET, so that a connection may be
handed to a less-trusted service or application to do some work with.
Some years back, I
On 05/16/2015 08:04 PM, Peter Geoghegan wrote:
I'm seeing the following problem on the master branch:
postgres=# select '{foo:5}'::jsonb - 'bar'; -- okay
?column?
{foo: 5}
(1 row)
postgres=# select '{foo:{bar:5}}'::jsonb - 'foo'; -- okay
?column?
--
{}
(1 row)
On Sun, May 17, 2015 at 7:45 AM, Robert Haas robertmh...@gmail.com wrote:
crazy-ideaI wonder if we could write WAL to two different files in
alternation, so that we could be writing to one file which fsync-ing
the other./crazy-idea
Won't the order of transactions replay during recovery can
Robert Haas robertmh...@gmail.com writes:
So, getting back to this part, what's the value of returning a list of
Paths rather than a list of Plans?
(1) less work, since we don't have to fill in details not needed for
costing purposes;
(2) paths carry info that the planner wants but the
On 05/15/2015 05:58 AM, Bruce Momjian wrote:
I have processed all the open email items I can through mid-March,
though I do have two pg_upgrade fixes pending application today. I will
continue processing doc fixes and major bug fixes for 9.5, but
everything else I do will be for 9.6.
Did
On Mon, May 18, 2015 at 6:28 AM, Haribabu Kommi kommi.harib...@gmail.com
wrote:
On Wed, Apr 22, 2015 at 10:48 PM, Amit Kapila amit.kapil...@gmail.com
wrote:
parallel_seqscan_v14.patch (Attached with this mail)
This patch is not applying/working with the latest head after parallel
mode patch
On Wed, May 13, 2015 at 2:18 PM, Robert Haas robertmh...@gmail.com
mailto:robertmh...@gmail.com wrote:
All of this is fairly far afield from the original topic of this
thread, which was whether a configure option disabling trust + ident
authentication would be a good idea. I
On Mon, May 18, 2015 at 12:35 PM, Josh Berkus j...@agliodbs.com wrote:
Did it ever occur to you, Bruce, that you've turned into the GC daemon
for the project?
GC = global coordinator?
--
Michael
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
GC=Garbage Collector
On Mon, May 18, 2015 at 9:24 AM, Michael Paquier michael.paqu...@gmail.com
wrote:
On Mon, May 18, 2015 at 12:35 PM, Josh Berkus j...@agliodbs.com wrote:
Did it ever occur to you, Bruce, that you've turned into the GC daemon
for the project?
GC = global coordinator?
On May 17, 2015, at 8:38 PM, Peter Geoghegan p...@heroku.com wrote:
The current behavior does not seem acceptable for the concatenate
operator (operator || jsonb).
I don't agree. It seems pretty clear to me after reading the new posts that
the behavior is not an oversight, and that's enough
On Sun, May 17, 2015 at 5:46 PM, Robert Haas robertmh...@gmail.com wrote:
On May 17, 2015, at 8:38 PM, Peter Geoghegan p...@heroku.com wrote:
The current behavior does not seem acceptable for the concatenate
operator (operator || jsonb).
I don't agree. It seems pretty clear to me after
On Sun, May 17, 2015 at 8:04 AM, Andrew Dunstan and...@dunslane.net wrote:
Sure. I thought we'd covered this but it's possible that we didn't, or that
it got rebroken. There have been complaints about the limitation on values
containing jbvBinary, so let's just remove it if that can be done
Running the regression tests with -DCOPY_PARSE_PLAN_TREES reveals that
DROP TRANSFORM parse trees fail to be copiable:
regression=# DROP TRANSFORM IF EXISTS FOR fake_type LANGUAGE plperl;
ERROR: unrecognized node type: 1701866608
I've not tracked down the exact reason, but it kinda looks like
On May 17, 2015, at 5:57 PM, Thomas Munro thomas.mu...@enterprisedb.com wrote:
On Sun, May 17, 2015 at 2:15 PM, Robert Haas robertmh...@gmail.com wrote:
http://oldblog.antirez.com/post/fsync-different-thread-useless.html
It suggests that an fsync in progress blocks out not only other
fsyncs,
On Wed, Apr 22, 2015 at 10:48 PM, Amit Kapila amit.kapil...@gmail.com wrote:
parallel_seqscan_v14.patch (Attached with this mail)
This patch is not applying/working with the latest head after parallel
mode patch got committed.
can you please rebase the patch.
Regards,
Hari Babu
Fujitsu
Back in March we discussed the advisability of having a buildfarm critter
or two running with -DCOPY_PARSE_PLAN_TREES:
http://www.postgresql.org/message-id/14670.1427727...@sss.pgh.pa.us
but evidently nobody acted on the idea. I've now turned on that option
on dromedary. It will fail its next
On Sun, May 17, 2015 at 3:22 PM, Andrew Dunstan and...@dunslane.net wrote:
So what exactly do you want me or anybody else to do now, two days *after*
we declared (not without pain) feature freeze?
As much as I'd like to just fix the concatenate operator, I really
don't want to be the person
On Sun, May 17, 2015 at 7:16 AM, Petr Jelinek p...@2ndquadrant.com wrote:
Agreed, if you look at jquery for example, the extend() method by default
behaves like our current || and you have to specify that you want deep merge
if you want the behavior described by Peter. So there is definitely
On Sun, May 17, 2015 at 2:15 PM, Robert Haas robertmh...@gmail.com wrote:
http://oldblog.antirez.com/post/fsync-different-thread-useless.html
It suggests that an fsync in progress blocks out not only other
fsyncs, but other writes to the same file, which for our purposes is
just awful. More
On Sun, May 17, 2015 at 8:37 AM, Dmitry Dolgov 9erthali...@gmail.com wrote:
And I agree with thoughts above, that both concatenation modes (simple and
deep) definitely can be useful. I can try to figure out how much work that
would be to modify the IteratorConcat function (or adapt Ilya's
On 05/17/2015 05:56 PM, Peter Geoghegan wrote:
On Sun, May 17, 2015 at 8:37 AM, Dmitry Dolgov 9erthali...@gmail.com wrote:
And I agree with thoughts above, that both concatenation modes (simple and
deep) definitely can be useful. I can try to figure out how much work that
would be to modify
On 05/17/2015 05:46 PM, Robert Haas wrote:
On May 17, 2015, at 8:38 PM, Peter Geoghegan p...@heroku.com wrote:
The current behavior does not seem acceptable for the concatenate
operator (operator || jsonb).
I don't agree. It seems pretty clear to me after reading the new posts that
the
On Sun, May 17, 2015 at 8:41 PM, Josh Berkus j...@agliodbs.com wrote:
Is there a particular reason why + makes more sense as shallow
concatination and || makes more sense as deep concatination? Like,
something in JS or other client languages which would make that
preference make more sense to
On Sat, May 16, 2015 at 6:34 PM, Shigeru Hanada shigeru.han...@gmail.com
wrote:
Attached is the v15 patch of foreign join support for postgres_fdw.
This patch is based on current master, and having being removed some
hunks which are not essential.
And I wrote description of changes done by
On Sun, May 17, 2015 at 11:00 PM, Stephen Frost sfr...@snowman.net wrote:
Fujii, Michael,
* Fujii Masao (masao.fu...@gmail.com) wrote:
pg_audit uses 1.0.0 as its version number. But, is the third digit really
required? Why? We usually uses the version number with two digits in
contrib
Historical note: I think it's based on the nested hstore work, not on
current hstore, but Dmitry can answer on that.
Yes, you're right.
And I agree with thoughts above, that both concatenation modes (simple
and deep) definitely can be useful. I can try to figure out how much work
that would be
On May 17, 2015, at 11:04 AM, Amit Kapila amit.kapil...@gmail.com wrote:
On Sun, May 17, 2015 at 7:45 AM, Robert Haas robertmh...@gmail.com wrote:
crazy-ideaI wonder if we could write WAL to two different files in
alternation, so that we could be writing to one file which fsync-ing
the
On Sun, May 17, 2015 at 9:15 AM, Greg Sabino Mullane g...@turnstep.com
wrote:
Dave Cramer wrote:
Well our solution was to use ?? but that does mean we have to do some
extra parsing which in a perfect world wouldn't be necessary.
That's not a good solution as '??' is a perfectly valid
On May 16, 2015, at 10:56 PM, Peter Geoghegan p...@heroku.com wrote:
Another thing that I noticed about the new jsonb stuff is that the
concatenate operator is based on the hstore one. This works as
expected:
postgres=# select '{a:1}'::jsonb || '{a:2}';
?column?
--
{a: 2}
(1
On 05/17/2015 07:39 PM, Tom Lane wrote:
=?windows-1252?Q?Jos=E9_Luis_Tall=F3n?= jltal...@adv-solutions.net writes:
On the other hand, ISTM that what we all intend to achieve is some
Postgres equivalent of the SUID bit... so why not just do something
equivalent?
---
LOGIN-- as user
On Tue, May 12, 2015 at 4:23 PM, Peter Geoghegan p...@heroku.com wrote:
Rebased version of patch is attached.
FYI, I found an unrelated bug within ruleutils.c (looks like the
targetlist kludge in set_deparse_planstate() isn't sufficiently
general):
postgres=# explain insert into upsert as u
On 7 April 2015 at 13:41, Tomas Vondra tomas.von...@2ndquadrant.com wrote:
(1) The current patch only does the trick when the FK matches the
conditions perfectly - when there are no missing columns (present
in the FK, not covered by a condition).
Hi Tomas,
I did glance at this
Hello. Please, see this patch with typos.
Thank you.
--
Dmitriy Olshevskiy
From e9c463e50efdaa1fbdcabea92cd95cbffea3d3bd Mon Sep 17 00:00:00 2001
From: olshevskiy87 olshevski...@bk.ru
Date: Sun, 17 May 2015 15:40:40 +0400
Subject: [PATCH] fix typos
---
On Sun, May 17, 2015 at 1:46 PM, Dmitriy Olshevskiy olshevski...@bk.ru
wrote:
Hello. Please, see this patch with typos.
Thank you.
Thanks, applied!
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On 05/16/2015 10:56 PM, Peter Geoghegan wrote:
Another thing that I noticed about the new jsonb stuff is that the
concatenate operator is based on the hstore one. This works as
expected:
postgres=# select '{a:1}'::jsonb || '{a:2}';
?column?
--
{a: 2}
(1 row)
However, the nesting
43 matches
Mail list logo