Re: npgsql and postgres enum type

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: danclemson <danclemson(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: npgsql and postgres enum type
Date: 2009-10-15 18:42:01
Message-ID: b42b73150910151142pdfb30f7l138b24d57644feaf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 15, 2009 at 12:31 PM, danclemson <danclemson(at)gmail(dot)com> 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 type?

that's really a npgsql question, but as long as you have access to the
sql being used, you should be able to work around it by altering the
sql like this:

select some_function('abc'::the_enum);

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Temperley 2009-10-15 18:52:53 Re: npgsql and postgres enum type
Previous Message danclemson 2009-10-15 16:31:58 npgsql and postgres enum type