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

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

Modified files:
src/interfaces/ecpg: ChangeLog 
src/interfaces/ecpg/compatlib: informix.c 

Log message:
Applied patch by Dave Cramer to fix several bugs in compatlib.


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


Re: [COMMITTERS] pgsql-server/src/backend/storage/freespace fre ...

2003-10-30 Thread Tatsuo Ishii
> CVSROOT:  /cvsroot
> Module name:  pgsql-server
> Changes by:   [EMAIL PROTECTED]   03/10/29 13:36:57
> 
> Modified files:
>   src/backend/storage/freespace: freespace.c 
> 
> Log message:
>   compact_fsm_storage() does need to handle the case where a relation's
>   FSM data has to be both moved down and compressed.  Per report from
>   Dror Matalon.

Do we need to make a back patch for this? I know that
compact_fsm_storage() does not exist in 7.3-stable but I do not know
if similar logic exists there.
--
Tatsuo Ishii

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


Re: [COMMITTERS] pgsql-server/src/backend/storage/freespace fre ...

2003-10-30 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
>> compact_fsm_storage() does need to handle the case where a relation's
>> FSM data has to be both moved down and compressed.  Per report from
>> Dror Matalon.

> Do we need to make a back patch for this?

No.  That code is all new in 7.4.

regards, tom lane

---(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/pl/plpgsql/src gram.y

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

Modified files:
src/pl/plpgsql/src: gram.y 

Log message:
Allow the query for a plpgsql cursor to begin with '(' as well as 'SELECT'.
Per example from Kumar, 30-Oct-03.


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


Re: [COMMITTERS] pgsql-server/src/port Makefile

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

> This patch broke the Darwin port, and invalidated whatever port reports
> we now have for platforms where AROPT isn't "crs" (which includes all
> the BSDen as well as a couple other platforms --- can any BSDers report
> whether CVS tip still builds for them?).  I suggest more prudence
> about making portability-related fixes when we are hard upon a release.
> Was there any reported bug that this actually fixed?

The OpenBSD port was broken, because the ar program did not support the
flags that used to be there.  Elsewhere, we use AROPT to build a static
library as well.

-- 
Peter Eisentraut   [EMAIL PROTECTED]


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


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

2003-10-30 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/30 15:43:01

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

Log message:
Mark release note comments as new subsections rather than footnotes, per
Peter.

Remove "Changes" section and pull all sections below it up one level.

More comment additions.


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


[COMMITTERS] pgsql-server/src/pl/tcl Tag: REL7_3_STABLE pltcl.c

2003-10-30 Thread Jan Wieck
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/29 22:00:44

Modified files:
src/pl/tcl : Tag: REL7_3_STABLE pltcl.c 

Log message:
Support for qualified type names in PL/Tcl's spi_prepare command.

This is not 100% backward compatible as formerly a double quoted
type name containing a dot could be used. But I don't think may people
use dot's in the name of user defined types.

Jan


---(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 release.sgml

2003-10-30 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/30 16:25:36

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

Log message:
Update SGML release notes with Peter's direction. Does not compile
because of section adjustments still needed.


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

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


[COMMITTERS] pgsql-server/src/interfaces/jdbc/org/postgresq ...

2003-10-30 Thread Dave Cramer
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/28 22:39:10

Modified files:
src/interfaces/jdbc/org/postgresql/core: BaseConnection.java 
 BaseStatement.java 
src/interfaces/jdbc/org/postgresql/jdbc1: 
  AbstractJdbc1Connection.java 
  AbstractJdbc1ResultSet.java 
  AbstractJdbc1Statement.java 
src/interfaces/jdbc/org/postgresql/jdbc2: 
  AbstractJdbc2ResultSet.java 
src/interfaces/jdbc/org/postgresql/test/jdbc2: 
   CursorFetchTest.java 

Log message:
Patches from Oliver Jowett to fix CursorFetchTest, 7.4 now does not 
automatically delete cursors


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


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

2003-10-30 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/30 16:29:35

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

Log message:
SGML cleanup.


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


[COMMITTERS] pgsql-server/src/interfaces/jdbc/org/postgresq ...

2003-10-30 Thread Dave Cramer
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/30 08:18:56

Modified files:
src/interfaces/jdbc/org/postgresql/test/jdbc2: 
   CursorFetchTest.java 

Log message:
use the result set to set the fetchsize


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

   http://archives.postgresql.org


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

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

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

Log message:
More SGML cleanup.


---(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/ /HISTORY oc/src/sgml/release.sgml

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

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

Log message:
Fix markup by using  for comments.


---(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/bin/psql tab-complete.c

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

Modified files:
src/bin/psql   : tab-complete.c 

Log message:
Further work on tab completion code: arrange for system catalogs to be
offered for completion only when the input-so-far is at least 'pg_'.
This seems to be the best compromise behavior emerging from yesterday's
discussion.  While at it, refactor code to eliminate repetitive use of
nearly identical queries, which was exceedingly tedious to maintain.
Also const-ify code more thoroughly in hopes of moving constant data into
text segment, and remove unnecessary length limit on queries.


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


[COMMITTERS] pgsql-server/ oc/src/sgml/libpgtcl.sgml rc/int ...

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

Modified files:
doc/src/sgml   : libpgtcl.sgml 
src/interfaces/libpgtcl: pgtclCmds.c 

Log message:
Use Tcl ByteArray objects to avoid unwanted character set translation
in libpgtcl's lo_read/lo_write commands.  Also, deal correctly with
failure return from lo_read().  ljb and Tom Lane.


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


[COMMITTERS] pgsql-server/src/tutorial syscat.source

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

Modified files:
src/tutorial   : syscat.source 

Log message:
Small fix to Christopher's recent improvements --- underscore is not
a special character in regexes, but it is for LIKE, so NOT LIKE 'pg_%'
is incorrect.  Need NOT LIKE 'pg\_%'.


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

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


Re: [COMMITTERS] pgsql-server/src/tutorial syscat.source

2003-10-30 Thread Christopher Kings-Lynne
Doh!  I forgot all about that.

Chris

Tom Lane wrote:

CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/30 23:58:16
Modified files:
	src/tutorial   : syscat.source 

Log message:
Small fix to Christopher's recent improvements --- underscore is not
a special character in regexes, but it is for LIKE, so NOT LIKE 'pg_%'
is incorrect.  Need NOT LIKE 'pg\_%'.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
   http://www.postgresql.org/docs/faqs/FAQ.html


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


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

2003-10-30 Thread Tom Lane
[EMAIL PROTECTED] (Peter Eisentraut - PostgreSQL) writes:
> Log message:
>   Fix CFLAGS selection to actually work.  Add test to detect whether gcc's
>   option -fno-strict-aliasing is available.

A couple comments on this patch ...

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.

I think you changed the behavior for the AIX port.  Diffing
src/template/aix against the old contents:

diff -c -r1.11 -r1.14
*** pgsql-server/src/template/aix   2002/09/04 22:54:18 1.11
--- pgsql-server/src/template/aix   2003/10/25 15:32:11 1.14
***
*** 1,9 
! if test "$GCC" = yes ; then
!   CFLAGS='-O2 -pipe'
! else # not GCC
!   CFLAGS='-O2 -qmaxmem=16384 -qsrcmsg -qlonglong'
case $host_os in
! aix3.2.5 | aix4.1*)
!   CFLAGS='-qmaxmem=16384 -qsrcmsg' ;;
esac
! fi # not GCC
--- 1,7 
! if test "$GCC" != yes ; then
case $host_os in
! aix3.2.5 | aix4.1*) ;;
! *) CFLAGS="-O2 -qlonglong";;
esac
!   CFLAGS="-O -qmaxmem=16384 -qsrcmsg"
! fi

The "case" is now useless because CFLAGS will always end up with the
later setting.  Don't we want something like

if test "$GCC" != yes ; then
  case $host_os in
aix3.2.5 | aix4.1*)  CFLAGS='-qmaxmem=16384 -qsrcmsg' ;;
*)  CFLAGS='-O2 -qmaxmem=16384 -qsrcmsg -qlonglong' ;;
  esac
fi

regards, tom lane

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

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

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

Log message:
Update with more comments.


---(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/. HISTORY

2003-10-30 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 00:32:36

Modified files:
.  : HISTORY 

Log message:
Update HISTORY.


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

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


[COMMITTERS] pgsql-server/ /HISTORY oc/src/sgml/release.sgml

2003-10-30 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/31 00:44:26

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

Log message:
Remove  take, use another paragraph for description.


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