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 arch

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. ( http://archives.postgresql.org/pgsql-bug

[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 h

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. ( > http://archives.postgr

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. ( http://arch

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 fu

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 co