[COMMITTERS] python - be: Fix array creation.

2005-05-03 Thread James William Pye
Log Message:
---
Fix array creation.
The result is of the array type, not the typelem type.
Revealed a bug where the Array creation routine did not properly trap error, fix
coming soon.

Modified Files:
--
be/src:
type.c (r1.7 -> r1.8)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/type.c.diff?r1=1.7&r2=1.8)

---(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: Change tsearch2 to not use the unsafe practice of creating

2005-05-03 Thread Tom Lane
Log Message:
---
Change tsearch2 to not use the unsafe practice of creating functions
that return INTERNAL without also having INTERNAL arguments.  Since the
functions in question aren't meant to be called by hand anyway, I just
redeclared them to take 'internal' instead of 'text'.  Also add code
to ProcedureCreate() to enforce the restriction, as I should have done
to start with :-(

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/contrib/tsearch2/gendict:
sql.IN (r1.1 -> r1.1.8.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/gendict/sql.IN.diff?r1=1.1&r2=1.1.8.1)
pgsql/contrib/tsearch2:
tsearch.sql.in (r1.10 -> r1.10.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/tsearch.sql.in.diff?r1=1.10&r2=1.10.4.1)
untsearch.sql.in (r1.5 -> r1.5.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/untsearch.sql.in.diff?r1=1.5&r2=1.5.4.1)
pgsql/src/backend/catalog:
pg_proc.c (r1.122 -> r1.122.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_proc.c.diff?r1=1.122&r2=1.122.4.1)

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


[COMMITTERS] pgsql: Change tsearch2 to not use the unsafe practice of creating

2005-05-03 Thread Tom Lane
Log Message:
---
Change tsearch2 to not use the unsafe practice of creating functions
that return INTERNAL without also having INTERNAL arguments.  Since the
functions in question aren't meant to be called by hand anyway, I just
redeclared them to take 'internal' instead of 'text'.  Also add code
to ProcedureCreate() to enforce the restriction, as I should have done
to start with :-(

Tags:

REL7_4_STABLE

Modified Files:
--
pgsql/contrib/tsearch2/gendict:
sql.IN (r1.1 -> r1.1.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/gendict/sql.IN.diff?r1=1.1&r2=1.1.4.1)
pgsql/contrib/tsearch2:
tsearch.sql.in (r1.1.2.1 -> r1.1.2.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/tsearch.sql.in.diff?r1=1.1.2.1&r2=1.1.2.2)
untsearch.sql.in (r1.2 -> r1.2.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/untsearch.sql.in.diff?r1=1.2&r2=1.2.4.1)
pgsql/src/backend/catalog:
pg_proc.c (r1.109 -> r1.109.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_proc.c.diff?r1=1.109&r2=1.109.2.1)

---(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: Change tsearch2 to not use the unsafe practice of creating

2005-05-03 Thread Tom Lane
Log Message:
---
Change tsearch2 to not use the unsafe practice of creating functions
that return INTERNAL without also having INTERNAL arguments.  Since the
functions in question aren't meant to be called by hand anyway, I just
redeclared them to take 'internal' instead of 'text'.  Also add code
to ProcedureCreate() to enforce the restriction, as I should have done
to start with :-(

Modified Files:
--
pgsql/contrib/tsearch2/gendict:
sql.IN (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/gendict/sql.IN.diff?r1=1.1&r2=1.2)
pgsql/contrib/tsearch2:
tsearch.sql.in (r1.10 -> r1.11)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/tsearch.sql.in.diff?r1=1.10&r2=1.11)
untsearch.sql.in (r1.5 -> r1.6)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/untsearch.sql.in.diff?r1=1.5&r2=1.6)
pgsql/src/backend/catalog:
pg_proc.c (r1.128 -> r1.129)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_proc.c.diff?r1=1.128&r2=1.129)

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


[COMMITTERS] pgsql: Alter the signature for encoding conversion functions to declare

2005-05-03 Thread Tom Lane
Log Message:
---
Alter the signature for encoding conversion functions to declare the
output area as INTERNAL not CSTRING.  This is to prevent people from
calling the functions by hand.  This is a permanent solution for the
back branches but I hope it is just a stopgap for HEAD.

Modified Files:
--
pgsql/doc/src/sgml/ref:
create_conversion.sgml (r1.15 -> r1.16)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_conversion.sgml.diff?r1=1.15&r2=1.16)
pgsql/src/backend/commands:
conversioncmds.c (r1.17 -> r1.18)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/conversioncmds.c.diff?r1=1.17&r2=1.18)
pgsql/src/backend/utils/mb/conversion_procs:
Makefile (r1.13 -> r1.14)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/mb/conversion_procs/Makefile.diff?r1=1.13&r2=1.14)

---(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: Alter the signature for encoding conversion functions to declare

2005-05-03 Thread Tom Lane
Log Message:
---
Alter the signature for encoding conversion functions to declare the
output area as INTERNAL not CSTRING.  This is to prevent people from
calling the functions by hand.  This is a permanent solution for the
back branches but I hope it is just a stopgap for HEAD.

Tags:

REL7_4_STABLE

Modified Files:
--
pgsql/doc/src/sgml/ref:
create_conversion.sgml (r1.13 -> r1.13.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_conversion.sgml.diff?r1=1.13&r2=1.13.2.1)
pgsql/src/backend/commands:
conversioncmds.c (r1.11 -> r1.11.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/conversioncmds.c.diff?r1=1.11&r2=1.11.4.1)
pgsql/src/backend/utils/mb/conversion_procs:
Makefile (r1.9.2.1 -> r1.9.2.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/mb/conversion_procs/Makefile.diff?r1=1.9.2.1&r2=1.9.2.2)

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

   http://www.postgresql.org/docs/faq


[COMMITTERS] pgsql: Alter the signature for encoding conversion functions to declare

2005-05-03 Thread Tom Lane
Log Message:
---
Alter the signature for encoding conversion functions to declare the
output area as INTERNAL not CSTRING.  This is to prevent people from
calling the functions by hand.  This is a permanent solution for the
back branches but I hope it is just a stopgap for HEAD.

Tags:

REL7_3_STABLE

Modified Files:
--
pgsql/doc/src/sgml/ref:
create_conversion.sgml (r1.5 -> r1.5.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_conversion.sgml.diff?r1=1.5&r2=1.5.2.1)
pgsql/src/backend/commands:
conversioncmds.c (r1.5 -> r1.5.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/conversioncmds.c.diff?r1=1.5&r2=1.5.2.1)
pgsql/src/backend/utils/mb/conversion_procs:
Makefile (r1.7.2.1 -> r1.7.2.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/mb/conversion_procs/Makefile.diff?r1=1.7.2.1&r2=1.7.2.2)

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


[COMMITTERS] pgsql: Alter the signature for encoding conversion functions to declare

2005-05-03 Thread Tom Lane
Log Message:
---
Alter the signature for encoding conversion functions to declare the
output area as INTERNAL not CSTRING.  This is to prevent people from
calling the functions by hand.  This is a permanent solution for the
back branches but I hope it is just a stopgap for HEAD.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/doc/src/sgml/ref:
create_conversion.sgml (r1.14 -> r1.14.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_conversion.sgml.diff?r1=1.14&r2=1.14.4.1)
pgsql/src/backend/commands:
conversioncmds.c (r1.16 -> r1.16.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/conversioncmds.c.diff?r1=1.16&r2=1.16.4.1)
pgsql/src/backend/utils/mb/conversion_procs:
Makefile (r1.11 -> r1.11.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/mb/conversion_procs/Makefile.diff?r1=1.11&r2=1.11.4.1)

---(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: Clean up MultiXactIdExpand's API by separating out the case where

2005-05-03 Thread Tom Lane
Log Message:
---
Clean up MultiXactIdExpand's API by separating out the case where we
are creating a new MultiXactId from two regular XIDs.  The original
coding was unnecessarily complicated and didn't save any code anyway.

Modified Files:
--
pgsql/src/backend/access/heap:
heapam.c (r1.189 -> r1.190)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/heapam.c.diff?r1=1.189&r2=1.190)
pgsql/src/backend/access/transam:
multixact.c (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/multixact.c.diff?r1=1.1&r2=1.2)
pgsql/src/include/access:
multixact.h (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/multixact.h.diff?r1=1.1&r2=1.2)

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


[COMMITTERS] pqa - pqa: tweak

2005-05-03 Thread User Tom
Log Message:
---
tweak

Modified Files:
--
pqa/www:
index.html (r1.30 -> r1.31)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/www/index.html.diff?r1=1.30&r2=1.31)

---(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] python - be: Split off Array_FromPySequence to take an elmtoid instead

2005-05-03 Thread James William Pye
Log Message:
---
Split off Array_FromPySequence to take an elmtoid instead of the type tuple.

A small management improvement, but, of course, fails to address the more
serious issue of consistent instantiation methods.

Calling a type object will do something different than the Datum_From routines.

Modified Files:
--
be/include/pypg:
conv.h (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/include/pypg/conv.h.diff?r1=1.2&r2=1.3)
be/src:
conv.c (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/conv.c.diff?r1=1.5&r2=1.6)

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


[COMMITTERS] python - be: Add ugly CPP to allow _compilation_ against 8.1devel.

2005-05-03 Thread James William Pye
Log Message:
---
Add ugly CPP to allow _compilation_ against 8.1devel. This fails to address the
issue of the Array friendly oidvectors; as namespace.c/ns_function depends on
the old style, so just #if it out for now.

pg_config.h is actually included by c.h in both 8.0 and 8.1, but the issue of a
redef only showed when compiled against 8.1.
New heap_tuplemodify takes a TupleDesc now.
Changes in TupleTableSlot and DestReceiver causes a number of changes in Portal.

Use new static system RelationId's instead of RelationSysNameGetRelation.
A better way to handle this difference might be to setup some argument-less
macros which map to the appropriate call for each version; should look a lot
better than those #if's sprinkled about.

(No official support for 8.1 ;)

Modified Files:
--
be/include/pypg:
postgres.h (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/include/pypg/postgres.h.diff?r1=1.4&r2=1.5)
be/src:
call.c (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/call.c.diff?r1=1.4&r2=1.5)
constants.c (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/constants.c.diff?r1=1.5&r2=1.6)
error.c (r1.6 -> r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/error.c.diff?r1=1.6&r2=1.7)
function.c (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/function.c.diff?r1=1.4&r2=1.5)
module.c (r1.12 -> r1.13)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/module.c.diff?r1=1.12&r2=1.13)
namespace.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/namespace.c.diff?r1=1.3&r2=1.4)
pl.c (r1.11 -> r1.12)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/pl.c.diff?r1=1.11&r2=1.12)
query.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/query.c.diff?r1=1.3&r2=1.4)
relation.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/relation.c.diff?r1=1.3&r2=1.4)
savepoint.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/savepoint.c.diff?r1=1.3&r2=1.4)
tif.c (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/tif.c.diff?r1=1.5&r2=1.6)
transaction.c (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/transaction.c.diff?r1=1.5&r2=1.6)
utils.c (r1.7 -> r1.8)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/utils.c.diff?r1=1.7&r2=1.8)
be/src/call:
function.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/call/function.c.diff?r1=1.3&r2=1.4)
pl.c (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/call/pl.c.diff?r1=1.5&r2=1.6)
portal.c (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/call/portal.c.diff?r1=1.2&r2=1.3)
trigger.c (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/call/trigger.c.diff?r1=1.5&r2=1.6)

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