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 export an Excel

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

2010-11-13 Thread Merlin Moncure
2010/11/12 ΑΠΟΣΤΟΛΟΣ ΛΕΛΕΝΤΖΗΣ lelentzisaposto...@gmail.com: 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

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

2010-11-13 Thread Peter Geoghegan
2010/11/12 ΑΠΟΣΤΟΛΟΣ ΛΕΛΕΝΤΖΗΣ lelentzisaposto...@gmail.com: 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

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

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 r...@iol.ie 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:

Re: [GENERAL] dblink_get_result issue

2010-11-13 Thread Joe Conway
On 11/10/2010 03:54 PM, Tom Lane wrote: Marc Mamin m.ma...@intershop.de 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

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 any way running

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

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Tom Lane
Rich Shepard rshep...@appl-ecosys.com 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

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

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Thom Brown
On 13 November 2010 18:49, Tom Lane t...@sss.pgh.pa.us wrote: Rich Shepard rshep...@appl-ecosys.com 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

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Tom Lane
Thom Brown t...@linux.com 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

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 Joe Conway
On 11/13/2010 11:24 AM, Tom Lane wrote: Thom Brown t...@linux.com 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

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Thom Brown
On 13 November 2010 19:38, Joe Conway m...@joeconway.com wrote: On 11/13/2010 11:24 AM, Tom Lane wrote: Thom Brown t...@linux.com 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

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 forum at:

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-13 Thread Thom Brown
On 13 November 2010 19:44, Thom Brown t...@linux.com wrote: On 13 November 2010 19:38, Joe Conway m...@joeconway.com wrote: On 11/13/2010 11:24 AM, Tom Lane wrote: Thom Brown t...@linux.com writes: It's a shame that a forum can't act as a front-end for a mailing list, so signing up to

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 pagong...@gmail.com 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

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

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 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 past

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

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,

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. Drakej...@commandprompt.com 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

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

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