Re: [GENERAL] Problem libpython2.3.so.1.0

2009-08-31 Thread nesfree
:) Of course. As I have told I am using Ubuntu 9.04, python 2.6.2, postgres 8.4. Supported version for Ubuntu 9.04 is PostgreSQL 8.3.7 and when I install it I have plpython. As I understood 8.4 have some new possibilities regarding plpython. I installed Postgres 8.4 using binary file downloaded

Re: [GENERAL] [Skytools-users] WAL Shipping + checkpoint

2009-08-31 Thread Sébastien Lardière
On 28/08/2009 18:14, Simon Riggs wrote: On Fri, 2009-08-28 at 17:54 +0200, Sébastien Lardière wrote: Since this moment, the slave didn't make any checkpoint. Now, we know why. Thanks a lot ! But how can i fix it ? Current issue: Rebuild standby from base backup. Cause: Locate the

Re: [GENERAL] Problem libpython2.3.so.1.0

2009-08-31 Thread Daniel Verite
nesfree wrote: :) Of course. As I have told I am using Ubuntu 9.04, python 2.6.2, postgres 8.4. Supported version for Ubuntu 9.04 is PostgreSQL 8.3.7 and when I install it I have plpython. As I understood 8.4 have some new possibilities regarding plpython. I installed Postgres

[GENERAL] Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.

2009-08-31 Thread NNL
Hello. I¹m having a problem starting server on mac os x. - bash-3.2$ /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data server starting bash-3.2$ LOG: could not open configuration file /usr/local/pgsql/data/pg_hba.conf: Permission denied FATAL: could not load pg_hba.conf

Re: [GENERAL] Query and the number of row result

2009-08-31 Thread bilal ghayyad
Just writing a Function in the PostgreSQL it self (so it is sql scripting). It is not from any development language. Regards Bilal --- On Sun, 8/30/09, David Fetter da...@fetter.org wrote: From: David Fetter da...@fetter.org Subject: Re: [GENERAL] Query and the number of row result To:

Re: [GENERAL] Problem libpython2.3.so.1.0

2009-08-31 Thread nesfree
Thank u man, After many difficulties (adding new software sources) I succeeded! U enlightened my way! Best regards, Predrag On Mon, Aug 31, 2009 at 11:19 AM, Daniel Verite dan...@manitou-mail.orgwrote: nesfree wrote: :) Of course. As I have told I am using Ubuntu 9.04, python

Re: [GENERAL] Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.

2009-08-31 Thread Sachin Srivastava
Hello, -- hostall all 10.0.0.6 md5 You have to add mask to the ip. like, hostall all 10.0.0.6/32 md5 -- Regards, Sachin Srivastava www.enterprisedb.com

Re: [GENERAL] Query and the number of row result

2009-08-31 Thread Naoko Reeves
Which client do you use to access to db? GUI (pgAdmin?)? Command-line? Either way, it should give you row number... -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of bilal ghayyad Sent: Monday, August 31, 2009 4:11 AM To:

Re: [GENERAL] Query and the number of row result

2009-08-31 Thread Sam Mason
On Mon, Aug 31, 2009 at 04:10:48AM -0700, bilal ghayyad wrote: Just writing a Function in the PostgreSQL it self (so it is sql scripting). It is not from any development language. You mean you're using plpgsql? If so then the plpgsql docs are available here and should help:

Re: [GENERAL] Query and the number of row result

2009-08-31 Thread Adrian Klaver
On Monday 31 August 2009 4:10:48 am bilal ghayyad wrote: Just writing a Function in the PostgreSQL it self (so it is sql scripting). It is not from any development language. Regards Bilal If you move to pl/pgsql you could use GET DIAGNOSTICS:

[GENERAL] print/return only the first X chars of a varchar column?

2009-08-31 Thread Kevin Kempter
Hi all; I'm selecting from a table that has a varchar(1000) but I only want to display the firs 20 characters. Looked at the string functions in the docs but nothing jumped out... Suggestions? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] print/return only the first X chars of a varchar column?

2009-08-31 Thread Adrian Klaver
On Monday 31 August 2009 7:49:12 am Kevin Kempter wrote: Hi all; I'm selecting from a table that has a varchar(1000) but I only want to display the firs 20 characters. Looked at the string functions in the docs but nothing jumped out... Suggestions? Thanks in advance substring(string

[GENERAL] Looking for proper escape string syntax from pg_get_constraintdef

2009-08-31 Thread Marc Munro
I am trying to recreate a domain definition from information in pg_catalog and getting the following warnings: WARNING: nonstandard use of \\ in a string literal LINE 3: CHECK (((VALUE ~ '^\\d{4}$'::text) OR (VALUE ~ '^\\d{5}-\\... ^ HINT: Use the escape

Re: [GENERAL] Looking for proper escape string syntax from pg_get_constraintdef

2009-08-31 Thread Tom Lane
Marc Munro m...@bloodnok.com writes: but retrieving the constraint definition using pg_get_constraintdef(oid) gives me this: CHECK (((VALUE ~ '^\\d{4}$'::text) OR (VALUE ~ '^\\d{5}-\\d{4}$'::text))) How can I get the constraint definition with proper escaping from the catalog? Is there

Re: [GENERAL] Audit Trigger puzzler

2009-08-31 Thread David Kerr
On Fri, Aug 28, 2009 at 08:07:40PM +0100, Simon Riggs wrote: - - On Fri, 2009-08-28 at 08:50 -0700, David Kerr wrote: - - so, is there a way in a trigger to know if edited_by is expressly - being set in the update statement? it seems like if I can know that, - then i should be able to figure

Re: [GENERAL] Query and the number of row result

2009-08-31 Thread bilal ghayyad
I am talking in case I am writing a script for a function, and I need to know the number of the returned rows of the query, then I will do IF statement based on that number, how? Regards Bilal --- On Mon, 8/31/09, Naoko Reeves na...@lawlogix.com wrote: From: Naoko Reeves na...@lawlogix.com

Re: [GENERAL] Query and the number of row result

2009-08-31 Thread Tim Landscheidt
bilal ghayyad bilmar...@yahoo.com wrote: I am talking in case I am writing a script for a function, and I need to know the number of the returned rows of the query, then I will do IF statement based on that number, how? [...] Presuming that you are talking about a function written in

Re: [GENERAL] Import data from XML file

2009-08-31 Thread Erwin Brandstetter
Thanks Scott! (And thanks for all the other hints!) Yes, the goal is to get the data into tables in a pg database. Having a CSV file or having the data in pg-tables, both equally solve the problem. I like this approach as it does not involve additional tools. I will have to upgrade to pg 8.4

Re: [GENERAL] Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.

2009-08-31 Thread John DeSoi
On Aug 31, 2009, at 5:24 AM, NNL wrote: BigMac:~ postgres$ FATAL: data directory /usr/local/pgsql/data has group or world access DETAIL: Permissions should be u=rwx (0700). chmod 700 /usr/local/pgsql/data/ BigMac:~ postgres$ /usr/local/pgsql/bin/pg_ctl start -D /usr/local/ pgsql/data

Re: [GENERAL] indexes on partitioned tables - on the base table, or the partitioned tables?

2009-08-31 Thread Hrishikesh Mehendale
Hi Kevin, From the PG documentation (section 5.8 - inheritance): http://www.postgresql.org/docs/current/static/ddl-inherit.html A serious limitation of the inheritance feature is that indexes (including unique constraints) and foreign key constraints only apply to single tables, not to their

[GENERAL] Import Using PHPPGADMIN

2009-08-31 Thread BlackMage
Is there a plug-in or anything that will allow me to import a whole databases using PHPPGADMIN. I can import tables seperately but I have about some 70 odd tables to import. -- View this message in context: http://www.nabble.com/Import-Using-PHPPGADMIN-tp25228684p25228684.html Sent from the

Re: [GENERAL] Question on round-robin partitioning

2009-08-31 Thread Vick Khera
On Sat, Aug 29, 2009 at 7:31 AM, Alban Hertroysdal...@solfertje.student.utwente.nl wrote: What about foo_id = 100 AND foo_id % 8 = 100 % 8 ? If the optimizer computes 100 % 8 before running the constraint matching then it would work. I'm not sure it does. foo_id=100 and foo_id % 8 = 4 will

[GENERAL] Aggregate function with subquery in 8.3 and 8.4.

2009-08-31 Thread Sheng Cheng
PostgreSQL version: 8.4.0 / 8.3.1 Operating system: Red Hat 4.1.1-52 Description:Aggregate function with subquery in 8.3 and 8.4. Details: Here are some facts and questions about the aggregate function with subquery in 8.3 and 8.4. = Question 1. ==

Re: [GENERAL] [Skytools-users] WAL Shipping + checkpoint

2009-08-31 Thread Yaroslav Tykhiy
On 31/08/2009, at 6:16 PM, Sébastien Lardière wrote: On 28/08/2009 18:14, Simon Riggs wrote: On Fri, 2009-08-28 at 17:54 +0200, Sébastien Lardière wrote: Since this moment, the slave didn't make any checkpoint. Now, we know why. Thanks a lot ! But how can i fix it ? Current issue:

[GENERAL] Eclipse jdbc postgresql

2009-08-31 Thread Sheepjxx
If I want to use postgres with jdbc , I have already download jdbc, do I need extra option for compile postgres?--with-java?do I need change postgres.conf? From iTouch. z3246...@student.unsw.edu.au xia...@student.unsw.edu.au -- Sent via pgsql-general mailing list

Re: [GENERAL] Eclipse jdbc postgresql

2009-08-31 Thread John R Pierce
Sheepjxx wrote: If I want to use postgres with jdbc , I have already download jdbc, do I need extra option for compile postgres?--with-java?do I need change postgres.conf? you just need postgres configured so you can connect to it via tcp (as jdbc doesn't do local domain sockets), and you