Re: [BUGS] pg_restore problem

2006-05-31 Thread Harco de Hilster
I had similar problems with the tar format. 3 smaller databases worked, the biggest did not. Switching to -Fc fixed it for me. Sorry for not reporting this. Harco Tom Lane wrote: Michael Andreasen [EMAIL PROTECTED] writes: pg_dump -Ft $db | bzip2 $db.dump.tbz ... pg_restore: [tar

Re: [BUGS] reindexdb command utlility

2006-05-31 Thread Henrik Zagerholm
31 maj 2006 kl. 03:47 skrev Euler Taveira de Oliveira: I used wanted to point out the the ( -q, --quiet ) parameter for reindexdb command utility does not work. Actually it is *not* a bug. The NOTICE is printed by the REINDEX command; reindexdb is just a wrapper around REINDEX command. If you

[BUGS] error starting service on win2k platform

2006-05-31 Thread Parang Saraf
Hey, I am trying to install the Postgreql 8.1.3 on the windows 2k platform. While installing I am getting the following error : Your local 'Power Users' group contains 'Authenticated Users' . This Error has been previously discussed in the mailing list. (

[BUGS] BUG #2460: bug on postgres crash recovery

2006-05-31 Thread raja chidambaram
The following bug has been logged online: Bug reference: 2460 Logged by: raja chidambaram Email address: [EMAIL PROTECTED] PostgreSQL version: postgres-7.5-3 Operating system: linux EL3 Description:bug on postgres crash recovery Details: the psqlodbc version 7.3-5

Re: [BUGS] error starting service on win2k platform

2006-05-31 Thread Magnus Hagander
Hey, I am trying to install the Postgreql 8.1.3 on the windows 2k platform. While installing I am getting the following error : Your local 'Power Users' group contains 'Authenticated Users' . This Error has been previously discussed in the mailing list. (

Re: [BUGS] error starting service on win2k platform

2006-05-31 Thread John R Pierce
Magnus Hagander wrote: Hey, I am trying to install the Postgreql 8.1.3 on the windows 2k platform. While installing I am getting the following error : Your local 'Power Users' group contains 'Authenticated Users' . This Error has been previously discussed in the mailing list. (

Re: [BUGS] Too many function calls in view with LEFT JOIN

2006-05-31 Thread Tom Lane
Andreas Heiduk [EMAIL PROTECTED] writes: But as far as I can tell both queries should always return the same results. So I don't understand why the STRICT does not matter in the first query but is necessary in the second one. Especially because the JOIN criterium is not affected by the

Re: [BUGS] reindexdb command utlility

2006-05-31 Thread Euler Taveira de Oliveira
Henrik Zagerholm wrote: You can always ignore NOTICE. grep is your friend. :-) True, but usually I like to have my ERROR messages to stderr and INFO to stdout. But it's not true in PostgreSQL. All ereport() messages are sent to stderr. In some scripts, the -e (echo) is used to print