Re: [BUGS] pg_upgrade issues

2010-06-18 Thread depstein
Another issue: 4. The --link option doesn't seem to work on Windows: pg_upgrade still copies data from the old cluster to the new. There doesn't appear to be a way to upgrade a database on Windows without copying the entire uncompressed database, which can be a problem where disk space is limit

[BUGS] pg_upgrade issues

2010-06-18 Thread depstein
PostgreSQL 9.0 beta 2 Windows XP Professional SP2 While migrating the database from 8.4 to 9.0 using pg_upgrade (now part of the Postgres project), the following issues came up: 1. When using the --logfile option, pg_upgrade quits with an error like this: The process cannot access the file beca

Re: [BUGS] BUG #5511: Handling of case in Username and database names are inconsistant.

2010-06-18 Thread Tom Lane
"Brett Sutton" writes: > Essentially if you peform: > create user Abc; > Postgres creates a user abc (as expected). Yeah, because *in the context of SQL* the standard mandates case-folding. But note that the actual user name here is "abc". Not "Abc". > The problem is that you cannot the use mix

[BUGS] odbc driver could not be loaded due to system error code 127

2010-06-18 Thread Praveen Upadhyaya (ZA)
Hi, Good Day I am trying to create a DSN for POSTGRESQL db. I have installed the package from psqlodbc_08_04_0200 I am getting the following error. Can you please help? odbc driver could not be loaded due to system error code 127 OS : Windows 2000 SP 4 Kind regards U Praveen Kumar Sr Domin

[BUGS] BUG #5511: Handling of case in Username and database names are inconsistant.

2010-06-18 Thread Brett Sutton
The following bug has been logged online: Bug reference: 5511 Logged by: Brett Sutton Email address: bsut...@noojee.com.au PostgreSQL version: 8.4.4 Operating system: Ubuntu 10.04 Description:Handling of case in Username and database names are inconsistant. Details:

[BUGS] BUG #5510: ODBC database 8.4.2 not working on windows 7 32 bit

2010-06-18 Thread Ravi
The following bug has been logged online: Bug reference: 5510 Logged by: Ravi Email address: surabi...@gmail.com PostgreSQL version: 8 Operating system: Windows 7 Description:ODBC database 8.4.2 not working on windows 7 32 bit Details: ODBC database 8.4.2 not workin

Re: [BUGS] BUG #5503: error in trigger function with dropped columns

2010-06-18 Thread Robert Haas
On Sun, Jun 13, 2010 at 7:20 PM, Maxim Boguk wrote: > I think changes in 9.0 now mask actual bug instead of fix it. If I was > wrong, still would be useful to know how to use return record from > trigger function in that case, because I can't make a working version > at all. Why do you think that