[COMMITTERS] pgsql: Fixed more parsing bugs in other CREATE statements.

2005-02-10 Thread Michael Meskes
Log Message:
---
Fixed more parsing bugs in other CREATE statements.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/src/interfaces/ecpg/preproc:
preproc.y (r1.303.4.2 -> r1.303.4.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/preproc/preproc.y.diff?r1=1.303.4.2&r2=1.303.4.3)

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[COMMITTERS] pgsql: Fixed changelog entry to list correct bug reporter.

2005-02-10 Thread Michael Meskes
Log Message:
---
Fixed changelog entry to list correct bug reporter.

Modified Files:
--
pgsql/src/interfaces/ecpg:
ChangeLog (r1.286 -> r1.287)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/ChangeLog.diff?r1=1.286&r2=1.287)

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[COMMITTERS] pgsql: Fixed more parsing bugs in other CREATE statements as pointed out

2005-02-10 Thread Michael Meskes
Log Message:
---
Fixed more parsing bugs in other CREATE statements as pointed out by TANIDA
Yutaka <[EMAIL PROTECTED]>.

Modified Files:
--
pgsql/src/interfaces/ecpg:
ChangeLog (r1.285 -> r1.286)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/ChangeLog.diff?r1=1.285&r2=1.286)
pgsql/src/interfaces/ecpg/preproc:
preproc.y (r1.306 -> r1.307)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/preproc/preproc.y.diff?r1=1.306&r2=1.307)

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[COMMITTERS] pgsql: Fix SPI cursor support to allow scanning the results of utility

2005-02-10 Thread Tom Lane
Log Message:
---
Fix SPI cursor support to allow scanning the results of utility commands
that return tuples (such as EXPLAIN).  Per gripe from Michael Fuhr.
Side effect: fix an old bug that unintentionally disabled backward scans
for all SPI-created cursors.

Modified Files:
--
pgsql/src/backend/executor:
spi.c (r1.133 -> r1.134)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/spi.c.diff?r1=1.133&r2=1.134)
pgsql/src/backend/tcop:
pquery.c (r1.90 -> r1.91)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/pquery.c.diff?r1=1.90&r2=1.91)

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql: Fix SPI cursor support to allow scanning the results of utility

2005-02-10 Thread Tom Lane
Log Message:
---
Fix SPI cursor support to allow scanning the results of utility commands
that return tuples (such as EXPLAIN).  Per gripe from Michael Fuhr.
Side effect: fix an old bug that unintentionally disabled backward scans
for all SPI-created cursors.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/src/backend/executor:
spi.c (r1.133 -> r1.133.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/spi.c.diff?r1=1.133&r2=1.133.4.1)
pgsql/src/backend/tcop:
pquery.c (r1.89.4.1 -> r1.89.4.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/pquery.c.diff?r1=1.89.4.1&r2=1.89.4.2)

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[COMMITTERS] pgsql: Back-patch fix for a typo that unintentionally disabled backward

2005-02-10 Thread Tom Lane
Log Message:
---
Back-patch fix for a typo that unintentionally disabled backward scans
for all SPI-created cursors.

Tags:

REL7_4_STABLE

Modified Files:
--
pgsql/src/backend/executor:
spi.c (r1.107 -> r1.107.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/spi.c.diff?r1=1.107&r2=1.107.2.1)

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


[COMMITTERS] pgsql: Fix ANALYZE to accumulate some minimal statistics for an all-null

2005-02-10 Thread Tom Lane
Log Message:
---
Fix ANALYZE to accumulate some minimal statistics for an all-null column.
Per gripes from Mike Mascari and Bernd Heller.

Modified Files:
--
pgsql/src/backend/commands:
analyze.c (r1.81 -> r1.82)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/analyze.c.diff?r1=1.81&r2=1.82)

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


[COMMITTERS] pgsql: Adjust input routines for float4, float8 and oid to reject the

2005-02-10 Thread Neil Conway
Log Message:
---
Adjust input routines for float4, float8 and oid to reject the empty string
as valid input (it was previously treated as 0). This input was deprecated
in 8.0 (and a warning was emitted). Regression tests updated.

Modified Files:
--
pgsql/src/backend/utils/adt:
float.c (r1.112 -> r1.113)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/float.c.diff?r1=1.112&r2=1.113)
oid.c (r1.60 -> r1.61)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/oid.c.diff?r1=1.60&r2=1.61)
pgsql/src/test/regress/expected:
float4-exp-three-digits.out (r1.5 -> r1.6)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/float4-exp-three-digits.out.diff?r1=1.5&r2=1.6)
float4.out (r1.11 -> r1.12)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/float4.out.diff?r1=1.11&r2=1.12)
float8-exp-three-digits-win32.out (r1.4 -> r1.5)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/float8-exp-three-digits-win32.out.diff?r1=1.4&r2=1.5)
float8-exp-three-digits.out (r1.9 -> r1.10)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/float8-exp-three-digits.out.diff?r1=1.9&r2=1.10)
float8-small-is-zero.out (r1.7 -> r1.8)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/float8-small-is-zero.out.diff?r1=1.7&r2=1.8)
float8-small-is-zero_1.out (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/float8-small-is-zero_1.out.diff?r1=1.1&r2=1.2)
float8.out (r1.21 -> r1.22)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/float8.out.diff?r1=1.21&r2=1.22)
oid.out (r1.10 -> r1.11)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/oid.out.diff?r1=1.10&r2=1.11)
pgsql/src/test/regress/sql:
float4.sql (r1.6 -> r1.7)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/float4.sql.diff?r1=1.6&r2=1.7)
float8.sql (r1.12 -> r1.13)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/float8.sql.diff?r1=1.12&r2=1.13)
oid.sql (r1.6 -> r1.7)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/oid.sql.diff?r1=1.6&r2=1.7)

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[COMMITTERS] pgsql: Mention that some psql environment variables come from libpq and

2005-02-10 Thread Bruce Momjian
Log Message:
---
Mention that some psql environment variables come from libpq and note
more variables can be found in the libpq manual section.

Mention .pgpass in the psql manual page section dealing with connection
parameters and point to the libpq section for more details.

Backpatch to 8.0.X.

Modified Files:
--
pgsql/doc/src/sgml/ref:
psql-ref.sgml (r1.132 -> r1.133)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/psql-ref.sgml.diff?r1=1.132&r2=1.133)

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql: Mention that some psql environment variables come from libpq and

2005-02-10 Thread Bruce Momjian
Log Message:
---
Mention that some psql environment variables come from libpq and note
more variables can be found in the libpq manual section.

Mention .pgpass in the psql manual page section dealing with connection
parameters and point to the libpq section for more details.

Backpatch to 8.0.X.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/doc/src/sgml/ref:
psql-ref.sgml (r1.130.4.2 -> r1.130.4.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/psql-ref.sgml.diff?r1=1.130.4.2&r2=1.130.4.3)

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


[COMMITTERS] pgsql: Make clearer warning about using 'now' with DEFAULT: SELECT

2005-02-10 Thread Bruce Momjian
Log Message:
---
Make clearer warning about using 'now' with DEFAULT:

SELECT CURRENT_TIMESTAMP;
SELECT now();
SELECT TIMESTAMP 'now';  -- incorrect for use with DEFAULT

Modified Files:
--
pgsql/doc/src/sgml:
func.sgml (r1.237 -> r1.238)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.237&r2=1.238)

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[COMMITTERS] pgsql: Update to Russian FAQ, HEAD and 8.0.X.

2005-02-10 Thread Bruce Momjian
Log Message:
---
Update to Russian FAQ, HEAD and 8.0.X.

Modified Files:
--
pgsql/doc:
FAQ_russian (r1.23 -> r1.24)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ_russian.diff?r1=1.23&r2=1.24)
pgsql/doc/src/FAQ:
FAQ_russian.html (r1.24 -> r1.25)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ_russian.html.diff?r1=1.24&r2=1.25)

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql: Update to Russian FAQ, HEAD and 8.0.X.

2005-02-10 Thread Bruce Momjian
Log Message:
---
Update to Russian FAQ, HEAD and 8.0.X.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/doc:
FAQ_russian (r1.23 -> r1.23.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ_russian.diff?r1=1.23&r2=1.23.4.1)
pgsql/doc/src/FAQ:
FAQ_russian.html (r1.24 -> r1.24.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ_russian.html.diff?r1=1.24&r2=1.24.4.1)

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])