On Nov 29, 2009, at 4:40 AM, Tom Lane wrote:
Alexey Klyukin al...@commandprompt.com writes:
Isn't it also the case with the existing plperl code ? I've noticed that
free(prodesc) is called when it's no longer used (i.e. in
plperl_compile_callback:1636), but refcount of desc-reference is
Bruce == Bruce Momjian br...@momjian.us writes:
Bruce I think there is general agreement that we should have a
Bruce timezone data type which validates against
Bruce pg_timezone_names().name.
What happens when pg_timezone_names output changes? (which it can do,
especially if the install is
Tom Lane wrote:
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
Jan Urba??ski wrote:
ISTM that there's a superfluous curly brace in print_path (which only
gets compiled with -DOPTIMIZER_DEBUG.
Thanks, committed.
You know, the last couple of times I've touched that
On Fri, Sep 18, 2009 at 02:24, Robert Fleming flemi...@gmail.com wrote:
On Thu, Sep 17, 2009 at 11:15 AM, Magnus Hagander mag...@hagander.net
wrote:
On Thu, Sep 17, 2009 at 18:02, Robert Fleming flemi...@gmail.com wrote:
Following a discussion on the pgsql-admin list
Robert Haas wrote:
I have to say I'm not really impressed by the idea of removing things
from our documentation and replacing them with pages on the wiki. The
documentation is better-written and easier to navigate. Yeah, the
part about 28K modems is pretty silly, but we can fix that without
Andrew Gierth wrote:
Bruce == Bruce Momjian br...@momjian.us writes:
Bruce I think there is general agreement that we should have a
Bruce timezone data type which validates against
Bruce pg_timezone_names().name.
What happens when pg_timezone_names output changes? (which it can do,
Hi,
I think this is more of code uniformity issue. Nevertheless, i just
thought of putting it here.
In the CommentCast function, i think both sourcetype and targettype
should be in the arguments, whereas in the code, source type is made as the
name and the target type is passed in as
Bruce Momjian br...@momjian.us writes:
Tom Lane wrote:
You know, the last couple of times I've touched that code, I've been
wondering why we bother to maintain it. Personally I always use pprint()
when I'm interested in a printout of a plan tree. Is anyone actually
using the printout code
Bruce Momjian br...@momjian.us writes:
Robert Haas wrote:
I have to say I'm not really impressed by the idea of removing things
from our documentation and replacing them with pages on the wiki. The
documentation is better-written and easier to navigate. Yeah, the
part about 28K modems is
On Sat, Nov 28, 2009 at 11:47 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Dave Page dp...@pgadmin.org writes:
Updated application name patch, including a GUC assign hook to clean
the application name of any unsafe characters, per discussion.
Applied with assorted editorialization. There were a
On Sun, Nov 29, 2009 at 13:05, Magnus Hagander mag...@hagander.net wrote:
On Fri, Sep 18, 2009 at 02:24, Robert Fleming flemi...@gmail.com wrote:
On Thu, Sep 17, 2009 at 11:15 AM, Magnus Hagander mag...@hagander.net
wrote:
On Thu, Sep 17, 2009 at 18:02, Robert Fleming flemi...@gmail.com
Dave Page dp...@pgadmin.org writes:
On Sat, Nov 28, 2009 at 11:47 PM, Tom Lane t...@sss.pgh.pa.us wrote:
1. The patch prevents non-superusers from seeing other users'
application names in pg_stat_activity. This seems at best pretty
debatable to me. Yes, it supports usages in which you want
Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
Robert Haas wrote:
I have to say I'm not really impressed by the idea of removing things
from our documentation and replacing them with pages on the wiki. The
documentation is better-written and easier to navigate. Yeah, the
part
On Nov 28, 2009, at 5:40 PM, Bruce Momjian wrote:
I think there is general agreement that we should have a timezone data
type which validates against pg_timezone_names().name. It might be
enough to just document how users can create such a domain data type,
but I don't know of a way to do
2009/11/29 David E. Wheeler da...@kineticode.com:
On Nov 28, 2009, at 5:40 PM, Bruce Momjian wrote:
I think there is general agreement that we should have a timezone data
type which validates against pg_timezone_names().name. It might be
enough to just document how users can create such a
Hi,
The attached patch is offered for the 2010-01 commitfest.
It's also available in my git repository in the submitted branch:
http://git.postgresql.org/gitweb?p=users/harriman/share.git;a=shortlog;h=refs/heads/submitted
In palloc.h and pg_list.h, some inline functions are defined if
Hi,
we tried to discuss on a lower level what should be needed
for a partial replication based on streaming replication.
a. transferring base data after a slave got added a relation/index/...
(and initial setup)
b. communicating the the slaves which relations they currently should
have available
Hi,
Le 29 nov. 2009 à 18:22, Tom Lane a écrit :
I think we should use GUC_NO_RESET_ALL.
I agree with you, but it seems we have at least as many votes to not do
that. Any other votes out there?
Driven by the pooler use case (pgbouncer, even), I'd say RESET ALL should reset
also the
2009/11/29 Bruce Momjian br...@momjian.us:
Wow, we mention 28k modems --- we are legacy software: ;-)
This initial checkout is a little slower than simply downloading
a filenametar.gz/filename file; expect it to take 40 minutes
or so if you have a 28.8K modem.
Yes, and what
Kurt Harriman harri...@acm.org writes:
(Does anybody still use a C compiler that doesn't support
inline functions?)
The question isn't so much that, it's whether the compiler supports
inline functions with the same behavior as gcc. At minimum that
would require
* not generating extra
On Sat, Nov 28, 2009 at 10:15:40PM -0500, Tom Lane wrote:
Joshua Tolley eggyk...@gmail.com writes:
Makes sense on both counts. Thanks for the help. How does the attached look?
Applied with minor corrections, mainly around the state save/restore
logic. I also put in some code to fix the
On Sat, Nov 28, 2009 at 11:59, Tom Lane t...@sss.pgh.pa.us wrote:
1. I thought we'd agreed at
http://archives.postgresql.org/pgsql-hackers/2009-10/msg00558.php
that the patch should support WITH on DML statements, eg
with (some-query) insert into foo ...
This might not take much more
Dimitri Fontaine dfonta...@hi-media.com writes:
Le 29 nov. 2009 à 18:22, Tom Lane a écrit :
I think we should use GUC_NO_RESET_ALL.
I agree with you, but it seems we have at least as many votes to not do
that. Any other votes out there?
Driven by the pooler use case (pgbouncer, even), I'd
Tom Lane wrote:
: One possibility would be to make it possible to issue SETs that
behave : as if set in a startup packet - imho its an implementation
detail that : SET currently is used.
I think there's a good deal of merit in this, and it would't be hard
at all to implement, seeing that we
Brendan Jurd wrote:
2009/11/29 Bruce Momjian br...@momjian.us:
Wow, we mention 28k modems --- we are legacy software: ;-)
This initial checkout is a little slower than simply downloading
a filenametar.gz/filename file; expect it to take 40 minutes
or so if you have a 28.8K
Fujii Masao masao.fu...@gmail.com writes:
Why doesn't application_name appear in postgresql.conf.sample?
That is expected to be set from only libpq?
It would seem pretty silly to set it in the conf file. You *can*,
if you want, but I see no reason to list it there.
On Mon, Nov 30, 2009 at 10:20 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Fujii Masao masao.fu...@gmail.com writes:
Why doesn't application_name appear in postgresql.conf.sample?
That is expected to be set from only libpq?
It would seem pretty silly to set it in the conf file. You *can*,
if you
On Fri, 2009-11-27 at 20:28 -0500, Greg Smith wrote:
In the context of the read case, I'm not as sure it's so black and
white. While the current situation does map better to a function that
produces a stream of bytes, that's not necessarily the optimal approach
for all situations. It's
On Thu, 2009-11-26 at 18:30 -0800, Daniel Farina wrote:
Okay, so this thread sort of wandered into how we could refactor other
elements of COPY. Do we have a good sense on what we should do to the
current patch (or at least the idea represented by it) to get it into
a committable state within
On Sun, Nov 29, 2009 at 6:35 PM, Jeff Davis pg...@j-davis.com wrote:
What if the network buffer is flushed in the middle of a line? Is that
possible, or is there a guard against that somewhere?
What do you mean? They both catenate onto one stream of bytes, it
shouldn't matter where the flush
Boszormenyi Zoltan z...@cybertec.at wrote:
we tried to discuss on a lower level what should be needed
for a partial replication based on streaming replication.
We need to discuss a partial recovery before the partial replication.
There are some related items in out ToDo list and previous
On Sun, 2009-11-29 at 18:53 -0800, Daniel Farina wrote:
On Sun, Nov 29, 2009 at 6:35 PM, Jeff Davis pg...@j-davis.com wrote:
What if the network buffer is flushed in the middle of a line? Is that
possible, or is there a guard against that somewhere?
What do you mean? They both catenate
On Mon, Nov 30, 2009 at 4:56 AM, Boszormenyi Zoltan z...@cybertec.at wrote:
I don't think its reasonable trying to discuss and implement this all
in one huge patch so I propose implementing at least 1) as a seperate
patch.
I agree with this development plan.
Now there unforatunately are two
On Mon, Nov 30, 2009 at 11:21 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Mon, Nov 30, 2009 at 10:20 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Fujii Masao masao.fu...@gmail.com writes:
Why doesn't application_name appear in postgresql.conf.sample?
That is expected to be set from only libpq?
Itagaki Takahiro itagaki.takah...@oss.ntt.co.jp wrote:
My rewrite is relatively large. Please reversely-review the patch.
I rethink the code cleanup should be done with another patch even if needed.
Here is a lite version of yaml YAML explan patch.
All of the logic for indent is done in
On Fri, 2009-11-20 at 10:35 +0100, Joachim Wieland wrote:
On Thu, Nov 19, 2009 at 11:04 PM, Joachim Wieland j...@mcknight.de wrote:
Given your example, what I am proposing now is to stop reading from
the queue once we see a not-yet-committed notification but once the
queue is full, read the
Thanks for review!
Jeff Davis pg...@j-davis.com wrote:
* VACUUM (FULL REPLACE) pg_class should be rejected, not silently
turned into VACUUM (FULL INPLACE) pg_class.
Hmmm, it requires to remember whether REPLACE is specified or not
for the non-INPLACE vacuum, but I don't want to add
Itagaki Takahiro wrote:
KaiGai Kohei kai...@kaigai.gr.jp wrote:
-- keep it smaller, and step-by-step enhancement
I'd prefer smaller concept rather than smaller patch.
For the last a few days, I've talked with Itagaki-san off list to make clear
where is the point of his suggestion.
In
Boszormenyi Zoltan wrote:
c. splitting wal into different replication sets
Just a side note: in addition to its use for partial replication, this
might have potential for performance-prioritizing databases or tablespaces.
Being able to separate WAL logging so that different DBs, tablespaces,
Hi,
On Monday 30 November 2009 01:16:43 Florian G. Pflug wrote:
Tom Lane wrote:
: One possibility would be to make it possible to issue SETs that
behave : as if set in a startup packet - imho its an implementation
detail that : SET currently is used.
I think there's a good deal of
Euler Taveira de Oliveira eu...@timbira.com wrote:
The functionality is divided in two parts. The first part is a hook in the
utility module. The idea is capture the commands that doesn't pass through
executor. I'm afraid that that hook will be used only for capturing non-DML
queries. If so,
-- Forwarded message --
From: rahimeh khodadadi rahimeh.khodad...@gmail.com
Date: 2009/11/29
Subject: Re: psql+krb5
To: Denis Feklushkin denis.feklush...@gmail.com
These items have added after my sending.
I repeat again my configurations:
*
1) The configuration of krb5.conf
On 11/29/09, Tom Lane t...@sss.pgh.pa.us wrote:
Kurt Harriman harri...@acm.org writes:
(Does anybody still use a C compiler that doesn't support
inline functions?)
+1 for modern C.
The question isn't so much that, it's whether the compiler supports
inline functions with the same
Hi,
why we can't do $subject? it could have any benefit on the planner?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
44 matches
Mail list logo