Deprecated: Assigning the return value of new by reference is deprecated in /home/bluestat/public_html/source/index.php on line 477
Changes that will need to be made to support PostgreSQL: $Id$ ################################################################################ - All integers need to have their length dropped: int(20) goes to int - Small integers int(2) et alter should be changed to smallint - Cannot use REPLACE INTO x; need to delete records first or use UPDATE - mediumtext needs to be converted to text - Column renames need to be DB-specific. MySQL uses "ALTER TABLE x CHANGE y(def) TO z(def)" and PGSQL uses "ALTER TABLE x RENAME COLUMN y TO z" - Joins need to be explicit "(INNER|LEFT|RIGHT) JOIN" instead of "WHERE x.a = y.a" - AUTO_INCREMENT needs to be DB-specific switched to SERIAL without any integral information, but with primary-unique constraints - Need change limiting agent from "LIMIT offset,max" and PGSQL uses "LIMIT max OFFSET offset" - Fulltext searching is not supported in PGSQL, will need to rewrite searches to allow for some degree of niceness - Need DB-specific DB->insert_id() for MySQL and DB->insert_id(table, column) for PGSQL - FIND_IN_SET(find, field) needs to be "find = ANY(STRING_TO_ARRAY(field, ','))" - Blobs need to become bytea fields; when inserting into them, pg_escape_bytea() needs to be run and when outputting it pg_unescape_bytea() needs to be run on the output