DBI PostgreSQL array has 2 fields, should have 3

2005 is nearly over and this bug still exists in the DBD for
PostgreSQL. The error you might get will be similar to this:

_set_fbav(ARRAY(0x184f704)): array has 2 fields, should have 3 at
C:/Perl/site/lib/DBD/PgPP.pm line 409.

I have managed to work around this problem by not executing an SQL
query inside a loop for which another query is still open. Loop through
the first query and stuff everything inside an array, then loop through
the array and execute the "sub query" based on information stored in
the array. No more annoying, dumb, error.

This problem was previously discussed here:
http://groups.google.com.au/group/perl.dbi.users/browse_thread/thread/83216e6fc71a9e3a/2e2b394c1f9605a8?lnk=st&q=%22array+has+*+fields+should+have+*+at%22&rnum=1&hl=en#2e2b394c1f9605a8

.

Relevant Pages

  • RE: Array Help
    ... Dim strSQL As String ... the Access "INSERT INTO" SQL query is: ... one field is changed for each query, I was thinking that I could loop though ... I am not sure how to do a loop through the array or write any code for it as ...
    (microsoft.public.access.modulesdaovba)
  • Re: JDBC Driver extremely slow??
    ... activity while executing the query, the query is sent, server dedicates one ... I've executed the query by setting the array size to 1 on sql+ results came ... CULTEXT.OWNERNAME ASC, CULTEXT.OWNERTYPEDESC ASC, CULTEXT.LOGICALREF ...
    (comp.databases.oracle.server)
  • Re: Copying a table to an array
    ... You probably don't need a query, ... Dim rstRSet As Recordset ... table to enable data from the latter to be read into an array with GetRows. ... exercise has therefore to be repeated prior to each interrogation. ...
    (microsoft.public.access.formscoding)
  • Re: Mix/Max/Avg Help based on dynamic ranges
    ... Did you enter Biff's formula as an array? ... The query I gave you is dependent on your breaking out the ranges as Biff ... Where Nums are the values to avg based on the head count range. ... deemed optimal for building device profiles based on locn size and device ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Need Help With Pivot/Cross-Tab Query Please/ **Dates Are Not Fixed**
    ... I was able to get the pivot-like query to work. ... and loop in the QUERY's SELECT statement that returns the "AS Day1, ... Used another CF array and loop to get the column headers to print the ... variables when outputting the query results to a report, ...
    (microsoft.public.sqlserver.programming)