Re: [GENERAL] Change the UI language of psql connection

2010-09-12 Thread Brodie Thiesfield
On Mon, Sep 13, 2010 at 12:33 PM, Tom Lane wrote: > Brodie Thiesfield writes: >> I have a PostgreSQL 8.4 database, installed with Japanese as the main >> language. I am connecting from an English Windows 7 client using >> psql.exe. Is there any way to change the UI of the me

[GENERAL] Change the UI language of psql connection

2010-09-12 Thread Brodie Thiesfield
I have a PostgreSQL 8.4 database, installed with Japanese as the main language. I am connecting from an English Windows 7 client using psql.exe. Is there any way to change the UI of the messages shown to me (e.g. the help, column headers from the \l command, etc) to English? I know that I can set

Re: [GENERAL] How to prevent duplicate key error when two processes do DELETE/INSERT simultaneously?

2009-07-29 Thread Brodie Thiesfield
On Thu, Jul 30, 2009 at 12:23 AM, Tom Lane wrote: > Brodie Thiesfield writes: >> Essentially, I have two processes connecting to a single PG database >> and simultaneously issuing the following statements: > >> BEGIN; >> SET TRANSACTION ISOLATION LEVE

[GENERAL] How to prevent duplicate key error when two processes do DELETE/INSERT simultaneously?

2009-07-29 Thread Brodie Thiesfield
Hi, I've got a problem with a PG client that I'm not sure how to fix. Essentially, I have two processes connecting to a single PG database and simultaneously issuing the following statements: BEGIN; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; DELETE FROM licence_properties WHERE key = xxx; INS