Received: from localhost (IDENT:root@hectic-1.jpl.nasa.gov [128.149.68.203]) by hub.org (8.9.2/8.9.1) with ESMTP id KAA04387 for ; Tue, 13 Apr 1999 10:07:43 -0400 (EDT) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (lockhart@localhost [127.0.0.1]) by localhost (8.8.7/8.8.7) with ESMTP id GAA10574; Tue, 13 Apr 1999 06:18:51 GMT Sender: lockhart@hub.org Message-ID: <3712E1CB.898FFA21@alumni.caltech.edu> Date: Tue, 13 Apr 1999 06:18:51 +0000 From: Thomas Lockhart X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: StOo CC: "pgsql-interfaces@postgreSQL.org" Subject: Re: [INTERFACES] i broke my int8 =( References: <371230CF.721F4138@comodo.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > ive got an intresting problem with then int8 in postgres its not > actually working properly as it goes out of range with a value like > 2147483648 !!!! oops i need it to go just a bit higher!!! i think the > build naffed up the int8 is there any way of checking this ??? any > settings i > may have missed or need to configure ??? You need to enter the values with a single quote around the string. Otherwise, the number is interpreted as an int4 (and rejected) before it would be converted to an int8. The quotes keep it as a string until the right time... - Tom -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California