Re: BUG #5502: Preparing an array return Bug

On Sun, Jun 13, 2010 at 5:05 AM, xMoMx <waritach@gmail.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05502
> Logged by: =A0 =A0 =A0 =A0 =A0xMoMx
> Email address: =A0 =A0 =A0waritach@gmail.com
> PostgreSQL version: 8.3
> Operating system: =A0 Window
> Description: =A0 =A0 =A0 =A0Preparing an array return Bug
> Details:
>
> Spending the whole day trying to figure this out myself and finally I gave
> up. My postGre simply refuse to prepare an array for insert and update. It
> work fine when not preparing though. (But heck we all know we want to
> prepare everything right?)
>
> Here's the code:
> comm.Parameters.Add(new NpgsqlParameter("myArray", NpgsqlDbType.Array |
> NpgsqlDbType.Smallint));
> comm.Parameters[0].Value =3D new Int16[2]{0,0};
>
> Once execute, nothing is return. Not even error log.

Hmm.  This looks like it might be an npgsql problem.  I confess I
don't know the first thing about npgsql.  I think this might be their
mailing list though - maybe you want to try there?

http://pgfoundry.org/mailman/listinfo/npgsql-devel

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company