[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 it. I can use

[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

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 that mean it's simply impossible

[GENERAL] Changing column type from oid to int4

' 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)--- TIP 4: Don't 'kill -9

Re: [GENERAL] pg_xlog question

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] foreign keys constraints, depending on each other

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

[GENERAL] strange query plan

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 KPNQwest Austria GmbH Senior Engineer Web

Re: [GENERAL] pg_dumpall - fails

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 Weilguni KPNQwest Austria GmbH