docs/pgsql_info.txt

   1 Changes that will need to be made to support PostgreSQL:
   2
   3 $Id$
   4 ################################################################################
   5
   6 - All integers need to have their length dropped: int(20) goes to int
   7 - Small integers int(2) et alter should be changed to smallint
   8 - Cannot use REPLACE INTO x; need to delete records first or use UPDATE
   9 - mediumtext needs to be converted to text
  10 - 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"
  11 - Joins need to be explicit "(INNER|LEFT|RIGHT) JOIN" instead of "WHERE x.a = y.a"
  12 - AUTO_INCREMENT needs to be DB-specific switched to SERIAL without any integral information, but with primary-unique constraints
  13 - Need change limiting agent from "LIMIT offset,max" and PGSQL uses "LIMIT max OFFSET offset"
  14 - Fulltext searching is not supported in PGSQL, will need to rewrite searches to allow for some degree of niceness
  15 - Need DB-specific DB->insert_id() for MySQL and DB->insert_id(table, column) for PGSQL
  16 - FIND_IN_SET(find, field) needs to be "find = ANY(STRING_TO_ARRAY(field, ','))"
  17 - 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