Re: insert and heritage... ooops... solved

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