pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Riho Maisa <riho@centrum.ee>
To: pgsql-admin@postgresql.org
Subject: Inserting bit-type value into integer-type column
Date: Tue, 29 Aug 2006 11:32:35 +0300
Message-ID: <00ec01c6cb45$ae19dbb0$6607a8c0@Maisa> (raw)

Hi!

I have quite strange situation (at least for me). In one older server I have debian Woody and postgresql version shows "PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4". The server is not installed by me.

I built new server, debian Sarge with default Postgresql from package: PostgreSQL 7.4.7 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.5 (Debian 1:3.3.5-12)

I create database and a table: CREATE TABLE test (id integer, id2 integer);

I have SQL sentence: INSERT INTO test VALUES (x'0121', 7)  (yes, type BIT into INTEGER column)

The anomaly for me: in 7.2 it works, but in 7.4 it doesn't. I cannot rewrite SQL INSERT because it's in compiled application.

Could anybody say how it is possible and is there any way to get the same sql working in my newer server using PostgreSQL 7.4? It seems for me as a configuration issue.

  Riho

view thread (3+ messages)  latest in thread

Message-ID: <00ec01c6cb45$ae19dbb0$6607a8c0@Maisa>
Permalink:  ../00ec01c6cb45$ae19dbb0$6607a8c0@Maisa/
Also on:    postgresql.org/message-id/00ec01c6cb45$ae19dbb0$6607a8c0@Maisa

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: riho@centrum.ee
  Subject: Re: Inserting bit-type value into integer-type column
  In-Reply-To: <00ec01c6cb45$ae19dbb0$6607a8c0@Maisa>
  References: <00ec01c6cb45$ae19dbb0$6607a8c0@Maisa>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox