Re: [ADMIN] LATIN2 encoding and Polish_Poland locale

2010-03-01 Thread Andrzej Angowski
Peter, The following actually works: >createdb -E LATIN2 -l Polish_Poland.28592 test Thanks a lot! 2010/3/1 Jan-Peter Seifert : > Hello Andrzej, > > try this: > > Identify the code page Windows is using for LATIN2 with the PostgreSQL tool > pg_controldata (8.2 server's version). Look for the n

[ADMIN] severely wierd problem & PgSQL log analyzer

2010-03-01 Thread Achilleas Mantzios
Hi, i am facing a very wierd situation, a piece of java code seems correct, however *some* times a connection instead of being rollbacked gets commited. (which has driven me nuts). So what i did, is replicate the problem with full logging enabled from java, in order to know at any point in the co

Re: [ADMIN] LATIN2 encoding and Polish_Poland locale

2010-03-01 Thread Jan-Peter Seifert
Hello Andrzej, try this: Identify the code page Windows is using for LATIN2 with the PostgreSQL tool pg_controldata (8.2 server's version). Look for the number following the dot in LC_COLLATE / LC_TYPE. For LATIN1 it's 28591. Try creating the database for 8.4 with the PostgreSQL tool createdb

Re: [ADMIN] vacuum deadlock

2010-03-01 Thread Ibrahim Harrani
Hi, Yes, I am trying to full vacuum. I think, I found the problem. There were more then 10 million records which my scripts trying to delete at night from a table while other processes were adding new entries to same table. Delete can't finish in the day, and script tries to delete the table ag