Update and test PostgreSQL Support

tresero - September 28, 2009 - 18:36
Project:Amazon Module
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

# warning: pg_query() [function.pg-query]: Query failed: ERROR: type "real_unsigned" does not exist LINE 14: listpriceamount real_unsigned, ^ in /var/www/sites/dev.xxxxx.com/drupal-6.14/includes/database.pgsql.inc on line 139.

# user warning: query: CREATE TABLE amazon_item ( asin varchar(64) NOT NULL, title varchar(255) NOT NULL, detailpageurl varchar(255) NOT NULL, salesrank int_unsigned, brand varchar(64) NOT NULL, publisher varchar(64) NOT NULL, manufacturer varchar(64) NOT NULL, mpn varchar(128), studio varchar(64) NOT NULL, label varchar(64) NOT NULL, binding varchar(64) NOT NULL, releasedate varchar(64) NOT NULL, listpriceamount real_unsigned, listpricecurrencycode varchar(32), listpriceformattedprice varchar(32), productgroup varchar(255) NOT NULL, producttypename varchar(255) NOT NULL, timestamp int_unsigned NOT NULL default 0, PRIMARY KEY (asin) )

There is no unsigned in SQL, please change it to numeric. float and real are inexact.

#1

tresero - September 29, 2009 - 16:56

You also are using not null in fields that are returned null.
binding
releasedate
are 2.

#2

rfay - October 4, 2009 - 06:35

Postgres porting will be a significant task. Is it worth doing? Please chime in if this is relevant to you.

#3

rfay - October 4, 2009 - 15:32
Title:Postgres issues» Update and test PostgreSQL Support
 
 

Drupal is a registered trademark of Dries Buytaert.