A.M. age...@themactionfaction.com writes:
On Apr 11, 2011, at 7:13 PM, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
I mean I'm not convinced that fcntl() locking will be as reliable.
I'm not either. Particularly not on NFS.
Is there an example of a recent system where fcntl is
On Tuesday 12 April 2011 01.02:35 Lucas Cotta wrote:
Does postgre execute the queries following a execution plan tree, where
the leafs are table scans, and the nodes are joins?
yes, see the EXPLAIN SQL command (EXPLAIN SELECT * FROM ), it will
shwo this tree.
On Tue, Apr 12, 2011 at 22:36, Brar Piening b...@gmx.de wrote:
On Tue, 12 Apr 2011 08:51:57 -0400, Andrew Dunstan and...@dunslane.net
wrote:
that's in the SDK? If not, I still think that should be our primary
option - I certainly don't see how it's obsolete. (and you can,
afaics, still get
The code we added recently to the stack-depth check to also check the
register stack on ia64 doesn't compile on HP-UX B.11.31, using the HP
aCC compiler:
cc -Ae +O2 -g -I../../../src/include -D_XOPEN_SOURCE_EXTENDED -c -o
postgres.o postgres.c
postgres.c, line 3002: warning #2837-D:
On 04/13/2011 05:12 AM, Heikki Linnakangas wrote:
The code we added recently to the stack-depth check to also check the
register stack on ia64 doesn't compile on HP-UX B.11.31, using the HP
aCC compiler:
cc -Ae +O2 -g -I../../../src/include -D_XOPEN_SOURCE_EXTENDED -c -o
postgres.o
On 13.04.2011 14:22, Andrew Dunstan wrote:
I wish we could get some buildfarm coverage for HPUX. I've whined about
this in the past, but nobody's ever made an offer to provide suitable
platform(s) that I know of.
I only have temporary access to this HPUX box, but I'm trying to arrange
that.
On Apr 13, 2011, at 2:06 AM, Tom Lane wrote:
A.M. age...@themactionfaction.com writes:
On Apr 11, 2011, at 7:13 PM, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
I mean I'm not convinced that fcntl() locking will be as reliable.
I'm not either. Particularly not on NFS.
Is
The attached patches fixes a pg_upgrade crash in 9.0 caused by a new
cluster database that doesn't exist in the old cluster; instead throw
an error. This was reported to me by EnterpriseDB testing staff. This
bug does not exist in git head.
--
Bruce Momjian br...@momjian.us
pg_regress supports a --multibyte option, which can also be invoked
using the MULTIBYTE make variable when you run make check. I think this
is fairly unknown, but we are now documenting it as part of how to run
the collation regression tests. I think it would also be useful in the
PL/Python
On Tue, Apr 12, 2011 at 4:14 PM, Andres Freund and...@anarazel.de wrote:
Also add some regression tests for that behaviour.
Found after seing a report about it in IRC by Daniel Grace.
This patch didn't apply cleanly for me, but I committed the basic fix.
--
Robert Haas
EnterpriseDB:
An off-list discussion with Leo Carson of SDSC led to the following
test case, which reproducibly crashes 8.4:
-- do this in the regression database, or use some other base table
create or replace view vv as
select a.unique1, b.unique2, c.tenthous, 'label'::text as lab
from tenk1 a
left join
Peter Eisentraut pete...@gmx.net writes:
pg_regress supports a --multibyte option, which can also be invoked
using the MULTIBYTE make variable when you run make check. I think this
is fairly unknown, but we are now documenting it as part of how to run
the collation regression tests. I think
On Wed, 13 Apr 2011 10:45:25 +0200, Magnus Hagander
mag...@hagander.net wrote:
So per your experience, all we really need to do is to define what the
*max* level of the Windows SDK we can use is, to make sure people
don't get the VS2010 compiler instead?
(And adding the note that VS2010 isn't
On Wed, Apr 13, 2011 at 7:20 AM, A.M. age...@themactionfaction.com wrote:
The goal of this patch is to eliminate SysV shared memory, not to implement
NFS-capable locking which, as you point out, is virtually impossible.
As far as I can tell, in the worst case, my patch does not change how
Robert Haas robertmh...@gmail.com writes:
In answer to your off-list question, one of the principle ways I've
seen fcntl() locking fall over and die is when someone removes the
lock file. You might think that this could be avoided by picking
something important like pg_control as the log
On Apr 13, 2011, at 8:36 PM, Robert Haas wrote:
I don't see why we need to get rid of SysV shared memory; needing less
of it seems just as good.
1. As long one keeps SysV shared memory around, the postgresql project has to
maintain the annoying platform-specific document on how to configure
On Sun, Apr 10, 2011 at 5:23 AM, Noah Misch n...@leadboat.com wrote:
On Sun, Apr 10, 2011 at 07:35:53AM -0400, Robert Haas wrote:
On Sun, Apr 10, 2011 at 6:36 AM, Noah Misch n...@leadboat.com wrote:
3. Make AlterTableCreateToastTable acquire only ShareUpdateExclusiveLock
and
remove the
On Wed, Apr 13, 2011 at 6:11 PM, A.M. age...@themactionfaction.com wrote:
I don't see why we need to get rid of SysV shared memory; needing less
of it seems just as good.
1. As long one keeps SysV shared memory around, the postgresql project has to
maintain the annoying platform-specific
On Mon, Apr 11, 2011 at 1:39 PM, Зотов Роман zo...@oe-it.ru wrote:
11.04.2011 5:19, Robert Haas пишет:
You only sent this to me, I think; I assume you meant to copy the list.
...Robert
On Mar 16, 2011, at 12:46 AM, Zotovzo...@oe-it.ru wrote:
I send full patch, prev patch could be not so
On Sat, Apr 9, 2011 at 6:57 PM, Noah Misch n...@leadboat.com wrote:
While looking at the typed table/pg_upgrade problem, I ran into a few smaller
problems in the area. I'm not envisioning a need for much code shift to fix
them, but there are a few points of policy.
* Table row types used in
On Fri, Apr 8, 2011 at 5:12 PM, Noah Misch n...@leadboat.com wrote:
Implemented as attached. The first patch just adds the ALTER TABLE
subcommands
to attach and detach a table from a composite type. A few open questions
concerning typed tables will probably yield minor changes to these
A.M. age...@themactionfaction.com writes:
1. As long one keeps SysV shared memory around, the postgresql project
has to maintain the annoying platform-specific document on how to
configure the poorly named kernel parameters.
No, if it's just a small area, I don't see that that's an issue.
Robert Haas robertmh...@gmail.com writes:
If we adopt the elsewhere-proposed approach of forbidding the use of
rowtypes to create typed tables, the circularity-checking logic here
can become simpler. I think it's not actually water-tight right now:
rhaas=# create table a (x int);
CREATE
I wish we could get some buildfarm coverage for HPUX. I've whined about this in
the past, but nobody's ever made an offer to provide suitable platform(s) that I
know of.
cheers
I've got two HP-UX 11 boxes, PA-RISC and IA64.
From uname:
HP-UX B.11.23 U 9000/785
HP-UX B.11.23 U ia64
They
24 matches
Mail list logo