Re: [GENERAL] The first dedicated PostgreSQL forum

[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 database types are conservative by nature, almost as much as 
accountants. But a little change is good now and then ;-)


 Dennis Gearon
From: Guillaume Lelarge 

To: r...@iol.ie
Cc: Elliot Chance , pgsql-general@postgresql.org
Subject: Re: The first dedicated PostgreSQL forum
Message-ID: <4cded73f.90...@lelarge.info>

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 down the effort you've put into the above,
> I'm just curious as to what it's meant to achieve that the mailing list
> and wiki don't.
> 

Actually, you could be quite surprised on the number of people not
willing to use a mailing list, and ready to use web forums.

Just to take an example, pgsql-fr-generale (the french general mailing
list) is really quiet. Usually not more than 10 threads per month. But
the french web forums (http://forums.postgresql.fr) are much much more used.


-- 
Guillaume
http://www.postgresql.fr
http://dalibo.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 to the list, and vice
versa.  And such a system would need to support cross-posting too somehow.


It can. The glassfish forums are bidirectionally gatewayed to the 
mailing list in just such a manner, and it works astonishingly well. 
Before using those I would've been opposed to the idea, but now ... it 
doesn't seem so bad.


--
Craig Ringer

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[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 this problem maybe 3 times in my whole career, precisely
because if you are dealing with text that big, you move to full text
search.


Yeah, the real question here is exactly what do you think a btree index
on a large text column will get you?


About the only useful case I can see is with text data of very irregular 
size. The vast majority is small, but there are a few massively bigger 
items. It'd be nice if the index method had a fallback for items too big 
to index in this case, such as a prefix match and heap recheck.


Of course, I've never run into this in practice, and if I did I'd be 
wondering if I had my schema design quite right. I can't imagine that 
the mostly aesthetic improvement of eliminating this indexing limitation 
would be worth the effort. I'd never ask or want anyone to waste their 
time on it, and don't intend to myself. Most of the interesting "big 
text" indexing problems are solved by tsearch and/or functional indexes.


--
Craig Ringer

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The first dedicated PostgreSQL forum

[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, steal and guess your 
email address for many years. I'll say that if you use an address at all 
(meaning, you send people email using it), then you'll receive spam (and 
lots of it).




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 which is a slight shame because I would
prefer to use my attributable, professional email address.  Do the long
standing members not have problems with spam?

On Sat, Nov 13, 2010 at 10:00 PM, Adrian Klaver wrote:

> On Saturday 13 November 2010 1:52:11 pm thatsanicehatyouh...@mac.comwrote:
> > 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 web interface for the lists, but it's my
> > first go-to for searching.
> >
> > I realize you can search this list here:
> >
> > http://archives.postgresql.org/pgsql-general/
> >
> > but a more polished web interface of the list I think would satisfy
> > everyone.
> >
> > BTW, I performed a search on that page for the word "replication" and the
> > result was very slow ("Searching in 863,821 pages took 25.1127 seconds").
> >
> > Demitri
>
> You must have hit a batch of slow electrons :) My result:
> "Searching in 863,821 pages took 0.84438 seconds."
>
> --
> Adrian Klaver
> adrian.kla...@gmail.com
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 posts. You can't post to the web site though
> - it is strictly a third-party web interface for the lists, but it's my
> first go-to for searching.
>
> I realize you can search this list here:
>
> http://archives.postgresql.org/pgsql-general/
>
> but a more polished web interface of the list I think would satisfy
> everyone.
>
> BTW, I performed a search on that page for the word "replication" and the
> result was very slow ("Searching in 863,821 pages took 25.1127 seconds").
>
> Demitri

You must have hit a batch of slow electrons :) My result:
"Searching in 863,821 pages took 0.84438 seconds."

-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 are
great to be able to save and search on but would like to get rid of the
posts from my emails.  I don't want to not have access to them because when
I'm board I can start to read through threads that interest me.  I just
don't want to have to download the emails to do that.


Best Regards


Mike Gould


 


"Thom Brown"  wrote:



>
>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 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 vice versa.
>>
>> That would be cool.  Wonder if there's something like that out there
>already.
>It exists -- not sure what they are using, but for example the Users
>forum here -- href="http://forum.sipfoundry.org/index.php";>http://forum.sipfoundry.org/index.php
>-- is
>bidirectionally linked with href="mailto:sipx-us...@list.sipfoundry.org";>sipx-us...@list.sipfoundry.org
>

 FUDForum by the look of it: http://cvs.prohost.org/index.php";>http://cvs.prohost.org/index.php
  

And mailing list integration looks pretty straightforward and well
supported: http://cvs.prohost.org/index.php/Mailing_List_Manager";>http://cvs.prohost.org/index.php/Mailing_List_Manager
 Feasible?  Desirable?

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

 

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 web interface for the lists, but it's my first go-to for 
searching.

I realize you can search this list here:

http://archives.postgresql.org/pgsql-general/

but a more polished web interface of the list I think would satisfy everyone.

BTW, I performed a search on that page for the word "replication" and the 
result was very slow ("Searching in 863,821 pages took 25.1127 seconds").

Demitri

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL database model creation

[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 like the ones i
> have been reading.
>
> What i need is something powerful enough to connect to an existing
> PostgreSQL DB and make the model (reverse), and allow editing and syncing.
>
> Will appreciate any input. Thanks.
>
>
>
> MV
>



-- 
// Dmitriy.

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 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 vice versa.
>> >
>> > That would be cool.  Wonder if there's something like that out there
>> already.
>>
>> It exists -- not sure what they are using, but for example the Users
>> forum here -- http://forum.sipfoundry.org/index.php -- is
>> bidirectionally linked with sipx-us...@list.sipfoundry.org
>>
>
> FUDForum by the look of it: http://cvs.prohost.org/index.php
>
>
And mailing list integration looks pretty straightforward and well
supported: http://cvs.prohost.org/index.php/Mailing_List_Manager

Feasible?  Desirable?

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

Re: [GENERAL] The first dedicated PostgreSQL forum

[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:
> >> http://forums.postgresql.com.au
> > 
> > Hi there,
> > 
> > Without in any way running down the effort you've put into the above,
> > I'm just curious as to what it's meant to achieve that the mailing list
> > and wiki don't.
> > 
> 
> Actually, you could be quite surprised on the number of people not
> willing to use a mailing list, and ready to use web forums.
> 
> Just to take an example, pgsql-fr-generale (the french general mailing
> list) is really quiet. Usually not more than 10 threads per month. But
> the french web forums (http://forums.postgresql.fr) are much much more used.

Yep and if we ever want to get Drupal developers (as an example) a forum
is the way to go. They don't like mailing lists either.

JD

-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 up), but without receiving any emails.  Messages
> posted
> >> to the forum would get sent to the list, and vice versa.
> >
> > That would be cool.  Wonder if there's something like that out there
> already.
>
> It exists -- not sure what they are using, but for example the Users
> forum here -- http://forum.sipfoundry.org/index.php -- is
> bidirectionally linked with sipx-us...@list.sipfoundry.org
>

FUDForum by the look of it: http://cvs.prohost.org/index.php

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

Re: [GENERAL] The first dedicated PostgreSQL forum

[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
>> to the forum would get sent to the list, and vice versa.
> 
> That would be cool.  Wonder if there's something like that out there already.

It exists -- not sure what they are using, but for example the Users
forum here -- http://forum.sipfoundry.org/index.php -- is
bidirectionally linked with sipx-us...@list.sipfoundry.org

Joe

-- 
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support



signature.asc
Description: OpenPGP digital signature

Re: [GENERAL] The first dedicated PostgreSQL forum

[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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 vice versa.

That would be cool.  Wonder if there's something like that out there already.

> And such a system
> would need to support cross-posting too somehow.

Dunno, seems like we've been discouraging cross-posting lately anyhow.
I wouldn't see anything wrong with forum posts only being able to go to
one mailing list, as long as there were a forum corresponding to each
active list.

regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 thing.
>
> 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 because there's no traffic in
> this forum".  It needs to be connected to the community as a whole, and
> some random guy deciding to create his own forum doesn't sound like a
> recipe for getting to that.
>
> (BTW, if memory serves, this has happened before, with no positive
> long-term results.)
>

Yes, that was at postgresqlforums.com I think, which wasn't very popular.
 Not that the guy who ran it wasn't helpful though.  I've noticed a similar
problem with MSSQL, various scattered forums around with no sense of a
focused community.

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 vice versa.  And such a system
would need to support cross-posting too somehow.

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 because there's no traffic in
this forum".  It needs to be connected to the community as a whole, and
some random guy deciding to create his own forum doesn't sound like a
recipe for getting to that.


Tom,

  A reasonable concern. I was certainly not advocating or supporting the
idea of a Web-based forum. As an old curmudgeon I much prefer mail lists.

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 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 because there's no traffic in
this forum".  It needs to be connected to the community as a whole, and
some random guy deciding to create his own forum doesn't sound like a
recipe for getting to that.

(BTW, if memory serves, this has happened before, with no positive
long-term results.)

regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 information pushed to us via a mail
list. Those who are more used to doing everything with a GUI and pointing
device seem to prefer pulling information by visiting a Web site. I much
prefer having information pushed to me, and that's one reason (the
noise-to-signal ratio being another) why I no longer use Usenet news groups
as much as I did.

  When this same issue came up on other mail lists someone would always
point out that there are websites (gmane, perhaps?) that allow a Web BUI
interface to mail lists.

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 down the effort you've put into the above,
> I'm just curious as to what it's meant to achieve that the mailing list
> and wiki don't.
> 

Actually, you could be quite surprised on the number of people not
willing to use a mailing list, and ready to use web forums.

Just to take an example, pgsql-fr-generale (the french general mailing
list) is really quiet. Usually not more than 10 threads per month. But
the french web forums (http://forums.postgresql.fr) are much much more used.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] dblink_get_result issue

[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, but it seems OK in 9.0.  The only
> one of the 9.0 commits that seems likely to be relevant is
> http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=56cbb611ec749ba867a4cfc09c8b7df0f4446620
> which looks a bit overcomplex for a back-patch.  Joe, any thoughts?

Sorry for the slow response.

I think this issue was fixed by that patch only as a side effect of
significant restructuring. The attached one liner against 8.4 seems to
fix it. Objections?

Joe

-- 
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
diff --git a/contrib/dblink/dblink.c b/contrib/dblink/dblink.c
index 72e80f2..0d21cc0 100644
*** a/contrib/dblink/dblink.c
--- b/contrib/dblink/dblink.c
*** dblink_record_internal(FunctionCallInfo 
*** 920,926 
  		/*
  		 * check result and tuple descriptor have the same number of columns
  		 */
! 		if (PQnfields(res) != tupdesc->natts)
  			ereport(ERROR,
  	(errcode(ERRCODE_DATATYPE_MISMATCH),
  	 errmsg("remote query result rowtype does not match "
--- 920,926 
  		/*
  		 * check result and tuple descriptor have the same number of columns
  		 */
! 		if (!is_sql_cmd && PQnfields(res) != tupdesc->natts)
  			ereport(ERROR,
  	(errcode(ERRCODE_DATATYPE_MISMATCH),
  	 errmsg("remote query result rowtype does not match "


signature.asc
Description: OpenPGP digital signature

Re: [GENERAL] The first dedicated PostgreSQL forum

[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.com.au
>>
>
> Hi there,
>
> Without in any way running down the effort you've put into the above, I'm
> just curious as to what it's meant to achieve that the mailing list and wiki
> don't.
>
> Ray.
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> r...@iol.ie
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



-- 
// Dmitriy.

Re: [GENERAL] The first dedicated PostgreSQL forum

[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 curious as to what it's meant to achieve that the mailing list 
and wiki don't.


Ray.

--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[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 CLIENT_ENCODING TO 'UTF8';
> but i can't insert my data!!
> Can you help me??

You're not using psql under windows, are you? It works horribly on windows.

It'll use a weird legacy encoding such as IBM codepage 850 (that's
what it is on my Irish locale Windows XP, but it's probably something
else for you).


-- 
Regards,
Peter Geoghegan

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[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 CLIENT_ENCODING TO 'UTF8';
> but i can't insert my data!!
> Can you help me??

works for me...
pg9=# select 'ΑΠΟΣΤΟΛΟΣ ΛΕΛΕΝΤΖΗΣ';
  ?column?
-
 ΑΠΟΣΤΟΛΟΣ ΛΕΛΕΝΤΖΗΣ
(1 row)

merlin

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Basic Tutorials for 9.0

[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 file as CVS and ;'copy' into pg.  So I
>>> would like to learn how to create a new database and what ever goes
>>> along with that to acheive this goal.
>> 
>>> I would appreciate all help.
>> 
>>> Thanks,
>>> ray
>> 
>> if the defaults are in play the owning account should be able to do
>> 
>> createdb somedbname;
>> 
>> You left of the "db" in createdb in your posting.

> I really didn't understand.  I was trying to create a new db inside of
> the pg shell.  I found that I needed to do it at the OS command
> prompt.  This was totally unclear in the manual.

That's not true, it's just that the command you used wouldn't have worked in 
either.

On the OS shell's command line (cmd in Windows) you use "createdb mydb" to 
create a database,
in the psql shell you use "CREATE DATABASE mydb;".
I expect the latter command would work in pgadmin too (although you may have to 
leave out the semi-colon), but it probably has a convenient menu option for 
creating databases somewhere.

I tend to install MSys in Windows so that I have a proper UNIX shell to run 
those commands from, but it's a bit hard to set up.

> Now I have found that the copy cammand is to be done in the shell.

If you're saying shell, do you mean your OS shell (cmd.exe) or are you talking 
about the psql shell?

To copy data you can use either the \copy command built in the psql shell, or 
you can use the COPY statement directly and copy from STDIN, followed by your 
CSV data and closed with a \. terminator.
Check the documentation on COPY for details and examples.

> Now if I could just find out if it is working.  I can't seem to look into the 
> db.


I guess you're talking about pgadmin here, with which I'm not familiar. It's 
probably just not connected to your database, guessing from your earlier remark 
about the red X.
Is the database server on the same machine as pgadmin? If not, you probably 
need to edit pg_hba.conf to allow access from the machine running pgadmin.

In the psql shell you can type \dt to see your tables (or \? for a list of 
built-in commands) and use SELECT statements to look at your data.

You could also try to hook up an ODBC connection to your database and look at 
it using Access or Openoffice's variant of that. There are plenty more 
possibilities.

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:737,4cde80ae10261879520974!



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general