malformed array literal in 8beta1

From: "Chris" <chris(at)paymentonline(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: malformed array literal in 8beta1
Date: 2004-08-29 21:35:13
Message-ID: 06aa01c48e10$1192c9b0$0500a8c0@home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2004-08-29 21:38:45 Re: Single Row Table?
Previous Message Bruno Wolff III 2004-08-29 21:30:44 Re: Single Row Table?