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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html