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:
You can:
- Log in, click Edit, and edit this page
- Log in, click Discuss, update the Page status value, and suggest an improvement
- Log in and create a Documentation issue with your suggestion