Re: how to make an 'UNLOCK'?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Grand Titus" <grand(dot)titus(at)free(dot)fr>
Cc: "postgresql general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to make an 'UNLOCK'?
Date: 2002-12-02 01:25:07
Message-ID: 3614.1038792307@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Grand Titus" <grand(dot)titus(at)free(dot)fr> writes:
> If I declare AbsoluteURL as UNIQUE, do you think it will be good for the
> efficient of the DB?

It sure beats doing manual uniqueness checks, which is what it sounds
like you are doing now. And you need an index on AbsoluteURL anyway
if you are doing searches on it ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2002-12-02 01:53:09 Re: Shema functionality in 7.3
Previous Message Tom Lane 2002-12-02 01:23:17 Re: Renaming schema's