X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A4D43D1D28B for ; Mon, 26 Jan 2004 05:29:46 +0000 (GMT) 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 49736-05 for ; Mon, 26 Jan 2004 01:29:16 -0400 (AST) Received: from mail.netspace.net.au (whirlwind.netspace.net.au [203.10.110.76]) by svr1.postgresql.org (Postfix) with ESMTP id 3D869D1CCCC for ; Mon, 26 Jan 2004 01:29:10 -0400 (AST) Received: from asusp4 (dsl-203-113-216-67.VIC.netspace.net.au [203.113.216.67]) by mail.netspace.net.au (Postfix) with SMTP id D3455122773 for ; Mon, 26 Jan 2004 16:30:42 +1100 (EST) Message-ID: <00c301c3e3cd$52122eb0$0301a8c0@asusp4> From: "Coby Beck" To: Subject: suddenly changed behaviour Date: Mon, 26 Jan 2004 16:29:01 +1100 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 6.00.2800.1158 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/205 X-Sequence-Number: 12068 Hi, Below is a snippet of code that is generated via another program: CREATE TABLE tActuals ( kActual INTEGER NOT NULL DEFAULT NEXTVAL('kActual') PRIMARY KEY, fActualID TEXT, fAllocationCode TEXT, fWorkItemCode TEXT, fInvoicedAmount FLOAT, fDescription TEXT NOT NULL DEFAULT '', pSUPPLIER INTEGER NOT NULL DEFAULT 0, fSupplierCode TEXT NOT NULL DEFAULT ''||dSupplierMenu('**FORMFIELD**','')||'', pBATCHENTRY INTEGER NOT NULL DEFAULT 0 ); I have reformatted it and snipped the bulk of fields. The code chunks in quotes given as default values are part of a complicated hack so that the Zope application server will present some customized html where otherwise there would just be a normal small textbox. This is not my design but it has served its purpose and I have used similar tricks all over the place in an application I am working on. Now for reasons unknown, Posgres will not build the data base. I have verified that the Create statement that fails now is identical to what was working one hour ago. A very simple function that merely returned a foreign key field given the primary key was taking 60+ seconds to return on my development version of the dB so I decided to drop the dB and build it again. I now get the error "Relation "tsuppliers" does not exist" which happens during execution of dSupplierMenu, which makes sense because tSuppliers comes later in the file but does not make sense because there should be no function call yet. That should happen at run time when Zope fills in default values. Any one have any ideas what might be different, how I can restore it and optionally how it might have happened? I am using 7.2 (yes I know, but upgrading is a bit of a difficulty at the moment) Thanks in advance for assistance! Coby Beck