[rt.cpan.org #19604] ARRAY[] notation no longer supported in INSERT, missing bind parameter

"Guest via RT" <[email protected]> Tue, 30 May 2006 13:38:55 -0400 (EDT)

Newsgroups	gmane.comp.db.postgresql.dbdpg
Message-ID	<[email protected]>

Tue May 30 13:38:54 2006: Request 19604 was acted upon.
Transaction: Ticket created by guest
       Queue: DBD-Pg
     Subject: ARRAY[] notation no longer supported in INSERT, missing bind
 parameter
   Broken in: 1.31, 1.43
    Severity: Normal
       Owner: Nobody
  Requestors: brian-cp66wjWseKLjhXMFFKpSz1aTQe2KTcn/@public.gmane.org
      Status: new
 Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=19604 >


Inserting of array values using the ARRAY[?,?] notation no longer works.  The only 
alternative is to use a single bind paramter and insert the array using the VARCHAR 
notation '{"",""}'.  Once upon a time this worked, but alas, no longer.

The error message indicates that the question marks inside the array brackets are 
skipped as bind parameters altogether, prompting and error message like "failed: called 
with N bind parameters when N-arraysize are needed".