PgSql

Japanies translation breaks solaris build
Zdenek Kotala <Zdenek.Kotala(a)Sun.COM> wrote: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=comet_moth&dt=2010-05-13%2021:06:01 The problem is that it contains mix of DOS/Unix end of lines. I removed two CRs in ja.po. Regards, --- Takahiro Itagaki NTT Open Source Software Center -- Sent v... 15 May 2010 01:53

[HACKERS] Japanies translation breaks solaris build
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=comet_moth&dt=2010-05-13%2021:06:01 msgfmt -o po/ja.mo po/ja.po WARNING: the string after closing " is ignored at line number 11. Error, No space after directive at line number 2008. ERROR: Exiting... gmake[2]: *** [po/ja.mo] Error 2 The problem is that it... 14 May 2010 03:01

Row-level Locks & SERIALIZABLE transactions, postgresvs. Oracle
On 05/14/2010 03:37 AM, Greg Stark wrote: On Thu, May 13, 2010 at 10:25 PM, Florian Pflug<fgp(a)phlo.org> wrote: C1: BEGIN C1: SELECT * FROM t WHERE id = 1 FOR UPDATE C2: BEGIN C2: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE C2: SELECT * FROM t -- Take snapshot before C1 commits C1: CO... 14 May 2010 01:56

[HACKERS] Generalized Inverted Generalized Search Tree
We can index multiple scalar values per row with GIN access method, and also can index single vector value per row with GiST AM. Is it worth having a new AM to index multiple vector values per row? It will be an AM for the missing feature in below: | scalar | vector | ----------------+--------+... 14 May 2010 00:51

nvarchar notation accepted?
Jaime Casanova <jaime(a)2ndquadrant.com> wrote: i migrate a ms sql server database to postgres and was trying some queries from the application to find if everything works right... when i was looking to those queries i found some that has a notation for nvarchar (ej: campo = N'sometext') Do you have do... 3 Jul 2010 11:16

pgsql: Add PGFILEDESCdescription to Makefiles for all /contrib
Magnus Hagander wrote: On Thu, May 13, 2010 at 1:47 AM, Bruce Momjian <bruce(a)momjian.us> wrote: bruce wrote: Tom Lane wrote: Bruce Momjian <bruce(a)momjian.us> writes: All other binaries had such a designation, and all /contrib binaries were missing them. ?I assume I was doing cl... 13 May 2010 20:29

Row-level Locks & SERIALIZABLE transactions, postgres vs. Oracle
On May 13, 2010, at 23:51 , Kevin Grittner wrote: Florian Pflug <fgp(a)phlo.org> wrote: All in all, I believe that SHARE and UPDATE row-level locks should be changed to cause concurrent UPDATEs to fail with a serialization error. I can come up with a patch that does that, but I wanted to get so... 14 May 2010 07:20

[HACKERS] nvarchar notation accepted?
Hi, i migrate a ms sql server database to postgres and was trying some queries from the application to find if everything works right... when i was looking to those queries i found some that has a notation for nvarchar (ej: campo = N'sometext') i was expecting those to fail but this actually works, is that fine?... 13 May 2010 19:23

[HACKERS] HS/SR Assert server crash
I was able to easily crash the standby server today just by starting it and connecting to it via psql. The master was idle. The failure was: LOG: streaming replication successfully connected to primary TRAP: FailedAssertion("!(((xmax) >= ((TransactionId) 3)))", File: "procarray.c", Line: 1211) LOG: server ... 13 May 2010 18:17

Row-level Locks & SERIALIZABLE transactions, postgres vs. Oracle
Florian Pflug <fgp(a)phlo.org> writes: All in all, I believe that SHARE and UPDATE row-level locks should be changed to cause concurrent UPDATEs to fail with a serialization error. I don't see an argument for doing that for FOR SHARE locks, and it already happens for FOR UPDATE (at least if the row actually ... 19 May 2010 00:42