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

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

Modified files:
src/interfaces/ecpg: ChangeLog 
src/interfaces/ecpg/compatlib: informix.c 
src/interfaces/ecpg/include: Makefile datetime.h decimal.h 
 ecpg_informix.h 
src/interfaces/ecpg/pgtypeslib: interval.c 
Added files:
src/interfaces/ecpg/include: compatlib.h 

Log message:
Hide Informix datatypes. They are not seen by our built process anymore.


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


[COMMITTERS] pgsql-server/. configure configure.in

2003-10-03 Thread PostgreSQL Daemon
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/03 00:08:14

Modified files:
.  : configure configure.in 

Log message:
brand her beta4


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[COMMITTERS] pgsql-server/src/interfaces/ecpg include/ecpgl ...

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

Modified files:
src/interfaces/ecpg/include: ecpglib.h 
src/interfaces/ecpg/pgtypeslib: Makefile 

Log message:
Remove assorted compilation failures introduced by latest ecpg changes.
Also remove -g, which has no business in CPPFLAGS in the first place,
let alone being hardwired there by a sub-Makefile.


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[COMMITTERS] pgsql-server/ oc/src/sgml/libpq.sgml rc/interf ...

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

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

Log message:
Cause PQescapeString to stop processing at a null character, rather
than generating an invalid output string.  Per observation and patch
from Igor Shevchenko.  Further code cleanup and documentation by
Tom Lane.


---(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/ oc/src/sgml/runtime.sgml rc/back ...

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

Modified files:
doc/src/sgml   : runtime.sgml 
src/backend/catalog: pg_proc.c 
src/backend/utils/misc: guc.c postgresql.conf.sample 

Log message:
Add GUC parameter check_function_bodies to control whether validation
of function bodies is done at CREATE FUNCTION time.  This is normally
true but can be set false to avoid problems with forward references,
wrong schema search path, etc.  This is just the backend patch, still
need to adjust pg_dump to make use of it.


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

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


[COMMITTERS] pgsql-server/src/bin/pg_dump pg_backup_archive ...

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

Modified files:
src/bin/pg_dump: pg_backup_archiver.c pg_backup_archiver.h 
 pg_backup_db.c 

Log message:
Issue 'SET check_function_bodies = false' to suppress possible restore
failures in SQL functions, due to forward references or unqualified
references to objects in other schemas.  Per recent discussion.


---(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/src/interfaces/libpq nls.mk po/hr.po

2003-10-03 Thread Peter Eisentraut - PostgreSQL
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/03 19:39:34

Modified files:
src/interfaces/libpq: nls.mk 
Added files:
src/interfaces/libpq/po: hr.po 

Log message:
New translation


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


Re: [COMMITTERS] pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...

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

>   Add GUC parameter check_function_bodies to control whether validation
>   of function bodies is done at CREATE FUNCTION time.  This is normally
>   true but can be set false to avoid problems with forward references,
>   wrong schema search path, etc.  This is just the backend patch, still
>   need to adjust pg_dump to make use of it.

If it's only honored by SQL functions, then it should probably be called
check_sql_function_bodies.

-- 
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/ oc/src/sgml/ref/psql-ref.sgml rc ...

2003-10-03 Thread Peter Eisentraut - PostgreSQL
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/03 22:04:46

Modified files:
doc/src/sgml/ref: psql-ref.sgml 
src/bin/psql   : prompt.c 

Log message:
Change transaction status indicator in prompt from %T to %x.


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

   http://archives.postgresql.org


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

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

Modified files:
src/bin/pg_dump/po: de.po 
src/bin/psql/po: de.po 
src/interfaces/libpq/po: de.po 

Log message:
Translation updates


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

   http://archives.postgresql.org


[COMMITTERS] pgsql-server/src/interfaces/ecpg/preproc ecpg.c

2003-10-03 Thread Peter Eisentraut - PostgreSQL
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/03 22:06:38

Modified files:
src/interfaces/ecpg/preproc: ecpg.c 

Log message:
Format help message internally consistent.


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

   http://archives.postgresql.org


[COMMITTERS] pgsql-server/doc FAQ src/FAQ/FAQ.html

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

Modified files:
doc: FAQ 
doc/src/FAQ: FAQ.html 

Log message:
Update MySQL mention.


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


[COMMITTERS] pgsql-server/doc FAQ src/FAQ/FAQ.html

2003-10-03 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/03 23:37:05

Modified files:
doc: FAQ 
doc/src/FAQ: FAQ.html 

Log message:
Update MySQL mention.


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

   http://archives.postgresql.org


[COMMITTERS] pgsql-server/src/backend/tcop postgres.c

2003-10-03 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/03 23:47:04

Modified files:
src/backend/tcop: postgres.c 

Log message:
Fix log_duration and log_min_duration_statement to print properly, as
pointed out by Peter.


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[COMMITTERS] pgsql-server/ /INSTALL oc/src/sgml/installatio ...

2003-10-03 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/04 00:14:13

Modified files:
.  : INSTALL 
doc/src/sgml   : installation.sgml 

Log message:
Update INSTALL file for 7.4.


---(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


Re: [COMMITTERS] pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...

2003-10-03 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> Add GUC parameter check_function_bodies to control whether validation
>> of function bodies is done at CREATE FUNCTION time.

> If it's only honored by SQL functions, then it should probably be called
> check_sql_function_bodies.

I thought about that while I was making the patch, but decided that it
would be a very un-forward-looking name.  Someday we will probably have
syntax-checking validators for plpgsql, etc.

The original version of the patch actually suppressed calling the
validator altogether, but I soon realized that wouldn't do --- it
would allow you to create SQL functions with unsupported pseudotype
arguments or results, for example.  Further thought led me to decide
explicitly not to suspend checking of internal and C function
references, on the grounds that if they are broken they'd still be
broken at the completion of the restore script, and so we'd only
be losing the ability to report the problem.

So the fact that it only affects SQL functions at the moment is IMHO
just happenstance; the scope of what it does will change as we add more
validation capability.

regards, tom lane

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