array_dims function is poorly behaved

From: Marc Lavergne <mlavergn(at)richlava(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: array_dims function is poorly behaved
Date: 2002-01-31 17:12:19
Message-ID: 3C597AF3.4030509@richlava.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Simply use an array_dims() on any non-array type, the messages vary from:

SIS=# select array_dims(datdba) from pg_database;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!# ;
You are currently not connected to a database.
!# \q

to:

SIS=# select array_dims(datname) from pg_database;
ERROR: MemoryContextAlloc: invalid request size 1702125936

Reproduces consistently on Linux (i386) 2.4.16 running 7.1.3.

Cheers,

Marc L.

--
01010101010101010101010101010101010101010101010101

Marc P. Lavergne [wk:407-648-6996]
Product Development
richLAVA Corporation

--

"Anyone who slaps a 'this page is best viewed with
Browser X' label on a Web page appears to be
yearning for the bad old days, before the Web,
when you had very little chance of reading a
document written on another computer, another word
processor, or another network."
-Tim Berners-Lee (Technology Review, July 1996)

01010101010101010101010101010101010101010101010101

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Fduch the Pravking 2002-01-31 17:33:28 Re: Dates and daylight saving time
Previous Message Tom Lane 2002-01-31 16:55:17 Re: New to Postgresql - Backend timeout /JDBC