Re: [GENERAL] Superuser lost access to particular database

Tom Lane writes: So pg_dump seems off the hook. Can you run the query, attach to the backend with gdb, and see what it's doing? As stated on another message tried a ktrace and got nothing. Trying with gdb. Is this what you need? (gdb) bt #0 0x0811a0a9 in ExecMakeFunctionResult () #1 0x0811

Re: [GENERAL] PostgreSQL slammed by PHP creator

On Thursday 14 September 2006 12:19, Joshua D. Drake wrote: > Arturo Perez wrote: > > Hi all, > > > > Any response to this: > > http://www.internetnews.com/dev-news/article.php/3631831 > > Well first, your subject line is very incendiary and not necessary... I expect that kind of thing from slash

Re: [GENERAL] ECPG: non-integer constant in group by

Joachim Wieland wrote: On Fri, Sep 15, 2006 at 02:40:49AM -0800, Poul Jensen wrote: 1) It seems like the fastest way to find the # of distinct elements in a column is using GROUP BY. With ECPG, if I try EXEC SQL SELECT filenm FROM beamdata GROUP BY filenm; I will get "sql error Too few

Re: [GENERAL] create table as problem

On Fri, Sep 15, 2006 at 09:42:35PM +0100, garry saddington wrote: > I am getting a syntax error at or near 'as' in this method, can anyone > help? > > create table iclasses > (classid serial, > subject text, > year text, > groups text, > teacher text, > set text > ) > as select distinct subject,y

[GENERAL] create table as problem

I am getting a syntax error at or near 'as' in this method, can anyone help? create table iclasses (classid serial, subject text, year text, groups text, teacher text, set text ) as select distinct subject,year,groups,teacher,set from interimclasses I need to make a new table with a classid. Any

Re: [GENERAL] compressed protocol

Michael Fuhr wrote: > On Fri, Sep 15, 2006 at 07:58:54PM +0200, zeljko wrote: > So you were doing SSL over an SSH tunnel. That explains why > compression didn't seem to be working -- SSH was trying to compress > essentially random data (the SSL-encrypted data), and random data > doesn't have enou

Re: [GENERAL] compressed protocol

On Fri, Sep 15, 2006 at 07:58:54PM +0200, zeljko wrote: > ARGH IT WORKS ! :) > postgresql.conf contained ssl=on , so ssl=off = speed of light via ssh > tunnel :) So you were doing SSL over an SSH tunnel. That explains why compression didn't seem to be working -- SSH was trying to comp

Re: [GENERAL] [OT] PHP vs Postgresql argument on Slashdot's front page.

"Karen Hill" <[EMAIL PROTECTED]> writes: > Looks like the PHP vs Postgresql argument is on slashdot.org's front > page. Just giving everyone a heads up so they can go and defend > postgresql. It looks like a discussion thread that doesn't require that much "defending" be done... -- output = ("cb

Re: [GENERAL] basic geographic structure

What about a self-referencing table? Region -- region_id country_id parent_region_id PRIMARY KEY ("region_id") FOREIGN KEY ("parent_region_id") REFERENCES "Region" ("region_id") ... -- Brandon Aiken CS/IT Systems Engineer From: [EMAIL PROTECTED]

[GENERAL] basic geographic structure

HelloI need help with the data model of a basic geographic structureCountry > State/Region > Sub-RegionMost of the countries have a 3 level, so i want to do this_Countrycontry_id..._Regionregion_idcountry_id__Sub-regionsub_region_idregion_id_Clientclient_idsub_re

Re: [GENERAL] PostgreSQL slammed by PHP creator

On Thursday 14. September 2006 17:27, Arturo Perez wrote: >Hi all, > >Any response to this: >http://www.internetnews.com/dev-news/article.php/3631831 I submitted the story to Slashdot: http://it.slashdot.org/article.pl?sid=06/09/15/1412249 In the /. discussion, Rasmus Lerdorf himself claims that

Re: [GENERAL] compressed protocol

Michael Fuhr wrote: > What does a sniffer like tcpdump or wireshark/ethereal show? Let's > see how much data is being sent over a compressed vs. uncompressed > connection and how long the data transfers are taking. ARGH IT WORKS ! :) postgresql.conf contained ssl=on , so ssl=off = s

Re: [GENERAL] compressed protocol

Michael Fuhr wrote: > On Fri, Sep 15, 2006 at 06:34:48PM +0200, zeljko wrote: >> I'm testing over DSL line (test server have 256k Upload and 1MB >> download). Results are based on this connection. >> Server : PIV 3Ghz HT, 1GB RAM. (DSL D 1MB U 256k) >> Client : PIV 3Ghz HT, 1GB RAM. (DSL D 3MB U 3

[GENERAL] [OT] PHP vs Postgresql argument on Slashdot's front page.

Looks like the PHP vs Postgresql argument is on slashdot.org's front page. Just giving everyone a heads up so they can go and defend postgresql. ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] ECPG: non-integer constant in group by

On Fri, Sep 15, 2006 at 02:40:49AM -0800, Poul Jensen wrote: > 1) It seems like the fastest way to find the # of distinct elements in a > column is using GROUP BY. With ECPG, if I try >EXEC SQL SELECT filenm FROM beamdata GROUP BY filenm; >I will get "sql error Too few arguments". Why? Can

Re: [GENERAL] Migration

I think I've already proven (see Scott and Bernhard's replies) that their troll alarms work just fine. Please realize that anyone who took time to reply to this was already checking their E-Mail and being unproductive. Had I not posted this message I may have saved someone say -- 30 seconds. -D

Re: [GENERAL] Migration

Sorry, I couldn't resist putting my toll hat on :} On 9/15/06, Bernhard Weisshuhn <[EMAIL PROTECTED]> wrote: On Fri, Sep 15, 2006 at 12:33:37PM -0400, Daniel Corbe <[EMAIL PROTECTED]> wrote: > I heard from a bunch of PHP guys that Postgres is total crap. Can > anyone recommend a guide for

Re: [GENERAL] Migration

Daniel, Is anybody paying you to steel the time of all the developers who will rush and answer you ? Unless their troll-alarm will go off, which is quite unusual for this species (the developer) in front of such challenge... Cheers, Csaba. On Fri, 2006-09-15 at 18:33, Daniel Corbe wrote: > Hello

Re: [GENERAL] Migration

On Fri, Sep 15, 2006 at 12:33:37PM -0400, Daniel Corbe <[EMAIL PROTECTED]> wrote: > I heard from a bunch of PHP guys that Postgres is total crap. Can > anyone recommend a guide for migrating to MySQL? Hello slashdot! ---(end of broadcast)--- TIP

Re: [GENERAL] Migration

On Fri, 2006-09-15 at 12:33 -0400, Daniel Corbe wrote: > Hello, > > I heard from a bunch of PHP guys that Postgres is total crap. Can > anyone recommend a guide for migrating to MySQL? Someone's been reading that Rasmus interview. OK, I don't have a complete guide, but I think the steps go some

Re: [GENERAL] compressed protocol

On Fri, Sep 15, 2006 at 06:34:48PM +0200, zeljko wrote: > I'm testing over DSL line (test server have 256k Upload and 1MB download). > Results are based on this connection. > Server : PIV 3Ghz HT, 1GB RAM. (DSL D 1MB U 256k) > Client : PIV 3Ghz HT, 1GB RAM. (DSL D 3MB U 384k). > > nTier results sh

[GENERAL] One of our own begins a new life

Hello, Yeah, this is a cross post and it is slightly off topic but IMHO this is important. Tomorrow one of our own, Devrim Gunduz is becoming a man. He is sucking it up, and committing to the cvs repo of project marriage. May the patches reviewers be kind to him! Congratz Devrim, have a go

[GENERAL] Migration

Hello, I heard from a bunch of PHP guys that Postgres is total crap. Can anyone recommend a guide for migrating to MySQL? Thanks! ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] compressed protocol

Michael Fuhr wrote: > On Fri, Sep 15, 2006 at 09:52:04AM -0600, Michael Fuhr wrote: >> On Fri, Sep 15, 2006 at 05:37:50PM +0200, zeljko wrote: >> > But, when I try (via tunnel, explained above) >> > psql -p 5400 -h localhost mydatabase >> > it connects and works fine, but there's no compression.

Re: [GENERAL] compressed protocol

On Fri, Sep 15, 2006 at 09:52:04AM -0600, Michael Fuhr wrote: > On Fri, Sep 15, 2006 at 05:37:50PM +0200, zeljko wrote: > > But, when I try (via tunnel, explained above) > > psql -p 5400 -h localhost mydatabase > > it connects and works fine, but there's no compression. > > Query returns in cca 2

Re: [GENERAL] compressed protocol

Michael Fuhr wrote: > That's a tenuous conclusion; it assumes that the data transfer is Are you trying to say that data won't be compressed ? > what's taking all the time. Query planning and execution and > client-side processing must also be taken into account. Using a > sniffer to observe th

Re: [GENERAL] compressed protocol

On Fri, Sep 15, 2006 at 05:37:50PM +0200, zeljko wrote: > But, when I try (via tunnel, explained above) > psql -p 5400 -h localhost mydatabase > it connects and works fine, but there's no compression. > Query returns in cca 20 seconds, almost same (maybe 0.5 sec. different) as > normal psql conne

Re: [GENERAL] compressed protocol

Michael Fuhr wrote: > On Fri, Sep 15, 2006 at 03:38:01PM +0200, zeljko wrote: >> Tom Lane wrote: >> > zeljko <[EMAIL PROTECTED]> writes: >> >> Is there any plans (or somebody already working on) to see compressed >> >> protocol in 8.2 ? >> > >> > Why bother? Run your session through an ssh tunne

Re: [GENERAL] berkley sockets

On Wed, Sep 13, 2006 at 08:40:24PM -0400, J S B wrote: Thanks alot Tony. just wondering if the same can be done with C If you are more comfortable with C, I don't see why you couldn't do the same thing as that PLperl function. It's just a matter of creating a socket and sending a string wit

Re: [GENERAL] Installation with sources or with packages

Fair enough. I've never done it before except with trivial things that had no dependencies, and I just downloaded the packages with wget. Another option would be to use Ubuntu server. That's kinda Debian de facto, and offers more current packages, IIRC. -- Brandon Aiken CS/IT Systems Engineer

Re: [GENERAL] berkley sockets

J S B wrote: What exactly is this LISTEN/NOTIFY? Is it some function in socket programing or some part of postgres? ~Jas Listen/Notify is a means of letting a connected postgresql client know a insert or other event has occurred. It won't help if you need to send a command/message to some othe

Re: [GENERAL] berkley sockets

What exactly is this LISTEN/NOTIFY?Is it some function in socket programing or some part of postgres?~JasOn 9/15/06, Martijn van Oosterhout wrote:On Wed, Sep 13, 2006 at 08:40:24PM -0400, J S B wrote: > Thanks alot Tony.> just wondering if the same can be done with CNot entirel

Re: [GENERAL] OK, this is a Test für

It is definitvly not the Mailinglist software which cut the Subject lines. My unencoded Subject looks: Subject: OK, this is a Test =?iso-8859-1?Q?f=FCr_a_?= =?iso-8859-1?Q?Subject_containing_one_non_ASCII_character_ans_some_more_?= =?iso-8859-1?B?bGlrZSDp4fPo4PL05yBbV0FTOiBSZTog

Re: [GENERAL] compressed protocol

zeljko wrote: > Tom Lane wrote: > > > zeljko <[EMAIL PROTECTED]> writes: > >> Is there any plans (or somebody already working on) to see compressed > >> protocol in 8.2 ? > > > > Why bother? Run your session through an ssh tunnel and ask it to > > compress. > > hm... tunneling works as expected

Re: [GENERAL] compressed protocol

On Fri, Sep 15, 2006 at 03:38:01PM +0200, zeljko wrote: > Tom Lane wrote: > > zeljko <[EMAIL PROTECTED]> writes: > >> Is there any plans (or somebody already working on) to see compressed > >> protocol in 8.2 ? > > > > Why bother? Run your session through an ssh tunnel and ask it to > > compress.

Re: [GENERAL] PostgreSQL slammed by PHP creator

Lincoln Yeoh wrote: > At 11:27 AM 9/14/2006 -0400, Arturo Perez wrote: > > >Hi all, > > > >Any response to this: > > > PHP makes "wrong things" easy, and "right things" hard. > > Evidence: "addslashes", "register_globals" and "magic quote

Re: [GENERAL] PostgreSQL slammed by PHP creator

At 11:27 AM 9/14/2006 -0400, Arturo Perez wrote: Hi all, Any response to this: http://www.internetnews.com/dev-news/article.php/3631831 The title of the article is funny: "Is PHP The Cure For The 'Broken' Web?" In my opinion PHP is

Re: [GENERAL] Installation with sources or with packages

I prefer Debian packages wherever possible. That will provide you with the easiest manageability in the long run for maintaining updates. It's hard to beat "sudo apt-get update && sudo apt-get upgrade && sudo apt-get autoclean" as a complete patch script. However, keep in mind that Debian Sarge

Re: [GENERAL] compressed protocol

Tom Lane wrote: > zeljko <[EMAIL PROTECTED]> writes: >> Is there any plans (or somebody already working on) to see compressed >> protocol in 8.2 ? > > Why bother? Run your session through an ssh tunnel and ask it to > compress. hm... tunneling works as expected, but there's no compression ?!? s

Re: [GENERAL] OK, this is a

Martijn van Oosterhout wrote: > On Wed, Sep 13, 2006 at 03:09:17PM +0200, Michelle Konzack wrote: > > Hi Alvaro, > > > > This is a second test with some non US-ACII characters... > > FWIW, this appeared fine in Mutt, the raw message has the subject split > across multiple lines, but Mutt handles

Re: [GENERAL] Installation with sources or with packages

On Fri, Sep 15, 2006 at 01:26:07PM +0200, [EMAIL PROTECTED] wrote: > Hello, > > I need install postgresql 8.X.X on my debian host. > But someone says me I should use sources files for the install > and other one says me I should use debian package. > Does anybody have some "theory" or opinion abou

[GENERAL] Installation with sources or with packages

Hello, I need install postgresql 8.X.X on my debian host. But someone says me I should use sources files for the install and other one says me I should use debian package. Does anybody have some "theory" or opinion about the installation of postgresql by sources or debian package ? What's the mos

Re: [GENERAL] ECPG: non-integer constant in group by

On 2006-09-15, Poul Jensen <[EMAIL PROTECTED]> wrote: > 2) The code below was meant to find the # of distinct elements for many > columns, but fails with the message > sql error 'non-integer constant in GROUP BY' > thrown at the EXEC SQL EXECUTE statement. What is the problem? > char db

[GENERAL] Postgresql 7.4 migration to (partially) new disks

Hi, Our main postgresql/jboss/lotus notes server is configured as follows. OS : Debian GNU linux 3.0 PgSQL: 7.4.13 The FS structure of the system has as follows: Filesystem 1k-blocks Used Available Use% Mounted on /dev/sda1 9614116 6528132 2597612 72% / /dev/sd

[GENERAL] ECPG: non-integer constant in group by

I actually have two questions. 1) It seems like the fastest way to find the # of distinct elements in a column is using GROUP BY. With ECPG, if I try EXEC SQL SELECT filenm FROM beamdata GROUP BY filenm; I will get "sql error Too few arguments". Why? Can I correct the query to avoid the

Re: [GENERAL] berkley sockets

On Wed, Sep 13, 2006 at 08:40:24PM -0400, J S B wrote: > Thanks alot Tony. > just wondering if the same can be done with C Not entirely clear what you're doing, but couldn't you do what you want with LISTEN/NOTIFY. That way the daemon connects to the server too and get notified when other clients

Re: [GENERAL] PostgreSQL slammed by PHP creator

On Fri, 2006-09-15 at 00:21 -0500, Ron Johnson wrote: > On 09/14/06 21:32, AgentM wrote: > > > > On Sep 14, 2006, at 21:25 , Bruce Momjian wrote: > > > >> > >> I am not going to ask how you got to 135MPH. > > > > Obviously he was running MySQL under the hood. > > No wonder he spun out and crash

Re: [GENERAL] OK, this is a

On Wed, Sep 13, 2006 at 03:09:17PM +0200, Michelle Konzack wrote: > Hi Alvaro, > > This is a second test with some non US-ACII characters... FWIW, this appeared fine in Mutt, the raw message has the subject split across multiple lines, but Mutt handles that just fine. My guess is someone's MUA t

Re: [GENERAL] [pgadmin-support] pgAdmin III v1.6 Beta 1 Released

  From: Harald Armin Massa [mailto:[EMAIL PROTECTED] Sent: 15 September 2006 09:21To: Dave PageCc: pgadmin-hackers@postgresql.org; pgsql-general@postgresql.orgSubject: Re: [pgadmin-support] pgAdmin III v1.6 Beta 1 Released Wow!  :-)  This really looks good. I espe

Re: [GENERAL] [pgadmin-support] pgAdmin III v1.6 Beta 1 Released

Wow!This really looks good. I especially like the subtile but helpfull improvements to the Query-Window --- that braces-matching really helps!Also the fine change to "finish" on the maintaince-OK button is a very nice solution. As pgadmin is distributed with PostgreSQL on Win32, maybe a slogan lik

Re: [GENERAL] select unique items in db

a schreef: it returns nill now or nuthing and it is very very very slow This is not much info. What is the actual query you are using now? What are the tables like you are running your query against? I'cant really get a good understanding of your problem. So far I have just given you a gener