PostgreSQLism: avoid mutiple ROW inserts (PostgreSQL < 8.2 only)

Last updated on
8 September 2016

Drupal 7 will no longer be supported after January 5, 2025. Learn more and find resources for Drupal 7 sites

PostgreSQL 8.2, 83 and 8.4 are not affected by this issue.

The following query fails:

INSERT INTO uc_zones (zone_country_id, zone_code, zone_name) 
VALUES (840, 'AL', 'Alabama'),(840, 'AK', 'Alaska');

Instead, use seperate queries:

INSERT INTO uc_zones (zone_country_id, zone_code, zone_name) VALUES (840, 'AL', 'Alabama');
INSERT INTO uc_zones (zone_country_id, zone_code, zone_name) VALUES (840, 'AK', 'Alaska');

Reference:
http://drupal.org/node/509312

Help improve this page

Page status: No known problems

You can: