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 ne
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 (pgsql-general@postgresql.
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: Rebuild
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. ==
I
On Sat, Aug 29, 2009 at 7:31 AM, Alban
Hertroys 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 definitely match your constraint.
D
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 Pos
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
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 firs
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
bilal ghayyad 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
PL/pgSQL, you will ha
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 wrote:
> From: Naoko Reeves
> Subject: RE: [GENERAL] Query and th
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 figu
Marc Munro 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 another functi
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 strin
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
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 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:
(http://www.postgresql.org/docs/8.4/intera
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:
http://www.post
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:
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
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 wrote:
>nesfree wrote:
>
> > :) Of course. As I have told I am using Ubuntu 9.04, python 2.6.2,
> postgres
> > 8
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 wrote:
> From: David Fetter
> Subject: Re: [GENERAL] Query and the number of row result
> To: "bilal ghayyad"
> Cc: pgsql-gener
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
--
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
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 b
:) 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
26 matches
Mail list logo
