column already exist (ERROR replaced by warning) - Mailing list pgsql-general

From Olivier Chapiteau
Subject column already exist (ERROR replaced by warning)
Date
Msg-id 01050315370600.07992@ochapiteau.dagon.pdt
Whole thread Raw
List pgsql-general
In my script, i do an ALTER TABLE l_table ADD next_h varchar(64) not null;

i get after the first execution !
 column name "next_h" already exists in table "l_table"

My problem is that the value returned by psql is 0, bu for me it's a warning,
not an error.(i want to obtain a 1 in this case)

Is it possible to disting the two types of error ?

thanks,

Olivier chapiteau

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multiple Inheritance
Next
From: Vladislav Breus
Date:
Subject: BLOB type