Re: [COMMITTERS] pgsql-server/ /configure /configure.in onfig/c ...

2003-10-31 Thread Peter Eisentraut
Tom Lane writes:

> The immediately previous code would default to CFLAGS="-g" if
> --enable-debug is specified and the compiler is not gcc.  As it
> now stands, we default to CFLAGS="-O -g" instead.  I'm not convinced
> this is a good idea.  On most non-gcc compilers, this combination
> gets you "-g" and possibly a ton of warnings.

Good point.  Back to the drawing board.

> I think you changed the behavior for the AIX port.  Diffing
> src/template/aix against the old contents:
>
> diff -c -r1.11 -r1.14

1.11 is not the old content.  But the current state is still broken as you
say.

-- 
Peter Eisentraut   [EMAIL PROTECTED]


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

   http://www.postgresql.org/docs/faqs/FAQ.html


[COMMITTERS] pgsql-server/src/interfaces/ecpg ChangeLog pre ...

2003-10-31 Thread Michael Meskes
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 10:10:41

Modified files:
src/interfaces/ecpg: ChangeLog 
src/interfaces/ecpg/preproc: pgc.l 

Log message:
If EOF is found inside a string/comment/etc. stop parsing.


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


[COMMITTERS] pgsql-server/src backend/utils/adt/ri_triggers ...

2003-10-31 Thread Jan Wieck
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/30 23:58:21

Modified files:
src/backend/utils/adt: ri_triggers.c 
src/test/regress/expected: foreign_key.out 
src/test/regress/sql: foreign_key.sql 

Log message:
Fix for possible referential integrity violation when a qualified ON INSERT
rule split the query into one INSERT and one UPDATE where the UPDATE
then hit's the just created row without modifying the key fields again.
In this special case, the new key slipped in totally unchecked.

Jan


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[COMMITTERS] pgsql-server/src/test/regress expected/foreign ...

2003-10-31 Thread Jan Wieck
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 10:27:57

Modified files:
src/test/regress/expected: foreign_key.out rules.out 
src/test/regress/sql: foreign_key.sql rules.sql 

Log message:
Moved the recently added test for foreign key disabled by rewrite
rule into the rule.sql since it affects the latter if run in paralell.

Jan


---(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-server/src backend/utils/adt/Tag: backen ...

2003-10-31 Thread Jan Wieck
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/30 23:57:42

Modified files:
src/backend/utils/adt: Tag: REL7_3_STABLE ri_triggers.c 
src/test/regress/expected: Tag: REL7_3_STABLE foreign_key.out 
src/test/regress/sql: Tag: REL7_3_STABLE foreign_key.sql 

Log message:
Fix for possible referential integrity violation when a qualified ON INSERT
rule split the query into one INSERT and one UPDATE where the UPDATE
then hit's the just created row without modifying the key fields again.
In this special case, the new key slipped in totally unchecked.

Jan


---(end of broadcast)---
TIP 8: explain analyze is your friend


[COMMITTERS] pgsql-server/src/test/regress expected/Tag: ex ...

2003-10-31 Thread Jan Wieck
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 10:27:51

Modified files:
src/test/regress/expected: Tag: REL7_3_STABLE foreign_key.out 
   rules.out 
src/test/regress/sql: Tag: REL7_3_STABLE foreign_key.sql 
  rules.sql 

Log message:
Moved the recently added test for foreign key disabled by rewrite
rule into the rule.sql since it affects the latter if run in paralell.

Jan


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[COMMITTERS] pgsql-server/src/interfaces/libpq fe-exec.c

2003-10-31 Thread Tom Lane
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 13:43:11

Modified files:
src/interfaces/libpq: fe-exec.c 

Log message:
Minor cleanup of PQunescapeBytea().  Avoid unportable assumptions about
behavior of malloc and realloc when request size is 0.  Fix escape
sequence recognizer so that only valid 3-digit octal sequences are
treated as escape sequences ... isdigit() is not a correct test.


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


[COMMITTERS] pgsql-server/src/interfaces/libpq Tag: REL7_3_ ...

2003-10-31 Thread Tom Lane
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 14:14:11

Modified files:
src/interfaces/libpq: Tag: REL7_3_STABLE fe-connect.c 

Log message:
Back-patch removal of unnecessary inclusion of , so that
7.3.5 will build out-of-the-box on Solaris.


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


[COMMITTERS] pgsql-server/doc/src/sgml release.sgml

2003-10-31 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 15:33:17

Modified files:
doc/src/sgml   : release.sgml 

Log message:
MAC OS X => Mac OS X


---(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-server/doc/src/sgml release.sgml

2003-10-31 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 15:24:17

Modified files:
doc/src/sgml   : release.sgml 

Log message:
Release updates suggested by Tom.


---(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-server/doc/src/sgml release.sgml

2003-10-31 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 15:49:40

Modified files:
doc/src/sgml   : release.sgml 

Log message:
Update for polymorphic functions, needs more work.


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[COMMITTERS] pgsql-server/doc/src/sgml release.sgml

2003-10-31 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 15:51:14

Modified files:
doc/src/sgml   : release.sgml 

Log message:
new protocol, faster startup.


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


[COMMITTERS] pgsql-server/ oc/src/sgml/ref/grant.sgml oc/sr ...

2003-10-31 Thread Tom Lane
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 16:00:49

Modified files:
doc/src/sgml/ref: grant.sgml revoke.sgml 
src/backend/catalog: aclchk.c 

Log message:
When a superuser does GRANT or REVOKE on an object he doesn't own,
process the command as though it were issued by the object owner.
This prevents creating weird scenarios in which the same privileges
may appear to flow from different sources, and ensures that a superuser
can in fact revoke all privileges if he wants to.  In particular this
means that the regression tests work when run by a superuser other than
the original bootstrap userid.  Per report from Larry Rosenman.


---(end of broadcast)---
TIP 8: explain analyze is your friend


[COMMITTERS] pgsql-server/src/bin/pg_dump/po es.po

2003-10-31 Thread Peter Eisentraut - PostgreSQL
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 18:14:15

Modified files:
src/bin/pg_dump/po: es.po 

Log message:
Translation update


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


[COMMITTERS] pgsql-server/doc/src/sgml release.sgml

2003-10-31 Thread Tom Lane
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 18:22:10

Modified files:
doc/src/sgml   : release.sgml 

Log message:
Fix broken markup.


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

   http://www.postgresql.org/docs/faqs/FAQ.html


[COMMITTERS] pgsql-server/doc/src/sgml gist.sgml

2003-10-31 Thread Tom Lane
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 18:41:21

Modified files:
doc/src/sgml   : gist.sgml 

Log message:
Rewrite GiST documentation into something actually useful.

Christopher Kings-Lynne


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


[COMMITTERS] pgsql-server/src/backend/storage/buffer README

2003-10-31 Thread Tom Lane
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 18:48:08

Modified files:
src/backend/storage/buffer: README 

Log message:
Update future-tense comments in README to present tense.  Noted by
Neil Conway.


---(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-server/doc/src/sgml arch-dev.sgml array. ...

2003-10-31 Thread Peter Eisentraut - PostgreSQL
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 21:56:29

Modified files:
doc/src/sgml   : arch-dev.sgml array.sgml catalogs.sgml 
 datatype.sgml ddl.sgml func.sgml indexcost.sgml 
 installation.sgml jdbc.sgml libpq.sgml 
 lobj.sgml maintenance.sgml monitoring.sgml 
 nls.sgml page.sgml perform.sgml plpgsql.sgml 
 protocol.sgml queries.sgml query.sgml 
 release.sgml rules.sgml runtime.sgml 
 syntax.sgml typeconv.sgml xfunc.sgml 
 xindex.sgml xoper.sgml xtypes.sgml 
doc/src/sgml/ref: alter_sequence.sgml create_table.sgml 
  create_type.sgml create_view.sgml 
  pg_ctl-ref.sgml psql-ref.sgml select.sgml 

Log message:
Spell checking, consistent terminology.


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

   http://archives.postgresql.org


[COMMITTERS] pgsql-server/src/test/regress/expected create_ ...

2003-10-31 Thread Peter Eisentraut - PostgreSQL
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 23:07:07

Modified files:
src/test/regress/expected: create_view.out geometry.out 
   geometry_1.out stats.out time.out 
   timetz.out 

Log message:
Fix hidden whitespace differences between expected and result files.


---(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-server/src/test/regress/expected stats.out

2003-10-31 Thread Peter Eisentraut - PostgreSQL
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 23:18:20

Modified files:
src/test/regress/expected: stats.out 

Log message:
More whitespace fixes.  Do people write the expected files by hand?


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

   http://archives.postgresql.org