Re: [PATCHES] pg_generate_sequence and info_schema patch (Was: SELECT Question)

2004-01-31 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > regression=# select * from pg_generate_sequence(8, 4); > ERROR: finish is less than start Hm, would it be better just to return an empty set? Certainly I'd expect pg_generate_sequence(1,0) to return an empty set with no error. > regression=# select * fro

[PATCHES] pg_generate_sequence and info_schema patch (Was: SELECT Question)

2004-01-31 Thread Joe Conway
Joe Conway wrote: Tom Lane wrote: I was thinking of proposing that we provide something just about like that as a standard function (written in C, not in plpgsql, so that it would be available whether or not you'd installed plpgsql). There are some places in the information_schema that desperately

Re: [HACKERS] [PATCHES] v7.4.1 text_position() patch

2004-01-31 Thread Joe Conway
Tatsuo Ishii wrote: Thanks. Please apply it. Applied to REL7_3_STABLE. Thanks, Joe ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] [PATCHES] v7.4.1 text_position() patch

2004-01-31 Thread Tatsuo Ishii
> Tatsuo Ishii wrote: > > It's surprising that nobody noticed the bug until now. It seems it has > > been there since 7.3 days. I would like to make a back patch for > > 7.3-stable if nobody objects. > > It's my bug :( -- sorry about that. Here's a 7.3 patch per Tom's nearby > advice. I'll apply

[PATCHES] fix minor memory error in initdb

2004-01-31 Thread Neil Conway
The new C version of initdb presently provokes the following valgrind warnings: ==15366== ==15366== Conditional jump or move depends on uninitialised value(s) ==15366==at 0x8049713: mkdir_p (initdb.c:556) ==15366==by 0x8049C8E: mkdatadir (initdb.c:812) ==15366==by 0x804C833: main (ini

[PATCHES] unified diffs, PLEASE?

2004-01-31 Thread Wiseguy
Is there a good reason why minor source revisions are not posted to the ftp mirrors as unified diff patchfiles? I mean, both 7.4.0 and 7.4.1 were nearly 10MB in size as bz2 archives. That's a 40 minute download per file for a 56kb modem connection. Whereas, I created a bz2 patchfile from 7.4.0

Re: [HACKERS] [PATCHES] v7.4.1 text_position() patch

2004-01-31 Thread Joe Conway
Tatsuo Ishii wrote: It's surprising that nobody noticed the bug until now. It seems it has been there since 7.3 days. I would like to make a back patch for 7.3-stable if nobody objects. It's my bug :( -- sorry about that. Here's a 7.3 patch per Tom's nearby advice. I'll apply if you'd like. Joe I