Re: [HACKERS] Time to move on...
Neil Conway wrote: Lamar Owen [EMAIL PROTECTED] writes: On Saturday 16 November 2002 01:07, Christopher Kings-Lynne wrote: OK sorry - I was under the impression that core == commit bit... committers != core Is there any reason for this distinction? I assume you are asking why there is core? It is really just for getting a quick vote among folks for final release date, and for discussing things with individuals and companies who require a private conversation among PostgreSQL representatives. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] RI_FKey_check: foreign key constraint blocks parall
void
heap_mark4fk_lock_acquire(Relation relation, HeapTuple tuple) {
Just wonder how are you going to implement it - is it by using
some kind of read-locks, ie FK transaction locks PK to prevent
delete (this is known as pessimistic approach)?
About two years ago we discussed with Jan optimistic approach
with using dirty reads, when PK/FK transactions do not check
existence of FK/PK untill constraint should be checked (after
statement processed for immediate mode, at the commit time/
set constraint immediate for deferred constraints).
So, at the check time, FK transaction uses dirty reads to know
about existence/status of PK:
1. No PK - abort.
2. PK (inserted?/)deleted/updated/selected for update by concurrent
transaction P - wait for P commit/abort (just like transactions do
for concurrent same-row-update); go to 1.
3. Else (PK exists and no one changing it right now) - proceed.
PK transaction does the same:
1. No FK - proceed.
2. FK inserted/updated/selected for update by concurrent transaction
F - wait for F commit/abort; go to 1.
This would be more in MVCC style -:)
Vadim
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Proposal of hierachical queries (a la Oracle)
Ok, full section would be very helpful, i don't have it. --- .evgen On 15 Nov 2002, Rod Taylor wrote: On Thu, 2002-11-14 at 06:52, Evgen Potemkin wrote: Hi there! I want to propose the patch for adding the hierarchical queries posibility. It allows to construct queries a la Oracle for ex: SELECT a,b FROM t CONNECT BY a PRIOR b START WITH cond;B Great addition. But please use the SQL 99 syntax for recursive queries (if you need the full segment, I can send them to you): Section 7.13 of Part 2: ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] pg_dump in 7.4
At 11:43 AM 15/11/2002 -0500, Rod Taylor wrote: Below is a summary of what pg_depend tracks that might be useful. This looks excellent. If people are happy with my earlier outline, it should be reasonably easy to proceed... Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.B.N. 75 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61) 03 5330 3172 | ___ | Http://www.rhyme.com.au |/ \| |---- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] Missing file from CVS?
All, I've just tried to build the Win32 components under Visual Studio's C++ compiler from the win32.mak CVS archive at :pserver:[EMAIL PROTECTED]:/projects/cvsroot and found that the following file was missing; src\bin\psql\sql_help.h I've copied the file from the the source tree of version 7.2.3 and the compile works with out any problems. Should the file be in CVS? Al. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] RC1 packaged and available ...
It looks okay from here ... I'll put out a notice later this evening if nobody sees anything wrong with it ... ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Where can I find a list of the new features appearing
From the /HISTORY file in the tarball. --- My Deja wrote: Where can I find a list of the new features appearing in Postgresql 7.3? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] [CYGWIN] ipc-daemon
We normally don't go into that much detail in the FAQ unless someone is seeing that problem case a lot. --- Richard Pais wrote: Just an explanation in the FAQ that the ipc-daemon is not running won't suffice. Because in my case I had ipc-daemon (version 1.11) running and it still hung (Jason's patch reported the IpcMemoryCreate error). Only when I downgraded to version 1.09 (office) and upgraded to 1.13 (home) did initdb succeed. So I'd suggest also covering this scenario. Thanks, Richard Bruce Momjian [EMAIL PROTECTED] wrote: At least that is an FAQ item. --- Jason Tishler wrote: Tom, Peter, On Mon, Nov 04, 2002 at 03:05:25PM -0500, Jason Tishler wrote: On Mon, Nov 04, 2002 at 02:43:01PM -0500, Tom Lane wrote: If you can detect that cygipc is not running, then ENOSYS seems the best choice for reporting that. (ENOSPC would be misleading too.) Thanks for your feedback. I will take this to the Cygwin list and see what happens. I happy to report that the above has been accomplished: http://cygwin.com/ml/cygwin-announce/2002-11/msg00025.html Hopefully, the Cygwin initdb and postmaster hang posts will be a thing of the past. Unfortunately, they probably will be replaced by questions like: Why does initdb fail with IpcMemoryCreate: shmget(...) failed: Function not implemented? Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html - Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Missing file from CVS?
Al Sutton wrote: All, I've just tried to build the Win32 components under Visual Studio's C++ compiler from the win32.mak CVS archive at :pserver:[EMAIL PROTECTED]:/projects/cvsroot and found that the following file was missing; src\bin\psql\sql_help.h I've copied the file from the the source tree of version 7.2.3 and the compile works with out any problems. Should the file be in CVS? I'm not seeing a problem here with cvs tip and VS .Net's C++, although I am now getting a few pedantic warnings that I wasn't seeing a few weeks ago. Where exactly are you getting an error? Joe p.s. here's my output: C:\Documents and Settings\jconway\My Documents\Visual Studio Projects\pgsql\srcnmake -f win32.mak Microsoft (R) Program Maintenance Utility Version 7.00.9466 Copyright (C) Microsoft Corporation. All rights reserved. cd include if not exist pg_config.h copy pg_config.h.win32 pg_config.h 1 file(s) copied. cd .. cd interfaces\libpq nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 7.00.9466 Copyright (C) Microsoft Corporation. All rights reserved. Building the Win32 static library... if not exist .\Release/ mkdir .\Release cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1A.tmp dllist.c cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1B.tmp md5.c cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1C.tmp wchar.c cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1D.tmp encnames.c cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1E.tmp win32.c fe-auth.c fe-connect.c fe-exec.c fe-lobj.c fe-misc.c fe-print.c fe-secure.c pqexpbuffer.c link.exe -lib @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1F.tmp cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm20.tmp libpqdll.c rc.exe /l 0x409 /fo.\Release\libpq.res libpq.rc link.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm21.tmp Creating library .\Release\libpqdll.lib and object .\Release\libpqdll.exp cd ..\..\bin\psql nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 7.00.9466 Copyright (C) Microsoft Corporation. All rights reserved. if not exist .\Release/ mkdir .\Release cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm27.tmp getopt.c cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm28.tmp command.c command.c(497) : warning C4244: 'function' : conversion from 'unsigned short' to 'bool', possible loss of data common.c help.c help.c(166) : warning C4244: 'function' : conversion from 'unsigned short' to 'bool', possible loss of data input.c stringutils.c mainloop.c copy.c startup.c prompt.c sprompt.c variables.c large_obj.c print.c print.c(1009) : warning C4244: 'function' : conversion from 'const unsigned short' to 'bool', possible loss of data describe.c tab-complete.c mbprint.c link.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm29.tmp cd ..\.. echo All Win32 parts have been built! All Win32 parts have been built! ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
