Re: [COMMITTERS] pgsql: Fix NUMERIC modulus to properly truncate

2005-06-04 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: >> No, I don't think so. It doesn't seem to be something that enough >> people use to risk the change in behavior --- it might break something >> that was working. But, if folks want it backported we can do it. It is >> only a change to properl

Re: [COMMITTERS] pgsql: Fix NUMERIC modulus to properly truncate

2005-06-04 Thread Christopher Kings-Lynne
> No, I don't think so. It doesn't seem to be something that enough people use to risk the change in behavior --- it might break something that was working. But, if folks want it backported we can do it. It is only a change to properly do modulus for numeric. Well, from my point of view it'

[COMMITTERS] pgsql: Add description for backend termination: < cleaned up

2005-06-04 Thread Bruce Momjian
Log Message: --- Add description for backend termination: < cleaned up properly. A new signal is needed for safe termination. > cleaned up properly. A new signal is needed for safe termination > because backends must first do a query cancel, then exit once they > have run the que

[COMMITTERS] pgsql: Here's a patch to do the following: 1.

2005-06-04 Thread Bruce Momjian
Log Message: --- Here's a patch to do the following: 1. Rename spi_return_next to return_next. 2. Add a new test for return_next. 3. Update the expected output. 4. Update the documentation. Abhijit Menon-Sen Modified Files: -- pgsql/doc/src/sgml: plperl.sgml (r2.4

[COMMITTERS] pgsql: Code for SET/SHOW TIME ZONE with a fixed-interval timezone was

2005-06-04 Thread Tom Lane
Log Message: --- Code for SET/SHOW TIME ZONE with a fixed-interval timezone was not prepared for HAVE_INT64_TIMESTAMP. Per report from Guillaume Beaudoin. Tags: REL8_0_STABLE Modified Files: -- pgsql/src/backend/commands: variable.c (r1.105 -> r1.105.4.1)

[COMMITTERS] pgsql: Code for SET/SHOW TIME ZONE with a fixed-interval timezone was

2005-06-04 Thread Tom Lane
Log Message: --- Code for SET/SHOW TIME ZONE with a fixed-interval timezone was not prepared for HAVE_INT64_TIMESTAMP. Per report from Guillaume Beaudoin. Tags: REL7_3_STABLE Modified Files: -- pgsql/src/backend/commands: variable.c (r1.71.2.2 -> r1.71.2.3)

[COMMITTERS] pgsql: Code for SET/SHOW TIME ZONE with a fixed-interval timezone was

2005-06-04 Thread Tom Lane
Log Message: --- Code for SET/SHOW TIME ZONE with a fixed-interval timezone was not prepared for HAVE_INT64_TIMESTAMP. Per report from Guillaume Beaudoin. Tags: REL7_4_STABLE Modified Files: -- pgsql/src/backend/commands: variable.c (r1.88.2.1 -> r1.88.2.2)

[COMMITTERS] pgsql: Code for SET/SHOW TIME ZONE with a fixed-interval timezone was

2005-06-04 Thread Tom Lane
Log Message: --- Code for SET/SHOW TIME ZONE with a fixed-interval timezone was not prepared for HAVE_INT64_TIMESTAMP. Per report from Guillaume Beaudoin. Modified Files: -- pgsql/src/backend/commands: variable.c (r1.106 -> r1.107) (http://developer.postgr

[COMMITTERS] pgsql: Add TODO.detail for 2phase commit: > * Add two-phase commit

2005-06-04 Thread Bruce Momjian
Log Message: --- Add TODO.detail for 2phase commit: > * Add two-phase commit [2phase] Modified Files: -- pgsql/doc: TODO (r1.1550 -> r1.1551) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1550&r2=1.1551) pgsql/doc/src/FAQ:

[COMMITTERS] pgsql: Add 2phase TODO.detail.

2005-06-04 Thread Bruce Momjian
Log Message: --- Add 2phase TODO.detail. Added Files: --- pgsql/doc/TODO.detail: 2phase (r1.3) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/2phase?rev=1.3&content-type=text/x-cvsweb-markup) pitr (r1.1) (http://developer.pos

[COMMITTERS] pgsql: Replace the parser's namespace tree (which formerly had the same

2005-06-04 Thread Tom Lane
Log Message: --- Replace the parser's namespace tree (which formerly had the same representation as the jointree) with two lists of RTEs, one showing the RTEs accessible by qualified names, and the other showing the RTEs accessible by unqualified names. I think this is conceptually simpler

[COMMITTERS] pgsql: Add TODO.detail.

2005-06-04 Thread Bruce Momjian
Log Message: --- Add TODO.detail. < logs > logs [pitr] 130c130 < * Allow a warm standby system to also allow read-only queries > * Allow a warm standby system to also allow read-only queries [pitr] Modified Files: -- pgsql/doc: TODO (r1.1549 -> r1.1550)

[COMMITTERS] pgsql: Remove duplicate emails.

2005-06-04 Thread Bruce Momjian
Log Message: --- Remove duplicate emails. Modified Files: -- pgsql/doc/TODO.detail: wal (r1.6 -> r1.7) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/wal.diff?r1=1.6&r2=1.7) ---(end of broadcast)--

[COMMITTERS] pgsql: Add TODO.detail for timezone: < information, either zone name

2005-06-04 Thread Bruce Momjian
Log Message: --- Add TODO.detail for timezone: < information, either zone name or offset from UTC > information, either zone name or offset from UTC [timezone] Modified Files: -- pgsql/doc: TODO (r1.1548 -> r1.1549) (http://developer.postgresql.org/cvs

[COMMITTERS] pgsql: Add TODO.detail of standard timezone data type.

2005-06-04 Thread Bruce Momjian
Log Message: --- Add TODO.detail of standard timezone data type. Added Files: --- pgsql/doc/TODO.detail: timezone (r1.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/timezone?rev=1.1&content-type=text/x-cvsweb-markup) -

[COMMITTERS] pgsql: Add pg_upgrade TODO.detail.

2005-06-04 Thread Bruce Momjian
Log Message: --- Add pg_upgrade TODO.detail. Added Files: --- pgsql/doc/TODO.detail: pg_upgrade (r1.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/pg_upgrade?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of br

[COMMITTERS] pgsql: Add TODO.detail: > * Allow major upgrades without dump/reload,

2005-06-04 Thread Bruce Momjian
Log Message: --- Add TODO.detail: > * Allow major upgrades without dump/reload, perhaps using pg_upgrade > [pg_upgrade] Modified Files: -- pgsql/doc: TODO (r1.1547 -> r1.1548) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1547&r2=

[COMMITTERS] pgsql: Add pg_dump TODO.detail for multiple -t / -n flags.

2005-06-04 Thread Bruce Momjian
Log Message: --- Add pg_dump TODO.detail for multiple -t / -n flags. Modified Files: -- pgsql/doc/TODO.detail: pg_dump (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/pg_dump.diff?r1=1.1&r2=1.2) ---(

[COMMITTERS] pgsql: Add pg_dump to TODO.detail.

2005-06-04 Thread Bruce Momjian
Log Message: --- Add pg_dump to TODO.detail. Modified Files: -- pgsql/doc: TODO (r1.1546 -> r1.1547) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1546&r2=1.1547) pgsql/doc/src/FAQ: TODO.html (r1.53 -> r1.54) (htt

[COMMITTERS] pgsql: Back out patch:

2005-06-04 Thread Bruce Momjian
Log Message: --- Back out patch: --- Tom Lane <[EMAIL PROTECTED]> writes: > a_ogawa <[EMAIL PROTECTED]> writes: > > It is a reasonable idea. However, the majority part of MemSet was not > > able to be avoided by this

[COMMITTERS] pgsql: Add comment for multi-byte computation.

2005-06-04 Thread Bruce Momjian
Log Message: --- Add comment for multi-byte computation. Modified Files: -- pgsql/src/backend/parser: parse_expr.c (r1.182 -> r1.183) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_expr.c.diff?r1=1.182&r2=1.183)

[COMMITTERS] pgsql: Allow kerberos name and username case sensitivity to be

2005-06-04 Thread Bruce Momjian
Log Message: --- Allow kerberos name and username case sensitivity to be specified from postgresql.conf. --- Here's an updated version of the patch, with the following changes: 1) No longer uses "service name" as "

[COMMITTERS] pgsql: At 2005-05-21 20:18:50 +0530, [EMAIL PROTECTED] wrote: > > > The

2005-06-04 Thread Bruce Momjian
Log Message: --- At 2005-05-21 20:18:50 +0530, [EMAIL PROTECTED] wrote: > > > The second issue is where plperl returns a large result set. I have attached the following seven patches to address this problem: 1. Trivial. Replaces some errant spaces with tabs. 2. Trivial. Fixes the spellin

[COMMITTERS] pgsql: Tom Lane <[EMAIL PROTECTED]> writes: > a_ogawa

2005-06-04 Thread Bruce Momjian
Log Message: --- Tom Lane <[EMAIL PROTECTED]> writes: > a_ogawa <[EMAIL PROTECTED]> writes: > > It is a reasonable idea. However, the majority part of MemSet was not > > able to be avoided by this idea. Because the per-tuple contexts are used > > at the early stage of executor. > > Drat. W

[COMMITTERS] pgsql: Change expandRTE() and ResolveNew() back to taking just the

2005-06-04 Thread Tom Lane
Log Message: --- Change expandRTE() and ResolveNew() back to taking just the single RTE of interest, rather than the whole rangetable list. This makes the API more understandable and avoids duplicate RTE lookups. This patch reverts no-longer-needed portions of my patch of 2004-08-19. Mod

[COMMITTERS] pgsql: Back out make_mkid change.

2005-06-04 Thread Bruce Momjian
Log Message: --- Back out make_mkid change. Modified Files: -- pgsql/src/tools: make_mkid (r1.9 -> r1.10) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tools/make_mkid.diff?r1=1.9&r2=1.10) ---(end of broadcast)--

[COMMITTERS] pgsql: Improve readability of config location params by adding newline.

2005-06-04 Thread Bruce Momjian
Log Message: --- Improve readability of config location params by adding newline. Modified Files: -- pgsql/src/backend/utils/misc: postgresql.conf.sample (r1.141 -> r1.142) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.

[COMMITTERS] pgsql: Add: > * Allow pg_ctl to work properly with configuration files

2005-06-04 Thread Bruce Momjian
Log Message: --- Add: > * Allow pg_ctl to work properly with configuration files located outside > the PGDATA directory > > pg_ctl can not read the pid file because it isn't located in the > config directory but in the PGDATA directory. The solution is to > allow pg_ctl to read a

[COMMITTERS] pgsql: Add description: > > O_DIRECT doesn't have the same media

2005-06-04 Thread Bruce Momjian
Log Message: --- Add description: > > O_DIRECT doesn't have the same media write guarantees as fsync, so it > is in addition to the fsync method, not in place of it. > Modified Files: -- pgsql/doc: TODO (r1.1544 -> r1.1545) (http://developer.postgresql

Re: [COMMITTERS] pgsql: Fix NUMERIC modulus to properly truncate

2005-06-04 Thread Bruce Momjian
Christopher Kings-Lynne wrote: > Is this a backport? No, I don't think so. It doesn't seem to be something that enough people use to risk the change in behavior --- it might break something that was working. But, if folks want it backported we can do it. It is only a change to properly do modul

Re: [COMMITTERS] pgsql: Fix NUMERIC modulus to properly truncate

2005-06-04 Thread Christopher Kings-Lynne
Is this a backport? Bruce Momjian wrote: Log Message: --- Fix NUMERIC modulus to properly truncate division in computation. Division rounding was causing incorrect results. Test case: test=> SELECT 12345678901234567890 % 123; ?column? --

[COMMITTERS] pgsql: Fix NUMERIC modulus to properly truncate division in computation.

2005-06-04 Thread Bruce Momjian
Log Message: --- Fix NUMERIC modulus to properly truncate division in computation. Division rounding was causing incorrect results. Test case: test=> SELECT 12345678901234567890 % 123; ?column? -- 78 (1 row) Was returning -45. Mod