column already exist (ERROR replaced by warning)

From: Olivier Chapiteau <ochapiteau(at)cyberdeck(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: column already exist (ERROR replaced by warning)
Date: 2001-05-03 13:37:06
Message-ID: 01050315370600.07992@ochapiteau.dagon.pdt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Einar Karttunen 2001-05-03 13:38:34 Re: Time to insert
Previous Message Vladislav Breus 2001-05-03 13:28:02 BLOB type