Re: [HACKERS] Review: Fix snapshot taking inconsistencies

2010-10-06 Thread Steve Singer
On Mon, 4 Oct 2010, Marko Tiikkaja wrote: the patch does, modules start behaving weirdly. So what I'm suggesting is: - Deprecate pg_parse_and_rewrite(). I have no idea how the project has done this in the past, but grepping the source code for deprecated suggests that we just remove

Re: [HACKERS] Sync Rep at Oct 5

2010-10-05 Thread Steve Singer
On 10-10-05 04:32 AM, Simon Riggs wrote: This is an attempt to compile everybody's stated viewpoints and come to an understanding about where we are and where we want to go. The idea from here is that we discuss what we are trying to achieve (requirements) and then later come back to how

Re: [HACKERS] Review: Fix snapshot taking inconsistencies

2010-10-03 Thread Steve Singer
On Mon, 4 Oct 2010, Marko Tiikkaja wrote: On 2010-10-03 5:08 AM +0300, Steve Singer wrote: Hmm.. I can't reproduce this. What platform are you on? Sorry, I it seems the changes to one file (pg_proc.c) didn't get applied to my source repository. Now that I've applied them initdb works

[HACKERS] Review: Fix snapshot taking inconsistencies

2010-10-02 Thread Steve Singer
This is my review on the Fix snapshot taking inconsistencies patch. The patch applies against master (a13f12b3a18da0a61571cb134fdecea03a10d6f) However initdb fails with: FATAL: return type mismatch in function declared to return record DETAIL: Function's final statement must be SELECT or

Re: [HACKERS] HS/SR on AIX

2010-08-27 Thread Steve Singer
on the replica does it make a difference? How about with a LIBPATH=/apps/pg_9.0_b4/lib/postgresql (I'm not exactly sure where libpq.a is on your install) Alanoly. -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] HS/SR on AIX

2010-08-25 Thread Steve Singer
Tom Lane wrote: Steve Singer ssin...@ca.afilias.info writes: I think I've been able to reproduce the issue floating around with streaming replication on AIX. Excellent, because we weren't getting much from the original reporter. I'm withdrawing my comment, today on a clean install

Re: [HACKERS] HS/SR on AIX

2010-08-25 Thread Steve Singer
Steve Singer wrote: Tom Lane wrote: Steve Singer ssin...@ca.afilias.info writes: I think I've been able to reproduce the issue floating around with streaming replication on AIX. I will do another clean build from the beta4 source tar to confirm that I'm not still having the issue but I'm

[HACKERS] HS/SR on AIX

2010-08-24 Thread Steve Singer
:../../../../src/backend/postgres.imp I'll try to look into this a bit more tomorrow or thursday. -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Patch: psql \whoami option

2010-07-18 Thread Steve Singer
On Sun, 18 Jul 2010, David Christensen wrote: It's helpful when you attach said patch. This has been rebased to current HEAD. One minor thing I noticed in the updated patch. You moved the '{' after the if(host) in command.c to it's own line(good) but you used spaces instead of tabstops

[HACKERS] stats collector connection refused on recv of test message

2010-06-20 Thread Steve Singer
On one of my machines I get LOG: could not receive test message on socket for statistics collector: Connection refused on startup. I noticed this testing 9.0 but when I went back to check I'm now getting it on 8.3 as well, disabling all of my iptables rules doesn't help. I've done some

Re: [HACKERS] Patch: psql \whoami option

2010-06-20 Thread Steve Singer
This is a review for the \whoami patch (changed to \conninfo). This review was done on the Feb 2 2010 version of the patch (rebased to head) that reflects some of the feedback from -hackers on the initial submission. The commitfest entry should be updated to reflect the most recent version

[HACKERS] 9.0 beta2 pg_upgrade: malloc 0 bytes patch

2010-06-16 Thread Steve Singer
consisting of a single table to 9.0 on an AIX server. -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 diff --git a/contrib/pg_upgrade/tablespace.c b/contrib/pg_upgrade/tablespace.c index 302eb0d..99a97e4 100644 --- a/contrib/pg_upgrade/tablespace.c +++ b/contrib/pg_upgrade

[HACKERS] 9.0 beta2 pg_upgrade command line parsing

2010-06-15 Thread Steve Singer
': option.c:103: warning: comparison is always true due to limited range of data type getopt_long (both our version in ports and the gnu version) is defined to return an int. The attach patch allows me to get beyond the options loop under AIX. -- Steve Singer Afilias Canada Data Services Developer

Re: [HACKERS] Exposing the Xact commit order to the user

2010-05-26 Thread Steve Singer
' You could then move the work of figuring out the commit order onto the replica where you would combine the output of the WAL scanning process with the transaction data that has been copied to the replica. Jan -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 -- Sent

Re: [HACKERS] dtester-0.1 released

2010-03-26 Thread Steve Singer
for the http protocol to work? Or just once to initialize the repository? Note that the git protocol said to be is more efficient. At least that's what I've heard. You might want to use that instead (especially if http continues to pose problems). Kind Regards Markus Wanner -- Steve Singer

Re: [HACKERS] dtester-0.1 released

2010-03-24 Thread Steve Singer
- The requested URL returned error: 500 Is your git server having issues or am I trying to get at the code in the wrong way. Thanks Regards Markus Wanner -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] [rfc,patch] PL/Proxy in core

2008-05-17 Thread Steve Singer
On Thu, 15 May 2008, Marko Kreen wrote: On 5/15/08, Josh Berkus [EMAIL PROTECTED] wrote: Has PL/proxy been tested on other OSes? FreeBSD/Solaris/Windows? It definitely works on Linux and MacOS. I've seen ports for *BSD. I think any unix-like OS-es should work fine. I've compiled it with

Re: [HACKERS] [rfc,patch] PL/Proxy in core

2008-05-17 Thread Steve Singer
On Sat, 17 May 2008, Marko Kreen wrote: On 5/17/08, Steve Singer [EMAIL PROTECTED] wrote: Somewhat unrelated, I can see use-cases for replacing the call to random() with something that allows user defined polices for RUN ON ANY. Well, thats why the RUN ON userfunc(..); exists. Also notice

Re: [PATCHES] Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?

2007-12-01 Thread Steve Singer
On Sat, 1 Dec 2007, Tom Lane wrote: I wrote: I got around to trying it with a dusty 5.6.1 I have laying about on my HPPA machine, and the news is not good: CREATE LANGUAGE plperl dumps core deep inside libperl. With or without this patch. As best I can tell at the moment, I have not tested

Re: [HACKERS] 8.2beta1 failure on IRIX

2006-10-05 Thread Steve Singer
On Wed, 4 Oct 2006, Tom Lane wrote: I've applied the patch and it seems to fix the problems. 8.2beta1 + the patch passes all of the regression tests on the IRIX box (accept the expected difference with the geometry test). I've applied the attached patch which merges ideas from your

Re: [HACKERS] 8.2beta1 failure on IRIX

2006-10-04 Thread Steve Singer
On Sun, 1 Oct 2006, Tom Lane wrote: Does this version of the patch address your concerns. Some searching of the net shows that this has been reported before. Once in the beta for 8.1 and again in January as bug #2192 (It looks like a patch was included then but wasn't applied). It seems

[HACKERS] 8.2beta1 failure on IRIX

2006-10-01 Thread Steve Singer
I'm getting some failures in the regression tests on 8.2beta1 on IRIX. It looks like IRIX (or at least some versions) has a broken strtod. The float4 and float8 tests fail, I've attached a patch to tools/adt/float.c that fixes the problem along with the regression output. As a side note,could

Re: [HACKERS] More nuclear options

2006-07-11 Thread Steve Singer
On Mon, 10 Jul 2006, Josh Berkus wrote: To be migrated to pgFoundry: dbmirror (need owner) I'll volunteer for this if no one else steps forward. I'm not planning on making any significant chances to dbmirror at this point stage but I can look after for the pgfoundry project.

<    1   2   3