Skip site navigation (1) Skip section navigation (2)

Re: malformed array literal in 8beta1

From: "Chris" <chris(at)paymentonline(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: malformed array literal in 8beta1
Date: 2004-08-29 21:42:37
Message-ID: 06b201c48e11$1a74b1a0$0500a8c0@home (view raw or flat)
Thread:
Lists: pgsql-general
After looking closer at the logs, what seems to be happening is that it 
doesn't like the empty array values.  All functions that I call with an 
array that have one or more empty elements are returning this error.  Should 
I be setting the value to NULL instead of just leaving it empty?

Chris

----- Original Message ----- 
From: "Chris" <chris(at)paymentonline(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, August 29, 2004 2:35 PM
Subject: malformed array literal in 8beta1


> Some changed behavior in 8beta1 bit me here and I'm not sure what it is I 
> am doing wrong.  This works fine on 7.4.
>
> Chris
>
>
> LOG:  statement:                                              select 
> insert_customers('{poi2-10000064,poi2,test1,10000064,1,MC,,John,Doe,,,123
> abc 
> st,mytown,WA,98101,,chris(at)paymentonline(dot)com,US,XFsWsbpBwQJHNK7z41QMv5bpoOLDefsljIXpaWMLeETb4DmStkfkTl1pQ2GT9Uxwe2Mip61TLOUI
> 
> y8iFwEQV7/Jz3eqvhbwAe6Bc8IQqmQOm84/rPRYRxWZ/SGhc014P7luhSQkV9FHzOJcdvxDzOCCS
> 
> 4siOC1Q1wETqhfs5fe0VCcydzahhgspRWeyKyboHWq61B032CW53SD0p3tOTo0JLe+qTRA8EGnrA
> 
> Kx6eWXn98wjyHJa7gGyHNQEJK+tlgkTxZmT7BYtkYGxhPOqsbj+MsyBDOFw7vZBXEVAi8TrZ2NdQ
>        AvDg6XSJBG9qDa9S954afLv9L7Z922bkt55krA==
>        ,1,4,545454,123 abc st}')
> ERROR:  malformed array literal: 
> "{poi2-10000064,poi2,test1,10000064,1,MC,,John,Doe,,,123 abc 
> st,mytown,WA,98101,,chris(at)paymentonline(dot)com,US,X
> FsWsbpBwQJHNK7z41QMv5bpoOLDefsljIXpaWMLeETb4DmStkfkTl1pQ2GT9Uxwe2Mip61TLOUI
> 
> y8iFwEQV7/Jz3eqvhbwAe6Bc8IQqmQOm84/rPRYRxWZ/SGhc014P7luhSQkV9FHzOJcdvxDzOCCS
> 
> 4siOC1Q1wETqhfs5fe0VCcydzahhgspRWeyKyboHWq61B032CW53SD0p3tOTo0JLe+qTRA8EGnrA
> 
> Kx6eWXn98wjyHJa7gGyHNQEJK+tlgkTxZmT7BYtkYGxhPOqsbj+MsyBDOFw7vZBXEVAi8TrZ2NdQ
>        AvDg6XSJBG9qDa9S954afLv9L7Z922bkt55krA==
>        ,1,4,545454,123 abc st}"
> LOG:  statement: rollback
> 


Responses

pgsql-general by date

Next:From: Tom LaneDate: 2004-08-29 22:06:55
Subject: Re: malformed array literal in 8beta1
Previous:From: Scott MarloweDate: 2004-08-29 21:38:45
Subject: Re: Single Row Table?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group