Discussions - pgsql.general

	Client Encoding and Latin characters
	My database is encoded UTF8. I recently was uploading (via COPY) some census data which included place names with ñ, é, ü, and other such characters. The upload choked on the Latin characters. Following the docs, I was able to fix this with: SET CLIENT_ENCODING TO 'LATIN1'; COPY table FROM 'filename';... more » By Lee Hachadoorian - 11:39am - 3 new of 3 messages

	[BUGS] BUG #5211: invalid password
	...This is not a bug, so I'm redirecting to the pgsql-general list, where it belongs. :) Change your pg_hba.conf to allow "trust" auth from localhost, restart the server, use the ALTER USER command to change the password to something else, change pg_hba.conf back, then restart the server again. Cheers,... more » By David Fetter - 7:48am - 1 new of 1 message

	Partitioning table and dynamic SQL in trigger
	In our DB we create partition table for each month (our naming convetion is follow , and I would like to create trigger that insert data to appropriate partition table accounting.cdr_y2009m05, accounting.cdr_y2009m06 etc..). What is the best solution to create such trigger? I can create trigger function as follow:... more » By Michal Szymanski - 7:22am - 1 new of 1 message

	[COMMITTERS] recover deleted records
	Hello Have you enabled autovacuum? Pavel p.s. please, don't use pgsql-commiters mailing list for general questions. use pgsql-general. 2009/11/24 Allan Morris Caras <amsca...@yahoo.com>: By Pavel Stehule - 5:14am - 3 new of 3 messages

	無料サイトが会えない理由。それは・・・
	会┃え┃る┃無┃料┃サ┃イ┃ト┃は┃ ━┛━┛━┛━┛━┛━┛━┛━┛━┛ コ┃コ┃が┃違┃う┃！┃ ━┛━┛━┛━┛━┛━┛ 全国には多数の無料サイトが御座います。会えた事が御座いますか？連絡先、携帯番号や直アドレスの交換... more » By shenghu...@126.com - 3:32am - 1 new of 1 message

	How identify a long running transaction
	Using 8.4.1. How can I 1) Get the transaction id of the oldest serializable transaction and the next transaction? 2) A list of all active transactions I have searched the docs and tried Google but I must not be using the right terminology. Also, am I correct in assuming that vacuuming is not blocked by a long... more » By Bill Todd - Nov 23 - 1 new of 1 message

	Multicolumn index including tsvector.
	Hi everyone, In the documentation and past messages to this list, it sounds like the btree_gist and btree_gin modules included in contrib/ in 8.4 should give me the functionality I'm looking for, but I don't seem to be getting the behavior I want. I've made an example table representing something like a simplified version... more » By Kris Gale - Nov 23 - 4 new of 4 messages

	get a log of queries that take up a lot of CPU or take a very long time.
	Is there a way I can get a list of the top 10 longest running queries for the day/week/month or the top 10 queries that took the most CPU? select * from pg_stat_activity only shows the current status. By Tim Uckun - Nov 23 - 2 new of 2 messages

I need help creating a composite type with some sort of constraints.

I can create one or more domains, and use those to create the composite type from. But each domain can only be constrained in its own value, I can't constrain element #1's value based on what element ...If I create a domain from a composite, it will complain with a "ERROR: cdt.instant_message is not a valid base type for a domain" error.... more »

By John Oyler - Nov 23 - 2 new of 2 messages

C++ and Postgis

Hi All, First off sorry for cross-posting. I'm hoping for a bigger audience... :] As for my question: How does one deal with Postgis geom fields in C++ ? Google hasn't offered much help so far. I know I can make a "SELECT astext(my_geom) FROM my_table" and after parsing the resulting text. This seems a bit awkward and time-consuming...... more »

By Pedro Doria Meunier - Nov 23 - 3 new of 3 messages