Hi,

I'm using DataMapper to load a PostgreSQL database in a standalone
Ruby script.  I'm getting this
error though:

/opt/local/lib/ruby/gems/1.8/gems/dm-core-0.9.10/lib/dm-core/adapters/
data_objects_adapter.rb:92:in `execute_non_query': (sql_state=42601)
ERROR:  syntax error at or near "RETURNING" (PostgresError)
LINE 1: ...m26/archive/NSW/1833/census/NSW-1833-census.dbk')
RETURNING ...
                                                             ^
Query: INSERT INTO "document_views" ("document_id", "mime_type",
"basename", "content", "main", "mtime", "variant", "path") VALUES
('NSW-1833-census', 'application/docbook+xml', 'NSW-1833-census.dbk',
'foo foo foo', TRUE, '2008-12-22T15:54:40+11:00', '.dbk', '/Volumes/
projects/m26/archive/NSW/1833/census/NSW-1833-census.dbk') RETURNING
"id"
        from /opt/local/lib/ruby/gems/1.8/gems/dm-core-0.9.10/lib/dm-
core/adapters/data_objects_adapter.rb:92:in `execute'

Is it something I'm doing wrong or is it a DataMapper or PostgreSQL
data objects library issue?  This is on OS/X with MacPorts version of
Ruby and PostgreSQL.

Any advice much appreciated,

Stu
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"DataMapper" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/datamapper?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to