[Ruby-DBI-devel] Timestamp without time zone typeid problems...

[Sean C. <se...@ch...>]

I'm writing a module that's selecting a 'timestamp without time zone'
data type, but when I go to perform the select statement, I get the
following error:


/usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:261:in `convert': Unsupported Type (typeid=1114) (DBI::InterfaceError)
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:476:in `fill_array'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:475:in `each_with_index'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:475:in `each'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:475:in `each_with_index'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:475:in `fill_array'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:457:in `fetchrow'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:412:in `fetch'
        from /usr/home/sean/open_source/ruby-dbi/src/lib/dbi/dbi.rb:766:in `fetch'
        from /usr/home/sean/open_source/ruby-dbi/src/lib/dbi/dbi.rb:601:in `select_one'
        from /usr/home/sean/open_source/ruby-dbi/src/lib/dbi/dbi.rb:600:in `execute'
        from /usr/home/sean/open_source/ruby-dbi/src/lib/dbi/dbi.rb:600:in `select_one'
        from ./session/dbi.rb:47:in `dbi_load'
        from ./session.rb:50:in `call'
        from ./session.rb:50:in `load'
        from ./session.rb:48:in `each'
        from ./session.rb:48:in `load'
        from ./test.rb:23

Which is correct because typid 1114 doesn't exist as a typeid in the
database.  The problem is, it doesn't exist in the database and I
don't know where the value 1114 is coming from.  Any thoughts?  I can
send code/schema to anyone who's interested.  -sc

-- 
Sean Chittenden