[COMMITTERS] newsysviews - newsysview: s/TEXT/NAME/ where appropriate; add schema

2005-04-05 Thread User Decibel
Log Message:
---
s/TEXT/NAME/ where appropriate; add schema columns where needed (though I 
probably missed some)

Modified Files:
--
newsysview/doc:
definition.txt (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/doc/definition.txt.diff?r1=1.5&r2=1.6)

---(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] newsysviews - newsysview: add index views.

2005-04-05 Thread User Andrewsn
Log Message:
---
add index views. add 7.4 compat. fix some stuff.

Modified Files:
--
newsysview/sql:
_typefuncs.sql (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_typefuncs.sql.diff?r1=1.1&r2=1.2)
table_columns.sql (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/table_columns.sql.diff?r1=1.1&r2=1.2)
tables.sql (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/tables.sql.diff?r1=1.2&r2=1.3)

Added Files:
---
newsysview/sql:
_compat74.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_compat74.sql?rev=1.1&content-type=text/x-cvsweb-markup)
_compat80.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_compat80.sql?rev=1.1&content-type=text/x-cvsweb-markup)
_schema.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_schema.sql?rev=1.1&content-type=text/x-cvsweb-markup)
index_columns.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/index_columns.sql?rev=1.1&content-type=text/x-cvsweb-markup)
indexes.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/indexes.sql?rev=1.1&content-type=text/x-cvsweb-markup)

---(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: Adjust grammar for plpgsql's OPEN command so that a cursor can be

2005-04-05 Thread Tom Lane
Log Message:
---
Adjust grammar for plpgsql's OPEN command so that a cursor can be
OPENed on non-SELECT commands such as EXPLAIN or SHOW (anything that
returns tuples is allowed).  This flexibility already existed for
bound cursors, but OPEN was artificially restricting what it would
take.  Per a gripe some months back.

Modified Files:
--
pgsql/doc/src/sgml:
plpgsql.sgml (r1.63 -> r1.64)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plpgsql.sgml.diff?r1=1.63&r2=1.64)
pgsql/src/pl/plpgsql/src:
gram.y (r1.67 -> r1.68)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/gram.y.diff?r1=1.67&r2=1.68)

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


[COMMITTERS] newsysviews - newsysview: pg_database.template should be a boolean

2005-04-05 Thread User Decibel
Log Message:
---
pg_database.template should be a boolean

Modified Files:
--
newsysview/doc:
definition.txt (r1.6 -> r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/doc/definition.txt.diff?r1=1.6&r2=1.7)

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


[COMMITTERS] pgsql: This file was whacked by pgindent before it knew it shouldn't

2005-04-05 Thread Neil Conway
Log Message:
---
This file was whacked by pgindent before it knew it shouldn't remove
braces around single statements (for PG_TRY macros).  This patch fixes
it. Alvaro Herrera.

Modified Files:
--
pgsql/src/backend/utils/resowner:
resowner.c (r1.11 -> r1.12)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/resowner/resowner.c.diff?r1=1.11&r2=1.12)

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


[COMMITTERS] newsysviews - newsysview: Add build script

2005-04-05 Thread User Decibel
Log Message:
---
Add build script

Added Files:
---
newsysview/sql:
.cvsignore (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/.cvsignore?rev=1.1&content-type=text/x-cvsweb-markup)
build.sh (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/build.sh?rev=1.1&content-type=text/x-cvsweb-markup)

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


[COMMITTERS] pgsql: Include information about a domain's CHECK constraint, if any, in

2005-04-05 Thread Neil Conway
Log Message:
---
Include information about a domain's CHECK constraint, if any, in the
output of \dD in psql. From Greg Sabino Mullane.

Modified Files:
--
pgsql/src/bin/psql:
describe.c (r1.114 -> r1.115)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/describe.c.diff?r1=1.114&r2=1.115)

---(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] newsysviews - newsysview: Make type definitions as old, add TODO to

2005-04-05 Thread User Decibel
Log Message:
---
Make type definitions as old, add TODO to types.sql

Modified Files:
--
newsysview/doc:
definition.txt (r1.7 -> r1.8)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/doc/definition.txt.diff?r1=1.7&r2=1.8)
newsysview/sql:
types.sql (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/types.sql.diff?r1=1.1&r2=1.2)

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