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  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

2010-06-17 Thread KOIZUMI Satoru

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

2010-06-17 Thread Tom Lane
"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 "

2010-06-17 Thread Fosforo Mann

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 "

2010-06-17 Thread Kevin Grittner
"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