:) 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
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
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
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
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:
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
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
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:
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:
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:
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
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
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
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
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
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
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
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
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
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
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
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
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. ==
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:
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
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
26 matches
Mail list logo