[HACKERS] ORDER BY different locales for 8.0

ED]> ftp://ftp2.zf.jcu.cz/users/zakkr/pg/ -- -------- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ... Only self-confident people can be si

Re: [HACKERS] Does psql use nested transactions?

exception you get, _continuing_ with your transaction. This way, large part of the application logic is shifted to the server and to the database schema. The client just tries if the command will run OK. -- ---- Honza Pazdziora |

Re: [HACKERS] Does psql use nested transactions?

, do update of the existing record It should be upto the application to decide if the failed insert should lead to abortion of the transaction, or if it should be silently ignored and based on the return value of the insert proceed with update. -- ---

Re: [HACKERS] Nested Transaction TODO list

or OTHERS. -- ---- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ... Only self-confident people can be simple. ---(end of

Re: [HACKERS] Adding VERSION to startup log output

mpt. Will the version information in log break anything? -- -------- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...

Re: [HACKERS] Improving postgresql.conf

pecifying datadirectory in the configuration file, or even defaulting to the same directory where the .conf file is stored when no datadirectory option is used. -- -------- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/

Re: [HACKERS] Improving postgresql.conf

ewhere else and in it the location of the data directory is specified. It does not mandate there will only be one cluster and it does not mean that each cluster cannot have completely different configuration file. -- ---- Honza

Re: [HACKERS] Refined LC_COLLATE or multiple database clusters?

ion instructions can be found at http://www.fi.muni.cz/~adelton/l10n/ -- ---- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI, Oracle, large Web s

Re: [HACKERS] PostgreSQL configuration

each and every setting in :-) I never used that "feature" so was never bitten by it. Anyway, Apache HTTP server seems to do it the right way, doesn't it? -- ---- Honza Pazdziora | [EMAIL PROTECTED] | http://w

Re: [HACKERS] PostgreSQL configuration

f configuration, or separate them in any way. -- -------- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ... Only self-confident people can be simple. ---(end of

Re: [HACKERS] locale

shouldn't it make elementary checks (upon startup, perhaps) that the current locale settings and the current locale version produces results compatible with the existing indexes? And if it does not, reindex? -- ---- Honza P

[HACKERS] Arbitrary collation support for PostgreSQL

distribution. I'd appreciate comments about the viability of the goal, name, and / or solution presented. Yours, -- -------- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI,