Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 6F8979A1342 for ; Fri, 3 Feb 2012 11:42:15 -0400 (AST) Received: from adsltrust.ath.forthnet.gr ([194.219.204.174] helo=smadev.internal.net) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RtLHB-00017B-Ld for pgsql-sql@postgresql.org; Fri, 03 Feb 2012 15:42:14 +0000 Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.14.4/8.14.4) with ESMTP id q13Ffxb7064929 for ; Fri, 3 Feb 2012 17:41:59 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Received: (from achill@localhost) by smadev.internal.net (8.14.4/8.14.4/Submit) id q13FfxbY064928 for pgsql-sql@postgresql.org; Fri, 3 Feb 2012 17:41:59 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) X-Authentication-Warning: smadev.internal.net: achill set sender to achill@matrix.gatewaynet.com using -f From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-sql@postgresql.org Subject: array dimensions, pg_catalog.pg_attribute and the \d command Date: Fri, 3 Feb 2012 17:41:59 +0200 User-Agent: KMail/1.13.7 (FreeBSD/8.2-RELEASE-p3; KDE/4.7.3; amd64; ; ) MIME-Version: 1.0 Content-Type: Text/Plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Message-Id: <201202031741.59171.achill@matrix.gatewaynet.com> X-Pg-Spam-Score: -0.5 (/) X-Archive-Number: 201202/12 X-Sequence-Number: 36305 Hello, just a question regarding multidimensional arrays. When i create an array, its number of dimensions is recorded in pg_catalog.pg_attribute (attndims), but they are not enforced upon insertion, nor is this presented by \d command. (i didn't see any attndims column showing up in the logs) Any reasons why this is so?