Обсуждение: BUG #5502: Preparing an array return Bug

The following bug has been logged online:

Bug reference:      5502
Logged by:          xMoMx
Email address:      waritach@gmail.com
PostgreSQL version: 8.3
Operating system:   Window
Description:        Preparing 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 = new Int16[2]{0,0};

Once execute, nothing is return. Not even error log.

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