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 |
Jump to:
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
You also are using not null in fields that are returned null.
binding
releasedate
are 2.
#2
Postgres porting will be a significant task. Is it worth doing? Please chime in if this is relevant to you.
#3