X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DAE3CD1E2C9 for ; Wed, 14 Apr 2004 10:21:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08927-04 for ; Wed, 14 Apr 2004 10:21:41 -0300 (ADT) Received: from CISX-Linux4.cisx.com (unknown [213.133.202.58]) by svr1.postgresql.org (Postfix) with ESMTP id 2B144D1E17E for ; Wed, 14 Apr 2004 10:21:37 -0300 (ADT) Received: from DEMOLITION ([192.168.100.22]) by CISX-Linux4.cisx.com (8.12.8/8.12.8) with SMTP id i3ECxAdq010205 for ; Wed, 14 Apr 2004 13:59:10 +0100 Message-ID: <006701c42223$2dfe5960$1664a8c0@DEMOLITION> From: "Donald Fraser" To: "[ADMIN]" Subject: Updgrade from 7.3 to 7.4 Date: Wed, 14 Apr 2004 14:19:55 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4927.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/214 X-Sequence-Number: 13187 I have just upgraded my development machine from 7.3.4 to 7.4.2 and have a couple of small questions which I can't find any answers to in the documents or history. 1) What does the TRIGGER group/user privilege mean when applied to a VIEW? (after the upgrade all groups that had access rights to views now have the TRIGGER option too) 2) One of my queries does an ORDER BY on a column that is of type BOX. This query no longer runs and returns the following error message: ERROR: could not identify an ordering operator for type box HINT: Use an explicit ordering operator or modify the query. The only things I can think of doing is splitting the box out into the four separate values, but how do I do that with a box? my_box[0] returns a point and my_box[0][0] is not recognised (I tried various other forms but to no avail). Any help/hints would be appreciated. Regards Donald Fraser