From: | ivan marchesini <marchesini(at)unipg(dot)it> |
---|---|
To: | Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: drop a check |
Date: | 2006-11-13 17:48:33 |
Message-ID: | 1163440113.15503.18.camel@geoivan |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
.....
or it depend on the fact I'm using postgres 7.4.13
many thanks...
Ivan
On lun, 2006-11-13 at 19:41 +0200, Volkan YAZICI wrote:
> On Nov 13 05:32, ivan marchesini wrote:
> > I have created a check constraint without giving it a name..
> > now I have a check named "$25" in my table that I need to drop or
> > modify!!!
> > How can I do???
> > with names is simple
> >
> > alter table tablename drop constraint constraintname;
> >
> > but without name?? :-)
>
> CREATE TABLE cons_test (
> u integer CHECK (u > 10)
> );
>
> SELECT constraint_name
> FROM information_schema.constraint_column_usage
> WHERE table_name = 'cons_test' AND
> column_name = 'u';
>
> See infoschema-constraint-column-usage.html in the manual for further
> assistance.
>
>
> Regards.
>
--
Ivan Marchesini
Department of Civil and Environmental Engineering
University of Perugia
Via G. Duranti 93/a
06125
Perugia (Italy)
e-mail: marchesini(at)unipg(dot)it
ivan(dot)marchesini(at)gmail(dot)com
tel: +39(0)755853760
fax: +39(0)755853756
jabber: geoivan73(at)jabber(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2006-11-13 18:16:52 | Re: COALESCE and GROUP BY and AGGREGATES |
Previous Message | Richard Broersma Jr | 2006-11-13 17:46:05 | Re: Another question about composite types |