Hello
I am playing with context callback functions. I found so we leave
early this function, when exception is raised by RAISE statement.
I can understand it when level is NOTICE, but it is strange for other
levels. More we can emulate any exception now, but these exceptions
are hidden in
On Wed, Jun 1, 2011 at 6:35 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
On 01/06/11 09:24, Cédric Villemain wrote:
Submission review
* The patch is not in context diff format.
* The patch apply, but contains some extra whitespace.
* Documentation is
On Wed, Jun 01, 2011 at 05:09:09PM -0500, Kevin Grittner wrote:
I won't be shocked if Dan can come up with a shorter proof, but I'm
confident this one is solid.
Well, so happens I wrote a proof on the airplane today, before I saw
your mail. It's actually quite straightforward... (well, at least
Hi,
I'm doing a hacking project which hacks the gram.y file and some other
so that postgres can execute some query plan language to run a particular
plan. I did some modifications and try run it. It compiled and installed
successfully. But when I was trying to run a MergeJoin operation with
Hello
you should to add new keywords to
postgresql/src/include/parser/kwlist.h (depends on pg version)
attention - keywords must be in alphabet order
Regards
Pavel Stehule
2011/6/2 HuangQi huangq...@gmail.com:
Hi,
I'm doing a hacking project which hacks the gram.y file and some other
Yes, I've also added mergejoin to kwlist.h as unreserved_keyword. In order
to build AST, I also keep a new node struct in planoperators.h and a new
node tag inside nodes.h.
On 2 June 2011 15:49, Pavel Stehule pavel.steh...@gmail.com wrote:
Hello
you should to add new keywords to
Hello
2011/6/2 HuangQi huangq...@gmail.com:
Yes, I've also added mergejoin to kwlist.h as unreserved_keyword. In order
to build AST, I also keep a new node struct in planoperators.h and a new
node tag inside nodes.h.
then recheck alphabet order of keywords, else recheck bison rules.
Pavel
Hello, Merlin.
You wrote:
MM 2011/6/1 Pavel Golub pa...@microolap.com:
Hello.
I'm some kind of PQdeleteTuple function will be very usefull in libpq.
Because right now after deleting some record I need refetch result
set, or mark tuple as deleted and this is headache for me.
So I checked
Hello, Andrew.
You wrote:
AC On 6/1/2011 11:43 AM, Pavel Golub wrote:
Hello.
I'm some kind of PQdeleteTuple function will be very usefull in libpq.
Because right now after deleting some record I need refetch result
set, or mark tuple as deleted and this is headache for me.
AC IMHO, this
Hello.
So having studied the fe-exec.c sources, I came to this conclusion:
we may just ignore deleted tuple and it will be destroyed by
PQclear automatically, becuase PQclear deals with memory blocks.
int PQdeleteTuple(PGresult *src, int tup_num)
{
if (!src)
return NULL;
Can we figure out some information about index i.e. whet is the height
of index tree, how many values are placed in one leaf node and one non
leaf level node?
http://www.sigaev.ru/cvsweb/cvsweb.cgi/gevel/
--
Teodor Sigaev E-mail: teo...@sigaev.ru
Hello
This patch enhances a GET DIAGNOSTICS statement functionality. It adds
a possibility of access to exception's data. These data are stored on
stack when exception's handler is activated - and these data are
access-able everywhere inside handler. It has a different behave (the
content is
On 02/06/11 18:34, Jaime Casanova wrote:
On Wed, Jun 1, 2011 at 6:35 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
I've created a new patch (attached)
Hi Mark,
A few comments:
- why only superusers can set this? if this is a per-backend setting,
i don't see the problem in allowing
On 06/02/2011 03:28 AM, HuangQi wrote:
Hi,
I'm doing a hacking project which hacks the gram.y file and some
other so that postgres can execute some query plan language to run a
particular plan. I did some modifications and try run it. It compiled
and installed successfully. But when I
On ons, 2011-06-01 at 22:00 +0200, Radosław Smogura wrote:
I partialy implemented following missing LOBs types. Requirement for this was
to give ability to create (B/C)LOB columns and add casting functionality e.g.
SET my_clob = 'My long text'.
Idea is as follow:
0. Blob is two state
2011/6/2 Peter Eisentraut pete...@gmx.net:
On ons, 2011-06-01 at 22:00 +0200, Radosław Smogura wrote:
I partialy implemented following missing LOBs types. Requirement for this was
to give ability to create (B/C)LOB columns and add casting functionality e.g.
SET my_clob = 'My long text'.
Idea
On 02.06.2011 15:16, Andrew Dunstan wrote:
On 06/02/2011 03:28 AM, HuangQi wrote:
Hi,
I'm doing a hacking project which hacks the gram.y file and some other
so that postgres can execute some query plan language to run a
particular plan. I did some modifications and try run it. It compiled
and
On Thu, Jun 02, 2011 at 02:58:52PM +0200, Pavel Stehule wrote:
2011/6/2 Peter Eisentraut pete...@gmx.net:
On ons, 2011-06-01 at 22:00 +0200, Radosław Smogura wrote:
I partialy implemented following missing LOBs types. Requirement for this
was
to give ability to create (B/C)LOB columns
Hello, Pavel.
You wrote:
PS 2011/6/2 Peter Eisentraut pete...@gmx.net:
On ons, 2011-06-01 at 22:00 +0200, Radosław Smogura wrote:
I partialy implemented following missing LOBs types. Requirement for this
was
to give ability to create (B/C)LOB columns and add casting functionality
e.g.
On Thu, 02 Jun 2011 15:39:39 +0300, Peter Eisentraut wrote:
On ons, 2011-06-01 at 22:00 +0200, Radosław Smogura wrote:
I partialy implemented following missing LOBs types. Requirement for
this was
to give ability to create (B/C)LOB columns and add casting
functionality e.g.
SET my_clob = 'My
On Thu, Jun 2, 2011 at 3:24 AM, Pavel Golub pa...@microolap.com wrote:
MM well, you have PQaddTuple, but this was exposed mainly for the purpose
MM of building a PQresult from outside the libpq library -- not so much
MM to remove the 'constness' property of the PGResult. I have no
MM
On Wed, Jun 1, 2011 at 7:35 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
Done - 'work_disk' it is to match 'work_mem'.
I guess I'm bikeshedding here, but I'm not sure I really buy this
parallel. work_mem is primarily a query planner parameter; it says,
if you're going to need more
2011/6/2 Pavel Golub pa...@microolap.com:
Hello, Pavel.
You wrote:
PS 2011/6/2 Peter Eisentraut pete...@gmx.net:
On ons, 2011-06-01 at 22:00 +0200, Radosław Smogura wrote:
I partialy implemented following missing LOBs types. Requirement for this
was
to give ability to create (B/C)LOB
On Thu, Jun 2, 2011 at 9:29 AM, Radosław Smogura
rsmog...@softperience.eu wrote:
What functionality exactly do you envision that the BLOB and CLOB types
would
need to have that would warrant treating them different from, say, bytea
and text?
Actually I thought about less sophisticated
On May 24, 2011, at 12:15 AM, Noah Misch wrote:
On Mon, May 23, 2011 at 03:01:40PM -0400, Tom Lane wrote:
Noah Misch n...@leadboat.com writes:
Good deal. Given that conclusion, the other policy decision I anticipate
affecting this particular patch is the choice of syntax. Presumably, it
On 6/2/2011 4:28 AM, Pavel Golub wrote:
Hello, Andrew.
You wrote:
AC On 6/1/2011 11:43 AM, Pavel Golub wrote:
Hello.
I'm some kind of PQdeleteTuple function will be very usefull in libpq.
Because right now after deleting some record I need refetch result
set, or mark tuple as deleted and
On Wed, Jun 1, 2011 at 7:47 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Tatsuo Ishii's message of mié jun 01 19:08:16 -0400 2011:
What pgpool really wanted to do was locking sequence tables, not
locking rows in sequences. I wonder why the former is not allowed.
Yeah --
On Wed, Jun 1, 2011 at 6:53 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Please note also that what pgpool users have got right now is a time
bomb, which is not better than immediately-visible breakage. I would
prefer to try to get this change out ahead of widespread adoption of the
broken pgpool
Robert Haas robertmh...@gmail.com writes:
On Wed, Jun 1, 2011 at 7:47 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Yeah -- why is LOCK SEQUENCE foo_seq not allowed? Seems a simple thing
to have.
It cause a grammar conflict.
That's a lot of work for a purely cosmetic issue, though.
Hello, Andrew.
You wrote:
AC On 6/2/2011 4:28 AM, Pavel Golub wrote:
Hello, Andrew.
You wrote:
AC On 6/1/2011 11:43 AM, Pavel Golub wrote:
Hello.
I'm some kind of PQdeleteTuple function will be very usefull in libpq.
Because right now after deleting some record I need refetch result
AC IMHO, this should be handled by the application. You could track
tuples
AC removed in an int[] or copy the result set into an application
defined
AC array of C structures. I've always been under the impression that
AC PGresult objects are immutable once delivered to the application.
Andrew,
On Wed, Jun 1, 2011 at 7:07 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
Excerpts from Robert Haas's message of mié jun 01 18:22:56 -0400 2011:
ISTM that it would be useful to run postgres in a mode where it
doesn't actually try to start up the
Robert Haas robertmh...@gmail.com writes:
So I'm not sure work_disk is a great name.
I agree. Maybe something along the lines of temp_file_limit?
Also, once you free yourself from the analogy to work_mem, you could
adopt some more natural unit than KB. I'd think MB would be a practical
unit
Robert Haas robertmh...@gmail.com writes:
But these problems can be fixed without inventing a completely new
system, I think. Or at least we should try. I can see the point of a
data type that is really a pointer to a LOB, and the LOB gets deleted
when the pointer is removed, but I don't
Robert Haas robertmh...@gmail.com writes:
Ugh. We are already stuck supporting all kinds of backward
compatibility cruft in tablecmds.c as a result of the fact that you
used to have to use ALTER TABLE to operate on views and sequences.
The whole thing is confusing and a mess.
[ shrug... ] I
Marko Kreen mark...@gmail.com writes:
Here's my attempt for it. As conditional port module seems trouble,
I set up an unconditional pgGetpeereid() that is always defined.
-1 ... why would you think that a conditional substitution is trouble?
We have plenty of others.
2011/6/2 Robert Haas robertmh...@gmail.com:
On Wed, Jun 1, 2011 at 7:35 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
Done - 'work_disk' it is to match 'work_mem'.
I guess I'm bikeshedding here, but I'm not sure I really buy this
parallel. work_mem is primarily a query planner
On Wed, Jun 1, 2011 at 3:02 PM, Steve Singer ssin...@ca.afilias.info wrote:
On 11-06-01 09:30 AM, Christopher Browne wrote:
On Wed, Jun 1, 2011 at 8:29 AM, Dave Pagedp...@pgadmin.org wrote:
On Wed, Jun 1, 2011 at 12:27 PM, Andrew Dunstanand...@dunslane.net
wrote:
The whole point of the
Excerpts from Andrew Chernow's message of jue jun 02 10:12:40 -0400 2011:
Andrew, why we have PQmakeEmptyPGresult, PQcopyResult,
PQsetResultAttrs, PQsetvalue and PQresultAlloc in this case? Of course
there's no big deal with their absence but let's be consistent.
I'm not entirely sure
On Wed, Jun 1, 2011 at 1:03 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Marko Kreen mark...@gmail.com writes:
My suggestion would be to use getpeereid() everywhere.
And just have compat getpeereid() implementation on non-BSD
platforms. This would minimize ifdeffery in core core.
Hm, maybe. I'd
Alvaro Herrera alvhe...@commandprompt.com writes:
Excerpts from Tom Lane's message of jue jun 02 10:31:58 -0400 2011:
That's a lot of work for a purely cosmetic issue, though. What would be
trivial is to let this work:
regression=# lock table s1;
ERROR: s1 is not a table
Yeah, though it'd
On Thu, Jun 2, 2011 at 10:31 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Wed, Jun 1, 2011 at 7:47 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Yeah -- why is LOCK SEQUENCE foo_seq not allowed? Seems a simple thing
to have.
It cause a grammar
isn't really specific to ANALYZE. I'm inclined to think that the most
reasonable fix is to make get_sort_group_operators() and related
Hm, patch is in attach but it doesn't solve all problems. Initial bug is still
here for array of row type, but when I tried to change that with recursive call
Excerpts from Tom Lane's message of jue jun 02 10:31:58 -0400 2011:
Robert Haas robertmh...@gmail.com writes:
On Wed, Jun 1, 2011 at 7:47 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Yeah -- why is LOCK SEQUENCE foo_seq not allowed? Seems a simple thing
to have.
It cause a
Hello, Alvaro.
You wrote:
AH Excerpts from Andrew Chernow's message of jue jun 02 10:12:40 -0400 2011:
Andrew, why we have PQmakeEmptyPGresult, PQcopyResult,
PQsetResultAttrs, PQsetvalue and PQresultAlloc in this case? Of course
there's no big deal with their absence but let's be
On Thu, Jun 2, 2011 at 5:49 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Marko Kreen mark...@gmail.com writes:
Here's my attempt for it. As conditional port module seems trouble,
I set up an unconditional pgGetpeereid() that is always defined.
-1 ... why would you think that a conditional
Excerpts from Merlin Moncure's message of jue jun 02 11:33:28 -0400 2011:
On Thu, Jun 2, 2011 at 10:02 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Seems pretty wasteful if you want to delete a single tuple from a large
result. I think if you desired to compact the result to free
On 06/02/2011 11:29 AM, Marko Kreen wrote:
As there was no going back now, I even touched msvc.pm.
Why? Windows doesn't have Unix domain sockets at all.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
Excerpts from Tom Lane's message of jue jun 02 11:10:00 -0400 2011:
Alvaro Herrera alvhe...@commandprompt.com writes:
Excerpts from Tom Lane's message of jue jun 02 10:31:58 -0400 2011:
That's a lot of work for a purely cosmetic issue, though. What would be
trivial is to let this work:
On Thu, Jun 2, 2011 at 10:02 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Andrew Chernow's message of jue jun 02 10:12:40 -0400 2011:
Andrew, why we have PQmakeEmptyPGresult, PQcopyResult,
PQsetResultAttrs, PQsetvalue and PQresultAlloc in this case? Of course
there's
Teodor Sigaev teo...@sigaev.ru writes:
isn't really specific to ANALYZE. I'm inclined to think that the most
reasonable fix is to make get_sort_group_operators() and related
Hm, patch is in attach but it doesn't solve all problems. Initial bug is
still
here for array of row type, but when
Hi, thanks a lot for your ideas. But I've done all these things. I've
checked the gram.y and kwlist.h files many times but can not find what's
wrong. So is there any possibility that the problem comes from something
after parser, though it seems it should comes from parser?
On 2 June 2011 21:14,
2011/6/2 Tom Lane t...@sss.pgh.pa.us:
Robert Haas robertmh...@gmail.com writes:
But these problems can be fixed without inventing a completely new
system, I think. Or at least we should try. I can see the point of a
data type that is really a pointer to a LOB, and the LOB gets deleted
when
On 06/02/2011 12:04 PM, Marko Kreen wrote:
On Thu, Jun 2, 2011 at 6:59 PM, Andrew Dunstanand...@dunslane.net wrote:
On 06/02/2011 11:29 AM, Marko Kreen wrote:
As there was no going back now, I even touched msvc.pm.
Why? Windows doesn't have Unix domain sockets at all.
Because the function
Andrew Dunstan and...@dunslane.net writes:
On 06/02/2011 12:04 PM, Marko Kreen wrote:
On Thu, Jun 2, 2011 at 6:59 PM, Andrew Dunstanand...@dunslane.net wrote:
On 06/02/2011 11:29 AM, Marko Kreen wrote:
As there was no going back now, I even touched msvc.pm.
Why? Windows doesn't have Unix
On 6/2/2011 11:02 AM, Alvaro Herrera wrote:
Excerpts from Andrew Chernow's message of jue jun 02 10:12:40 -0400 2011:
Andrew, why we have PQmakeEmptyPGresult, PQcopyResult,
PQsetResultAttrs, PQsetvalue and PQresultAlloc in this case? Of course
there's no big deal with their absence but let's
I think we could just let this code assume success for type RECORD. It
won't affect VACUUM/ANALYZE, since there are (for reasons that should
now be obvious) no table or index columns of anonymous composite types.
Of course, it's impossible to store anonymous composite type anywhere, but
we
On Thu, Jun 2, 2011 at 10:47 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
Ugh. We are already stuck supporting all kinds of backward
compatibility cruft in tablecmds.c as a result of the fact that you
used to have to use ALTER TABLE to operate on views and
On Thu, Jun 2, 2011 at 10:57 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Merlin Moncure's message of jue jun 02 11:33:28 -0400 2011:
On Thu, Jun 2, 2011 at 10:02 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Seems pretty wasteful if you want to delete a single
On Thu, Jun 2, 2011 at 7:20 PM, Andrew Dunstan and...@dunslane.net wrote:
On 06/02/2011 12:04 PM, Marko Kreen wrote:
On Thu, Jun 2, 2011 at 6:59 PM, Andrew Dunstanand...@dunslane.net
wrote:
On 06/02/2011 11:29 AM, Marko Kreen wrote:
As there was no going back now, I even touched msvc.pm.
Tom Lane t...@sss.pgh.pa.us Thursday 02 of June 2011 16:42:42
Robert Haas robertmh...@gmail.com writes:
But these problems can be fixed without inventing a completely new
system, I think. Or at least we should try. I can see the point of a
data type that is really a pointer to a LOB, and
On Thu, Jun 2, 2011 at 6:59 PM, Andrew Dunstan and...@dunslane.net wrote:
On 06/02/2011 11:29 AM, Marko Kreen wrote:
As there was no going back now, I even touched msvc.pm.
Why? Windows doesn't have Unix domain sockets at all.
Because the function is still referenced in the code.
--
marko
Marko Kreen mark...@gmail.com writes:
-1 ... why would you think that a conditional substitution is trouble?
We have plenty of others.
Because it required touching autoconf. ;)
So now I did it. I hope it was that simple.
Applied with minor adjustments --- notably, I didn't agree with
On Thu, Jun 2, 2011 at 10:58 AM, Cédric Villemain
cedric.villemain.deb...@gmail.com wrote:
I am not specially attached to a name, idea was not to use work_disk
but backend_work_disk. I agree with you anyway, and suggestion from
Tom is fine for me (temp_file_limit).
Yeah, I like that too.
--
While working on my patch to reduce the overhead of frequent table
locks, I had cause to monkey with InitProcGlobal() and noticed that
it's sort of a mess. For reasons that are not clear to me, it
allocates one of the three PGPROC arrays using ShemInitStruct() and
the other two using
Teodor Sigaev teo...@sigaev.ru writes:
I think we could just let this code assume success for type RECORD. It
won't affect VACUUM/ANALYZE, since there are (for reasons that should
now be obvious) no table or index columns of anonymous composite types.
Of course, it's impossible to store
On 06/02/2011 01:04 PM, Alvaro Herrera wrote:
Excerpts from Marko Kreen's message of jue jun 02 12:45:04 -0400 2011:
On Thu, Jun 2, 2011 at 7:31 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Andrew Dunstan's message of jue jun 02 11:59:02 -0400 2011:
On 06/02/2011
Excerpts from Andrew Dunstan's message of jue jun 02 11:59:02 -0400 2011:
On 06/02/2011 11:29 AM, Marko Kreen wrote:
As there was no going back now, I even touched msvc.pm.
Why? Windows doesn't have Unix domain sockets at all.
So much for being thorough :-P
--
Álvaro Herrera
Excerpts from Alvaro Herrera's message of mié jun 01 20:56:12 -0400 2011:
Excerpts from Thom Brown's message of mié jun 01 19:48:44 -0400 2011:
Is this expected?
[ pg_dump fails to preserve not-valid status of constraints ]
Certainly not.
Shouldn't the constraint be dumped as not
Excerpts from HuangQi's message of jue jun 02 11:17:21 -0400 2011:
Hi, thanks a lot for your ideas. But I've done all these things. I've
checked the gram.y and kwlist.h files many times but can not find what's
wrong. So is there any possibility that the problem comes from something
after
Excerpts from Marko Kreen's message of jue jun 02 12:45:04 -0400 2011:
On Thu, Jun 2, 2011 at 7:31 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Andrew Dunstan's message of jue jun 02 11:59:02 -0400 2011:
On 06/02/2011 11:29 AM, Marko Kreen wrote:
As there was no
On Thu, Jun 2, 2011 at 7:44 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Marko Kreen mark...@gmail.com writes:
On Thu, Jun 2, 2011 at 7:20 PM, Andrew Dunstan and...@dunslane.net wrote:
Then maybe we need to use #ifndef WIN32 in those places. That's what we do
for similar cases.
No, that would be a
Robert Haas robertmh...@gmail.com writes:
While working on my patch to reduce the overhead of frequent table
locks, I had cause to monkey with InitProcGlobal() and noticed that
it's sort of a mess. For reasons that are not clear to me, it
allocates one of the three PGPROC arrays using
On Thu, Jun 2, 2011 at 7:31 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Andrew Dunstan's message of jue jun 02 11:59:02 -0400 2011:
On 06/02/2011 11:29 AM, Marko Kreen wrote:
As there was no going back now, I even touched msvc.pm.
Why? Windows doesn't have Unix domain
Marko Kreen mark...@gmail.com writes:
On Thu, Jun 2, 2011 at 7:20 PM, Andrew Dunstan and...@dunslane.net wrote:
Then maybe we need to use #ifndef WIN32 in those places. That's what we do
for similar cases.
No, that would be a bad idea - uglifies code for no good reason.
The function is
Tab completion for \d currently does not complete composite types, even
though \d works for composite types.
That's easy to be fixed, but I have two more general questions:
Since \d is happy to describe any kind of pg_class entry, should we also
remove the relkind restriction in what
On 06/01/2011 05:18 PM, Alvaro Herrera wrote:
Excerpts from Jeff Davis's message of mié jun 01 19:57:40 -0400 2011:
On Fri, 2011-05-27 at 16:43 -0400, Alvaro Herrera wrote:
Hi,
One of our customers is interested in being able to store original
timezone along with a certain timestamp.
I
Excerpts from Merlin Moncure's message of mié jun 01 21:36:32 -0400 2011:
On Wed, Jun 1, 2011 at 8:18 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Jeff Davis's message of mié jun 01 19:57:40 -0400 2011:
On Fri, 2011-05-27 at 16:43 -0400, Alvaro Herrera wrote:
Hi,
=?utf-8?q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
Tom Lane t...@sss.pgh.pa.us Thursday 02 of June 2011 16:42:42
Yes. I think the appropriate problem statement is provide streaming
access to large field values, as an alternative to just fetching/storing
the entire value at
Dan Ports d...@csail.mit.edu wrote:
On Wed, Jun 01, 2011 at 05:09:09PM -0500, Kevin Grittner wrote:
Published papers have further proven that the transaction which
appears to have executed last of these three must actually commit
before either of the others for an anomaly to occur.
We can
On Thu, Jun 2, 2011 at 11:17 AM, HuangQi huangq...@gmail.com wrote:
Hi, thanks a lot for your ideas. But I've done all these things. I've
checked the gram.y and kwlist.h files many times but can not find what's
wrong. So is there any possibility that the problem comes from something
after
Hello,
We've recently come across the task of estimating the size of shared memory
required for PostgreSQL to start. This comes from the problem of validating
postgresql.conf files
(http://archives.postgresql.org/pgsql-hackers/2011-03/msg01831.php), i.e.
checking that the server will be able to
On Thu, 2011-06-02 at 18:46 +, Christopher Browne wrote:
1. How would the time-zone be defined in this composite? Offset from GMT?
Timezone (well, link thereto) with all DST rules intact? Would extract
need to be modified to include the ability to grab the timezone?
That doesn't seem
On Thu, Jun 2, 2011 at 6:06 PM, Steve Crawford
scrawf...@pinpointresearch.com wrote:
On 06/01/2011 05:18 PM, Alvaro Herrera wrote:
Excerpts from Jeff Davis's message of mié jun 01 19:57:40 -0400 2011:
On Fri, 2011-05-27 at 16:43 -0400, Alvaro Herrera wrote:
Hi,
One of our customers is
On Thu, Jun 2, 2011 at 7:36 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Also, once you free yourself from the analogy to work_mem, you could
adopt some more natural unit than KB. I'd think MB would be a practical
unit size, and would avoid (at least for the near term) the need to make
the
On Fri, 2011-05-27 at 16:43 -0400, Alvaro Herrera wrote:
One of our customers is interested in being able to store original
timezone along with a certain timestamp.
Another thing to consider is that this will eliminate any useful total
order.
You could define an arbitrary total order, of
On Thu, Jun 2, 2011 at 1:53 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
While working on my patch to reduce the overhead of frequent table
locks, I had cause to monkey with InitProcGlobal() and noticed that
it's sort of a mess. For reasons that are not
On Thu, Jun 2, 2011 at 12:55 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
One of our customers is interested in being able to store original
timezone along with a certain timestamp.
I assume that you're talking about a new data type, not augmenting the
current types, correct?
Alexey Klyukin al...@commandprompt.com writes:
We've recently come across the task of estimating the size of shared memory
required for PostgreSQL to start.
...
- Try to actually allocate the shared memory in a way postmaster does this
nowadays, if the process fails - analyze the error
Robert Haas robertmh...@gmail.com writes:
On Wed, Jun 1, 2011 at 6:53 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Please note also that what pgpool users have got right now is a time
bomb, which is not better than immediately-visible breakage. I would
prefer to try to get this change out ahead of
Tom Lane t...@sss.pgh.pa.us Thursday 02 of June 2011 19:43:16
=?utf-8?q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
Tom Lane t...@sss.pgh.pa.us Thursday 02 of June 2011 16:42:42
Yes. I think the appropriate problem statement is provide streaming
access to large field
On Tue, May 24, 2011 at 2:54 PM, Tom Lane t...@sss.pgh.pa.us wrote:
David E. Wheeler da...@kineticode.com writes:
On May 24, 2011, at 11:30 AM, Tom Lane wrote:
I guess that the question that's immediately at hand is sort of a
variant of that, because using a polymorphic function declared to
On Thu, Jun 2, 2011 at 3:13 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
OK, here's a version with more comments.
Looks OK to me, assuming you've checked that the right number of PGPROCs
are getting created (in particular the AV launcher is no longer
Hi Alexey,
On Thu, Jun 02, 2011 at 05:08:51PM +0300, Alexey Klyukin wrote:
Looks like this thread has silently died out. Is there an agreement on the
syntax and implementation part? We (CMD) have a customer, who is interested in
pushing this through, so, if we have a patch, I'd be happy to
Robert Haas robertmh...@gmail.com writes:
OK, here's a version with more comments.
Looks OK to me, assuming you've checked that the right number of PGPROCs
are getting created (in particular the AV launcher is no longer
accounted for explicitly).
regards, tom lane
--
Dne 2.6.2011 15:49, Pavel Stehule napsal(a):
2011/6/2 Pavel Golub pa...@microolap.com:
Hello, Pavel.
You wrote:
PS 2011/6/2 Peter Eisentraut pete...@gmx.net:
On ons, 2011-06-01 at 22:00 +0200, Radosław Smogura wrote:
I partialy implemented following missing LOBs types. Requirement for this
Robert Haas robertmh...@gmail.com writes:
I'll commit this to 9.2 after we branch. (When are we doing that, BTW?)
Sometime in the next two weeks I guess ;-). At the PGCon meeting we
said 1 June, but seeing that we still have a couple of open beta2 issues
I'm not in a hurry.
I think a
Dne 2.6.2011 15:18, k...@rice.edu napsal(a):
On Thu, Jun 02, 2011 at 02:58:52PM +0200, Pavel Stehule wrote:
2011/6/2 Peter Eisentraut pete...@gmx.net:
Superficially, this looks like a reimplementation of TOAST. What
functionality exactly do you envision that the BLOB and CLOB types would
Robert Haas robertmh...@gmail.com writes:
On Tue, May 24, 2011 at 2:54 PM, Tom Lane t...@sss.pgh.pa.us wrote:
I'm starting to think that maybe we should separate the two cases after
all. If we force a downcast for ANYARRAY matching, we will fix the loss
of functionality induced by the bug
On Thu, Jun 02, 2011 at 01:43:16PM -0400, Tom Lane wrote:
=?utf-8?q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
Tom Lane t...@sss.pgh.pa.us Thursday 02 of June 2011 16:42:42
Yes. I think the appropriate problem statement is provide streaming
access to large field values, as an
1 - 100 of 124 matches
Mail list logo