El Lunes, 28 de Diciembre de 2009, Iñaki Baz Castillo escribió:
> Hi, I'm testing Sequel with 'pg' driver using Posgres-8.4 database. I use
> prepared statements.

Now I've tryed with 'postgres-pr' driver. It doesn't suuport neither bound 
varialbes or prepared statemets. However Sequel never reconnects after 
restarting the database:


First query after DB restart:

-------------
EOFError: EOFError
/usr/local/lib/ruby1.9/gems/1.9.1/gems/postgres-pr-0.6.1/lib/postgres-
pr/message.rb:11:in `read_exactly_n_bytes'                                      
                                            
/usr/local/lib/ruby1.9/gems/1.9.1/gems/postgres-pr-0.6.1/lib/postgres-
pr/message.rb:47:in `read' 
/usr/local/lib/ruby1.9/gems/1.9.1/gems/postgres-pr-0.6.1/lib/postgres-
pr/connection.rb:118:in `block in query'                                        
                                            
/usr/local/lib/ruby1.9/gems/1.9.1/gems/postgres-pr-0.6.1/lib/postgres-
pr/connection.rb:117:in `loop'                                                  
                                            
/usr/local/lib/ruby1.9/gems/1.9.1/gems/postgres-pr-0.6.1/lib/postgres-
pr/connection.rb:117:in `query'                                                 
                                            
/usr/local/lib/ruby1.9/gems/1.9.1/gems/postgres-pr-0.6.1/lib/postgres-
pr/postgres-compat.rb:33:in `query'                                             
                                            
/usr/local/lib/ruby1.9/gems/1.9.1/gems/sequel-3.7.0/lib/sequel/adapters/postgres.rb:147:in
 
`execute'                                                                       
                       
--------------


Next queries:
---------------
Errno::EPIPE: Broken pipe                                                       
                 
/usr/local/lib/ruby1.9/gems/1.9.1/gems/postgres-pr-0.6.1/lib/postgres-
pr/connection.rb:112:in `write'                                                 
                                            
/usr/local/lib/ruby1.9/gems/1.9.1/gems/postgres-pr-0.6.1/lib/postgres-
pr/connection.rb:112:in `<<'                                                    
                                            
/usr/local/lib/ruby1.9/gems/1.9.1/gems/postgres-pr-0.6.1/lib/postgres-
pr/connection.rb:112:in `query'                                                 
                                            
/usr/local/lib/ruby1.9/gems/1.9.1/gems/postgres-pr-0.6.1/lib/postgres-
pr/postgres-compat.rb:33:in `query'                                             
                                            
/usr/local/lib/ruby1.9/gems/1.9.1/gems/sequel-3.7.0/lib/sequel/adapters/postgres.rb:147:in
 
`execute'                                                                       
                       
/usr/local/lib/ruby1.9/gems/1.9.1/gems/sequel-3.7.0/lib/sequel/adapters/postgres.rb:224:in
 
`block in execute'                                                              
                       
/usr/local/lib/ruby1.9/gems/1.9.1/gems/sequel-3.7.0/lib/sequel/connection_pool.rb:313:in
 
`hold' 
-------------


It seems that the 'postgres-pr' driver raises error exception not belonging to 
"Postgres" class so it's difficult for Sequel to handle them. Am I right?


-- 
Iñaki Baz Castillo <[email protected]>

--

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.


Reply via email to