Home » Issue Tracker » Ubercart

PostgreSQL and use of extended inserts into uc_zones

Submitted by neilnz@drupal.org on Sun, 05/04/2008 - 23:02.
Project: 
Ubercart
Category: 
bug report
Version: 
Ubercart 1.0 RC
Priority: 
normal
Assigned: 
Unassigned
Status: 
active

Hi,

the uc_store/countries/*.cif files all make use of extended inserts, which are not supported until Postgres 8.2.

Most Debian and Red Hat-based distributions still only bundle 8.1, and Drupal technically supports down to 7.4, so you really shouldn't be using extended inserts. This caused the zones table to not populate.

I would submit a patch for all these files, but I figured that these files are automatically generated by some means, so maybe just that needs tweaking?
#1Submitted by TR on Sun, 05/04/2008 - 23:42.

Re: PostgreSQL and use of extended inserts into uc_zones

No, they're not generated automatically, they were all generated by hand, by a variety of people. That's gonna need a lot of patches. Also, the documentation which shows how to write .cif files will need to be changed. Is there any way around this? Can you show an example of what needs to be changed?