Re: [HACKERS] msg translation into sk_SK, Docs: SGML - XML

2004-01-29 Thread Karel Zak
On Thu, Jan 29, 2004 at 08:29:14AM +0100, BARTKO, Zoltan wrote: I would like to take up the translation of pgsql msg strings into slovak (sk_SK). It is fairly similar to czech (cz_CZ), so it should go quite fast. Please stand up, if you have any objections. If you don't want to waste

[HACKERS] Proposed dirmod.c fix for Win32

2004-01-29 Thread Claudio Natoli
The current version of dirmod.c causes a compilation failure under MingW: ../../../src/port/libpgport.a(dirmod.o.b)(.text+0xe1): In function `pgrename': e:/cygwin/opt/diff8c/pgsql/src/port/dirmod.c:38: undefined reference to `errstart'

Re: [HACKERS] Question about indexes

2004-01-29 Thread lnd
A small comment on Oracle's implementation of persistent bitmap indexes: Oracle's bitmap index is concurently locked by DML, i.e. it suites for OLAP (basically read only data warehouses) but in no way for OLTP. IMHO, Laimis Maybe the lack of heap/btree consistent ordering in Oracle and

Re: [HACKERS] Disaster!

2004-01-29 Thread Christoph Haller
Tom Lane wrote: I said: If there wasn't disk space enough to hold the clog page, the checkpoint attempt should have failed. So it may be that allowing a short read in slru.c would be patching the symptom of a bug that is really elsewhere. After more staring at the code, I have

Re: [HACKERS] Disaster!

2004-01-29 Thread Tom Lane
Christoph Haller [EMAIL PROTECTED] writes: Tom was referring to close(), not fclose(). I once had an awful time searching for a memory leak caused by a typo using close instead of fclose. So adding checks for both is probably a good idea. Already done. regards,

Re: [HACKERS] Getting the results columns before execution

2004-01-29 Thread Jan Wieck
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: Are those exposed through the libpq interface? No, because libpq doesn't really have any concept of prepared statements. It would probably make sense to add some more API to libpq to allow creation and interrogation of

Re: [HACKERS] returning PGresult as xml

2004-01-29 Thread Peter Eisentraut
Andrew Dunstan wrote: Peter: this looks very nice. What are your intentions with this code? Once we figure out how to handle the on-the-wire character set recoding when faced with XML documents (see separate thread a few weeks ago), I would like to finish it. Put it in contrib? Also, do you

[HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Marc G. Fournier
http://www.postgresql.org/docs/7.3/static/transaction-iso.html#XACT-READ-COMMITTED Reading this: BEGIN; UPDATE accounts SET balance = balance + 100.00 WHERE acctnum = 12345; UPDATE accounts SET balance = balance - 100.00 WHERE acctnum = 7534; COMMIT; If two such transactions concurrently

Re: [HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Jeroen T. Vermeulen
On Thu, Jan 29, 2004 at 01:33:48PM -0400, Marc G. Fournier wrote: What happens if I abort on the first transaction? If I'm reading this Doesn't matter, because your second transaction doesn't read any of the changes you're making there--until (and if) that first one commits. The second

Re: [HACKERS] msg translation into sk_SK, Docs: SGML - XML

2004-01-29 Thread Peter Eisentraut
Karel Zak wrote: On Thu, Jan 29, 2004 at 08:29:14AM +0100, BARTKO, Zoltan wrote: I would like to take up the translation of pgsql msg strings into slovak (sk_SK). It is fairly similar to czech (cz_CZ), so it should go quite fast. Please stand up, if you have any objections. If you

Re: [HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Jeroen T. Vermeulen
On Thu, Jan 29, 2004 at 06:54:21PM +0100, Jeroen T. Vermeulen wrote: On Thu, Jan 29, 2004 at 01:33:48PM -0400, Marc G. Fournier wrote: What happens if I abort on the first transaction? If I'm reading this AFAICS the part about not having inconsistencies refers only to the spectre of

Re: [HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Chris Bowlby
Would this not create the potention for a dead lock if transaction1 is never completed, and still active for an indefinate period of time? On Thu, 2004-01-29 at 14:06, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: What happens if I abort on the first transaction? If I'm reading

Re: [HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Tom Lane
Chris Bowlby [EMAIL PROTECTED] writes: Would this not create the potention for a dead lock if transaction1 is never completed, and still active for an indefinate period of time? If trans1 later waits (directly or indirectly) for trans2, we'll detect the deadlock and abort one xact or the other

Re: [HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Jeroen T. Vermeulen
On Thu, Jan 29, 2004 at 02:07:25PM -0400, Marc G. Fournier wrote: If two such transactions concurrently try to change the balance of account 12345, we clearly want the second transaction to start from the updated version of the account's row To me, I read this as the first transaction has

Re: [HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Marc G. Fournier
On Thu, 29 Jan 2004, Jeroen T. Vermeulen wrote: On Thu, Jan 29, 2004 at 02:07:25PM -0400, Marc G. Fournier wrote: If two such transactions concurrently try to change the balance of account 12345, we clearly want the second transaction to start from the updated version of the account's

Re: [HACKERS] postgresql.org reverse lookup fail

2004-01-29 Thread Marc G. Fournier
Thank you Tatsuo, the problem with reverse DNS has been fixed, and I've tested that powergrew.sra.co.jp once more works, and have re-enabled it. Please let me know of any other problems in the future ... On Wed, 28 Jan 2004, Tatsuo Ishii wrote: Hi, We have serious problems past 4 days in

[HACKERS] Problem with pgtcl on HP

2004-01-29 Thread Michael Brusser
Just want to share in case you want to make a change in the code, or perhaps tell us that we didn't do the right thing. At some point we needed to add -DTCL_THREADS and -D_REENTRANT to the makefiles and then we ran into a problem with pgtcl library. This seems to be HP specific (HP-11) and

Re: [HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: Marc G. Fournier [EMAIL PROTECTED] writes: What happens if I abort on the first transaction? If I'm reading this right, if Trans2 does the exact same as above, and COMMITs before Trans1 Aborts, the value of balance becomes +200 (Trans2 + Trans1) ... but

Re: [HACKERS] Disaster!

2004-01-29 Thread Jeroen Ruigrok/asmodai
-On [20040125 03:52], Tom Lane ([EMAIL PROTECTED]) wrote: Hm, okay, I'm pretty sure that that combination wouldn't report ENOSPC at close(). From Tru64's write(2): [ENOSPC] [XSH4.2] No free space is left on the file system containing the file. [Tru64 UNIX] An attempt was made