]> src.bluestatic.org Git - isso.git/blob - docs/pgsql_info.txt
Discovered another older style of accessing the registry
[isso.git] / 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