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