On Mon, Sep 26, 2011 at 12:45 AM, Ramanujam wrote:
> On Mon, Sep 26, 2011 at 9:57 AM, Robert Haas wrote:
>> Does it work if you use EXECUTE?
>
> Apologies to have not included the list when I replied to Pavel.
> Re-writing it as a dynamic sql stmt indeed works. Sorry for the noise.
Ah, OK. No p
Robert Haas writes:
> It would actually be nice if worked even without that, but I'm not
> sure what would be involved in making that happen.
I've been too busy to look at this in detail, but I imagine the issue is
failure to pass parameters down from the ProcessUtility call to COPY
into the pars
The following bug has been logged online:
Bug reference: 6225
Logged by: Daniel Cristian Cruz
Email address: danielcrist...@gmail.com
PostgreSQL version: 9.1.0
Operating system: "PostgreSQL 9.1.0 on x86_64-unknown-linux-gnu, compiled
by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2
On Sun, Sep 25, 2011 at 9:16 PM, Fujii Masao wrote:
> When I made pgbench tables unlogged and ran pgbench, I encountered a
> segmentation fault. Here is the test case which reproduces a segmentation
> fault:
>
> $ pgbench -i
> $ pg_dump > pgbench.dump
> $ sed s/"CREATE TABLE"/"CREATE UNLOGGED TABL
The following bug has been logged online:
Bug reference: 6223
Logged by: Ola van Dunen
Email address: vandu...@smart-interfaces.de
PostgreSQL version: 9.*
Operating system: Windows Server 2008
Description:Installation with service account
Details:
In order to run th
hi,
> y...@mwd.biglobe.ne.jp (YAMAMOTO Takashi) writes:
>>> There isn't terribly much we can do with this report unless you can
>>> provide a complete test case to reproduce it.
>
>> after some investigation, i think it is triggered by protocol-level prepare
>> of ROLLBACK in an aborted transacti
The following bug has been logged online:
Bug reference: 6224
Logged by: Dean Heller
Email address: dhel...@tainstruments.com
PostgreSQL version: 4.95.170.0
Operating system: Windows 7 64bit
Description:Installation Error of dotconnect for postgre SQL
Professional
Det
hi,
GetCachedPlan can pass the 'qlist' to the planner twice.
if i understand the code correctly, it's unsafe because the planner is
destructive wrt the input tree. for my application, it often causes
a crash in executor.
YAMAMOTO Takashi
diff --git a/src/backend/utils/cache/plancache.c
b/src/b
On Mon, Sep 26, 2011 at 9:40 AM, Ola van Dunen
wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6223
> Logged by: Ola van Dunen
> Email address: vandu...@smart-interfaces.de
> PostgreSQL version: 9.*
> Operating system: Windows Server 2008
> Description:
On Mon, Sep 26, 2011 at 11:00 AM, Robert Haas wrote:
> The whole thing is a bit mysterious because ExecQual() doesn't really
> do much that seems like it could generate an invalid memory reference.
>
> I'll poke at this some more...
I added some debugging code which sets a global variable to vari
On Mon, Sep 26, 2011 at 3:02 PM, Dean Heller wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6224
> Logged by: Dean Heller
> Email address: dhel...@tainstruments.com
> PostgreSQL version: 4.95.170.0
> Operating system: Windows 7 64bit
> Description:
On Mon, Sep 26, 2011 at 11:40 AM, Robert Haas wrote:
> To check my work, I did this:
>
> --- a/src/backend/executor/execQual.c
> +++ b/src/backend/executor/execQual.c
> @@ -5003,6 +5003,7 @@ ExecQual(List *qual, ExprContext *econtext, bool
> resultForNull)
> Datum expr_val
On Mon, Sep 26, 2011 at 11:08 AM, Robert Haas wrote:
> On Mon, Sep 26, 2011 at 11:40 AM, Robert Haas wrote:
>> To check my work, I did this:
>>
>> --- a/src/backend/executor/execQual.c
>> +++ b/src/backend/executor/execQual.c
>> @@ -5003,6 +5003,7 @@ ExecQual(List *qual, ExprContext *econtext, bo
On Mon, Sep 26, 2011 at 12:17 PM, Merlin Moncure wrote:
> hm. any relation to YAMAMOTO Takashi's recent email, [BUGS] bug in
> plancache.c, which hasn't hit the archives yet?
>
>> "GetCachedPlan can pass the 'qlist' to the planner twice.
> if i understand the code correctly, it's unsafe because th
y...@mwd.biglobe.ne.jp (YAMAMOTO Takashi) writes:
>> Maybe, but I'd still like to see a test case, because I can't reproduce
>> any such problem by preparing ROLLBACK in an aborted transaction.
> reading GetTransactionSnapshot, it seems that the problem happens
> only with IsolationUsesXactSnapsho
On Mon, Sep 26, 2011 at 12:20 PM, Robert Haas wrote:
> On Mon, Sep 26, 2011 at 12:17 PM, Merlin Moncure wrote:
>> hm. any relation to YAMAMOTO Takashi's recent email, [BUGS] bug in
>> plancache.c, which hasn't hit the archives yet?
>>
>>> "GetCachedPlan can pass the 'qlist' to the planner twice.
Robert Haas writes:
>> I was just wondering about that. It seems like it could very well be
>> the same issue, but I have not tested it yet.
> OK, I tested it. On my system, that patch appears to fix this problem.
Yeah, I was just going to suggest that that might be related, but
I see you beat
y...@mwd.biglobe.ne.jp (YAMAMOTO Takashi) writes:
> GetCachedPlan can pass the 'qlist' to the planner twice.
> if i understand the code correctly, it's unsafe because the planner is
> destructive wrt the input tree. for my application, it often causes
> a crash in executor.
Good catch, thanks! (
On Fri, Sep 23, 2011 at 11:36 PM, YAMAMOTO Takashi
wrote:
> see the following patch.
> it seems some function names in the comment are out of sync with the reality.
Thanks, fixed.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs
I was building postgresql via Macports (with the debug flag on) and I saw this
output -- including a notice to report this to pgsql-bugs@postgresql.org. So
I'm doing so!
---> Configuring postgresql91
DEBUG: Using compiler 'Mac OS X llvm-gcc 4.2'
DEBUG: Executing org.macports.configure (postgres
The following bug has been logged online:
Bug reference: 6226
Logged by: Daniel Cristian Cruz
Email address: danielcrist...@gmail.com
PostgreSQL version: 9.1.1
Operating system: "PostgreSQL 9.1.0 on x86_64-unknown-linux-gnu, compiled
by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2
Excerpts from Daniel Cristian Cruz's message of lun sep 26 15:29:33 -0300 2011:
>
> The following bug has been logged online:
>
> Bug reference: 6226
> Logged by: Daniel Cristian Cruz
> Email address: danielcrist...@gmail.com
> PostgreSQL version: 9.1.1
> Operating system: "
Excerpts from Tom Lane's message of lun sep 26 13:26:37 -0300 2011:
>
> y...@mwd.biglobe.ne.jp (YAMAMOTO Takashi) writes:
> >> Maybe, but I'd still like to see a test case, because I can't reproduce
> >> any such problem by preparing ROLLBACK in an aborted transaction.
>
> > reading GetTransacti
Alvaro Herrera writes:
> Excerpts from Tom Lane's message of lun sep 26 13:26:37 -0300 2011:
>> The place where that refcount normally gets dropped is
>> AtEarlyCommit_Snapshot, but that isn't going to be called at all in
>> aborted-transaction cleanup. Worse, if we just transposed it over to be
Is this a bug, or due to the way I am using the RANK() function in the
following query? The error is triggered when I use (sum(y) / sum(x))
in the ORDER BY of the RANK() function.
Simple test case:
create table t (a int, b int, x numeric, y integer );
insert into t
select g,round(mod(g,4)),
roun
bricklen writes:
> Is this a bug,
Yes. Thanks for the test case, will look.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
I wrote:
> bricklen writes:
>> Is this a bug,
> Yes. Thanks for the test case, will look.
Fixed, patch is at
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1679e9feddc94bd7372a6829db92868e55ef7177
regards, tom lane
--
Sent via pgsql-bugs mailing lis
The following bug has been logged online:
Bug reference: 6227
Logged by: Itagaki Takahiro
Email address: itagaki.takah...@gmail.com
PostgreSQL version: 9.1 and all
Operating system: N/A
Description:No arguments for COPY OIDS and HEADER
Details:
Our documentation say
28 matches
Mail list logo
