You have probably copied the UPDATE .. SET .. syntax for the INSERT INTO .. syntax.
The valid SQL syntax is actually different.

You need to use INSERT INTO (..) VALUES (..)

See: http://www.w3schools.com/SQL/sql_insert.asp

I have attached a patch that fixes this where I have noticed the problem.

CommentFileSizeAuthor
type_local_nids-sql_syntax_fix-1.patch581 bytesthekevinday

Comments

jbrown’s picture

jbrown commented
Title: invalid SQL insert into syntax » Make INSERT INTO syntax ANSI compliant
Version: 6.x-1.3 » 6.x-1.x-dev
Assigned: Unassigned » jbrown
Category: bug » task
Priority: Critical » Normal
Status: Active » Fixed

I guess this should work on postgres now. :-)

jbrown’s picture

jbrown commented

http://drupal.org/cvs?commit=266310

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.