Re: [GENERAL] npgsql and postgres enum type

2009-10-15 Thread Merlin Moncure
On Thu, Oct 15, 2009 at 4:14 PM, danclemson wrote: > > 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

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

Re: [GENERAL] npgsql and postgres enum type

2009-10-15 Thread Merlin Moncure
On Thu, Oct 15, 2009 at 2:52 PM, William Temperley > I recently stopped using enums after reading this: > http://www.commandprompt.com/blogs/joshua_drake/2009/01/fk_check_enum_or_domain_that_is_the_question/ > Using a foreign key to a single column table is pretty much as fast as > an enum, is supp

Re: [GENERAL] npgsql and postgres enum type

2009-10-15 Thread William Temperley
2009/10/15 Merlin Moncure : > On Thu, Oct 15, 2009 at 12:31 PM, danclemson wrote: >> >> 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 w

Re: [GENERAL] npgsql and postgres enum type

2009-10-15 Thread Merlin Moncure
On Thu, Oct 15, 2009 at 12:31 PM, danclemson wrote: > > 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 typ

[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