On Friday, June 14, 2013 3:17 AM Josh Berkus wrote:
> On 06/13/2013 05:35 AM, Amit Kapila wrote:
> > On Friday, June 07, 2013 9:45 AM Amit Kapila wrote:
> >> On Thursday, June 06, 2013 10:22 PM Robert Haas wrote:
> >>> On Wed, Jun 5, 2013 at 7:24 AM, Amit Kapila
>
> >>> wrote:
> On Monday, Ma
On 14/06/13 07:38, Fujii Masao wrote:
On Wed, Jun 12, 2013 at 12:55 PM, Mark Kirkwood
wrote:
On 12/06/13 13:15, Stephen Frost wrote:
* Fujii Masao (masao.fu...@gmail.com) wrote:
The attached patch fixes this problem. It just changes walsender so that
it
waits for all the outstanding WAL rec
* Tom Lane (t...@sss.pgh.pa.us) wrote:
> I promptly forgot to do anything about it, but I'd still like to get
> such a change into 9.3. I've now written and tested a patch that
> makes that change without creating any new noise during initdb or in a
> manually-started standalone backend. Does any
I think the suggested emacs configuration snippets in
src/tools/editors/emacs.samples no longer represent current best
practices. I have come up with some newer things that I'd like to
propose for review.
First, I propose adding a .dir-locals.el file to the top-level directory
with basic emacs se
- Original Message -
> From: Peter Eisentraut
> To: pgsql-hackers@postgresql.org
> Cc:
> Sent: Thursday, 13 June 2013 12:16 PM
> Subject: [HACKERS] [PATCH] Remove useless USE_PGXS support in contrib
>
>T his has served no purpose except to
>
> 1. take up space
> 2. confuse users
> 3. p
Barring objections, I will branch off REL9_3_STABLE in the git repo
tomorrow afternoon, probably around 1800 UTC.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailp
Jeff Davis writes:
> The patch is a bit ugly: I had to copy some code, and copy the entire
> checksum.c file (minus some Asserts, which don't work in an external
> program). Suggestions welcome.
What I propose we do about this is reduce backend/storage/page/checksum.c
to something like
#include
Daniel,
The pgsql-hackers mailing list is for people working on the PostgreSQL
database engine itself. Please post your question to one of the
following lists instead:
pgsql-general
pgsql-admin
Or you can use our IRC channel: http://www.postgresql.org/community/irc/
Thanks!
--
Josh Berkus
Po
Hi here!
Centos 6.4
Postgres 9.1
I want to automate rsync backups from server1 to server2 via ssh using the
postgres(linux deamon user) and a pair of private/public keys generated by
ssh-keygen
I generated the keys in Server1 and copy and added id_rsa.pub to
/var/lib/pgsql/.ssh/authorized_keys i
Jeff Janes escribió:
> I think I did the right thing with the message translation files, but
> I can't figure out how to test that.
Don't do that. These files are automatically generated. Just leave
them alone and translators will get to them in time.
--
Álvaro Herrerahttp://w
Bernd Helmle writes:
> What i tried before was to access (in PlanForeignModify) the RelOptInfo
> structure through PlannerInfo->simple_rel_array, assuming the the
> resultRelation index points to the right array member. However, that didn't
> work, the fdw_private List is not the one filled by
Some places in the docs and elog hints refer to "standalone" backends,
while the official name as used in app-postgres.html is "single-user mode",
and in fact "standalone" does not appear on that page.
This tries to standardize the other locations to use "single-user". I
think I did the right thi
--On 13. Juni 2013 11:06:31 -0400 Tom Lane wrote:
My
recommendation would be to see if you can't save the relevant info in
the RelOptInfo node for the relation, probably during GetForeignPlan,
and then get it from there in PlanForeignModify instead of digging in
the plan tree. (You can use t
On 06/13/2013 05:35 AM, Amit Kapila wrote:
> On Friday, June 07, 2013 9:45 AM Amit Kapila wrote:
>> On Thursday, June 06, 2013 10:22 PM Robert Haas wrote:
>>> On Wed, Jun 5, 2013 at 7:24 AM, Amit Kapila
>>> wrote:
On Monday, May 27, 2013 4:17 PM Amit Kapila wrote:
> On Wednesday, April 03
On 6/13/13 5:35 AM, Dean Rasheed wrote:
> Attached is a patch implementing a new aggregate function md5_agg() to
> compute the aggregate MD5 sum across a number of rows.
That seems somewhat useful.
> In passing, I've tidied up and optimised the code in md5.c a bit ---
> specifically I've removed
On Fri, Jun 14, 2013 at 1:30 AM, Erik Rijkers wrote:
> On Thu, June 13, 2013 22:19, Alexander Korotkov wrote:
>
> > [index_on_regexes.1.patch.gz ]
>
> Hi,
>
> Compile of core is OK, but contrib compilation fails:
>
> -- [2013.06.13 23:23:14 idxregex] make contrib
> trgm_gin.c: In function ‘gin_r
On Thu, June 13, 2013 22:19, Alexander Korotkov wrote:
> [index_on_regexes.1.patch.gz ]
Hi,
Compile of core is OK, but contrib compilation fails:
-- [2013.06.13 23:23:14 idxregex] make contrib
trgm_gin.c: In function gin_regexp_trgm_config:
trgm_gin.c:410:2: error: unknown type name GinConf
Back before Christmas I complained that elog.c's behavior of
prioritizing LOG-level messages differently in standalone mode had
masked at least one significant bug, as well as causing confusion
in some other cases:
http://www.postgresql.org/message-id/6967.1355520...@sss.pgh.pa.us
I promptly forgo
Hackers,
Attached patch contains opclass which demonstrates advantages of GIN
additional information storing itself without other GIN improvements. It
implements inversed task of regex indexing. It works so: you create index
on regexes and search for regexes matched query string. It introduce two
Hackers,
Revised version of patch for additional information storage in GIN is
attached. Changes are mostly bug fixes.
Resemble GIN interface changes that this patch introduce.
Patch modifies GIN interface as following:
1) Two arguments are added to extractValue
Datum **addInfo, bool **addInfoIsN
On Wed, Jun 12, 2013 at 9:48 PM, Stephen Frost wrote:
> * Magnus Hagander (mag...@hagander.net) wrote:
>> On Wed, Jun 12, 2013 at 1:48 PM, Andres Freund
>> wrote:
>> > On 2013-06-12 07:53:29 +0900, Fujii Masao wrote:
>> >> The attached patch fixes this problem. It just changes walsender so that
On Wed, Jun 12, 2013 at 9:55 PM, Andres Freund wrote:
> On 2013-06-12 08:48:39 -0400, Stephen Frost wrote:
>> * Magnus Hagander (mag...@hagander.net) wrote:
>> > On Wed, Jun 12, 2013 at 1:48 PM, Andres Freund
>> > wrote:
>> > > On 2013-06-12 07:53:29 +0900, Fujii Masao wrote:
>> > >> The attache
On Wed, Jun 12, 2013 at 12:55 PM, Mark Kirkwood
wrote:
> On 12/06/13 13:15, Stephen Frost wrote:
>>
>> * Fujii Masao (masao.fu...@gmail.com) wrote:
>>>
>>> The attached patch fixes this problem. It just changes walsender so that
>>> it
>>> waits for all the outstanding WAL records to be replicated
On Jun 12, 2013, at 8:00 PM, Brendan Jurd wrote:
> array_dims - Returns the dimensions of the array, unless it is empty
> in which case NULL.
> array_proper_dims - Returns the dimensions of the array.
> array_ndims - Returns the number of dimension, unless it is empty in
> which case NULL.
> arra
On Jun 12, 2013, at 8:16 PM, Peter Eisentraut wrote:
> This has served no purpose except to
>
> 1. take up space
> 2. confuse users
> 3. produce broken external extension modules that take contrib as an example
> 4. break builds of PostgreSQL when users try to fix 3. by exporting USE_PGXS
>
> T
On Wed, Jun 12, 2013 at 10:00 PM, Brendan Jurd wrote:
> On 13 June 2013 04:26, Merlin Moncure wrote:
>> On Wed, Jun 12, 2013 at 1:20 PM, Tom Lane wrote:
>>> Josh Berkus writes:
On 06/12/2013 11:01 AM, Tom Lane wrote:
> I'm going to be disappointed if all we can get out of this is
>
Bernd Helmle writes:
> During the planning phase, the Informix FDW currently plans a server side
> cursor, which identifier i'd like to pass into the planning phase of the
> modify action to reuse it in conjunction with UPDATE ... WHERE CURRENT OF.
> I understand that the ModifyTable structure
I'm currently implementing DML actions in the informix FDW module and
trying to understand how UPDATE/DELETE actions interact with the various
structures, especially how states between the associated ForeignScan and
ForeignModify actions could be transmitted. As far as i understood, with
e.g. a
On Thu, Jun 13, 2013 at 11:24 AM, Simon Riggs wrote:
> That idea is not dependent upon CSNs.
>
> It is an option for us to implement snapshot synchronisation now, we
> just haven't done it yet.
>
> I'm currently working on exporting/importing snapshots on standbys,
> which is a precursor to that i
On Thu, Jun 13, 2013 at 11:39 AM, Hannu Krosing wrote:
>>> Coincidentally getting cluster wide consistent snapshots and delaying
>>> until some specific point in commit ordering is almost trivial to
>>> solve with Commit Sequence Number based snapshot scheme that I
>>> proposed.
>> Can you elabora
Hi,
Attached is a patch implementing a new aggregate function md5_agg() to
compute the aggregate MD5 sum across a number of rows. This is
something I've wished for a number of times. I think the primary use
case is to do a quick check that 2 tables, possibly on different
servers, contain the same
On 9 June 2013 11:14, Dean Rasheed wrote:
> Here's a rebased version of the patch implementing WITH CHECK OPTION
> for auto-updatable views.
>
> It now includes documentation, and a clearer description of the
> patch's limitations --- WITH CHECK OPTION is only supported on
> auto-updatable views,
On 06/13/2013 02:22 AM, Tatsuo Ishii wrote:
>> On Jun 12, 2013 2:02 AM, "Tatsuo Ishii" wrote:
>>> No, I'm not talking about conflict resolution.
>>>
>>> From
>>> http://www.cs.cmu.edu/~natassa/courses/15-823/F02/papers/replication.pdf:
>>> --
>>> Eager
On 13 June 2013 02:18, Stephen Frost wrote:
> * Ants Aasma (a...@cybertec.at) wrote:
>> In a cluster setting you take the CSN value on the master, then before
>> starting execution on a standby you wait until that the standby has
>> replayed enough WAL to reach the CSN point read from the master a
On 11 June 2013 15:59, Tatsuo Ishii wrote:
> I wonder why "true" synchronous replication nor "eager replication"
> are not in the developer TODO list. If we want them in the future,
> they should be on it.
I think you still need to explain what "true" synchronous replication is.
IMHO eager repl
On 13 June 2013 01:11, Tom Lane wrote:
> Dean Rasheed writes:
>> The more I read the spec, the less sense it seems to make, and each
>> time I read it, I seem to reach a different conclusion.
>
>> On my latest reading, I've almost convinced myself that "updatable" is
>> meant to imply support for
36 matches
Mail list logo
