Re: [BUGS] BUG #2386: pg_restore doesn't restore large objects

2006-04-17 Thread Patrick Headley
Andreas, I had another opportunity to do a restore for a client today. Both restore attempts that I'll be describing were to a remote Mac OS X machine with PostgreSQL 8.0.7 installed. Knowing that it wasn't going to work using PGAdmin III, I went directly to a command window on the machine with P

Re: Permission denied on fsync / Win32 (was [BUGS] right

2006-04-17 Thread Peter Brant
The error messages refer to the old relfilenode (in 3 out of 3 occurrences today). Pete >>> Tom Lane <[EMAIL PROTECTED]> 04/14/06 2:41 am >>> OK ... but what's still unclear is whether the failures are occurring against the old relfilenode (the one just removed by the CLUSTER) or the new one just

[BUGS] [Win32] Problem with rename()

2006-04-17 Thread Peter Brant
Hi all, In the last couple of days, we've been bitten (a couple of times, on different servers) by an apparent glitch or bad interaction in the Windows implementation of rename(). The relevant log message is: [2006-04-17 16:49:22.583 ] 2252 LOG: could not rename file "pg_xlog/0001010A00

[BUGS] BUG #2399: Postgis DLL corrupted

2006-04-17 Thread Alvaro
The following bug has been logged online: Bug reference: 2399 Logged by: Alvaro Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3-1 Operating system: Windows Description:Postgis DLL corrupted Details: Hello, I'm from Argentina. I've downloaded twice from di

[BUGS] syntax error

2006-04-17 Thread Roberto Castro
  Boa Tarde !! Numa aplicação, de acordo com o btnbotton clicado, a variável ‘opçao’ receberá um valor. No decorrer do processo, de acordo com a ‘opcao’ deverá executar um comando da function onde os valores a serem adicionados (input) serão supridos na aplicação.Só que dá o seguinte erro:ERROR: 

Re: [BUGS] [EMAIL PROTECTED]: BUG in logs]

2006-04-17 Thread Bruce Momjian
I have looked at this behavior, which indeed is new for 8.1. The change was caused by code I think I did to improve the behavior of log_statement, specifically streamlining how we check for the type of command. In looking at reverting to the 8.0 behavior of logging error commands with 'all', I s

Re: [BUGS] [Win32] Problem with rename()

2006-04-17 Thread Bruce Momjian
Peter Brant wrote: > Hi all, > > In the last couple of days, we've been bitten (a couple of times, on > different servers) by an apparent glitch or bad interaction in the > Windows implementation of rename(). > > The relevant log message is: > > [2006-04-17 16:49:22.583 ] 2252 LOG: could not re

Re: [BUGS] [Win32] Problem with rename()

2006-04-17 Thread Qingqing Zhou
""Peter Brant"" <[EMAIL PROTECTED]> > > In the last couple of days, we've been bitten (a couple of times, on > different servers) by an apparent glitch or bad interaction in the > Windows implementation of rename(). > > The relevant log message is: > > [2006-04-17 16:49:22.583 ] 2252 LOG: could n

Re: [BUGS] syntax error

2006-04-17 Thread Euler Taveira de Oliveira
Roberto Castro wrote: Numa aplicação, de acordo com o btnbotton clicado, a variável ‘opçao’ receberá um valor. No decorrer do processo, de acordo com a ‘opcao’ deverá executar um comando da function onde os valores a serem adicionados (input) serão supridos na aplicação. Envie somente *bugs*