Re: [BUGS] BUG #5502: Preparing an array return Bug

2010-06-17 Thread Robert Haas
On Sun, Jun 13, 2010 at 5:05 AM, xMoMx warit...@gmail.com wrote:

 The following bug has been logged online:

 Bug reference:      5502
 Logged by:          xMoMx
 Email address:      warit...@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.

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

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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[BUGS] BUG #5502: Preparing an array return Bug

2010-06-13 Thread xMoMx

The following bug has been logged online:

Bug reference:  5502
Logged by:  xMoMx
Email address:  warit...@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.

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs