Use of DB over pgsql
| From: | Marcos Lois Bermúdez | Date: | Mon, 16 Sep 2002 08:54:04 +0000 |
| Subject: | Use of DB over pgsql | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-2311@lists.php.net to get a copy of this message | ||
I tried to migrate a web aplication writen for mysql to pgsql, i use the DB API, but it seems to nopt work, see some examples:
In Mysql
SELECT A.id AS ID, B.nombre AS NAME WHERE (A.id=B.id_tipo)this will result in a row of this tipe:
ID -> 1
NAME -> nombre
in pgsql the same sql return different nome on columns
id -> 1
name -> nombre
I use prepare/execute to insert some data of a file, into a blob column in mysql, it works fine, but when i try this in pgsql it broken with a:
DB Error: unknown error - INSERT INTO propuesta_ficheros (nombre, tipo, datos, id_propuesta, comentario) VALUES ('pwobjects.sxw','application/vnd.sun.xml.writer','PK
Anybody experiencie the same problems.
I think that the API tell me the facility of migrate DB if i don't use DB specific SQL statements, but i see that it's not true.
Regards.
-----------------------------------------------
Marcos Lois Bermúdez
marcos.lois@iqc-services.com
IQC - Services
Avda. Garcia Barbón, 90 / 4ºB
36201 Vigo (Pontevedra)
Tel: +34 986.884.244
Fax: +34 986.415.074
http://www.iqc-services.com
-----------------------------------------------