[COMMITTERS] pgsql-server/src backend/access/heap/heapam.c ...

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

Modified files:
src/backend/access/heap: heapam.c 
src/backend/commands: async.c 
src/backend/executor: execMain.c execUtils.c nodeSubplan.c 
  nodeSubqueryscan.c spi.c 
src/backend/storage/ipc: sinval.c 
src/backend/utils/adt: ri_triggers.c 
src/backend/utils/time: tqual.c 
src/include/access: heapam.h 
src/include/executor: executor.h spi.h 
src/include/nodes: execnodes.h 
src/include/utils: tqual.h 

Log message:
Repair RI trigger visibility problems (this time for sure ;-)) per recent
discussion on pgsql-hackers: in READ COMMITTED mode we just have to force
a QuerySnapshot update in the trigger, but in SERIALIZABLE mode we have
to run the scan under a current snapshot and then complain if any rows
would be updated/deleted that are not visible in the transaction snapshot.


---(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/pl/plpgsql/src pl_exec.c

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

Modified files:
src/pl/plpgsql/src: pl_exec.c 

Log message:
Add code to check that IF/WHILE/EXIT test expressions are boolean,
and try to coerce the values to boolean if not.  Per recent discussions.


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


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

2003-10-01 Thread Jan Wieck
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/09/29 16:24:06

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

Log message:
Fixed type lookup in spi_prepare for possible qualified
type name specification.

Jan


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


[COMMITTERS] pgsql-server/contrib/tablefunc tablefunc.c exp ...

2003-10-01 Thread Tom Lane
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/02 00:51:40

Modified files:
contrib/tablefunc: tablefunc.c 
contrib/tablefunc/expected: tablefunc.out 

Log message:
Attached is a patch for contrib/tablefunc. It fixes two issues raised by
Lars Boegild Thomsen (full email below) and also corrects the regression
expected output for a recent backend message adjustment. Please apply.

Joe Conway


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

   http://archives.postgresql.org


[COMMITTERS] pgsql-server/src backend/parser/analyze.c test ...

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

Modified files:
src/backend/parser: analyze.c 
src/test/regress/expected: alter_table.out cluster.out 
   foreign_key.out truncate.out 

Log message:
Remove NOTICE about foreign key creating implicit triggers, because it no
longer conveys useful information.


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


[COMMITTERS] pgsql-server/src/backend commands/functioncmds ...

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

Modified files:
src/backend/commands: functioncmds.c indexcmds.c proclang.c 
  trigger.c typecmds.c 
src/backend/parser: gram.y 
src/backend/tcop: postgres.c utility.c 

Log message:
Change some notices to warnings and vice versa according to criteria
developed on -hackers.


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


[COMMITTERS] pgsql-server/src/backend/commands tablecmds.c ...

2003-10-01 Thread Peter Eisentraut - PostgreSQL
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/02 03:36:37

Modified files:
src/backend/commands: tablecmds.c user.c 

Log message:
String fixes/improvements found by Alvaro Herrera


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

   http://archives.postgresql.org


[COMMITTERS] pgsql-server/src/bin/psql help.c

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

Modified files:
src/bin/psql   : help.c 

Log message:
Add documentation about \pset footer to \?.

from Patrick Welche


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