On Thu, Oct 14, 2010 at 05:53:30PM -0400, Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
Should we consider moving pg_filedump into our /contrib?
Can't: it's GPL.
Depends on whether we can get it relicensed.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone:
On Tue, 12 Oct 2010 20:03:29 +0200, Magnus Hagander mag...@hagander.net
wrote:
On Tue, Oct 12, 2010 at 17:55, David Fetter da...@fetter.org wrote:
On Tue, Oct 12, 2010 at 10:37:00AM -0500, Kevin Grittner wrote:
David Fetter da...@fetter.org wrote:
Is there something incomplete about the ones
Recently I worked a lot with gist and read about knngist. I have spotted
weaknesses in docs. So I would be happy to help if you tell me how.
On Fri, Oct 15, 2010 at 5:57 AM, Robert Haas robertmh...@gmail.com wrote:
On Wed, Oct 13, 2010 at 7:07 PM, Marios Vodas mvo...@gmail.com wrote:
I would
--On 14. Oktober 2010 20:47:27 +0100 Dean Rasheed
dean.a.rash...@gmail.com wrote:
OK, here it is.
I've not cured this compiler warning (in fact I'm not sure what it's
complaining about, because the variable *is* used):
tablecmds.c: In function 'ATExecSetNotNull':
tablecmds.c:4747:
On 15 October 2010 08:32, Bernd Helmle maili...@oopsware.de wrote:
--On 14. Oktober 2010 20:47:27 +0100 Dean Rasheed dean.a.rash...@gmail.com
wrote:
OK, here it is.
I've not cured this compiler warning (in fact I'm not sure what it's
complaining about, because the variable *is* used):
On Thu, Oct 14, 2010 at 2:53 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Bruce Momjian br...@momjian.us writes:
Should we consider moving pg_filedump into our /contrib?
Can't: it's GPL.
I don't particularly see a problem with having GPL'd contrib modules.
It would mean any users hoping to
On Fri, Oct 15, 2010 at 08:56, Radosław Smogura
rsmog...@softperience.eu wrote:
On Tue, 12 Oct 2010 20:03:29 +0200, Magnus Hagander mag...@hagander.net
wrote:
On Tue, Oct 12, 2010 at 17:55, David Fetter da...@fetter.org wrote:
On Tue, Oct 12, 2010 at 10:37:00AM -0500, Kevin Grittner wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
Maybe it would be worthwhile to split the parts that parse a file and
execute from a file, and submit separately. It is obviously
self-contained and serves a useful purpose on its own. It also forces
you to think harder about renaming the
On Fri, 15 Oct 2010 10:37:05 +0200, Magnus Hagander mag...@hagander.net
wrote:
But... connection pooler will not send RESET ALL in some situations,
because JDBC driver can have no notify about switching client. In EE
platforms (e. g. Glassfish), server sometimes creates it's own pool and
in
On Thu, 2010-10-14 at 18:05 -0400, Tom Lane wrote:
Brendan Jurd dire...@gmail.com writes:
Agreed that there are no doc bugs. The reason I suggested a backpatch
is that I'm concerned that a lot of people are going to be approaching
the whole Standby topic for the first time with 9.0, so it
2010/10/15 Itagaki Takahiro itagaki.takah...@gmail.com:
On Fri, Oct 15, 2010 at 12:59 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
then maybe %ls or %is - like literal string or ident string.
Yeah, good idea!
I don't think so merging sprintf and format can be good. Sprintf is
too
On Fri, Oct 15, 2010 at 8:20 PM, Pavel Stehule pavel.steh...@gmail.com wrote:
And the reply is - we have function to_char. I don't see any reason
why we have to have two independent formatting systems.
The formats for literal and identifier can be replaced to quote_nullable() and
quote_ident(),
On Fri, 15 Oct 2010, Marios Vodas wrote:
Recently I worked a lot with gist and read about knngist. I have spotted
weaknesses in docs. So I would be happy to help if you tell me how.
We have some documentation already, Teodor will post soon. Marios,
I'd happy to help in writing docs. Do you
Hi,
As the result of the discussion, I think that we need the following two
parameters for the case where the standby goes down.
* replication_timeout
This is the maximum time to wait for the ACK from the standby. If this
timeout expires, the master closes the replication connection and
KaiGai,
* KaiGai Kohei (kai...@kaigai.gr.jp) wrote:
However, it requires the plugin modules need to know everything;
such as what is visible/invisible. It seems to me too closely-
coupled interface.
I agree with Robert on this one. We're not trying to design a wholly
independent security
On Fri, Oct 15, 2010 at 4:06 AM, Dean Rasheed dean.a.rash...@gmail.com wrote:
If these were the only problems with this patch, given that they
required only trivial changes to initialise variables to NIL/false,
perhaps it was premature to mark it as returned with feedback.
Sure. Is someone
The new patch applies cleanly to head, there are no compile errors and
all the make check tests pass (linux).
Thanks
Andrew
On Thu, Oct 14, 2010 at 4:35 PM, Bernd Helmle maili...@oopsware.de wrote:
--On 14. Oktober 2010 16:28:51 -0300 Alvaro Herrera
alvhe...@commandprompt.com wrote:
On Fri, Oct 15, 2010 at 2:36 AM, Greg Stark gsst...@mit.edu wrote:
On Thu, Oct 14, 2010 at 2:53 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Bruce Momjian br...@momjian.us writes:
Should we consider moving pg_filedump into our /contrib?
Can't: it's GPL.
I don't particularly see a problem with
On Fri, Oct 15, 2010 at 12:55 AM, Itagaki Takahiro
itagaki.takah...@gmail.com wrote:
On Fri, Oct 15, 2010 at 12:59 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
then maybe %ls or %is - like literal string or ident string.
Yeah, good idea!
-1 from me. What does this do except make it
On 10/15/2010 7:24 AM, Robert Haas wrote:
I think that's a bad idea for all kinds of reasons. For one thing, it
seems that someone could easily end up copying some of that code into
some other place. It would be *nice* to have this available as part
of our regular distribution but I don't
Howdy folks,
Was wondering if there are any docs on which contrib modules don't work with
pg_upgrade? I seem to remember discussion on this during the 9.0 cycle, but
couldn't find it in the mail archive, and don't see anything in the wiki. What
brings this up is I'm currently working on an
On 10/15/2010 02:36 AM, Greg Stark wrote:
On Thu, Oct 14, 2010 at 2:53 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Bruce Momjianbr...@momjian.us writes:
Should we consider moving pg_filedump into our /contrib?
Can't: it's GPL.
I don't particularly see a problem with having GPL'd contrib
Robert Haas robertmh...@gmail.com writes:
On Fri, Oct 15, 2010 at 2:36 AM, Greg Stark gsst...@mit.edu wrote:
I don't particularly see a problem with having GPL'd contrib modules.
I think that's a bad idea for all kinds of reasons.
Yeah. From my viewpoint as a downstream packager, it creates
On 10/15/2010 04:33 AM, Dean Rasheed wrote:
I started looking at this last night, but ran out of time. I'll
continue this evening / over the weekend. Here are my comments so far:
Patch applies cleanly to current git master with no offsets.
Compiles cleanly with no warnings.
Regression tests
Hi Robert,
I would like to contribute for community. Under licence used by PostgreSQL.
So is (or was) there anybody with the same interest as me?
Původní zpráva
Od: Robert Haas robertmh...@gmail.com
Předmět: Re: [HACKERS] XML schema validation
Datum: 15.10.2010
* Radosław Smogura (rsmog...@softperience.eu) wrote:
To me, that sounds like a bug in the connection pooler. It is only
safe under quite limited circumstances.
It's hard to say this is bug. The GF connection pooler is general pooler
for all drivers, so it can't know anything about
=?UTF-8?Q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
On Fri, 15 Oct 2010 10:37:05 +0200, Magnus Hagander mag...@hagander.net
wrote:
But... connection pooler will not send RESET ALL in some situations,
To me, that sounds like a bug in the connection pooler. It is only
safe under
Robert Haas robertmh...@gmail.com writes:
On Fri, Oct 15, 2010 at 4:06 AM, Dean Rasheed dean.a.rash...@gmail.com
wrote:
If these were the only problems with this patch, given that they
required only trivial changes to initialise variables to NIL/false,
perhaps it was premature to mark it as
David Boreham david_l...@boreham.org writes:
Just wondering what was the motivation to GPL this code ?
It was written at Red Hat and they have (or at least had at the time)
a company policy of using GPL for any code written in-house.
regards, tom lane
--
Sent via
Stephen Frost sfr...@snowman.net writes:
* RadosÅaw Smogura (rsmog...@softperience.eu) wrote:
But benefits of pooling statements are much more greater then RESET ALL,
because you can take advance of precompiling prepared statements,
increasing performance; it is comparable to using connection
On 15/10/10 15:08, Tomáš Pospíšil wrote:
Hi Robert,
I would like to contribute for community. Under licence used by PostgreSQL.
So is (or was) there anybody with the same interest as me?
Yes, I've been looking at improving the XML support overall, or at least
working to finish the
On 14/10/10 15:53, Alastair Turner wrote:
It isn't a TODO item, or related to any previous thread I could find.
It's certainly something I can see a use for. When I'm having a bad
typing day I get annoyed that I find I've made a mistake after I've
typed the password. To me this is a
* Tom Lane (t...@sss.pgh.pa.us) wrote:
Stephen Frost sfr...@snowman.net writes:
errr, I don't believe RESET ALL touches cache'd plans and whatnot (which
is actually a problem I've run into in the past, because changing the
search_path also doesn't invalidate plans, and neither does set
Robert Haas robertmh...@gmail.com writes:
On Fri, Oct 15, 2010 at 12:55 AM, Itagaki Takahiro
itagaki.takah...@gmail.com wrote:
I agree that full-spec sprintf is too complex, but precision and
zero-full for numeric types are commonly used. I think someone
will ask us Why don't have numeric
On Thu, Oct 14, 2010 at 19:37, Greg Smith g...@2ndquadrant.com wrote:
We got an interesting documentation document left by Christian Freund
recently, in regards to
http://www.postgresql.org/docs/9.0/interactive/install-windows-full.html ;
it says:
Regarding 16.1.3 - perl mkvcbuild.pl
In
On Fri, 2010-10-15 at 21:41 +0900, Fujii Masao wrote:
As the result of the discussion, I think that we need the following two
parameters for the case where the standby goes down.
* replication_timeout
This is the maximum time to wait for the ACK from the standby. If this
timeout
forward. Tom and I laid out a technical design back in January and I
still think it's a good one, even though I know you think it's silly.
We may just have to agree to disagree on this point.
As I remember, there were several suggested designs:
1) 5-th boolean column (amopfamily,
Teodor Sigaev teo...@sigaev.ru writes:
As I remember, there were several suggested designs:
1) 5-th boolean column (amopfamily, amoplefttype, amoprighttype,
amopstrategy,
amoporder) to point kind of operator (search or order)
+ saves one record for operator in pg_amop
- operator
Tom Lane wrote:
I'm all for doing this client-side.
Well, that makes a big difference. Unless someone can make a
convincing argument for why we should modify the server side to
support this, I think we should just focus on this one client-side
patch.
I'd be happy to give it a closer
Hi.
Ahh, as for Japanese, it becomes the same.
C:\MinGW\home\HIROSHIvcbuild /?
Microsoft(R) Visual C++ Project Builder - コマンド ライン バージョン 9.00.21022
Copyright (C) Microsoft Corporation. All rights reserved.
http://winpg.jp/~saito/pg_work/VisualStudio/vcbuild_help_SJIS.txt
Regards,
Hiroshi Saito
On Wed, 2010-10-13 at 22:29 +0200, Alastair Turner wrote:
I am proposing altering psql to raise certain errors and exit before
prompting for a password. These errors would have to be on items which
didn't leak any information, my current list is:
- Does the input file (-f) exist and is it
On 10/15/2010 05:43 PM, Simon Riggs wrote:
On Fri, 2010-10-15 at 21:41 +0900, Fujii Masao wrote:
As the result of the discussion, I think that we need the following two
parameters for the case where the standby goes down.
* replication_timeout
This is the maximum time to wait for the ACK
Bernd Helmle maili...@oopsware.de writes:
Here is an updated version of the patch. It fixes the following issues
Andrew discovered during his review cycle:
I looked through this a bit. It's not ready to commit unfortunately.
The main gripe I've got is that you've paid very little attention to
On Fri, 2010-10-15 at 18:51 +0200, Stefan Kaltenbrunner wrote:
When exactly don't the keepalives work?
well tcp level keepalives are not terribly portable(or can only be
partially controlledd from the app) and on some platforms have lower
limits that are in the minutes which is too long
Dimitri Fontaine dimi...@2ndquadrant.fr writes:
So, you will find two new branches for those purposes at the repository,
named cfparser and pg_execute_from_file:
http://git.postgresql.org/gitweb?p=postgresql-extension.git;a=summary
I updated the pg_execute_from_file branch with
On Thu, Oct 14, 2010 at 7:35 PM, Tatsuo Ishii is...@postgresql.org wrote:
What new public interfaces do you think are needed for 9.1 in this
regard?
At this point I'm thinking of modifying existing pg_is_in_recovery(),
thus 0 new public interface.
pg_is_in_recovery() returns a bool, are you
[Moving to -hackers]
On Fri, Oct 15, 2010 at 3:43 AM, Simon Riggs si...@2ndquadrant.com wrote:
On Mon, 2010-10-11 at 09:41 -0400, Josh Kupershmidt wrote:
On Thu, Oct 7, 2010 at 7:43 PM, Josh Kupershmidt schmi...@gmail.com wrote:
I noticed that granting a user column-level update privileges
Hitoshi Harada umi.tan...@gmail.com writes:
2010/10/15 Tom Lane t...@sss.pgh.pa.us:
I think it'd be hard to describe without confusing people, because
while DISTINCT is a noise word there, it's definitely not a noise
word after SELECT.
I thought adding DISTINCT next to ALL is enough like
I have addressed these issues in my final patch. One other change I did
was change the host name comparison to case insensitive (Apache and TCP
Wrappers do the same).
I'm planning to work on a wildcard mechanism soon. After that the issue
of which way the host resolution should work will have
Stephen Frost sfr...@snowman.net writes:
That assumption is certainly something I feel we should consider a valid
and important use-case. I'd think a lot of the time your typical website
is going to be using a dedicated pooler for connections and a dedicated
database where having those
Dimitri,
* Dimitri Fontaine (dimi...@2ndquadrant.fr) wrote:
[... much useful info ...]
Thanks for all of that, I certainly appreciate it.
By default pgbouncer maintains a different pool per database and role,
so you should be partly covered here.
No, not really.. We have a single
Stephen Frost sfr...@snowman.net writes:
The whole problem with search_path and role is very frustrating. We've
taken to just hacking things to be dynamic SQL whenever it's
role-specific, but that's a really poor solution. I wonder if it would
be possible to have the function and prepare'd
Tom Lane t...@sss.pgh.pa.us writes:
* Lots of bogus trailing whitespace. git diff --check can help you
with that.
This is a repetitive common remark that I think sharing tips to avoid
that problem is a good idea. Here's an emacs setup to have trailing
whitespace hurt the eyes, and more-than-80
* Tom Lane (t...@sss.pgh.pa.us) wrote:
Stephen Frost sfr...@snowman.net writes:
The whole problem with search_path and role is very frustrating. We've
taken to just hacking things to be dynamic SQL whenever it's
role-specific, but that's a really poor solution. I wonder if it would
be
On 09/27/2010 08:13 AM, Andrew Dunstan wrote:
In about a week I propose to have the buildfarm server start to reject
results based on snapshots where the newest file is older than the
time of the git migration a week ago. That means buildfarm owners need
to upgrade to using git. Many have
On Fri, Oct 15, 2010 at 10:54 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Fri, Oct 15, 2010 at 12:55 AM, Itagaki Takahiro
itagaki.takah...@gmail.com wrote:
I agree that full-spec sprintf is too complex, but precision and
zero-full for numeric types are
Stephen Frost sfr...@snowman.net writes:
IOW, yeah, you're right, the role doesn't really matter. One thing that
occurs to me when I last ran into a problem with this- it was painful to
debug because the permission denied error didn't indicate which schema
the table it was trying to access
Andrew Dunstan and...@dunslane.net writes:
I have now implemented a policy of refusing results from snapshots older
than 10 days. It's not quite what I said above, but I think it's sound
policy.
+1.
Might be time to advise buildfarm owners to shut down the 7.4 and 8.0
branches, and remind
On Fri, Oct 15, 2010 at 12:02 PM, Tom Lane t...@sss.pgh.pa.us wrote:
BTW, have we discussed the idea of embedding the role in the strategy
number? For example, require regular operators to have strategy
numbers 1-, while ordering operators have numbers 1-1,
leaving room for a
Robert Haas robertmh...@gmail.com writes:
On Fri, Oct 15, 2010 at 10:54 AM, Tom Lane t...@sss.pgh.pa.us wrote:
I think we should go into this with the idea that it might only do 10%
of what sprintf can do initially, but there will be pressure to cover a
lot of the other 90% eventually.
Hmm.
On Fri, Oct 15, 2010 at 5:35 PM, Robert Haas robertmh...@gmail.com wrote:
On Fri, Oct 15, 2010 at 12:02 PM, Tom Lane t...@sss.pgh.pa.us wrote:
BTW, have we discussed the idea of embedding the role in the strategy
number? For example, require regular operators to have strategy
numbers 1-,
On Fri, Oct 15, 2010 at 5:42 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Fri, Oct 15, 2010 at 10:54 AM, Tom Lane t...@sss.pgh.pa.us wrote:
I think we should go into this with the idea that it might only do 10%
of what sprintf can do initially, but there
Robert Haas robertmh...@gmail.com writes:
I still feel vaguely uneasy about the fact that the proposed patch
can't handle ASC/DESC or NULLS FIRST/LAST, and that unease grew a bit
more last night when I read Peter's patch to add collation support.
Good point.
We could possibly cram ASC/DESC
On Fri, Oct 15, 2010 at 7:10 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
I still feel vaguely uneasy about the fact that the proposed patch
can't handle ASC/DESC or NULLS FIRST/LAST, and that unease grew a bit
more last night when I read Peter's patch to
Hitoshi Harada umi.tan...@gmail.com writes:
2010/10/5 Marko Tiikkaja marko.tiikk...@cs.helsinki.fi:
This patch conflicted with Tom's WITH .. INSERT change. I tweaked the
patch just a bit and it now passes all regression tests so I can review
it. New version attached for documentation
Robert Haas robertmh...@gmail.com writes:
On Fri, Oct 15, 2010 at 7:10 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Well, we cannot avoid changing pg_amop, or at least changing its
interpretation, because the current scheme simply can't represent
indexable operators that are used for anything except
On Fri, Oct 15, 2010 at 8:10 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Perhaps we should think of pg_amop not so much
as a way to tell the AM what to do, but just a way to tell it what
operator is logically involved without relying on the name or OID.
I already think of it that way ...
OK.
--On 15. Oktober 2010 13:36:38 -0400 Tom Lane t...@sss.pgh.pa.us wrote:
Bernd Helmle maili...@oopsware.de writes:
Here is an updated version of the patch. It fixes the following issues
Andrew discovered during his review cycle:
I looked through this a bit. It's not ready to commit
On Fri, Oct 15, 2010 at 8:45 PM, Robert Haas robertmh...@gmail.com wrote:
On Fri, Oct 15, 2010 at 8:10 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Perhaps we should think of pg_amop not so much
as a way to tell the AM what to do, but just a way to tell it what
operator is logically involved without
On 15/10/2010 10:38 PM, Tom Lane wrote:
Yeah, actually what you need is DISCARD ALL when reassigning a
connection to another client. Anything less than that assumes the
clients are cooperating closely, ie they *want* the same prepared
statements etc.
For what it's worth, this is quite common
Excerpts from Dimitri Fontaine's message of vie oct 15 16:15:23 -0300 2010:
Dimitri Fontaine dimi...@2ndquadrant.fr writes:
So, you will find two new branches for those purposes at the repository,
named cfparser and pg_execute_from_file:
Excerpts from Alvaro Herrera's message of sáb oct 16 00:30:41 -0300 2010:
Hmm, did you try make install in contrib? It fails for me in intagg:
make[1]: Entering directory
`/home/alvherre/Code/CVS/pgsql/build/HEAD/contrib/intagg'
/bin/mkdir -p '/pgsql/install/HEAD/share/contrib'
touch
Excerpts from Dimitri Fontaine's message of vie oct 15 16:15:23 -0300 2010:
I updated the pg_execute_from_file branch with documentation for the
function, and added documentation (catalog, functions, custom classes)
to the main feature branch too.
Hmm. To be honest I don't like the direction
73 matches
Mail list logo
