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

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

> > I've verified that this is a fix for the problem.  I've also
> > gotten to the point of being able to reproduce it reliably:
> > 
> > echo "CREATE TABLE dbi_test ( t TIMESTAMP WITH OUT TIMEZONE NOT NULL );" | psql

Grrr... typing too fast.

echo "CREATE TABLE dbi_test ( t TIMESTAMP WITHOUT TIME ZONE NOT NULL );" | psql

> Sorry, but I can't create this table using PostgreSQL 7.2.1.
> If I omit "WITH OUT TIMEZONE", then it works.

I needed to transpose a space.  ::sigh::

> > # in dbi_test.rb
> > require 'dbi'
> > 
> > DBI.connect('dbi:Pg:test') do |dbh|
> >   dbh.select_all('SELECT t FROM dbi_test') do |row|
> >     puts row.inspect
> >   end
> > end
> > 
> > 
> > That'll throw it 100% of the time.  Any ideas on a fix for this?  -sc
> 
> What tells the raised exception?

/usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:289:in `convert': Unsupported Type (typeid=1114) (DBI::InterfaceError)
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:567:in `fill_array'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:566:in `each_with_index'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:566:in `each'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:566:in `each_with_index'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:566:in `fill_array'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:519:in `fetchrow'
        from /usr/local/lib/ruby/site_ruby/1.7/DBD/Pg/Pg.rb:456:in `fetch'
        from /usr/local/lib/ruby/site_ruby/1.7/dbi/dbi.rb:742:in `fetch'
        from /usr/local/lib/ruby/site_ruby/1.7/dbi/dbi.rb:767:in `each'
        from /usr/local/lib/ruby/site_ruby/1.7/dbi/dbi.rb:595:in `select_all'
        from /usr/local/lib/ruby/site_ruby/1.7/dbi/dbi.rb:593:in `execute'
        from /usr/local/lib/ruby/site_ruby/1.7/dbi/dbi.rb:593:in `select_all'
        from tmp/dbi.rb:6
        from tmp/dbi.rb:5:in `connect'
        from /usr/local/lib/ruby/site_ruby/1.7/dbi/dbi.rb:332:in `connect'
        from tmp/dbi.rb:5

-sc

-- 
Sean Chittenden