[COMMITTERS] python - be: Override linecache.updatecache to allow access to

2005-04-18 Thread James William Pye
Log Message: --- Override linecache.updatecache to allow access to procedures. This gives traceback.print_tb the ability to read pg_proc->prosrc by looking up the proc entry if the filename is a single, base-10 number that strtol can take. If an invalid Oid, fallback on the old function th

[COMMITTERS] pgsql: >>>>Luckily, PG 8 is available for this.

2005-04-18 Thread Bruce Momjian
Log Message: --- Luckily, PG 8 is available for this. Do you have a short example? >>> >>>No, and I think it should be in the manual as an example. >>> >>>You will need to enter a loop that uses exception handling to detect >>>unique_violation. >> >>Pursuant to an IRC discussion to whi

[COMMITTERS] pgsql: The following patch should allow UPDATE_INTERVAL to be specified

2005-04-18 Thread Bruce Momjian
Log Message: --- The following patch should allow UPDATE_INTERVAL to be specified on the command line. We find this useful because we frequently deal with thousands of tables in an environment where neither the databases nor the tables are updated frequently. This helps allow us to cut down

[COMMITTERS] pgsql: > >Luckily, PG 8 is available for this.

2005-04-18 Thread Bruce Momjian
Log Message: --- > >Luckily, PG 8 is available for this. Do you have a short example? > > No, and I think it should be in the manual as an example. > > You will need to enter a loop that uses exception handling to detect > unique_violation. Pursuant to an IRC discussion to which Dennis Bj

[COMMITTERS] pgsql: Attached patch gets rid of the global timezone in the following

2005-04-18 Thread Bruce Momjian
Log Message: --- Attached patch gets rid of the global timezone in the following steps: * Changes the APIs to the timezone functions to take a pg_tz pointer as an argument, representing the timezone to use for the selected operation. * Adds a global_timezone variable that represents the c

[COMMITTERS] pgsql: Update PITR wording, per Simon.

2005-04-18 Thread Bruce Momjian
Log Message: --- Update PITR wording, per Simon. Modified Files: -- pgsql/doc/src/sgml: backup.sgml (r2.64 -> r2.65) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/backup.sgml.diff?r1=2.64&r2=2.65) ---(end of broadca

[COMMITTERS] pgsql: Update PITR wording, per Simon.

2005-04-18 Thread Bruce Momjian
Log Message: --- Update PITR wording, per Simon. Tags: REL8_0_STABLE Modified Files: -- pgsql/doc/src/sgml: backup.sgml (r2.54.4.4 -> r2.54.4.5) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/backup.sgml.diff?r1=2.54.4.4&r2=2.54.4.5)

[COMMITTERS] autodoc - autodoc: Fix GraphViz foreign key links (they were missing).

2005-04-18 Thread User Rbt
Log Message: --- Fix GraphViz foreign key links (they were missing). Modified Files: -- autodoc: postgresql_autodoc.pl (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/autodoc/autodoc/postgresql_autodoc.pl.diff?r1=1.9&r2=1.10) -

[COMMITTERS] autodoc - autodoc: The latest version of dia crashes when I open a dia

2005-04-18 Thread User Rbt
Log Message: --- The latest version of dia crashes when I open a dia file produced with the zigzag.dia.tmpl template. I replaced the following lines in zigzag.dia.tmpl with and dia no longer crashes. best whishes, Piebe de Vries Modified Files: -- autodoc:

[COMMITTERS] pgsql: pg_dumpall should enforce the server version check for itself,

2005-04-18 Thread Tom Lane
Log Message: --- pg_dumpall should enforce the server version check for itself, rather than simply passing it down to pg_dump. Else, version-related failures in pg_dumpall itself generate unhelpful error messages. Modified Files: -- pgsql/src/bin/pg_dump: pg_dumpal

[COMMITTERS] pgsql: pg_dumpall should enforce the server version check for itself,

2005-04-18 Thread Tom Lane
Log Message: --- pg_dumpall should enforce the server version check for itself, rather than simply passing it down to pg_dump. Else, version-related failures in pg_dumpall itself generate unhelpful error messages. Tags: REL8_0_STABLE Modified Files: -- pgsql/src/bin/

[COMMITTERS] pgsql: Add WAL entry about compression.

2005-04-18 Thread Bruce Momjian
Log Message: --- Add WAL entry about compression. Modified Files: -- pgsql/doc/TODO.detail: wal (r1.2 -> r1.3) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/wal.diff?r1=1.2&r2=1.3) pgsql/doc/src/FAQ: TODO.html (r1.3 -> r1.4)

[COMMITTERS] pgsql: Added to TODO: > * Compress WAL entries [wal]

2005-04-18 Thread Bruce Momjian
Log Message: --- Added to TODO: > * Compress WAL entries [wal] Modified Files: -- pgsql/doc: TODO (r1.1496 -> r1.1497) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1496&r2=1.1497) ---(end of broadcast)--

[COMMITTERS] pgsql: When positioned before the start of a ResultSet issuing

2005-04-18 Thread Kris Jurka
Log Message: --- When positioned before the start of a ResultSet issuing relative(0) results in an exception being thrown when it really should be a no-op. Tags: REL7_4_STABLE Modified Files: -- pgsql/src/interfaces/jdbc/org/postgresql/jdbc2: AbstractJdbc2Resu

[COMMITTERS] pgsql: Update PITR setence to mention WAL and file system dump.

2005-04-18 Thread Bruce Momjian
Log Message: --- Update PITR setence to mention WAL and file system dump. Modified Files: -- pgsql/doc/src/FAQ: TODO.html (r1.2 -> r1.3) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.2&r2=1.3) pgsql/doc/src/sgml:

[COMMITTERS] pgsql: record_in and record_recv must be careful to return a separately

2005-04-18 Thread Tom Lane
Log Message: --- record_in and record_recv must be careful to return a separately pfree'able result, since some callers expect to be able to pfree the result of a pass-by-reference function. Per report from Chris Trawick. Modified Files: -- pgsql/src/backend/utils/adt:

[COMMITTERS] pgsql: record_in and record_recv must be careful to return a separately

2005-04-18 Thread Tom Lane
Log Message: --- record_in and record_recv must be careful to return a separately pfree'able result, since some callers expect to be able to pfree the result of a pass-by-reference function. Per report from Chris Trawick. Tags: REL8_0_STABLE Modified Files: -- pgsql/

[COMMITTERS] pgsql: Update PITR TODO items: < failure.

2005-04-18 Thread Bruce Momjian
Log Message: --- Update PITR TODO items: < failure. > failure. This could be triggered by a user command or a timer. < * Force archiving of partially-full WAL files when pg_stop_backup() is < called or the server is stopped > * Automatically force archiving of partially-filled WAL f

[COMMITTERS] pgsql: Update TODO script sample.

2005-04-18 Thread Bruce Momjian
Log Message: --- Update TODO script sample. Modified Files: -- pgsql/doc/src/FAQ: README (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/README.diff?r1=1.1&r2=1.2) TODO.html (r1.1 -> r1.2) (http://developer.post

[COMMITTERS] pgsql: Update for HTML markup.

2005-04-18 Thread Bruce Momjian
Log Message: --- Update for HTML markup. Modified Files: -- pgsql/doc: TODO (r1.1494 -> r1.1495) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1494&r2=1.1495) ---(end of broadcast)--- T

[COMMITTERS] pgsql: Add description that WAL files used during backup have to be

2005-04-18 Thread Bruce Momjian
Log Message: --- Add description that WAL files used during backup have to be archived before you are done. Modified Files: -- pgsql/doc/src/sgml: backup.sgml (r2.62 -> r2.63) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/backup.sgml.diff?r

[COMMITTERS] pgsql: Add HTML version of TODO to CVS, for web site use.

2005-04-18 Thread Bruce Momjian
Log Message: --- Add HTML version of TODO to CVS, for web site use. Added Files: --- pgsql/doc/src/FAQ: README (r1.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/README?rev=1.1&content-type=text/x-cvsweb-markup) TODO.html (r1.1)

[COMMITTERS] pgsql: Add HTML TODO version to CVS.

2005-04-18 Thread Bruce Momjian
Log Message: --- Add HTML TODO version to CVS. Modified Files: -- pgsql/doc: TODO (r1.1493 -> r1.1494) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1493&r2=1.1494) ---(end of broadcast)---

[COMMITTERS] pgsql: Add description about partial WAL archiving for PITR: > >

2005-04-18 Thread Bruce Momjian
Log Message: --- Add description about partial WAL archiving for PITR: > > Doing this will allow administrators to know more easily when the > archive contins all the files needed for point-in-time recovery. Modified Files: -- pgsql/doc: TODO (r1.1492 -> r1.14

[COMMITTERS] How to get trigger oid by trigger name

2005-04-18 Thread rafaqat ali
Hello All Can any one tell me how can I get triggerOid from triggerName in c code. I first tried to use SearchSysCache Function but it does not search o the basis of triggername. ---(end of broadcast)--- TIP 9: the planner will ignore your de