I'm new in postgresql c function and I start following examples.
I want to write a simple function that have inside an SQL and passing
parameter evaluete anbd return 2 fields as sum (for now to be simpler).
The function below has problem passing the check
(get_call_result_type(fcinfo,
On 2013-11-08 17:11:58 -0500, Peter Eisentraut wrote:
On 11/8/13, 3:03 PM, Robert Haas wrote:
On Fri, Nov 8, 2013 at 12:38 PM, Robert Haas robertmh...@gmail.com wrote:
On Tue, Nov 5, 2013 at 10:21 AM, Andres Freund and...@2ndquadrant.com
wrote:
Attached to this mail and in the
On 11/08/2013 11:03 PM, Robert Haas wrote:
Separate READ DELETE etc would only be interesting if we wanted to let
someone DELETE rows they cannot SELECT. Since we have DELETE ...
RETURNING, and since users can write a predicate function for DELETE
that leaks the information even if we
The B-tree page deletion algorithm has a race condition. We don't allow
a page to be deleted if it's the rightmost child of its parent, but that
situation can change after we check for it.
Problem
---
We check that the page to be deleted is not the rightmost child of its
parent, and then
Heikki Linnakangas hlinnakan...@vmware.com writes:
2. The second-simplest solution I see is to keep locked the whole chain
of pages that will be deleted, and delete all of them as one atomic
WAL-logged operation. Ie. the leaf page, and all the parent pages above
it that will become
On 09.11.2013 18:24, Tom Lane wrote:
Heikki Linnakangas hlinnakan...@vmware.com writes:
2. The second-simplest solution I see is to keep locked the whole chain
of pages that will be deleted, and delete all of them as one atomic
WAL-logged operation. Ie. the leaf page, and all the parent pages
On 09.11.2013 18:49, Heikki Linnakangas wrote:
We could just punt if more than X pages would need to be changed. That
would mean that we never delete pages at the top (h - X) levels of the
tree. In practice that should be fine if X is high enough.
As a data point, GIN list page deletion holds 16
On 09.11.2013 19:18, Heikki Linnakangas wrote:
On 09.11.2013 18:49, Heikki Linnakangas wrote:
We could just punt if more than X pages would need to be changed. That
would mean that we never delete pages at the top (h - X) levels of the
tree. In practice that should be fine if X is high enough.
On Fri, Nov 8, 2013 at 5:36 PM, Tom Lane t...@sss.pgh.pa.us wrote:
[ I'm so far behind ... ]
Bruce Momjian br...@momjian.us writes:
Applied. Thank you for all your suggestions.
I thought the suggestion had been to issue a *warning*. How did that
become an error? This patch seems likely
MauMau wrote:
Let me repeat myself: I think the biggest and immediate issue is that
PostgreSQL does not support national character types at least officially.
Officially means the description in the manual. So I don't have strong
objection against the current (hidden) implementation of nchar
Forwarding to -hackers.
- Forwarded Message -
From: Kevin Grittner kgri...@ymail.com
To: Tom Lane t...@sss.pgh.pa.us
Cc: pgsql-committ...@postgresql.org pgsql-committ...@postgresql.org
Sent: Friday, November 8, 2013 3:19 PM
Subject: Re: [COMMITTERS] pgsql: Fix blatantly broken
Forwarded to -hackers
- Forwarded Message -
From: Kevin Grittner kgri...@ymail.com
To: Kevin Grittner kgri...@ymail.com; Tom Lane t...@sss.pgh.pa.us
Cc: pgsql-committ...@postgresql.org pgsql-committ...@postgresql.org
Sent: Friday, November 8, 2013 4:33 PM
Subject: Re: [COMMITTERS]
Kevin Grittner kgri...@ymail.com wrote:
int warning_test(int a);
int warning_test(int a)
{
int result;
if (a == 1)
result = 1;
return result;
}
I had to file separate bug reports for gcc and clang. I have
already gotten a response on the clang bug report
On 11/05/2013 10:21 AM, Andres Freund wrote:
Hi,
Attached to this mail and in the xlog-decoding-rebasing-remapping branch
in my git[1] repository you can find the next version of the patchset that:
* Fixes full table rewrites of catalog tables using the method Robert
prefers (which is to log
On 2013-11-09 17:36:49 -0500, Steve Singer wrote:
On 11/05/2013 10:21 AM, Andres Freund wrote:
Hi,
Attached to this mail and in the xlog-decoding-rebasing-remapping branch
in my git[1] repository you can find the next version of the patchset that:
* Fixes full table rewrites of catalog
Kevin Grittner kgri...@ymail.com wrote:
I distilled it down to the simplest case I could find which
failed to produce the warning; attached. Do you agree that it is
a compiler bug that this generates no warning?
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
On Sat, Nov 9, 2013 at 12:40 PM, Heikki Linnakangas
hlinnakan...@vmware.com wrote:
On 09.11.2013 19:18, Heikki Linnakangas wrote:
On 09.11.2013 18:49, Heikki Linnakangas wrote:
We could just punt if more than X pages would need to be changed. That
would mean that we never delete pages at the
On Thu, Nov 7, 2013 at 10:56 AM, Antonin Houska
antonin.hou...@gmail.com wrote:
catalog/catalog.c:GetNewRelFileNode() and its calls indicate that the
following change makes sense:
diff --git a/src/include/storage/relfilenode.h
b/src/include/storage/relfilenode.h
index 75f897f..7190974
On Sat, Nov 9, 2013 at 12:45 AM, David Rowley dgrowle...@gmail.com wrote:
Commit 9b4d52f2095be96ca238ce41f6963ec56376491f introduced a new compiler
warning to the windows visual studios build
D:\Postgres\b\pgsql.sln (default target) (1) -
D:\Postgres\b\pg_regress_ecpg.vcxproj (default target)
On 11/09/2013 05:42 PM, Andres Freund wrote:
On 2013-11-09 17:36:49 -0500, Steve Singer wrote:
On 11/05/2013 10:21 AM, Andres Freund wrote:
Hi,
Attached to this mail and in the xlog-decoding-rebasing-remapping branch
in my git[1] repository you can find the next version of the patchset that:
On Sat, Nov 9, 2013 at 1:00 PM, David Rowley dgrowle...@gmail.com wrote:
On Sat, Nov 9, 2013 at 7:29 PM, Amit Kapila amit.kapil...@gmail.com wrote:
Thanks for the link.
The reason that we don't see more warnings for this is that it seems in all
other places where we have used
On Sat, Nov 9, 2013 at 2:43 AM, Noah Misch n...@leadboat.com wrote:
On Wed, Nov 06, 2013 at 10:14:53AM +0530, Amit Kapila wrote:
On Thu, Oct 31, 2013 at 8:22 PM, Noah Misch n...@leadboat.com wrote:
About unclean FATAL-then-ERROR scenario, one way to deal at high level
could be to treat such a
Hi Naoya,
On Thu, Oct 31, 2013 at 5:42 PM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Oct 31, 2013 at 1:44 AM, Asif Naeem anaeem...@gmail.com wrote:
On Thu, Oct 31, 2013 at 10:17 AM, Amit Kapila amit.kapil...@gmail.com
wrote:
On Tue, Oct 29, 2013 at 12:46 PM, Naoya Anzai
23 matches
Mail list logo