Thanks for all the help and suggestions everyone. By installing ruby via cygwin on windows instead of the one-click installer I'm now able to add the "newer" postgresql gems. In fact, several gems I was never able to use before all work fine now :D
Clive 2008/12/13 Clive Crous <[email protected]>: > This is just FYI for everyone. > > Unfortunately none of the gems suggested work on windows. I'm > currently stuck working on windows until I get back to my own box and > postgres-pr is all that works. > * pg and ruby-pg both fail while attempting to compile > * ruby-postgres installs but at runtime pops up a missing dll dialog > > So I'm a little stuck right now. Long term ruby-pg is looking for > windows porters and I think I can help with that effort. Short term I > guess I'm going to have to hack at postgres-pr's source so that I can > continue working on my project. > > Clive > > 2008/12/13 spox <[email protected]>: >> >> On Friday 12 December 2008 16:02:47 entropy wrote: >>> Hi, >>> >>> I'm using Sequel directly from Jeremy Evan's github repository (as at >>> 2.8.0) and >>> >>> I have the following code: >>> >>> Model::Note.create( >>> >>> :creator => person, >>> :created => 'NOW()'.lit, >>> :content => "I'm broken" ) >>> >>> Shouldn't the apostrophe be escaped? >>> >>> I get the following error: >>> >>> ERROR C42601 Msyntax error at or near "m" P76 Fscan.l L807 >>> Rbase_yyerror >>> c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.5.0/lib/postgres-pr/ >>> connection.rb:142:in `query' >>> c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.5.0/lib/postgres-pr/ >>> postgres-compat.rb:33:in `async_exec' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_core/adapters/postgres.rb:137:in `execute' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_core/adapters/postgres.rb:229:in `execute' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_core/connection_pool.rb:109:in `hold' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_core/database.rb:361:in `synchronize' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_core/adapters/postgres.rb:229:in `execute' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_core/dataset.rb:464:in `execute' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_core/adapters/postgres.rb:315:in `fetch_rows' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_core/dataset.rb:454:in `_each' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_core/dataset.rb:204:in `each' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_core/dataset/convenience.rb:180:in `single_record' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_core/adapters/shared/postgres.rb:469:in `insert_select' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_model/record.rb:206:in `save!' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_model/record.rb:191:in `save' >>> c:/local/repositories/github.com/clivecrous/scribbl/vendor/sequel/ >>> lib/sequel_model/base.rb:111:in `create' >>> >>> >>> >> I don't have postgres-pr installed anymore to test this, but it is probably >> your problem. Use the 'pg' gem and you should be just fine. >> >> spox >> >> >> >> > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" 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/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
