I think I see what is going on now. We are sometimes failing to set the
commitSeqNo correctly on the lock. In particular, if a lock assigned to
OldCommittedSxact is marked with InvalidSerCommitNo, it will never be
cleared.
The attached patch corrects this:
TransferPredicateLocksToNewTarget
Hi,
I can't help thinking I must be missing something obvious here, but is
there any way to persist some data from PlanForeignScan to at least
BeginForeignScan in an FDW? I'm aware of fdwplan-fdw_private, but at
that needs to be copyObject compatible, it's not much use to me.
The issue I have is
On fre, 2011-04-01 at 09:12 +0200, Adrian von Bidder wrote:
Since URI stings are popular, it might really make sense if pg could
recommend a preferred form of postgres URI strings (and obviously
implement it in libpq). For the non-libpq APIs (there's at least
On Sat, 2011-04-02 at 18:10 -0400, Tom Lane wrote:
It could explain Devrim's report if the parameters passed by psql had
some problem that was detectable by conninfo_array_parse(). That
seems a bit unlikely, but I did think of one possibility: if Devrim
was
testing 9.1 psql with a 9.0
On Thu, Mar 31, 2011 at 22:10, Peter Eisentraut pete...@gmx.net wrote:
On tor, 2011-03-31 at 16:00 -0400, Andrew Dunstan wrote:
On 03/31/2011 03:38 PM, Peter Eisentraut wrote:
So is 2010 supported, and where is the vcbuild program supposed to come
from?
Not that I know of. But VS 2008
Dave Page dp...@pgadmin.org writes:
I can't help thinking I must be missing something obvious here, but is
there any way to persist some data from PlanForeignScan to at least
BeginForeignScan in an FDW? I'm aware of fdwplan-fdw_private, but at
that needs to be copyObject compatible, it's not
Peter Eisentraut pete...@gmx.net writes:
Well, there isn't any requirement that URIs be
prot://hostname:port/something
They just have to be
prot:something
So you could just turn the existing conninfo syntax into a URI by doing
something like
postgresql:dbname=foo%20hostname=bar
True,
Dear PostgreSQL developers,
After having done extensive web search and not found anybody to solve
the problem of interest on the general PostgreSQL mailing list, in the
PostgreSQL newsgroup on usenet or on the PostgreSQL IRC channel, I would
like to ask you how to compile a static libpq
I wrote:
Robert Haas robertmh...@gmail.com writes:
I had intended to commit Greg's patch with a show hook and an assign
hook and the calculated value stored separately from the GUC variable,
which I believe would avoid this is a problem, but Tom thought this
way was better. Unfortunately, my
On 03.04.2011 19:38, Tom Lane wrote:
Dave Pagedp...@pgadmin.org writes:
I can't help thinking I must be missing something obvious here, but is
there any way to persist some data from PlanForeignScan to at least
BeginForeignScan in an FDW? I'm aware of fdwplan-fdw_private, but at
that needs to
Hi all!
What i need is transform xml document to table like that:
insert into tmp(Name, Value)
select t.Name, t.Value from myxml.Nodes(/doc/person) as
t('Name:varchar|Value:int')
or similar. In fact I have many rows with many columns.
How I can do it with PG 9.0.3 where I can't find xpath_table?
On Sun, Apr 3, 2011 at 1:26 PM, Tom Lane t...@sss.pgh.pa.us wrote:
IMO the real problem is essentially that GUC assign hooks have two
functions, checking and canonicalization of the value-to-be-stored
versus executing secondary actions when an assignment is made; and
there's no way to get at
Robert Haas robertmh...@gmail.com writes:
On Sun, Apr 3, 2011 at 1:26 PM, Tom Lane t...@sss.pgh.pa.us wrote:
IMO the real problem is essentially that GUC assign hooks have two
functions, checking and canonicalization of the value-to-be-stored
versus executing secondary actions when an
On Sat, Apr 2, 2011 at 8:37 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Merlin Moncure mmonc...@gmail.com writes:
On Thu, Mar 31, 2011 at 5:38 PM, Merlin Moncure mmonc...@gmail.com wrote:
working on exanding the cache to # xid 1.
patch attached. this is essentially my original idea except it's
On Sat, Apr 2, 2011 at 4:51 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Fri, Apr 1, 2011 at 11:11 PM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Mar 31, 2011 at 11:12 PM, Fujii Masao masao.fu...@gmail.com wrote:
Another simple fix is to make walsender send SIGUSR1 to postmaster
so
On Sat, Apr 2, 2011 at 3:31 AM, Susanne Ebrecht susa...@2ndquadrant.com wrote:
Is man really working on Windows?
Also the sentence says that the whole product isn't correct
installed just because docs aren't installed. Which also isn't
really true.
Honesty, I just would like to drop the
On Fri, Apr 1, 2011 at 7:51 AM, Noah Misch n...@leadboat.com wrote:
On Fri, Apr 01, 2011 at 11:44:23AM +0100, Gianni Ciolli wrote:
Please find attached v2 of the numeric-doc patch, which takes into
account your remarks. In particular, numeric limits are now correct
and documented only in that
On Fri, Apr 1, 2011 at 12:56 AM, Noah Misch n...@leadboat.com wrote:
On Thu, Mar 31, 2011 at 11:11:49AM -0400, Robert Haas wrote:
On Thu, Mar 31, 2011 at 6:06 AM, Noah Misch n...@leadboat.com wrote:
I think this is a manifestation the same problem mentioned here:
On Fri, Apr 1, 2011 at 10:33 PM, Joseph Adams
joeyadams3.14...@gmail.com wrote:
On Thu, Mar 31, 2011 at 6:39 PM, Stephen Frost sfr...@snowman.net wrote:
Going just integer-money, with the 1 - $1.00, seems completely
reasonable to me. As for being too late in the cycle.. if someone's
willing
On Sat, Apr 2, 2011 at 5:41 AM, bschaudhari972 bschaudhari...@gmail.com wrote:
i edited postgreql file so that i can check the flow of .c files invoked when
we fire a query but only what i am getting is just parse trees ,rewritten
trees and plan but no names of .c files invoked...
plz help me
Robert Haas robertmh...@gmail.com writes:
On Fri, Apr 1, 2011 at 10:33 PM, Joseph Adams
joeyadams3.14...@gmail.com wrote:
The only other numeric types (other than oid, cardinal_number,
etc.) that can't be casted directly to money are float4 and float8,
and I suspect this is intentional.
21 matches
Mail list logo