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

Re: strange array insertion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bernie Huang" <bernieyth(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: strange array insertion
Date: 2000-11-02 17:08:18
Message-ID: 25733.973184898@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
"Bernie Huang" <bernieyth(at)hotmail(dot)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

In response to

pgsql-bugs by date

Next:From: Thomas LockhartDate: 2000-11-02 18:18:22
Subject: Re: Bug in Time/Date routines
Previous:From: Tom LaneDate: 2000-11-02 16:23:33
Subject: Re: Bug in Time/Date routines

pgsql-general by date

Next:From: Peter KorsgaardDate: 2000-11-02 18:42:43
Subject: Re: server protocol used by Postgres
Previous:From: Tom LaneDate: 2000-11-02 16:04:29
Subject: Re: server protocol used by Postgres

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