Re: how to make an 'UNLOCK'? - Mailing list pgsql-general

From Tom Lane
Subject Re: how to make an 'UNLOCK'?
Date
Msg-id 3614.1038792307@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to make an 'UNLOCK'?  ("Grand Titus" <grand.titus@free.fr>)
List pgsql-general
"Grand Titus" <grand.titus@free.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Renaming schema's
Next
From: Joe Conway
Date:
Subject: Re: Shema functionality in 7.3