interchange-cvs at icdevgroup
May 13, 2008, 3:59 PM
Post #1 of 1
(84 views)
Permalink
|
|
interchange - jon modified UPGRADE
|
|
User: jon
Date: 2008-05-13 22:59:21 GMT
Modified: . UPGRADE
Log:
Upgrade note for 5.5.3 so far, and PostgreSQL 8.3.
Revision Changes Path
2.28 interchange/UPGRADE
rev 2.28, prev_rev 2.27
Index: UPGRADE
===================================================================
RCS file: /var/cvs/interchange/UPGRADE,v
retrieving revision 2.27
retrieving revision 2.28
diff -u -u -r2.27 -r2.28
--- UPGRADE 22 Apr 2008 07:00:01 -0000 2.27
+++ UPGRADE 13 May 2008 22:59:21 -0000 2.28
@@ -73,6 +73,39 @@
K N O W N I S S U E S
+
+PROBLEM WORKAROUND FOR POSTGRESQL 8.3 USERS
+
+In PostgreSQL 8.3 many implicit casts were removed, some of which Interchange
+relied on. By default, the Standard demo and some Interchange core SQL does
+not work with PostgreSQL 8.3.
+
+We expect to work around this in a future version of Interchange, but at the
+moment the easiest way to get things working is to manually put back the
+removed casts, as Peter Eisentraut describes here:
+
+ http://people.planetpostgresql.org/peter/index.php?/archives/18-Readding-implicit-casts-in-PostgreSQL-8.3.html
+
+Running his pg83-implicit-casts.sql script fixes the known problems with the
+Standard demo.
+
+This issue does not affect earlier versions of PostgreSQL.
+
+
+KNOWN ISSUES UPGRADING FROM 5.5.2
+
+The syntax of the custom SQL function for counters has changed. At the time
+of the feature's introduction on 2007-11-17, the syntax was e.g.:
+
+ UserDB default sql_counter "userdb:custom_counter('userdb_username_seq')"
+
+That conflicted with MySQL pseudo-sequence functionality that used the same
+syntax. The new syntax does not conflict and has the benefit of being more
+generic, allowing any SELECT statement:
+
+ UserDB default sql_counter "userdb:SELECT custom_counter('userdb_username_seq')"
+
+
KNOWN ISSUES UPGRADING FROM 5.5.1
SpecialSub catalog_init has been renamed to request_init.
_______________________________________________
interchange-cvs mailing list
interchange-cvs[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-cvs
|
