#156 ✓resolved
Michael Klaus

Cannot add multiple references using postgres adapter

Reported by Michael Klaus | February 13th, 2008 @ 02:28 PM

The trace will look similar to

ERROR: syntax error at or near ","

LINE 4: (1, 1), (1, 2), (1, 3)

^

QUERY: " INSERT INTO "groups_profiles"

("profile_id", "group_id")

VALUES

(1, 1), (1, 2), (1, 3)"

/usr/lib/ruby/gems/1.8/gems/do_postgres-0.2.3/lib/do_postgres.rb:186:in `execute_non_query'

This is because postgres is not able to do batch inserty, but the postgres adapter does not declare so.

The error can be circumvented by following code:

module DataMapper

module Adapters

class PostgresqlAdapter

def batch_insertable?

false

end

end

end

end

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

People watching this ticket

Pages