[GENERAL] Anderson dos Santos Donda wants to stay in touch on LinkedIn

LinkedIn Anderson dos Santos Donda requested to add you as a connection on LinkedIn: -- Andrew, I'd like to add you to my professional network on LinkedIn. - Anderson dos Santos Donda Accept invitation from Anderson dos Santos Donda http://ww

[GENERAL] Error of text2ltree

I can't use text2ltree. Any suggestion? Thanks. SELECT text2ltree('abc'). It's okay. But, got error if: SELECT text2ltree(to_char(243, '0999')) Error ** ERROR: syntax error at position 0 SQL state: 42601

Re: [GENERAL] sintax error in script

Le vendredi 28 mai 2010 20:34:13, Shoaib Mir a écrit : > On Sat, May 29, 2010 at 11:09 AM, Luis Daniel Lucio Quiroz < > > luis.daniel.lu...@gmail.com> wrote: > > pgsql is telling me /-- END has a sintax error, > > just to confirm, is it okay if i get rid of that line? > > I think you should be fi

Re: [GENERAL] No lidbl.so in libpq.so (postgresql 8.4.4)

> Gary Fu writes: > > Nilesh Govindarajan wrote: > >> Could you please explain a little more what you want to do actually ? > > > I have the following problem to run 'configure' when building pgpool > > 2.3.3 with libpq from normal built of postgreSQL 8.4.4. > > > configure:24789: result: no >

Re: [GENERAL] sintax error in script

On Sat, May 29, 2010 at 11:09 AM, Luis Daniel Lucio Quiroz < luis.daniel.lu...@gmail.com> wrote: > pgsql is telling me /-- END has a sintax error, > just to confirm, is it okay if i get rid of that line? > > I think you should be fine removing this, as if I re-call I haven't seen something like th

[GENERAL] getaddrinfo problems in pl/python

Hi all, I am having problems with getaddrinfo in plpython. Pl/Python is the same as my system python (2.6), this is MacOS X. Here's what happens in the python prompt: >>> from _socket import * >>> import _socket >>> import sys >>> print _socket.__file__ /System/Library/Frameworks/Python.framework

[GENERAL] sintax error in script

CREATE OR REPLACE FUNCTION to_number(integer) RETURNS "numeric" AS $BODY$ BEGIN RETURN to_number($1, 'S99D99'); EXCEPTION WHEN OTHERS THEN RETURN NULL; END; $BODY$ LANGUAGE 'plpgsql' IMMUTABLE; /-- END pgsql is telling me /-- END has a sintax error, just to confirm, is

Re: [GENERAL] Out of Memory and Configuration Problems (Big Computer)

I ran this query: EXPLAIN ANALYZE UPDATE nlpg.match_data SET org = org; And I got this result: "Seq Scan on match_data (cost=0.00..9762191.68 rows=32205168 width=206) (actual time=76873.592..357450.519 rows=2961 loops=1)" "Total runtime: 8028212.367 ms" On 28 May 2010 19:39, Tom Wilcox w

Re: [GENERAL] Out of Memory and Configuration Problems (Big Computer)

On 28 May 2010, at 20:39, Tom Wilcox wrote: > out = '' > for tok in toks: > ## full word replace > if tok == 'house' : out += 'hse'+ADDR_FIELD_DELIM > elif tok == 'ground' : out += 'grd'+ADDR_FIELD_DELIM > elif tok == 'gnd' : out += 'grd'+ADDR_FIELD_DELIM >

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

On Friday 28 May 2010 1:34:24 pm erobles wrote: > On 05/28/2010 03:18 PM, alvherre wrote: > > Excerpts from erobles's message of vie may 28 16:08:23 -0400 2010: > >> it did'nt work :-( , because the script is for pg 8.2 and i have pg > >> 7.2 and the table pg_cast doesn't exist. whatever is a

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

On Fri, May 28, 2010 at 2:34 PM, erobles wrote: > > > On 05/28/2010 03:18 PM, alvherre wrote: >> >> Excerpts from erobles's message of vie may 28 16:08:23 -0400 2010: >> >> >>> >>> it did'nt work  :-(  , because the script is  for  pg 8.2 and i have pg >>> 7.2 and the table  pg_cast doesn't exist.

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

erobles writes: > how can i get the same info from postgres 7.2 , and be able to get > the differences between 8.3 and 7.2 Before the pg_cast catalog there simply wasn't any explicit representation of available casts. I think what you need to look for is single-argument functions that hav

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

On 05/28/2010 03:34 PM, erobles wrote: On 05/28/2010 03:18 PM, alvherre wrote: Excerpts from erobles's message of vie may 28 16:08:23 -0400 2010: it did'nt work :-( , because the script is for pg 8.2 and i have pg 7.2 and the table pg_cast doesn't exist. whatever is a good idea but

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

On 05/28/2010 03:18 PM, alvherre wrote: Excerpts from erobles's message of vie may 28 16:08:23 -0400 2010: it did'nt work :-( , because the script is for pg 8.2 and i have pg 7.2 and the table pg_cast doesn't exist. whatever is a good idea but i need to know the table or tables

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

Excerpts from erobles's message of vie may 28 16:08:23 -0400 2010: > it did'nt work :-( , because the script is for pg 8.2 and i have pg > 7.2 and the table pg_cast doesn't exist. whatever is a good idea but i > need to know the table or tables on postgres 7.2. Of course it didn't wor

Re: [GENERAL] Statement Pooling

On Thursday 27 May 2010 16:56:28 you wrote: > > Additionally c3p0 can cache java instances of > > "java.sql.PreparedStatement" which means it is caching the java object. > > So when using > > c3p0.maxStatementsPerConnection = 100 it caches at most 100 different > > objects. It saves time on crea

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

On 05/28/2010 02:04 PM, erobles wrote: On 05/28/2010 01:51 PM, Adrian Klaver wrote: On 05/28/2010 11:45 AM, erobles wrote: On 05/28/2010 01:26 PM, Adrian Klaver wrote: On 05/28/2010 11:20 AM, erobles wrote: hi! only for ask, there is a way to deactivate type validation, so i can do s

Re: [GENERAL] No lidbl.so in libpq.so (postgresql 8.4.4)

On 05/28/2010 02:16 PM, Tom Lane wrote: Gary Fu writes: Nilesh Govindarajan wrote: Could you please explain a little more what you want to do actually ? I have the following problem to run 'configure' when building pgpool 2.3.3 with libpq from normal built of postgreSQ

Re: [GENERAL] No lidbl.so in libpq.so (postgresql 8.4.4)

Gary Fu writes: > Nilesh Govindarajan wrote: >> Could you please explain a little more what you want to do actually ? > I have the following problem to run 'configure' when building pgpool > 2.3.3 with libpq from normal built of postgreSQL 8.4.4. > configure:24789: result: no > configure:24799:

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

On 05/28/2010 01:51 PM, Adrian Klaver wrote: On 05/28/2010 11:45 AM, erobles wrote: On 05/28/2010 01:26 PM, Adrian Klaver wrote: On 05/28/2010 11:20 AM, erobles wrote: hi! only for ask, there is a way to deactivate type validation, so i can do select rtrim(number_field) from table ; wit

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

On 05/28/2010 11:45 AM, erobles wrote: On 05/28/2010 01:26 PM, Adrian Klaver wrote: On 05/28/2010 11:20 AM, erobles wrote: hi! only for ask, there is a way to deactivate type validation, so i can do select rtrim(number_field) from table ; with no error and the message: "You might need to exp

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

On 05/28/2010 01:26 PM, Adrian Klaver wrote: On 05/28/2010 11:20 AM, erobles wrote: hi! only for ask, there is a way to deactivate type validation, so i can do select rtrim(number_field) from table ; with no error and the message: "You might need to explicit type casts" this is postgres 8.3.

Re: [GENERAL] Out of Memory and Configuration Problems (Big Computer)

Oops. Sorry about that. I am having this problem with multiple queries however I am confident that a fair number may involve the custom plpython "normalise" function which I have made myself. I didn't think it would be complicated enough to produce a memory problem.. here it is: -- Normalises com

Re: [GENERAL] No lidbl.so in libpq.so (postgresql 8.4.4)

Nilesh Govindarajan wrote: On Tue, May 25, 2010 at 7:48 PM, Gary Fu wrote: Hi, On my mandriva linux, I don't have problem to build pgpool 2.3.3 with postgresql 8.4.2. But when I upgraded to 8.4.4, I cannot build pgpool again due to the libdl.so is not required in libpq.so (from the ldd com

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

In response to Adrian Klaver : > On 05/28/2010 11:20 AM, erobles wrote: > > hi! > > only for ask, there is a way to deactivate type validation, so i can do > > > > select rtrim(number_field) from table ; with no error and the message: > > "You might need to explicit type casts" > > > > this is pos

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

On 05/28/2010 11:20 AM, erobles wrote: hi! only for ask, there is a way to deactivate type validation, so i can do select rtrim(number_field) from table ; with no error and the message: "You might need to explicit type casts" this is postgres 8.3.1. What are you trying to do? I am trying to

[GENERAL] there is a way to deactivate type validation on 8.3.1????

hi! only for ask, there is a way to deactivate type validation, so i can do select rtrim(number_field) from table ; with no error and the message: "You might need to explicit type casts" this is postgres 8.3.1. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To mak

Re: [GENERAL] cannot use column references in default expression?

On Fri, May 28, 2010 at 10:50 PM, Jignesh Shah wrote: > Could anyone please help me to get rid of following error? I want to set the > 'ishuman' column based on the value of 'ID' column but it is not allowing me > to do so. Any alternatives? > > techdb=> CREATE TABLE Users ( >    ID INTEGER, >

Re: [GENERAL] cannot use column references in default expression?

On 05/28/2010 10:41 AM, Jignesh Shah wrote: Trigger should be the last solution. This used to be working but I think with latest postgresql upgrade, this stopped working. Might be someone around here knows whats going on here. Thanks, Jignesh On Fri, May 28, 2010 at 11:00 PM, Craig Ringer wrote

Re: [GENERAL] cannot use column references in default expression?

On May 28, 2010, at 10:41 AM, Jignesh Shah wrote: Trigger should be the last solution. This used to be working but I think with latest postgresql upgrade, this stopped working. Might be someone around here knows whats going on here. I'm afraid not. It's never been allowed to have a variab

Re: [GENERAL] cannot use column references in default expression?

Trigger should be the last solution. This used to be working but I think with latest postgresql upgrade, this stopped working. Might be someone around here knows whats going on here. Thanks, Jignesh On Fri, May 28, 2010 at 11:00 PM, Craig Ringer wrote: > On 29/05/2010 1:20 AM, Jignesh Shah wrote

Re: [GENERAL] cannot use column references in default expression?

On 29/05/2010 1:20 AM, Jignesh Shah wrote: Could anyone please help me to get rid of following error? I want to set the 'ishuman' column based on the value of 'ID' column but it is not allowing me to do so. Any alternatives? Use a BEFORE trigger to set it. -- Craig Ringer -- Sent via pgsql-ge

Re: [GENERAL] INSERTing lots of data

On 28/05/2010 9:17 PM, Joachim Worringen wrote: In the "import data" case, however, I really need concurrent processing on the CPU in the first place, so you may be right on this one. I'll check it. If you run into GIL problems, you can always work around it by spawning multiple processes and

[GENERAL] cannot use column references in default expression?

Could anyone please help me to get rid of following error? I want to set the 'ishuman' column based on the value of 'ID' column but it is not allowing me to do so. Any alternatives? techdb=> CREATE TABLE Users ( ID INTEGER, isHumanBOOLEAN NOT NULL DEFAUL

Re: [GENERAL] No lidbl.so in libpq.so (postgresql 8.4.4)

> On Fri, May 28, 2010 at 10:13 PM, Gary Fu wrote: > > Nilesh Govindarajan wrote: > >> > >> On Tue, May 25, 2010 at 7:48 PM, Gary Fu wrote: > >> > >>> > >>> Hi, > >>> > >>> On my mandriva linux, I don't have problem to build pgpool 2.3.3 with > >>> postgresql 8.4.2.  But when I upgraded to 8.4.4,

Re: [GENERAL] No lidbl.so in libpq.so (postgresql 8.4.4)

On Fri, May 28, 2010 at 10:13 PM, Gary Fu wrote: > Nilesh Govindarajan wrote: >> >> On Tue, May 25, 2010 at 7:48 PM, Gary Fu wrote: >> >>> >>> Hi, >>> >>> On my mandriva linux, I don't have problem to build pgpool 2.3.3 with >>> postgresql 8.4.2.  But when I upgraded to 8.4.4, I cannot build pgpo

Re: [GENERAL] Out of Memory and Configuration Problems (Big Computer)

In response to Tom Wilcox : > In addition, I have discovered that the update query that runs on each row > of a 27million row table and fails with Out of memory error will work when > limited to 1million rows in an extremely shorter period of time: > > EXPLAIN ANALYZE > UPDATE nlpg.match_

Re: [GENERAL] Config Changes Broke Postgres Service (Windows)

On 28 May 2010, at 15:40, Tom Wilcox wrote: > Hi, > > I am fighting with Postgres on a 64-bit Windows (Server 2008) machine with > 96GB trying to get it to use as much memory as possible (I am the only user > and I am running complex queries on large tables). [See my previous thread > for deta

Re: [GENERAL] Out of Memory and Configuration Problems (Big Computer)

In response to Tom Wilcox : > Also, can anyone give me any pointers for configuring postgres to use > ALL 96GB of RAM in my new machine? I would like to know it was using > everything available.. especially when it is possible to load an entire > 30m row table into memory! I am currently usin

Re: [GENERAL] Config Changes Broke Postgres Service (Windows)

Hi Stephen, Thanks for the response. Unfortunately, we are somewhat tied to a Windows platform and I would expect us to sooner switch to SQL Server rather than move to Linux/Unix/BSD.. Although, (in complete contrast to what I just said), I am toying with the idea of the dual boot or virtuali

[GENERAL] Re: [GENERAL] hi，for help!

What is the output of the following commands? psql -l psql --version -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On Fri, May 28, 2010 at 7:11 PM, zhenyang guo wrote: > hi, i have a problem not knowing how to fix . the follwi

Re: [GENERAL] Config Changes Broke Postgres Service (Windows)

* Tom Wilcox (hungry...@googlemail.com) wrote: > Can anyone tell me what might be going on and how I can fix it so that > postgres uses as much memory and processing power as poss... in a stable > manner? I realize this probably isn't the answer you're looking for, and hopefully someone can come u

Re: [GENERAL] hi，for help!

You need to "initdb" first. Am Freitag, 28. Mai 2010 15:41:38 schrieb zhenyang guo: > hi, i have a problem not knowing how to fix . the follwing are error > information: > > " > g...@guo-desktop:~$ su > Password: > r...@guo-desktop:/home/guo# su - postgres > postg...@guo-desktop:~$ psql > psql:

Re: [GENERAL] hi，for help!

zhenyang guo wrote: > hi, i have a problem not knowing how to fix . the follwing are error > information: > > " > g...@guo-desktop:~$ su > Password: > r...@guo-desktop:/home/guo# su - postgres > postg...@guo-desktop:~$ psql > psql: FATAL: database "postgres" does not exist > postg...@guo-desk

[GENERAL] Config Changes Broke Postgres Service (Windows)

Hi, I am fighting with Postgres on a 64-bit Windows (Server 2008) machine with 96GB trying to get it to use as much memory as possible (I am the only user and I am running complex queries on large tables). [See my previous thread for details "Out of Memory and Configuration Problems (Big Computer)

[GENERAL] subscribe

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

[GENERAL] hi，for help!

hi, i have a problem not knowing how to fix . the follwing are error information: " g...@guo-desktop:~$ su Password: r...@guo-desktop:/home/guo# su - postgres postg...@guo-desktop:~$ psql psql: FATAL: database "postgres" does not exist postg...@guo-desktop:~$ createdb test createdb: could not c

Re: [GENERAL] UPDATE...RETURNING col INTO var - what is returned?

Thank you for your reply. Yes, testing proved "after" values being returned. Nevertheless I'm wondering whether this behaviour is (formally) defined somewhere or just happens to be so by implementation detail. (Of course, this is a minor concern as the PG team for sure will guard against a chang

Re: [GENERAL] Searching for paper about pg's optimizer cost model

Daniel Bausch writes: > does anybody know a paper (or any document but the code itself) containing a > description of the current cost model used by the query optimizer/planner. If you look on the project website you can find slides from various conference presentations that give overviews of th

Re: [GENERAL] PostgreSQL DBA Opening

This is the wrong list for this. You should post to pgsql-jobs only, 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

[GENERAL] PostgreSQL DBA Opening

Company: Aggregate Knowledge Location: San Mateo, CA Position: PostgreSQL Database Administrator Job Description: Aggregate Knowledge, a fast growing company backed by top-tier venture capital, is pioneering the new category discovery as an on-line service. As a result of our rapid growth, we

Re: [GENERAL] Out of Memory and Configuration Problems (Big Computer)

* Tom Wilcox (hungry...@googlemail.com) wrote: > UPDATE tbl SET f1 = COALESCE(f2,'') || ' ' || COALESCE(f3); > > Can anyone suggest reasons why I might be running out of memory on such > a simple query? Do you have any triggers on that table? Or FK's? Stephen signature.asc Descriptio

Re: [GENERAL] INSERTing lots of data

On 05/28/2010 02:55 PM, Craig Ringer wrote: On 28/05/10 17:41, Joachim Worringen wrote: Greetings, my Python application (http://perfbase.tigris.org) repeatedly needs to insert lots of data into an exsting, non-empty, potentially large table. Currently, the bottleneck is with the Python applica

[GENERAL] Out of Memory and Configuration Problems (Big Computer)

Hi, I am fairly new to postgres and I have been using it with Python to develop a set of functions that operate on some moderately large tables (30million rows with 13-15 columns). I have spent some time messing with the configuration file to get PG to use indexes when planning queries, etc

Re: [GENERAL] INSERTing lots of data

On 28/05/10 17:41, Joachim Worringen wrote: Greetings, my Python application (http://perfbase.tigris.org) repeatedly needs to insert lots of data into an exsting, non-empty, potentially large table. Currently, the bottleneck is with the Python application, so I intend to multi-thread it. That

Re: [GENERAL] hi, trying to compile postgres 8.3.11

erobles wrote: >> Do you need the Pg server to run on SCO OpenServer? > > Yes, i need it :-P Of course it's none of my business, but whenever I had a supplier insisting on some idosyncratic or obsolete OS I started thinking hard about replacing the supplier and their product. Even worse if

Re: [GENERAL] Merge data from two databases

Actually you have to write a program to insert one database into another. This is so the program can check for concistancy and maybe recect records or datasets that are inconsistent. GH 2010/5/28 Jamie Lawrence-Jenner > Hi There > > > > We have a stats databases which has been dumped out a few

[GENERAL] Searching for paper about pg's optimizer cost model

Hello, does anybody know a paper (or any document but the code itself) containing a description of the current cost model used by the query optimizer/planner. I'm about to write a master thesis in this area that aims for more exact estimates. Best would be some mathematical formulas with a ratio

[GENERAL] Merge data from two databases

Hi There We have a stats databases which has been dumped out a few times over the last year. What i would now like to do is to merge these dumps into one database. The problem is is that when the dumps were done, a drop and create was carried out on the database so primary key columns will

Re: [GENERAL] INSERTing lots of data

On 28 May 2010, at 12:14, Martin Gainty wrote: > Good Afternoon Szymon! > > Could you explain what a Python GIL is? and if there is any workaround to > Python GIL we can implement to achieve better performance..possibly at the > database level? See here: http://en.wikipedia.org/wiki/Global_In

Re: [GENERAL] INSERTing lots of data

Good Afternoon Szymon! Could you explain what a Python GIL is? and if there is any workaround to Python GIL we can implement to achieve better performance..possibly at the database level? Mit freundlichen Grüßen/Les plus sincères amitiés Martin Gainty

Re: [GENERAL] INSERTing lots of data

On 05/28/2010 11:48 AM, Szymon Guz wrote: Remember about Python's GIL in some Python implementations so those threads could be serialized at the Python level. My multi-threaded queries scale nicely with Python 2.6 on Linux, so this is not an issue here. But the queries do not perform concurren

Re: [GENERAL] INSERTing lots of data

2010/5/28 Joachim Worringen > Greetings, > > my Python application (http://perfbase.tigris.org) repeatedly needs to > insert lots of data into an exsting, non-empty, potentially large table. > Currently, the bottleneck is with the Python application, so I intend to > multi-thread it. Each thread

[GENERAL] INSERTing lots of data

Greetings, my Python application (http://perfbase.tigris.org) repeatedly needs to insert lots of data into an exsting, non-empty, potentially large table. Currently, the bottleneck is with the Python application, so I intend to multi-thread it. Each thread should work on a part of the input fi

Re: [GENERAL] Download

From: Devrim GÜNDÜZ To: Piotr Kublicki Cc: pgsql-general@postgresql.org Date: 28/05/2010 09:36 Subject:Re: [GENERAL] Download On Fri, 2010-05-28 at 08:37 +0100, Piotr Kublicki wrote: > And here: > http://pgfoundry.org/docman/view.php/148/1338/PostgreSQL-RPM-Installa

Re: [GENERAL] Download

On Fri, 2010-05-28 at 08:37 +0100, Piotr Kublicki wrote: > And here: > http://pgfoundry.org/docman/view.php/148/1338/PostgreSQL-RPM-Installation-PGDG.pdf That is a bit outdated. :( -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http:/

Re: [GENERAL] Download

Faiyaz, You can start from here: http://www.postgresonline.com/journal/index.php?/archives/144-An-almost-idiots-guide-to-Install-and-Upgrade-to-PostgreSQL-8.4-with-Yum.html Section titled "Installing PostgreSQL 8.4.1 from Yum repository" And here: http://pgfoundry.org/docman/view.php/148/133