Thread: BUG #9841: Need some help in sql query

BUG #9841: Need some help in sql query

From
kurasanthoshkumar@gmail.com
Date:
The following bug has been logged on the website:

Bug reference:      9841
Logged by:          santhosh
Email address:      kurasanthoshkumar@gmail.com
PostgreSQL version: 9.3.1
Operating system:   mac os
Description:

Hi I was searching to use KEY SHARE lock on a column.I could not able to
find the syntax in net.Could you please explain in detail how to use that.

Re: BUG #9841: Need some help in sql query

From
John R Pierce
Date:
On 4/3/2014 1:09 AM, kurasanthoshkumar@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      9841
> Logged by:          santhosh
> Email address:kurasanthoshkumar@gmail.com
> PostgreSQL version: 9.3.1
> Operating system:   mac os
> Description:
>
> Hi I was searching to use KEY SHARE lock on a column.I could not able to
> find the syntax in net.Could you please explain in detail how to use that.

this is not a bug.     i suggest you get on the pgsql-general email list
and ask there.    you might also explain /why/ you feel you need a 'key
share lock on a column'.

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

Re: BUG #9841: Need some help in sql query

From
Michael Paquier
Date:
On Thu, Apr 3, 2014 at 5:09 PM,  <kurasanthoshkumar@gmail.com> wrote:
> Hi I was searching to use KEY SHARE lock on a column.I could not able to
> find the syntax in net.Could you please explain in detail how to use that.
That's not a bug, and documentation is your best friend:
http://www.postgresql.org/docs/devel/static/sql-select.html
--
Michael