Re: [HACKERS] git: uh-oh

2010-09-04 Thread Max Bowsher
On 03/09/10 03:34, Max Bowsher wrote: Robert Haas wrote: On Thu, Sep 2, 2010 at 8:13 AM, Michael Haggerty mhag...@alum.mit.edu wrote: What weirdness, exactly, are you discussing now? I've lost track of which problem(s) are still unresolved. Lots of commits that look like this: commit

Re: [HACKERS] english parser in text search: support for multiple words in the same position

2010-09-04 Thread Sushant Sinha
Updating the patch with emitting parttoken and registering it with snowball config. -Sushant. On Fri, 2010-09-03 at 09:44 -0400, Robert Haas wrote: On Wed, Sep 1, 2010 at 2:42 AM, Sushant Sinha sushant...@gmail.com wrote: I have attached a patch that emits parts of a host token, a url token,

Re: [HACKERS] The other major HS TODO: standby promotion

2010-09-04 Thread Itagaki Takahiro
On Sat, Sep 4, 2010 at 5:02 AM, Josh Berkus j...@agliodbs.com wrote: As far as I'm concerned, the other big missing feature for HS is the ability to promote standbys to become the new master. Absolutely. Users often express disappointment when they know a new base backup required after fail

Re: [HACKERS] upcoming wraps

2010-09-04 Thread Devrim GÜNDÜZ
On Mon, 2010-08-30 at 11:19 +0300, Peter Eisentraut wrote: Peter muttered something about doing that this week. The major blocker is preparing the release notes. If someone has time for that ... Peter, do you have a time estimation about this? I'd like to build 9.1 alpha1 RPMs before we

Re: [HACKERS] git: uh-oh

2010-09-04 Thread Robert Haas
On Sat, Sep 4, 2010 at 3:22 AM, Max Bowsher m...@f2s.com wrote: and the result is that things are looking pretty clean :-) Hey, that's great. But I wonder why Magnus got a different result. Can you post the repo you ended up with somewhere? -- Robert Haas EnterpriseDB:

Re: [HACKERS] git: uh-oh

2010-09-04 Thread Max Bowsher
On 04/09/10 12:24, Robert Haas wrote: On Sat, Sep 4, 2010 at 3:22 AM, Max Bowsher m...@f2s.com wrote: and the result is that things are looking pretty clean :-) Hey, that's great. But I wonder why Magnus got a different result. This is the first time I've posted these incantations for

Re: [HACKERS] returning multiple result sets from a stored procedure

2010-09-04 Thread Merlin Moncure
On Fri, Sep 3, 2010 at 4:07 PM, Josh Berkus j...@agliodbs.com wrote: I noticed in postgres you cannot return multiple result sets from a stored procedure (surprisingly as it looks like a very good dbms). That feature has been on the TODO list for years.  However, nobody has stepped forward

Re: [HACKERS] Streaming a base backup from master

2010-09-04 Thread Greg Stark
On Fri, Sep 3, 2010 at 8:30 PM, Martijn van Oosterhout klep...@svana.org wrote: rsync is not rocket science. All you need is for the receiving end to send a checksum for each block it has. The server side does the same checksum and for each block sends back same or new data. Well rsync is

Re: [HACKERS] Streaming a base backup from master

2010-09-04 Thread Thom Brown
On 4 September 2010 14:42, Greg Stark gsst...@mit.edu wrote: The industry standard solution that we're missing that we *should* be figuring out how to implement is incremental backups. I'll buy you a crate of beer if this gets implemented... although you're in Dublin so would be like buying

Re: [HACKERS] returning multiple result sets from a stored procedure

2010-09-04 Thread Pavel Stehule
2010/9/4 Merlin Moncure mmonc...@gmail.com: On Fri, Sep 3, 2010 at 4:07 PM, Josh Berkus j...@agliodbs.com wrote: I noticed in postgres you cannot return multiple result sets from a stored procedure (surprisingly as it looks like a very good dbms). That feature has been on the TODO list for

Re: [HACKERS] returning multiple result sets from a stored procedure

2010-09-04 Thread Merlin Moncure
On Sat, Sep 4, 2010 at 10:10 AM, Pavel Stehule pavel.steh...@gmail.com wrote: Also as mentioned upthread there are effective workarounds if you poke around a bit.  This is a FAQ, and there are about 3-4 solid methods (if you search the archives) that cover most problems you would be looking at

Re: [HACKERS] returning multiple result sets from a stored procedure

2010-09-04 Thread Pavel Stehule
2010/9/4 Merlin Moncure mmonc...@gmail.com: On Sat, Sep 4, 2010 at 10:10 AM, Pavel Stehule pavel.steh...@gmail.com wrote: Also as mentioned upthread there are effective workarounds if you poke around a bit.  This is a FAQ, and there are about 3-4 solid methods (if you search the archives)

Re: [HACKERS] can we enhance regtype infunction to support %type and %type[]

2010-09-04 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com writes: I am looking on ToDo topic - Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] Some the most simple solution can be enhancing regtype to support this syntax I'm not really in favor of adding a wart like that to regtype, and I don't see how it

Re: [HACKERS] git: uh-oh

2010-09-04 Thread Tom Lane
Max Bowsher m...@f2s.com writes: I think we should start a git repository somewhere containing the precise conversion recipe - i.e.: * cvs2git options file * cvs2git invocation command line * all scripts that massage the CVS repository before conversion, or the Git repository afterwards

Re: [HACKERS] can we enhance regtype infunction to support %type and %type[]

2010-09-04 Thread Pavel Stehule
2010/9/4 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com writes: I am looking on ToDo topic - Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] Some the most simple solution can be enhancing regtype to support this syntax I'm not really in favor of adding a wart like

[HACKERS] 9.1alpha1 bundled -- please verify

2010-09-04 Thread Peter Eisentraut
Alpha1 has been bundled and is available at http://developer.postgresql.org/~petere/alpha/ Please check that it is sane. If there are no concerns, I will move them to the FTP site tomorrow (Sunday) and send out announcements on Monday. If someone wants to volunteer to craft a brief release

Re: [HACKERS] 9.1alpha1 bundled -- please verify

2010-09-04 Thread Dave Page
Announcing on Monday doesn't give us any time to build installers. On 9/4/10, Peter Eisentraut pete...@gmx.net wrote: Alpha1 has been bundled and is available at http://developer.postgresql.org/~petere/alpha/ Please check that it is sane. If there are no concerns, I will move them to the

Re: [HACKERS] Fix for pg_upgrade's forcing pg_controldata into English

2010-09-04 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Tom Lane wrote: I certainly hope that pg_regress isn't freeing the strings it passes to putenv() ... pg_regress does not restore these settings (it says with C/English) so the code is different. That's not what I'm on about.

Re: [HACKERS] 9.1alpha1 bundled -- please verify

2010-09-04 Thread Tom Lane
Dave Page dp...@pgadmin.org writes: Announcing on Monday doesn't give us any time to build installers. Also, Monday is a major holiday in the US. Tuesday or Wednesday might be more sensible. regards, tom lane -- Sent via pgsql-hackers mailing list

Re: [HACKERS] ps buffer is incorrectly padded on the (latest) OS X

2010-09-04 Thread Tom Lane
I wrote: I tried this on a PPC Mac running 10.4.11, which is the oldest Mac OS I have handy at the moment. It worked fine. The existing coding in ps_status.c dates from late 2001, which means that it was first tested against OS X 10.1, and most likely we have not rechecked the question of

Re: [HACKERS] lexing small ints as int2

2010-09-04 Thread Robert Haas
On Sat, Sep 4, 2010 at 12:26 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: Maybe the lexer isn't the right place to fix this.  The problem here (or so I gather) is that if I say foo(1), then 1 is an integer and we'll do an implicit cast to bigint, real,

Re: [HACKERS] git: uh-oh

2010-09-04 Thread Robert Haas
On Sat, Sep 4, 2010 at 9:17 AM, Max Bowsher m...@f2s.com wrote: and the result is that things are looking pretty clean :-) Hey, that's great.  But I wonder why Magnus got a different result. This is the first time I've posted these incantations for excising the unwanted history, so he would

Re: [HACKERS] Streaming a base backup from master

2010-09-04 Thread Robert Haas
On Sat, Sep 4, 2010 at 9:42 AM, Greg Stark gsst...@mit.edu wrote: *However* I tihnk you're all headed in the wrong direction here. I don't think rsync is what anyone should be doing with their backups at all. It still requires scanning through *all* your data even if you've only changed a

Re: [HACKERS] lexing small ints as int2

2010-09-04 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: I am not too sure that the distinction between implicit casts and assignment casts is all that useful; We've been there and done that; it doesn't work. The current scheme was invented specifically because a two-way design didn't work.