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: (view raw, whole thread or download thread mbox)
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


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.


Marc L.


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)



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-2017 The PostgreSQL Global Development Group