X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 5C1329FB232 for ; Tue, 29 Aug 2006 10:03:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 70234-07 for ; Tue, 29 Aug 2006 13:03:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 3D0129FB227 for ; Tue, 29 Aug 2006 10:03:26 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k7TD3HKb003210; Tue, 29 Aug 2006 09:03:17 -0400 (EDT) To: Peter Eisentraut cc: pgsql-admin@postgresql.org, "Riho Maisa" Subject: Re: Inserting bit-type value into integer-type column In-reply-to: <200608291044.31542.peter_e@gmx.net> References: <00ec01c6cb45$ae19dbb0$6607a8c0@Maisa> <200608291044.31542.peter_e@gmx.net> Comments: In-reply-to Peter Eisentraut message dated "Tue, 29 Aug 2006 10:44:29 +0200" Date: Tue, 29 Aug 2006 09:03:17 -0400 Message-ID: <3209.1156856597@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/314 X-Sequence-Number: 22857 Peter Eisentraut writes: > Am Dienstag, 29. August 2006 10:32 schrieb Riho Maisa: >> I cannot rewrite SQL INSERT because it's in compiled application. > Either fix your application or patch the PostgreSQL server or stick with 7.2 > (not recommended, because 7.2 is not maintained anymore). The patch would be pretty easy though: just tweak the pg_cast entry for bit to int casting so that it's "assignment" rather than "explicit". regards, tom lane