From: | stephane parenton <stephane(at)parenton(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: insert and heritage... ooops... solved |
Date: | 2003-08-17 12:58:40 |
Message-ID: | 3F3F7C00.2050505@parenton.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
stephane parenton a écrit:
> hi Len,
>
> Len Morgan a écrit:
>
>> the next problem concerns the insert :
>>
>> INSERT INTO postetravail
>> (administrable,adresseip,adressemac,etat,nom) VALUES
>> ('false','192.168.0.2','FF:EE:DD:CC:BB:AB','1','big')\g
>> ERROR: value too long for type character(1)
>>
>> Administrable is defined as char (i.e., length of one) and 'false' is 5
>> characters. You probably want type Boolean instead of character.
>>
>>
> CREATE TABLE postetravail (
> nom character(1)
> )
> INHERITS (equipements);
hemmmmmmm.... let's say i'd better read my scripts before posting !!!!!!
if i tell the name to be stored only with char(1), it won't fit my needs
when i try to enter a longer name.... ;-)
sorry !!!! my fault !
Stephane
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Godden | 2003-08-17 13:28:33 | C vs plpgsql and child processes |
Previous Message | stephane parenton | 2003-08-17 12:51:34 | Re: insert and heritage... |