[GENERAL] PostgreSQL Database cluster with multiple different locale settings?

Is it possible to have a database cluster with one database being UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)? I checked a lot, and currently I found only the initdb way to influence --lc-ctype and --lc-collate Thanks! Mario ---(end of broadcast

Re: [GENERAL] PostgreSQL Database cluster with multiple different locale settings?

Am Freitag, 15. April 2005 17:57 schrieb Peter Eisentraut: > Mario Weilguni wrote: > > Is it possible to have a database cluster with one database being > > UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)? > > No, sorry. Thanks for the reply. Does

[GENERAL] How to modify a tuple returned by SPI_copytuple?

I checked the documentation, and still do not get it. I can use SPI_copytuple to return a modified version of a tuple, but how do I modify a structure of type HeapTuple. In my case, I just want to modify a INT32 column for sorting. Any ideas? Regards, Mario Weilguni

Re: [GENERAL] How to modify a tuple returned by SPI_copytuple?

Hello, for sure, I'm just did not find this function. Thanks alot. Best regards, Mario Am Montag, 19. September 2005 15:20 schrieb Michael Fuhr: > On Mon, Sep 19, 2005 at 08:01:55AM +0200, Mario Weilguni wrote: > > I checked the documentation, and still do not get

[GENERAL] Changing column type from oid to int4

='whatever' and attrelid=(select oid from pg_class where relname='a_table_name'); It seems to work fine, but I was not sure so I rolled back the change. So, has anyone ever tried this? Regards, Mario Weilguni ---(end of broadcast)

Re: [GENERAL] foreign keys constraints, depending on each other

some arabic countries. -- === Mario Weilguni                 KPNQwest Austria GmbH  Senior Engineer Web Solutions Nikolaiplatz 4  tel: +43-316-813824        8020 graz, austria  fax: +43-3

Re: [GENERAL] pg_xlog question

eless, because a failover will take place when there's an error, so the extra sync of pg_xlog is very likely to fail. Regards, Mario Weilguni ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] pg_dumpall -> fails

I'm just guessing, but it is possible that you're using different versions of pg_dump and postmaster? I had a similar problem when I had an old 7.0 binary lying around in /usr/bin/ when trying to dump a 7.1 database. -- === Mario Weilgun

[GENERAL] strange query plan

s it would be much cheaper to consult the index to get min(), max(), sum() and avg() instead of sequentially scanning ~500MB of data. Any idea? Thanks Best regards, Mario Weilguni -- ======= Mario Weilguni                 KPNQ