Re: npgsql and postgres enum type - Mailing list pgsql-general

From danclemson
Subject Re: npgsql and postgres enum type
Date
Msg-id 25915268.post@talk.nabble.com
Whole thread Raw
In response to Re: npgsql and postgres enum type  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: npgsql and postgres enum type
List pgsql-general
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 the
datareader to get the data in the refcursor.

The stored procedure (return setof refcursor) works if I use prepared
statement, but in this case I am unable to do the explict type cast.
--
View this message in context: http://www.nabble.com/npgsql-and-postgres-enum-type-tp25911871p25915268.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: npgsql and postgres enum type
Next
From: Merlin Moncure
Date:
Subject: Re: npgsql and postgres enum type