Re: [BUGS] BUG #5502: Preparing an array return Bug
On Sun, Jun 13, 2010 at 5:05 AM, xMoMx 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 #5508: wrong type of argument
The following bug has been logged online: Bug reference: 5508 Logged by: KOIZUMI Satoru Email address: koizumi...@minos.ocn.ne.jp PostgreSQL version: 9.0beta2 Operating system: MacOS X Description:wrong type of argument Details: At 31.17.5. SSL library initialization of PostgreSQL 9.0beta2 Documentation, the type of the second argument of PQinitOpenSSL is "init". Correct type would be "int". -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5508: wrong type of argument
"KOIZUMI Satoru" writes: > At 31.17.5. SSL library initialization of PostgreSQL 9.0beta2 Documentation, > the type of the second argument of PQinitOpenSSL is "init". Correct type > would be "int". Yeah, you're right, will fix. Thanks for the report! regards, tom lane -- 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 #5509: PostgreSQL fail to show table names containing "
The following bug has been logged online: Bug reference: 5509 Logged by: Fosforo Mann Email address: fosf...@gmail.com PostgreSQL version: 8.1.9 Operating system: Fedora Core release 6 Description:PostgreSQL fail to show table names containing " Details: List table names successfully (they were imported from access) Tried to view the table schema without success, and them only typing TAB TAB it appears teste=# \dt List of relations Schema | Name | Type | Owner +--+---+-- public | BOL | table | postgres public | CLI | table | postgres public | IBOL | table | postgres public | cta | table | postgres (4 rows) teste=# teste=# teste=# \d BOL Did not find any relation named "BOL". teste=# teste=# \d "BOL"cta information_schema. pg_temp_1. public. "CLI""IBOL" pg_catalog. pg_toast. teste=# \d "BOL" Table "public.BOL" Column | Type | Modifiers -++--- BOLREF | character varying(6) | -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5509: PostgreSQL fail to show table names containing "
"Fosforo Mann" wrote: > Tried to view the table schema without success, and them only > typing TAB TAB If the table name contains uppercase letters, you need to type the " before trying the TAB. -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs