Re: strange array insertion

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Bernie Huang" <bernieyth@hotmail.com>
Cc: pgsql-bugs@postgresql.org, pgsql-general@postgresql.org
Date: 2000-11-02T17:08:18Z
Lists: pgsql-bugs
"Bernie Huang" <bernieyth@hotmail.com> writes:
> Strange enough, it seems like the 2-d text array size depends on the last 
> element size.

Looks like a bug to me too ... probably silliness in the array_in
routine that determines dimensions of an unspecified-dimensions input.
Want to look at it?

> Btw, I was informed that 
> rollback is not possible if array is involved (it auto-commits before you 
> issue "commit" or "rollback" comands).
> eg; "begin;", "update tb1 set arr[1]='something';", "rollback;"

Array update had this strange idea that it's OK to scribble on the
source tuple :-(.  This is fixed for 7.1.

			regards, tom lane