Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Dennis Gearon
One thing that makes me agree with this is the antiquated format of the digest emails. I hate google mail, but I love the google groups application. If postgres had a combination online forum/google groups thing (if there is such a thing), communication would be much improved. Now, I KNOW that

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Craig Ringer
On 11/14/2010 03:13 AM, Thom Brown wrote: It's a shame that a forum can't act as a front-end for a mailing list, so signing up to the forum actually signs you up to a mailing list (if you're not already signed up), but without receiving any emails. Messages posted to the forum would get sent t

Re: [GENERAL] index row requires 10040 bytes, maximum size is 8191

2010-11-13 Thread Craig Ringer
On 11/13/2010 11:15 AM, Tom Lane wrote: "Joshua D. Drake" writes: On Sat, 2010-11-13 at 09:48 +0800, Craig Ringer wrote: Thoughts, folks? Does this matter in practice, since anything you'd want to index will in practice be small enough or a candidate for full-text indexing? I have run into

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread David Boreham
On 11/13/2010 3:31 PM, LazyTrek wrote: Do the long standing members not have problems with spam? As you can see I use a list alias. However, in my experience the notion that you can avoid spam by not frequenting mailing lists is quaint to say the least. The spammers have had ways to find, ste

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread LazyTrek
I must say that I come from a generation not used to mailing lists, but have adopted them for PostgreSQL recently. One of the main things I don't like is that my email address is now out there for crawlers to capture (thanks to the archive) and spam. For this reason I use an alias email address w

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Adrian Klaver
On Saturday 13 November 2010 1:52:11 pm thatsanicehatyouh...@mac.com wrote: > I've used lists where the the line between forum and mailing list is > blurred. See: > > http://www.cocoabuilder.com/ > > This is actually a web interface for a couple of mailing lists, and is a > great tool for searching

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Michael Gould
I would like to see this type of setup used.  I use my cell phone for about 90% of my internet access during the day when I'm on the road.  I've found in the past that forums usually have better search tools and they also will not fill up my email address.  I find many things in these forums which

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread thatsanicehatyouhave
I've used lists where the the line between forum and mailing list is blurred. See: http://www.cocoabuilder.com/ This is actually a web interface for a couple of mailing lists, and is a great tool for searching past posts. You can't post to the web site though - it is strictly a third-party we

Re: [GENERAL] PostgreSQL database model creation

2010-11-13 Thread Dmitriy Igrishin
Hey Miguel, You may try DbWrench or MicroOLAP database designer software. 2010/11/10 Miguel Vaz > Hi, > > Is there anything like MySQL workbench for PostgreSQL? > > I know there are a few alternatives, but was hoping to hear specific > choices and not just some random anonymous internet list li

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Thom Brown
On 13 November 2010 19:44, Thom Brown wrote: > On 13 November 2010 19:38, Joe Conway wrote: > >> On 11/13/2010 11:24 AM, Tom Lane wrote: >> > Thom Brown writes: >> >> It's a shame that a forum can't act as a front-end for a mailing list, >> so >> >> signing up to the forum actually signs you up

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Joshua D. Drake
On Sat, 2010-11-13 at 19:21 +0100, Guillaume Lelarge wrote: > Le 13/11/2010 17:43, Raymond O'Donnell a écrit : > > On 13/11/2010 03:43, Elliot Chance wrote: > >> Hi everyone, > >> > >> This is my first post on the mailing list :) > >> > >> As of today I have started the first dedicated postgres for

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Thom Brown
On 13 November 2010 19:38, Joe Conway wrote: > On 11/13/2010 11:24 AM, Tom Lane wrote: > > Thom Brown writes: > >> It's a shame that a forum can't act as a front-end for a mailing list, > so > >> signing up to the forum actually signs you up to a mailing list (if > you're > >> not already signed

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Joe Conway
On 11/13/2010 11:24 AM, Tom Lane wrote: > Thom Brown writes: >> It's a shame that a forum can't act as a front-end for a mailing list, so >> signing up to the forum actually signs you up to a mailing list (if you're >> not already signed up), but without receiving any emails. Messages posted >> t

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Rich Shepard
On Sat, 13 Nov 2010, Tom Lane wrote: That would be cool. Wonder if there's something like that out there already. I don't know if BUI-based subscription is supported, but there are reported solutions. Take a look at gmane.org (mail<->Usenet news groups) and see if that might work. Rich --

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Tom Lane
Thom Brown writes: > It's a shame that a forum can't act as a front-end for a mailing list, so > signing up to the forum actually signs you up to a mailing list (if you're > not already signed up), but without receiving any emails. Messages posted > to the forum would get sent to the list, and vi

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Thom Brown
On 13 November 2010 18:49, Tom Lane wrote: > Rich Shepard writes: > > On Sat, 13 Nov 2010, Guillaume Lelarge wrote: > >> Actually, you could be quite surprised on the number of people not > willing > >> to use a mailing list, and ready to use web forums. > > >I think this is a generational t

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Rich Shepard
On Sat, 13 Nov 2010, Tom Lane wrote: I'm not nearly as concerned about whether there are forums as about having "rogue" forums outside the postgresql.org domain. People could misperceive such things as having some official status, which would lead to conclusions like "postgres must be dead beca

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Tom Lane
Rich Shepard writes: > On Sat, 13 Nov 2010, Guillaume Lelarge wrote: >> Actually, you could be quite surprised on the number of people not willing >> to use a mailing list, and ready to use web forums. >I think this is a generational thing. I'm not nearly as concerned about whether there are

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Rich Shepard
On Sat, 13 Nov 2010, Guillaume Lelarge wrote: Actually, you could be quite surprised on the number of people not willing to use a mailing list, and ready to use web forums. I think this is a generational thing. Most of us who've been running linux or a *nix for a while prefer to have the inf

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Guillaume Lelarge
Le 13/11/2010 17:43, Raymond O'Donnell a écrit : > On 13/11/2010 03:43, Elliot Chance wrote: >> Hi everyone, >> >> This is my first post on the mailing list :) >> >> As of today I have started the first dedicated postgres forum at: >> http://forums.postgresql.com.au > > Hi there, > > Without in a

Re: [GENERAL] dblink_get_result issue

2010-11-13 Thread Joe Conway
On 11/10/2010 03:54 PM, Tom Lane wrote: > "Marc Mamin" writes: > >> SELECT * FROM dblink_get_result('myconn1', true ) as x (t text); > >> => >> ** Error ** >> remote query result rowtype does not match the specified FROM clause >> rowtype > Hmm. I can reproduce this in 8.4 too

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Dmitriy Igrishin
Hey, Yeah, we feel here at home and don't need forum. 2010/11/13 Raymond O'Donnell > On 13/11/2010 03:43, Elliot Chance wrote: > >> Hi everyone, >> >> This is my first post on the mailing list :) >> >> As of today I have started the first dedicated postgres forum at: >> http://forums.postgresql

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Raymond O'Donnell
On 13/11/2010 03:43, Elliot Chance wrote: Hi everyone, This is my first post on the mailing list :) As of today I have started the first dedicated postgres forum at: http://forums.postgresql.com.au Hi there, Without in any way running down the effort you've put into the above, I'm just curi

Re: [GENERAL] Insert data with greek characters using psql environment

2010-11-13 Thread Peter Geoghegan
2010/11/12 ΑΠΟΣΤΟΛΟΣ ΛΕΛΕΝΤΖΗΣ : > Hello, > > I am a new user of PostgreSQL , and i have a problem with encoding settings > of psql. > Specifically, i want to insert data with greek characters using psql > environment. > I change the enconding settings of psql, writing the following command: > SET

Re: [GENERAL] Insert data with greek characters using psql environment

2010-11-13 Thread Merlin Moncure
2010/11/12 ΑΠΟΣΤΟΛΟΣ ΛΕΛΕΝΤΖΗΣ : > Hello, > > I am a new user of PostgreSQL , and i have a problem with encoding settings > of psql. > Specifically, i want to insert data with greek characters using psql > environment. > I change the enconding settings of psql, writing the following command: > SET

Re: [GENERAL] Basic Tutorials for 9.0

2010-11-13 Thread Alban Hertroys
On 13 Nov 2010, at 3:44, ray wrote: > On Nov 10, 11:07 pm, robjsarg...@gmail.com (Rob Sargent) wrote: >> ray wrote: >>> I also tried the shell. create mydb. I used all the defaults but the >>> console came back and rejected all the defaults and closed the >>> console. >> >>> I would like to exp