On 2014-02-27 23:54:47 -0800, Peter Geoghegan wrote:
In any case, as I say, if that's the patch that Andres or Oleg or
Teodor really want to submit, then by all means let them submit it.
Just to make that clear, I am not one of the authors, I just did a
couple of light review passes.
On Fri, Feb 28, 2014 at 12:01 AM, Andres Freund and...@2ndquadrant.com wrote:
On 2014-02-27 23:54:47 -0800, Peter Geoghegan wrote:
In any case, as I say, if that's the patch that Andres or Oleg or
Teodor really want to submit, then by all means let them submit it.
Just to make that clear, I
Hi Fabrízio.
Here are a few comments based on a quick look at your updated patch.
At 2014-02-13 22:44:56 -0200, fabriziome...@gmail.com wrote:
diff --git a/doc/src/sgml/ref/alter_index.sgml
b/doc/src/sgml/ref/alter_index.sgml
index d210077..5e9ee9d 100644
---
(2014/02/27 20:19), Heikki Linnakangas wrote:
On 02/27/2014 12:38 PM, KONDO Mitsumasa wrote:
I found interesting for and while loop in WaitForWALToBecomeAvailable() in
xlog.c. Can you tell me this behavior?
for (;;)
{
~
} while (StanbyMode)
I confirmed this code is no problem in gcc
On 2014-02-27 15:06:33 -0500, Andrew Dunstan wrote:
You realize that this API dates from 9.3 and has been used in numerous
extensions, right? So the names are pretty well fixed, for good or ill.
Sure. Doesn't prevent adding a couple more comments tho. I've only
noticed this because I opened the
On 02/27/2014 11:04 PM, Alvaro Herrera wrote:
I pushed this patch with a few further tweaks. In your changes to
address the above point, you made the suffix mandatory in the
pg_basebackup -r option. This seemed a strange restriction, so I
removed it. It seems more user-friendly to me to
Hello, we found that hot standby doesn't came up under certain
condition. This occurs for 9.3 and 9.4dev.
The recovery process stays on 'incosistent' state forever when
the server has crashed before any wal record is inserted after
the last checkpoint.
This seems to be because EndRecPtr is set
Ouch. this is the same issue to the mail below,
http://www.postgresql.org/message-id/53104595.6060...@lab.ntt.co.jp
regards,
--
Kyotaro Horiguchi
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On 2014-02-28 17:55:21 +0900, Kyotaro HORIGUCHI wrote:
The recovery process stays on 'incosistent' state forever when
the server has crashed before any wal record is inserted after
the last checkpoint.
# killall postgres
# rm -rf $PGDATA/*
initdb
pg_ctl start -w
sleep 1
pg_ctl stop -m i
Hello,
2014/02/28 18:07 Andres Freund :
On 2014-02-28 17:55:21 +0900, Kyotaro HORIGUCHI wrote:
The recovery process stays on 'incosistent' state forever when
the server has crashed before any wal record is inserted after
the last checkpoint.
# killall postgres
# rm -rf $PGDATA/*
Peter Eisentraut pete...@gmx.net writes:
I think we should get rid of the module_pathname business, and
extensions' SQL files should just refer to the base file name and rely
on the dynamic library path to find the files. What would we lose if we
did that?
Control over *which* mylib.so file
Stephen Frost sfr...@snowman.net writes:
# hstore extension
comment = 'data type for storing sets of (key, value) pairs'
default_version = '1.3'
directory = 'local/hstore-new'
module_pathname = '$directory/hstore'
relocatable = true
Interesting idea. I'm a *little*
2014-02-27 20:10 GMT+01:00 Alvaro Herrera alvhe...@2ndquadrant.com:
Pavel Stehule escribió:
Hello
updated patch without timetz support
Great, thanks.
While testing, I noticed something strange regarding numeric timezone
specification. Basically the way any particular value is handled
On 28 Feb 2014 06:19, Andres Freund and...@2ndquadrant.com wrote:
On 2014-02-27 23:41:08 +, Greg Stark wrote:
Though I notice something I can't understand here.
After activating the new clone subsequent attempts to select rows from
the page bump the LSN, presumably due to touching
On 2014-02-28 10:44:14 +, Greg Stark wrote:
On 28 Feb 2014 06:19, Andres Freund and...@2ndquadrant.com wrote:
Generally the LSN is computed when writing, not when a buffer is
modified, so that's not particularly surprising. It'd be interesting to
see what the records are that end on
On 2/27/14, 12:53 PM, Fabien COELHO wrote:
A very minor fix to pgbench --help which is missing the expected
argument for the -t option.
done
Thanks!
--
Fabien.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On 28 February 2014 08:12, Andres Freund and...@2ndquadrant.com wrote:
On 2014-02-27 15:06:33 -0500, Andrew Dunstan wrote:
You realize that this API dates from 9.3 and has been used in numerous
extensions, right? So the names are pretty well fixed, for good or ill.
Sure. Doesn't prevent
On 02/28/2014 11:51 AM, Kyotaro HORIGUCHI wrote:
Hello,
2014/02/28 18:07 Andres Freund :
On 2014-02-28 17:55:21 +0900, Kyotaro HORIGUCHI wrote:
The recovery process stays on 'incosistent' state forever when
the server has crashed before any wal record is inserted after
the last checkpoint.
On Fri, Feb 28, 2014 at 5:08 AM, Abhijit Menon-Sen a...@2ndquadrant.com
wrote:
Hi Fabrízio.
Here are a few comments based on a quick look at your updated patch.
At 2014-02-13 22:44:56 -0200, fabriziome...@gmail.com wrote:
diff --git a/doc/src/sgml/ref/alter_index.sgml
* Dimitri Fontaine (dimi...@2ndquadrant.fr) wrote:
Stephen Frost sfr...@snowman.net writes:
# hstore extension
comment = 'data type for storing sets of (key, value) pairs'
default_version = '1.3'
directory = 'local/hstore-new'
module_pathname = '$directory/hstore'
Hi
Which equivalence rule from those are listed in
email's attachment are implemented in postgresql?
where are them?
Thanks
equivalenceRules.pdf
Description: Adobe PDF document
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
* Dimitri Fontaine (dimi...@2ndquadrant.fr) wrote:
Peter Eisentraut pete...@gmx.net writes:
I think we should get rid of the module_pathname business, and
extensions' SQL files should just refer to the base file name and rely
on the dynamic library path to find the files. What would we
On 28 February 2014 13:01, Andrew Dunstan and...@dunslane.net wrote:
On 02/28/2014 07:19 AM, Thom Brown wrote:
On 28 February 2014 08:12, Andres Freund and...@2ndquadrant.com mailto:
and...@2ndquadrant.com wrote:
On 2014-02-27 15:06:33 -0500, Andrew Dunstan wrote:
You realize
On 02/28/2014 07:19 AM, Thom Brown wrote:
On 28 February 2014 08:12, Andres Freund and...@2ndquadrant.com
mailto:and...@2ndquadrant.com wrote:
On 2014-02-27 15:06:33 -0500, Andrew Dunstan wrote:
You realize that this API dates from 9.3 and has been used in
numerous
Thanks for your patch!
On Fri, Feb 28, 2014 at 4:18 PM, pgsql...@postgresql.kr wrote:
I patched to add one column in pg_stat_statements module.
and sent to author but
I need a last time of query, because I want to analyse order by recent time.
Hm... I am not sure that this brings much to
On Thu, Feb 27, 2014 at 5:30 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Indeed. The root of the problem here is that we've never really thought
about changing a type's default opclass before. I don't think that a
two-line change in pg_dump fixes all the issues this will bring up.
I think we did
Pavel Stehule escribió:
so still I prefer to allow numeric time zones.
What I can:
a) disallow numeric only timezone without prefix + or -
or
b) add + prefix to time zone, when number is possitive.
I prefer @a.
I can live with (a) too. But I wonder if we should restrict the
On Tue, Jan 28, 2014 at 5:34 PM, Thom Brown t...@linux.com wrote:
Who would be up for mentoring this year? And are there any project
ideas folk would like to suggest?
I mentored in the past and felt I didn't do a very good job because I
didn't really understand the project the student was
* Peter Geoghegan (p...@heroku.com) wrote:
On Thu, Feb 27, 2014 at 8:07 PM, Peter Geoghegan p...@heroku.com wrote:
I'm not advocating authoring two extensions. I am tentatively
suggesting that we look at one extension for everything. That may well
be the least worst thing.
(Not that it's
On Thu, Feb 27, 2014 at 8:55 PM, Christophe Pettus x...@thebuild.com wrote:
On Feb 27, 2014, at 5:31 PM, Peter Geoghegan p...@heroku.com wrote:
Now, it's confusing that it has to go through hstore, perhaps, but
that's hardly all that bad in and of itself.
Yes, it is. It strikes me as
2014-02-27 18:15, Florian Pflug f...@phlo.org:
It can be possible to update the new operator class in the new cluster
as not default, before restore. After the restore, pg_upgrade can upgrade
the btree_gist extension and reset the operator class as the default.
pg_upgrade suggests to re-initdb
On 02/28/2014 09:27 AM, Robert Haas wrote:
On Thu, Feb 27, 2014 at 8:55 PM, Christophe Pettus x...@thebuild.com wrote:
On Feb 27, 2014, at 5:31 PM, Peter Geoghegan p...@heroku.com wrote:
Now, it's confusing that it has to go through hstore, perhaps, but
that's hardly all that bad in and of
* Robert Haas (robertmh...@gmail.com) wrote:
Taken individually, none of those decisions seem crazy, but taken
together it's pretty weird. Instead of inventing a new type (jsonb)
designed from the ground up to do what we want, we're, well, we're
doing what Christophe says: creating our own
W dniu 27.02.2014 22:25, Thom Brown pisze:
On 27 February 2014 21:08, David Fetter da...@fetter.org
mailto:da...@fetter.org wrote:
For MADlib, no. Are you asking for mentors in general?
Ah yes, I should clarify. Yes, mentors in general.
In general I can help but I'm not sure if I'm
On Fri, Feb 28, 2014 at 02:35:50PM +0900, Kyotaro HORIGUCHI wrote:
At Thu, 27 Feb 2014 21:53:52 -0500, Noah Misch wrote
On Thu, Feb 27, 2014 at 05:33:47PM -0500, Tom Lane wrote:
I wonder whether we should consider adding a pass to flatten any nested
appendrels after we're done creating
On Thu, Feb 27, 2014 at 4:14 PM, Christian Kruse
christ...@2ndquadrant.com wrote:
Hi,
On 25/02/14 16:11, Robert Haas wrote:
On Mon, Feb 24, 2014 at 10:13 AM, Christian Kruse
christ...@2ndquadrant.com wrote:
To be honest, I don't like the idea of setting up this error context
only for
On Feb28, 2014, at 15:45 , Emre Hasegeli e...@hasegeli.com wrote:
The problem is that pg_dump --binary-upgrade dumps objects in the extension
on the old cluster, not just the CREATE EXTENSION statement. pg_upgrade
fails to restore them, if the new operator class already exists on the new
* Kouhei Kaigai (kai...@ak.jp.nec.com) wrote:
* Stephen Frost (sfr...@snowman.net) wrote:
I don't see how you can be when there hasn't been any discussion that I've
seen about how parallel query execution is going to change things for us.
If parallel query execution changes whole of the
On 02/27/2014 11:02 PM, Christophe Pettus wrote:
On Feb 27, 2014, at 9:59 PM, Peter Geoghegan p...@heroku.com wrote:
I don't find that very reassuring.
Obviously, we have to try it, and that will decide it.
I don't understand why an extension is seen as not befitting
of a more important
On Feb28, 2014, at 05:29 , Tan Tran tankimt...@gmail.com wrote:
I'm applying for GSoC 2014 with Postgresql and would appreciate your comments
on my proposal (attached).
pg_gsoc2014_TanTran.pdf
First, please include your proposal as plain, inline text next time.
That makes it easier to quote
On Fri, Feb 28, 2014 at 8:57 AM, Stephen Frost sfr...@snowman.net wrote:
The specific issues mentioned on this thread look more like bugs to be
addressed or additional operators which need to be implemented for
jsonb (imv, that should really be done for 9.4, but we have this
deadline
2014-02-28 17:30, Florian Pflug f...@phlo.org:
Hm, what if we put the new opclass into an extension of its own, say
inet_gist,
instead of into core?
It will work but I do not think it is better than adding it in core as
not default.
--
Sent via pgsql-hackers mailing list
+v.size += VARSIZE_ANY(v.numeric) +sizeof(JEntry) /* alignment */ ;
Why does + sizeof(JEntry) change anything about alignment? If it was
aligned before, adding a statically sized value doesn't give any new
guarantees about alignment?
Teodor, please comment.
Because numeric type
Ali Piroozi wrote
Hi
Which equivalence rule from those are listed in
email's attachment are implemented in postgresql?
where are them?
What do you mean by where?
The various JOINS and UNION/INTERSECT/DIFFERENCE are all defined
capabilities.
SQL is not purely relational in nature so some of
On Feb 28, 2014, at 6:27 AM, Robert Haas robertmh...@gmail.com wrote:
Taken individually, none of those decisions seem crazy, but taken
together it's pretty weird. Instead of inventing a new type (jsonb)
designed from the ground up to do what we want, we're, well, we're
doing what
Hello
for beginners is relative difficult to set psql variable from command line
and option
-v ON_ERROR_STOP=1 is little bit unclean.
and for any user it is not comfortable. So I propose a new psql option
--on-error-stop
It is clean, and it will be mentioned in psql --help.
Comments, ideas?
On 02/27/2014 09:34 AM, Christian Kruse wrote:
Hi,
On 26/02/14 13:13, Alvaro Herrera wrote:
There's one thing that rubs me the wrong way about all this
functionality, which is that we've named it huge TLB pages. That is
wrong -- the TLB pages are not huge. In fact, as far as I understand,
On 02/28/2014 07:39 AM, Joshua D. Drake wrote:
This is an old and currently false argument. It is true that once upon a
time, contrib was a banished heart, weeping for the attention of a true
prince. Now? Not so much. She is a full on passion flower with the
princes of all the kingdoms
Pavel Stehule pavel.steh...@gmail.com writes:
for beginners is relative difficult to set psql variable from command line
and option
-v ON_ERROR_STOP=1 is little bit unclean.
and for any user it is not comfortable. So I propose a new psql option
--on-error-stop
That saves a whole three
2014-02-28 19:13 GMT+01:00 Tom Lane t...@sss.pgh.pa.us:
Pavel Stehule pavel.steh...@gmail.com writes:
for beginners is relative difficult to set psql variable from command
line
and option
-v ON_ERROR_STOP=1 is little bit unclean.
and for any user it is not comfortable. So I propose a
On Fri, Feb 28, 2014 at 3:17 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
2014-02-28 19:13 GMT+01:00 Tom Lane t...@sss.pgh.pa.us:
Pavel Stehule pavel.steh...@gmail.com writes:
for beginners is relative difficult to set psql variable from command
line
and option
-v ON_ERROR_STOP=1 is
2014-02-28 19:25 GMT+01:00 Fabrízio de Royes Mello fabriziome...@gmail.com
:
On Fri, Feb 28, 2014 at 3:17 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
2014-02-28 19:13 GMT+01:00 Tom Lane t...@sss.pgh.pa.us:
Pavel Stehule pavel.steh...@gmail.com writes:
for beginners is relative
Pavel Stehule escribió:
It is irony, so this is death code - it is not used now. So I removed it
from patch.
Reduced, fixed patch attached + used tests
Nice, thanks.
Here's a new version in which I reworded some comments and docs, and
also inverted the sense of some if/else so that the
where means, which function or which part of source code.
I want to use that(function or part of source code), to produce the
equivalence
(based on equivalence rules in attachment) Relational Algebra
for a given SQL query(Relational Algebra).
On Fri, Feb 28, 2014 at 5:01 AM, Andrew Dunstan and...@dunslane.net wrote:
But anyway, I think we've seen enough of these to conclude that the casts
from hstore to jsonb and back should not be implicit. I am fairly confident
that changing that would fix your complaint and the similar one that
Fabrízio de Royes Mello escribió:
On Fri, Feb 28, 2014 at 3:17 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
important is a placing in --help output
Well, then we just have to add more info to --help
I think psql could do with some lines for the possible options for
--pset (14) and
On Fri, Feb 28, 2014 at 3:44 PM, Alvaro Herrera alvhe...@2ndquadrant.com
wrote:
Fabrízio de Royes Mello escribió:
On Fri, Feb 28, 2014 at 3:17 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
important is a placing in --help output
Well, then we just have to add more info to --help
Peter Geoghegan p...@heroku.com writes:
On Fri, Feb 28, 2014 at 5:01 AM, Andrew Dunstan and...@dunslane.net wrote:
But anyway, I think we've seen enough of these to conclude that the casts
from hstore to jsonb and back should not be implicit. I am fairly confident
that changing that would fix
2014-02-28 19:31 GMT+01:00 Alvaro Herrera alvhe...@2ndquadrant.com:
Pavel Stehule escribió:
It is irony, so this is death code - it is not used now. So I removed it
from patch.
Reduced, fixed patch attached + used tests
Nice, thanks.
Here's a new version in which I reworded some
2014-02-28 19:55 GMT+01:00 Fabrízio de Royes Mello fabriziome...@gmail.com
:
On Fri, Feb 28, 2014 at 3:44 PM, Alvaro Herrera alvhe...@2ndquadrant.com
wrote:
Fabrízio de Royes Mello escribió:
On Fri, Feb 28, 2014 at 3:17 PM, Pavel Stehule
pavel.steh...@gmail.com
wrote:
On 02/28/2014 06:27 AM, Robert Haas wrote:
Taken individually, none of those decisions seem crazy, but taken
together it's pretty weird. Instead of inventing a new type (jsonb)
designed from the ground up to do what we want, we're, well, we're
doing what Christophe says: creating our own
On Fri, Feb 28, 2014 at 7:12 PM, Josh Berkus j...@agliodbs.com wrote:
* As cited, many sysadmins block the install of the -contrib package.
Of course the more you put things in core the more you make this logic
sound reasonable.
--
greg
--
Sent via pgsql-hackers mailing list
On 02/28/2014 02:00 PM, Tom Lane wrote:
Peter Geoghegan p...@heroku.com writes:
On Fri, Feb 28, 2014 at 5:01 AM, Andrew Dunstan and...@dunslane.net wrote:
But anyway, I think we've seen enough of these to conclude that the casts
from hstore to jsonb and back should not be implicit. I am
Josh Berkus j...@agliodbs.com writes:
... This requires larger changes to the existing patch, which likely means
missing the bus for 9.4 (and you've seen my blog about that)
Yeah. I realize you're gung-ho about getting jsonb into 9.4 in some
form, and I recognize that getting better JSON
On Fri, Feb 28, 2014 at 11:12 AM, Josh Berkus j...@agliodbs.com wrote:
I think Robert and Christophe are right: we're building a Berkeley BART
Curve. I think there's two courses of action from here which make sense:
A) We move *all* of the important HStore libraries and operators into
core,
On 2014-02-28 14:45:29 -0500, Andrew Dunstan wrote:
Well, the jsonb portion of this is arguably the most ready, certainly it's
had a lot more on-list review.
Having crossread both patches I tend to agree with this. I don't think
it's unrealistic to get jsonb committable, but the hstore bits are
On 02/28/2014 02:46 PM, Tom Lane wrote:
Josh Berkus j...@agliodbs.com writes:
... This requires larger changes to the existing patch, which likely means
missing the bus for 9.4 (and you've seen my blog about that)
Yeah. I realize you're gung-ho about getting jsonb into 9.4 in some
form, and
Pavel Stehule escribió:
I agree with Tom proposal - CINE - where object holds data, COR everywhere
else.
But it means, so all functionality from this patch have to be rewritten :(
So we return this patch with feedback, right? I don't think it's
reasonable to continue waiting this late.
I
Andrew Dunstan and...@dunslane.net writes:
That hasn't been the way we've done things in the past. We're frequently
incremental. New features sometimes take several releases to mature.
That's perfectly fair. What I don't want to see is a user-visible
dependency from jsonb to hstore. I think
Stephen Frost sfr...@snowman.net writes:
Yeah, default_version was the other one that looked like it might be
possible to include, but folks might decide to try and use 'comment' in
that way too. Basically, there's a chance that they'd want to use any
string in there.
Actually, I think that
On Fri, Feb 28, 2014 at 1:45 PM, Andrew Dunstan and...@dunslane.net wrote:
Well, the jsonb portion of this is arguably the most ready, certainly it's
had a lot more on-list review.
That is definitely true. Also, the jsonb type does not introduce any
new patterns that are not already covered
On 02/28/2014 11:19 AM, Greg Stark wrote:
On Fri, Feb 28, 2014 at 7:12 PM, Josh Berkus j...@agliodbs.com wrote:
* As cited, many sysadmins block the install of the -contrib package.
Of course the more you put things in core the more you make this logic
sound reasonable.
Touche'!
However,
On 02/28/2014 03:19 PM, Tom Lane wrote:
Andrew Dunstan and...@dunslane.net writes:
That hasn't been the way we've done things in the past. We're frequently
incremental. New features sometimes take several releases to mature.
That's perfectly fair. What I don't want to see is a user-visible
On 02/28/2014 01:27 PM, Pavel Stehule wrote:
three chars is not important
important is a placing in --help output
Well, then we just have to add more info to --help
it can be solution
+1 for at least doing that. I found it annoying just the other day not
On Feb 28, 2014, at 1:03 PM, Josh Berkus j...@agliodbs.com wrote:
However, the problems with admins not wanting to install -contrib aren't
really about what's in or not in -contrib.
I'll also mention that an increasingly large number of people are running
PostgreSQL in an environment where
On Fri, Feb 28, 2014 at 1:31 PM, Christophe Pettus x...@thebuild.com wrote:
I'll also mention that an increasingly large number of people are running
PostgreSQL in an environment where they don't get to pick what packages are
installed on their server (RDS, for example). Telling them that
On Fri, Feb 28, 2014 at 1:25 PM, Andrew Dunstan and...@dunslane.net wrote:
The only dependency is if you want to be able to use some advanced
indexing and other functionality, for which we don't currently have jsonb
equivalents of the new hstore operators, because we ran out of time. Then
you
On Feb 28, 2014, at 1:35 PM, Peter Geoghegan p...@heroku.com wrote:
I don't think hstore-style indexing is advanced; it's the main
reason for there being a jsonb, in my view.
jsonb is significantly faster than json even without indexing; there are plenty
of reasons to have jsonb even if we
Andrew Dunstan and...@dunslane.net writes:
Well, then we just have to add more info to --help
+1 for at least doing that. I found it annoying just the other day not
to find it in plsql's --help output, in a moment of brain fade when I
forgot how to spell it. So it's not just beginners who
On Feb 28, 2014, at 1:34 PM, Peter Geoghegan p...@heroku.com wrote:
Amazon RDS Postgres has hstore.
Just observing that putting something in -contrib does not mean every
installation can automatically adopt it.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-hackers
2014-02-28 22:38 GMT+01:00 Tom Lane t...@sss.pgh.pa.us:
Andrew Dunstan and...@dunslane.net writes:
Well, then we just have to add more info to --help
+1 for at least doing that. I found it annoying just the other day not
to find it in plsql's --help output, in a moment of brain fade when
On Fri, February 28, 2014 22:38, Tom Lane wrote:
Andrew Dunstan and...@dunslane.net writes:
Well, then we just have to add more info to --help
+1 for at least doing that. I found it annoying just the other day not
to find it in plsql's --help output, in a moment of brain fade when I
forgot
2014-02-28 22:52 GMT+01:00 Erik Rijkers e...@xs4all.nl:
On Fri, February 28, 2014 22:38, Tom Lane wrote:
Andrew Dunstan and...@dunslane.net writes:
Well, then we just have to add more info to --help
+1 for at least doing that. I found it annoying just the other day not
to find it in
On 02/28/2014 04:38 PM, Tom Lane wrote:
Andrew Dunstan and...@dunslane.net writes:
Well, then we just have to add more info to --help
+1 for at least doing that. I found it annoying just the other day not
to find it in plsql's --help output, in a moment of brain fade when I
forgot how to
2014-02-28 23:01 GMT+01:00 Andrew Dunstan and...@dunslane.net:
On 02/28/2014 04:38 PM, Tom Lane wrote:
Andrew Dunstan and...@dunslane.net writes:
Well, then we just have to add more info to --help
+1 for at least doing that. I found it annoying just the other day not
to find it in
On Fri, Feb 28, 2014 at 1:38 PM, Christophe Pettus x...@thebuild.com wrote:
jsonb is significantly faster than json even without indexing; there are
plenty of reasons to have jsonb even if we don't initially have indexing
operations for it.
That may be true, although I think that that's
Hi
However, I don't think this is behaving sanely in pg_dumpall. AFAICT,
pg_dumpall does not pass --clean to pg_dump (in other words it only
emits DROP for the global objects, not the objects contained inside
databases), so passing --if-exists results in failures. Therefore I
think the
2014-02-28 23:13 GMT+01:00 Pavel Stehule pavel.steh...@gmail.com:
Hi
However, I don't think this is behaving sanely in pg_dumpall. AFAICT,
pg_dumpall does not pass --clean to pg_dump (in other words it only
emits DROP for the global objects, not the objects contained inside
databases), so
This patch has redesigned implementation --if-exists for pg_dumpall. Now it
is not propagated to pg_dump, but used on pg_dumpall level.
Regards
Pavel
2014-02-28 23:18 GMT+01:00 Pavel Stehule pavel.steh...@gmail.com:
2014-02-28 23:13 GMT+01:00 Pavel Stehule pavel.steh...@gmail.com:
Hi
On Feb 28, 2014, at 2:12 PM, Peter Geoghegan p...@heroku.com wrote:
AFAICT, we have these
operator classes that work fine with jsonb for the purposes of
hstore-style indexing (the hstore operator classes).
That assumes that it is acceptable that jsonb be packaged in the hstore
extension.
On Fri, Feb 28, 2014 at 2:40 PM, Christophe Pettus x...@thebuild.com wrote:
On Feb 28, 2014, at 2:12 PM, Peter Geoghegan p...@heroku.com wrote:
AFAICT, we have these
operator classes that work fine with jsonb for the purposes of
hstore-style indexing (the hstore operator classes).
That
2014-03-01 0:36 GMT+09:00 Stephen Frost sfr...@snowman.net:
* Kouhei Kaigai (kai...@ak.jp.nec.com) wrote:
* Stephen Frost (sfr...@snowman.net) wrote:
I don't see how you can be when there hasn't been any discussion that I've
seen about how parallel query execution is going to change things
We have a couple of open bug reports in which the regex library takes
unreasonable amounts of time and/or memory to process a regexp. While
I have hopes that both of the known issues can be improved, it seems
likely that there will always be cases where sufficiently complicated
regexps just take
As announced with last week's releases, use of trust authentication in the
make check temporary database cluster makes it straightforward to hijack the
OS user account involved. The prerequisite is another user account on the
same system. The solution we discussed on secur...@postgresql.org was
On Sat, Jan 18, 2014 at 11:12 PM, Stephen Frost sfr...@snowman.net wrote:
Fabrízio, can you clarify the use-case for things like CREATE AGGREGATE
to have IF NOT EXISTS rather than OR REPLACE, or if there is a reason
why both should exist? Complicating our CREATE options is not something
we
On Fri, Feb 28, 2014 at 5:05 PM, Alvaro Herrera alvhe...@2ndquadrant.com
wrote:
Pavel Stehule escribió:
I agree with Tom proposal - CINE - where object holds data, COR
everywhere
else.
But it means, so all functionality from this patch have to be rewritten
:(
So we return this patch
On Fri, Feb 28, 2014 at 9:43 AM, Heikki Linnakangas
hlinnakan...@vmware.com wrote:
Hmm, I wonder if that could now be misunderstood to have something to do
with the PostgreSQL page size? Maybe add the word memory or operating
system in the first sentence in the docs, like this: Enables/disables
2014-02-28 22:52 GMT+01:00 Erik Rijkers e...@xs4all.nl:
e.g.: -v ON_ERROR_STOP=1
I checked it and it is not the most long line there, so it can be a good
solution.
Pavel
98 matches
Mail list logo