If operator statements

From: Elyor Latipov <elyor(at)outlook(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: If operator statements
Date: 2014-01-23 07:50:09
Message-ID: DUB122-W17C35B35436B45184B4A1FB1A60@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Don't work this statement:

IF NOT EXISTS (select TRUE from information_schema.constraint_column_usage where constraint_name='projects_pkey')
THEN
ALTER TABLE projects ADD CONSTRAINT projects_pkey PRIMARY KEY(id);
END IF;

__________________
Best regards,
Elyor.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message deadhead 2014-01-23 08:57:06 Re: BUG #8869: ip4r93-1.05-3.rhel6 syntax error in ip4r.sql - LANGUAGE 'C' instead of LANGUAGE 'c'
Previous Message rahuljadhav119 2014-01-23 06:47:39 BUG #8929: Drupal Website not working on Postgres 9.2