Re: [GENERAL] PostgreSQL 9.0 RPMs for RHEL 6 and Fedora 14 released

2010-11-21 Thread Allan Kamau
2010/11/14 Devrim GÜNDÜZ dev...@gunduz.org: I just released PostgreSQL 9.0 RPM for Red Hat Enterprise Linux 6 and Fedora 14, on both x86 and x86_64. Please note that 9.0 packages have a different layout as compared to previous ones. You may want to read this blog post about this first:

[GENERAL] finding rows with invalid characters

2010-11-21 Thread Sim Zacks
I am using PG 8.2.17 with UTF8 encoding. PostgreSQL 8.2.17 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 (Gentoo 4.1.1) One of my tables somehow has invalid characters in it: ERROR: invalid byte sequence for encoding UTF8: 0xa9 HINT: This error can also happen if the byte sequence

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Alban Hertroys
On 21 Nov 2010, at 24:17, Trevor Talbot wrote: I can't explain it any clearer, your email response goes to the mailing list and that mailing list sends a copy to the original person thats how a mailing list works. It also sends a copy to the forum which is parses you and that person and

Re: [GENERAL] shared data for different applications

2010-11-21 Thread Alban Hertroys
On 21 Nov 2010, at 5:08, Kent Tong wrote: Hi, Let's say that there is some data that should be logically shared by many applications in the company, such as some core information about its customers (name, address, contact info). In principle, such data should be stored in a DB for

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Trevor Talbot
On Sun, Nov 21, 2010 at 05:04, Alban Hertroys dal...@solfertje.student.utwente.nl wrote: On 21 Nov 2010, at 24:17, Trevor Talbot wrote: Elliot, Magnus wants forum-list email to come from a per-user address so that when he replies directly to that address (without sending it to the list), the

Re: [GENERAL] finding rows with invalid characters

2010-11-21 Thread Dmitriy Igrishin
Hey Sim, Maybe this helps: http://blog.tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_2.html 2010/11/21 Sim Zacks s...@compulab.co.il I am using PG 8.2.17 with UTF8 encoding. PostgreSQL 8.2.17 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 (Gentoo 4.1.1) One of my tables

Re: [GENERAL] SYSCONFDIR, initdb and postgresql.conf

2010-11-21 Thread Tom Lane
KM k...@xacrasis.netx writes: On an OpenBSD machine I just compiled and installed 9.0.1. The ./configure arguments included '--sysconfdir=/etc'. Running 'pg_config --sysconfdir' returns '/etc/postgresql'. The cluster is running and I can create a database and connect to it. However,

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Stuart McGraw
On 11/21/2010 06:04 AM, Alban Hertroys wrote: On 21 Nov 2010, at 24:17, Trevor Talbot wrote: I can't explain it any clearer, your email response goes to the mailing list and that mailing list sends a copy to the original person thats how a mailing list works. It also sends a copy to the

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Magnus Hagander
On Sun, Nov 21, 2010 at 18:12, Tom Lane t...@sss.pgh.pa.us wrote: Alban Hertroys dal...@solfertje.student.utwente.nl writes: I'm not one of the people who've been communicating off-list about this with him, so I may be wrong, but to my understanding what Magnus wants (the requirement, not a

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Tom Lane
Alban Hertroys dal...@solfertje.student.utwente.nl writes: I'm not one of the people who've been communicating off-list about this with him, so I may be wrong, but to my understanding what Magnus wants (the requirement, not a solution to it) is this: - Person A is on the forums and sends a

Re: [GENERAL] Fwd: [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Tom Lane
Elliot Chance elliotcha...@gmail.com writes: On 21/11/2010, at 2:41 AM, Tom Lane wrote: Elliot Chance elliotcha...@gmail.com writes: Then I can create a catch-all so that when an email is sent to forums-chan...@postgresql.com.au it finds the user chancey gets the real address and sends it

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Alban Hertroys
On 21 Nov 2010, at 16:16, Trevor Talbot wrote: I do see a difficulty here; if the forum software is only subscribed with one e-mail address, how is it going to distinguish between a reply-all and a private reply? Maybe it would help to subscribe it using two or three addresses, so that you

Fwd: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Elliot Chance
On 21/11/2010, at 2:59 AM, Bruce Momjian wrote: Magnus Hagander wrote: On Sat, Nov 20, 2010 at 14:46, Elliot Chance elliotcha...@gmail.com wrote: for...@postgresql.com.au is pointed to a black hole so that email disappears but the mailing list gets another copy. When the mailing list gets

Re: Fwd: [GENERAL] Postgres forums ... take 2

2010-11-21 Thread Magnus Hagander
On Sat, Nov 20, 2010 at 16:54, Bruce Momjian br...@momjian.us wrote: Elliot Chance wrote: Also, if someone registers on the forum, do they get a major domo registration email?  And if so, would this be set to receive no emails upon registration?  I'm not clear as to how this step would

Re: [GENERAL] SYSCONFDIR, initdb and postgresql.conf

2010-11-21 Thread KM
On 2010-11-21, Tom Lane t...@sss.pgh.pa.us wrote: SYSCONFDIR is only used for global configuration files, like the default psqlrc or pg_service.conf. OK, so it doesn't regard postgresql.conf and friends as conf files in that sense. It would be pretty inappropriate to put postgresql.conf there

Re: Fwd: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Joshua D. Drake
On Mon, 2010-11-22 at 10:40 +1100, Elliot Chance wrote: I would argue that if the person wants to use a forum, aren't they saying they don't want to be contacted via email. I think we just throw it only to the forum (that is the user) and leave it that. Forum users don't get the _rich_

Re: [GENERAL] shared data for different applications

2010-11-21 Thread Kent Tong
Hi Alban, Thanks a lot for your useful info! I think most companies have ended up at that point just by the progress of time. They have several different databases (often from different vendors even) that they need to aggregate their information from. So, is this the result of lack of

Re: Fwd: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread David Fetter
On Mon, Nov 22, 2010 at 10:40:34AM +1100, Elliot Chance wrote: It does surprise me a bit that when I (or someone else) signs up to a mailing list (not postgres specifically) that there is no fine print or agreement that says something along the lines of Your email address will be plastered all

Re: Fwd: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Craig Ringer
On 22/11/10 07:40, Elliot Chance wrote: It does surprise me a bit that when I (or someone else) signs up to a mailing list (not postgres specifically) that there is no fine print or agreement that says something along the lines of Your email address will be plastered all over the internet,

[GENERAL] Removing duplicates from multiple self left joins

2010-11-21 Thread James Moriarty
I am dynamically generating a query like below that creates different combinations of rules by left joining (any number of times) on itself and avoiding rules with some of the same attributes as part of the joins conditions e.g. SELECT count(*) FROM rules AS t1 LEFT JOIN rules AS t2

[GENERAL] What is Dialect

2010-11-21 Thread Adarsh Sharma
Dear all, I am reading about Dialects of different databases. Yet I can't understand what is the need of dialect in Postgres or any other like Hibernate uses Dialect of all Databases for ORM. What is it How can we create our own Dialect ? Thanks in Advance Adarsh Sharma -- Sent via

Re: [GENERAL] shared data for different applications

2010-11-21 Thread Alban Hertroys
On 22 Nov 2010, at 4:43, Kent Tong wrote: Hi Alban, Thanks a lot for your useful info! I think most companies have ended up at that point just by the progress of time. They have several different databases (often from different vendors even) that they need to aggregate their information