Recently (last Saturday, as it happens) I upgraded from PostgreSQL v6.0 to
v6.1. I believe I followed the correct procedure for saving the old
databases, and then restoring them in the new format. However, the
process didn't work quite right.
In particular, I had some indexes that were built around a function that
looks like this:
CREATE FUNCTION strcatc2c16 (char2,char16 ) RETURNS text AS
'/home/postgres/src/strcat/strcat.so' LANGUAGE 'C';
The index definition I created looked like this:
CREATE UNIQUE INDEX specialization_index ON specialization USING btree
(strcatc2c16(code, stateBarNum) char_ops);
But in the "db.out" file, it looked like this:
CREATE UNIQUE INDEX specialization_index on specialization using btree
(strcatc2c16(code) char_ops);
No real harm done. I don't know if composite unique indices didn't work
in v6.0 or if I just didn't know about them so I didn't use them, but I
reworked my database code to use them instead of the string concatenation
function.
However, it seems that there is a defect in pg_dumpall because it gets the
number of parameters wrong in that case.
Also, one of the features I was interested in in v6.1 (and, in addition to
the desire to upgrade before the Houston NW Bar Association WWW page is
operational, the real reason I upgraded early,) is the money data type. I
had done extensive work on my own currency data type in v6.0 and I wanted
to quickly switch to a system with a built-in type of that sort. However,
there are some features I desire from currenty types and I'd like to see
if I can't get them included in Postgres. Is there ongoing work on the
"money" data type? If so, how can I be a part of it. (Ideally, I'd like
to sort of take it over. Kind of meld it in my own image or some such.)
- --
Jonathan Guthrie (jguthrie@brokersys.com)
Information Broker Systems +281-895-8101 http://www.brokersys.com/
12703 Veterans Memorial #106, Houston, TX 77014, USA
We sell Internet access and commercial Web space. We also are general
network consultants in the greater Houston area.
------------------------------
