Re: [GENERAL] npgsql and postgres enum type

2009-10-15 Thread danclemson
Thanks for the information. I did try the approach, but it failed due to any other issue with npgsql. The stored procedure returns a setof refcursor. If I use "select * from test('e1':testEnum)", the command.ExecuteReader does not return the datareader properly. The code errored out when I use t

[GENERAL] npgsql and postgres enum type

2009-10-15 Thread danclemson
Hi, As postgres now has enum type, does npgsql driver support the enum type? I use c# and npgsql as databse driver. One of the database stored procedure takes enum as its parameter. What will be the DbType for postgres enum type? Thanks /dan -- View this message in context: http://www.nabb

[GENERAL] timestamp without time zone and datetime

2009-10-15 Thread danclemson
Hi, I have a stored procedure in db that takes a 'timestamp without time zone' as its parameter. The application uses c# and npgsql to access database. When I call the stored procedure from c#, I got an exception says that the stored procedure with 'timestamp with time zone' is unknown. It seems