Re: [HACKERS] No mail?

2004-07-28 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Marc G. Fournier wrote: | | all fixed ... had a kernel panic this morning, and fsck took a while to | run ... Also news.fr.postgresql.org it seems down since yesterday. Regards Gaeatano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4

Re: [HACKERS] Cannot initdb in cvs tip

2004-07-28 Thread Bruce Momjian
Dave, now that we are nearing beta, I think we need to correct the initdb problem with removing the directory on Win32. Would you code this up as something that sits in /port/dirmod.c and have both initdb and DROP DATABASE call the C routine rather than call rm -r/rmdir? (I think those are the

Re: [HACKERS] Cannot initdb in cvs tip

2004-07-28 Thread Dave Page
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 28 July 2004 09:29 To: Dave Page Cc: Tom Lane; PostgreSQL-development; [EMAIL PROTECTED] Subject: Re: [HACKERS] Cannot initdb in cvs tip Dave, now that we are nearing beta, I think we need to correct

Re: [HACKERS] Cannot initdb in cvs tip

2004-07-28 Thread Andrew Dunstan
Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 28 July 2004 09:29 To: Dave Page Cc: Tom Lane; PostgreSQL-development; [EMAIL PROTECTED] Subject: Re: [HACKERS] Cannot initdb in cvs tip Dave, now that we are nearing beta, I think we need to

Re: [HACKERS] [BUGS] casting strings to multidimensional arrays yields strange results

2004-07-28 Thread Tom Lane
[ cc'ing pghackers in case anyone wants to object ] Joe Conway [EMAIL PROTECTED] writes: Tom Lane wrote: Right now I think the sanest behavior would be to throw an error on non-rectangular input. Once we have support for null elements in arrays, however, it would arguably be reasonable to

Re: [HACKERS] Cannot initdb in cvs tip

2004-07-28 Thread Andrew Dunstan
Bruce Momjian wrote: Dave, now that we are nearing beta, I think we need to correct the initdb problem with removing the directory on Win32. Would you code this up as something that sits in /port/dirmod.c and have both initdb and DROP DATABASE call the C routine rather than call rm -r/rmdir? (I

Re: [HACKERS] Cannot initdb in cvs tip

2004-07-28 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: The small wrinkle here is that rmtree needs to make a copy of the file names before it starts removing things. In the backend case that means calling palloc() and friends - am I correct in assuming it is reasonable to do this in whatever context

Re: [HACKERS] Cannot initdb in cvs tip

2004-07-28 Thread Bruce Momjian
Andrew Dunstan wrote: I wanted to keep a solution that was as native to the OS as possible, but because we can't do that on Win32 and few people like the unix system call to 'rm', it is time to clean it up. One question --- why is there a sleep loop needed for unlink in your patch?

Re: [HACKERS] Point in Time Recovery

2004-07-28 Thread Bruce Momjian
We need someone to code two backend functions to complete PITR. The function would be called at start/stop of backup of the data directory. The functions would be checked during restore to make sure the requested xid is not between the start/stop xids of the backup. They would also contain

Re: [HACKERS] Point in Time Recovery

2004-07-28 Thread Bruce Momjian
Oh, here is something else we need to add --- a GUC to control whether pg_xlog is clean on recovery start. --- Tom Lane wrote: Bruce and I had another phone chat about the problems that can ensue if you restore a tar

Re: [ADMIN] [HACKERS] Point in Time Recovery

2004-07-28 Thread Bruce Momjian
[ Sorry, sent to hackers now.] Here is another open PITR issue that I think will have to be addressed in 7.6. If you do a critical transaction, but do nothing else for eight hours, that critical transaction hasn't been archived yet. It is still sitting in pg_xlog until the WAL file fills. I

[HACKERS] try/catch macros for Postgres backend

2004-07-28 Thread Tom Lane
In service of the refactoring of error handling that I was talking about a few days ago, I'm finding that there are several places that really ought to catch longjmps and clean up after themselves, instead of expecting that whatever mess they've made will be cleaned up for them when control gets

Re: [HACKERS] try/catch macros for Postgres backend

2004-07-28 Thread Gavin Sherry
On Wed, 28 Jul 2004, Tom Lane wrote: In service of the refactoring of error handling that I was talking about a few days ago, I'm finding that there are several places that really ought to catch longjmps and clean up after themselves, instead of expecting that whatever mess they've made will

Re: [HACKERS] try/catch macros for Postgres backend

2004-07-28 Thread Alvaro Herrera Munoz
On Wed, Jul 28, 2004 at 08:19:17PM -0400, Tom Lane wrote: Very cool and interesting idea. Does anyone have a problem with this macro syntax? The try/catch names are stolen from Java, so I'm figuring they won't terribly surprise any modern programmer, but I'm open to different names if anyone

[HACKERS] 7.5 devel initdb failure

2004-07-28 Thread Coloring Graph
I am download the 7.5 devel installer version, when I try install in win2000, I encountered a error, the below is the log: = The files belonging to this database system will be owned by user "postgres".This user must also own the server process. The

Re: [HACKERS] try/catch macros for Postgres backend

2004-07-28 Thread Fabien COELHO
Does anyone have a problem with this macro syntax? The try/catch names are stolen from Java, so I'm figuring they won't terribly surprise any modern programmer, but I'm open to different names if anyone has a better idea. I have done such a macro hiding of setjmp/longjmp for a math library