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

[Michael N. <uu...@rz...>]

On Sun, Jul 07, 2002 at 07:58:26PM -0700, Sean Chittenden wrote:
> > > 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
> > 
> > Can you send it me?
> > 
> > Another similar problem is:
> > 
> >   select 'h'
> > 
> > raises the following exception 
> > 
> >   Unsupported Type (typeid=705)
> > 
> > whereas
> > 
> >   select 'h'::text
> > 
> > gives the correct result.
> 
> 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

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

> # 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?

Regards,

  Michael