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

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 (view raw or flat)
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

pgsql-bugs by date

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

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