[GENERAL] Postgres cluster

Hi. I'm looking for a somewhat standardized means of configuring a cluster of postgres nodes for better performance and availability. I have a SAN available for data storage. Can this be done? Thanks, Morten ---(end of broadcast)--- TIP 4:

[GENERAL] Unicode database on non-unicode operating system

r(mycolumn)); ERROR: could not convert UTF-8 character 0x00e2 to ISO8859-1 I had a lot of data in the table before creating this index, and apparently one of the rows contained unicode character U+00E2 - which is latin small letter a with circumflex = â. This is a perfectly legal latin1-character (as any Unicode character below U+0100 is). My second question is then, why did it fail to convert this character to latin1? Thanks in advance for any help Regards, Morten Barklund Head of Development TBWA\

Re: [GENERAL] Unicode database on non-unicode operating system

created WITH ENCODING 'unicode', it is in fact "broken" as the locale does not fully support unicode string handling? I wanted to use Unicode, as I expected non-latin1 characters, but this actually means, that if I had any such, some string functions would not work at al

Re: [GENERAL] Unicode database on non-unicode operating system

Hi Peter, Thank you once again. That cleared up a lot of confusion for me and my co-workers and the next server set up will be with unicode and en_DK.utf8 to ensure consistency. Regards, Morten Barklund -Original Message- From: Peter Eisentraut [mailto:[EMAIL PROTECTED] Sent

[GENERAL] Re: Problems w. SERIAL

x 'tbl_c_a_key' for table 'tbl_c' NOTICE: CREATE TABLE/UNIQUE will create implicit index 'tbl_c_b_key' for table 'tbl_c' NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) CREATE Thanks for the tip, I'll consider this a bug and doub

Re: [GENERAL] ER diagram generator

e, only I haven't been able to make it run yet.. Working on that :) Thanks again, Morten ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[GENERAL] subselect, order by and left join

AS a LEFT JOIN content AS b ON a.object_id=b.id WHERE (b.onair = 't') LIMIT 1; Thanks, Morten -- Morten K. Poulsen <[EMAIL PROTECTED]> http://www.afdelingp.dk/ ---(end of broadcast)--- TIP 5: Have you checked our extensive

[GENERAL] subselect, order by and left join

index DESC) AS a LEFT JOIN content AS b ON a.object_id=b.id WHERE (b.onair = 't') LIMIT 1; Thanks, Morten -- Morten K. Poulsen <[EMAIL PROTECTED]> http://www.afdelingp.dk/ ---(end of broadcast)--- TIP 2: you can get off all lists a

Re: [GENERAL] subselect, order by and left join

ou have no guarantees as to the output order unless you have another > order by. The join may destroy the ordering, so even if you get the ordering > you want right now, you shouldn't rely on it. OK. Thanks for the reply. Morten -- Morten K. Poulsen <[EMA

[GENERAL] How to dump from Postgre

How do you dump from the Postgre database? (i.e. as with MySQL, where you have mysqldump) -Morten

Re: [GENERAL] How to dump from Postgre

> The PostgreSQL documentation is invisible? Yeah, it just vanished. Not my fault. The bitbucket ate it. -Morten =)

[GENERAL] How to lock a table

We're trying to use a unique-identifier scheme in a database; and therefore we need to put a lock on a table. Is there some way to do this using the PyGres (python) adapter? -Morten - How to reply to email: http://home.s

[GENERAL] Is level a reserved keyword?

atabases of the same version, both the psql client, and the pg python adapter complains near the word "level". Any ideas? Seems like a bug? Regards, Morten - How to reply to email: http://home.sol.no/~vidaandr/news/OBSquoting.htm

[GENERAL]

Hiya guys I'm having a problem with a PostgreSQL backend, the problem being that the backend can die, from the simplest queries. I'm wondering if this can be the sympthom of a corrupted database, or just a buggy version of Postgre. -Morten

Re: [GENERAL]

abase adapter on the machine that is working is at 3.0, while the one that isn't is at 3.0 beta. Hmm. Anyways, if you guys have any ideas I'd appreciate to hear about them. -Morten

Re: [GENERAL]

NOTICE: Rel inmail: Uninitialized page 433 - fixing I got this message trying to vacuum the DB. Can this be the problem? If so, does anyone know why this may be happening? -Morten

[GENERAL] Can PostgreSQL be a mail backend?

(How is the support for big data fields now BTW?) Thanks, Morten

Re: [GENERAL] Migrating from mysql.

on the PostgreSQL and such. Pointers to documents, HOWTOs etc. are much appreciated. -Morten