Skip site navigation (1) Skip section navigation (2)

Re: error on Database insert (off-topic)

From: Greg Spiegelberg <gspiegelberg(at)cranel(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: "Seader, Cameron" <CSeader(at)idahopower(dot)com>,pgsql-php(at)postgresql(dot)org
Subject: Re: error on Database insert (off-topic)
Date: 2003-12-01 17:40:31
Message-ID: 3FCB7D0F.1020500@cranel.com (view raw or flat)
Thread:
Lists: pgsql-php
Probably better if forwarded to the hackers list but it would
be nice if you could set a flag for each transaction/connection
to "autocast" on INSERT, UPDATE, DELETE and COPY according to
the column the value is destined for.

set enable_autocast = on;

Could make for sloppy, less portable SQL and may take a hit
in performance on INSERT's and the like conversely it would
reduce the code on the client side.

Guess it depends what you want to be doing the most work.

Greg



Joe Conway wrote:
> Seader, Cameron wrote:
> 
>> Bad int8 external representation "0x000000000002"
>>
>> what is this all about, why won't it insert this data into my bigint
>> field in my Database?  What does it mean by external representation? 
>> Does anyone have any suggestions
> 
> 
> You are apparently trying to insert a hex string "0x000000000002" 
> (notice it starts with '0x') into an int8 field -- don't do that. 
> Convert the hex to integer before inserting, or cast it, like so:
> 
> regression=# select x'000000000002'::int8;
>  int8
> ------
>     2
> (1 row)
> 
> 
> Joe
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly


-- 
Greg Spiegelberg
  Sr. Product Development Engineer
  Cranel, Incorporated.
  Phone: 614.318.4314
  Fax:   614.431.8388
  Email: gspiegelberg(at)Cranel(dot)com
Cranel. Technology. Integrity. Focus.



In response to

pgsql-php by date

Next:From: SaiHertz And Control SystemsDate: 2003-12-03 16:33:09
Subject: Auto commit Off how will it effect us ?
Previous:From: Mariusz PekalaDate: 2003-12-01 16:53:43
Subject: Re: Help Conecting to a database from PHP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group