Received: from teapot32.domain8.bigpond.com (teapot32.domain8.bigpond.com [139.134.5.180]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0C2Tcp73710 for ; Thu, 11 Jan 2001 21:29:38 -0500 (EST) (envelope-from aa2@bigpond.net.au) Received: from localhost (localhost [127.0.0.1]) by teapot32.domain8.bigpond.com (NTMail 3.02.13) with ESMTP id va790057 for ; Fri, 12 Jan 2001 12:29:25 +1000 Received: from CPE-144-132-51-31.vic.bigpond.net.au ([144.132.51.31]) by mail8.bigpond.com (Claudes-Happening-MailRouter V2.9c 17/2682523); 12 Jan 2001 12:29:25 Message-ID: <3A5E6B9B.2E45D429@bigpond.net.au> Date: Fri, 12 Jan 2001 13:27:39 +1100 From: Justin Clift X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: pgsql-sql@postgresql.org Subject: Re: Possible bug? WAS :Bad (null) varchar() external representation. References: <3A5CA5FA.CBDF0513@bigpond.net.au> <3A5CB33B.A2D61F9B@bigpond.net.au> <12256.979240778@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/111 X-Sequence-Number: 772 Hi Tom, I think you are right. It does seem to barf on NULLS and length(varchar), regardless. Thanks for your assistance. BTW - How do things normally get added to the FAQ? I would like to add something about length(varchar) and NULLS not working in PostgreSQL 7.0.x Regards and best wishes, Justin Clift Database Administrator Tom Lane wrote: > > Justin Clift writes: > > I haven't seen a mention of a maximum number of constraints of similar > > applying to a table. If so, then could someone please point me to it... > > There is no such limit that I know of. > > > Yet if I remove BOTH the "staff_details_phone_three" & > > "staff_details_managers_notes" constraints it works : > > Are you absolutely certain that that's how it went? I think the most > likely story is just that you were hitting the length(varchar)-barfs- > on-NULL bug, and got confused about which combinations you'd tried. > > regards, tom lane