duh!listen_addresses = '*'I must add that having to modify both files for
remote access is a bit misleading, and I didn't set at least 4 postgresql
servers before...From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: [GENERAL] Ubuntu,
Postgresql-8.2 and remote access thru pg_hba.confDate: Mon, 18 Jun 20
Jan Danielsson wrote:
> Andrej Ricnik-Bay wrote:
> > On 6/18/07, Jan Danielsson <[EMAIL PROTECTED]> wrote:
> >>UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
> > Something like this?
> > http://www.joeconway.com/plr/
>
>That looks too good to be true.
>
>Many thanks!
>
Hi,I just want to say that ubuntu team done an excelent job integration the
penultimate version of postgresql in spite of the fact that I was running 7.4.7
it manages to install 8.2 in paralel without affecting my production version.
There is one single thing that bothers me big time - I cannot
On Mon, Jun 18, 2007 at 05:11:51AM +0200, Jan Danielsson wrote:
> Are there any statistical libraries for postgresql?
>
> I'd like to do something along the lines of:
>
> UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
Somebody else has mentioned PL/R. For this particular example
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Andrej Ricnik-Bay wrote:
> On 6/18/07, Jan Danielsson <[EMAIL PROTECTED]> wrote:
>>UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
> Something like this?
> http://www.joeconway.com/plr/
That looks too good to be true.
Many
On 6/18/07, Jan Danielsson <[EMAIL PROTECTED]> wrote:
UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
Something like this?
http://www.joeconway.com/plr/
-- Cheers,
Andrej
---(end of broadcast)---
TIP 9: In versions below 8.0
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Are there any statistical libraries for postgresql?
I'd like to do something along the lines of:
UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
- --
Kind regards,
Jan Danielsson
-BEGIN PGP SIGNATURE-
Version: GnuP
Sergei Shelukhin <[EMAIL PROTECTED]> wrote:
> This is my first (and, by the love of the God, last) project w/pgsql
> and everything but the simplest selects is so slow I want to cry.
Please post an example query and its EXPLAIN ANALYZE output. The
pgsql-performance mailing list is a good place to
Hi Jhon
Diferent distros put file in diferent path
try
/usr/local/pgsql/initdb bla bla bla
or
/var/lib/postgres/bin/initdb bla bla bla
or
locate initdb
for locate that file
best regards
mdc
--- John K Masters <[EMAIL PROTECTED]>
escribió:
> I feel somewhat embarrassed to post this
A long time ago, in a galaxy far, far away, Sergei Shelukhin <[EMAIL
PROTECTED]> wrote:
> This is my first (and, by the love of the God, last) project w/pgsql
> and everything but the simplest selects is so slow I want to cry.
> This is especially bad with vacuum analyze - it takes several hours
>
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Allison escribió:
>> insert into table(string) values(('one'),('two'),('three')) returning
>> idx;
>>
>> I realize that this is an extension to standard SQL but it sure would
>> save me a lot.
> You are wrong -- you can do it, but it is not an
Tom Allison escribió:
> Holy Crud!
> you mean to tell me I can replace:
>
> insert into table(string) values(('one'),('two'),('three'));
> select idx from table where string in ('one','two','three');
>
> with
>
> insert into table(string) values(('one'),('two'),('three')) returning
> idx;
>
On sun, 2007-06-17 at 21:50 +, Ragnar wrote:
> On sun, 2007-06-17 at 19:59 +0100, John K Masters wrote:
> > I feel somewhat embarrassed to post this but I can't get past the first
> > post with Postgresql. I have installed onto a Debian testing system,
> > created a space for the database clust
On sun, 2007-06-17 at 19:59 +0100, John K Masters wrote:
> I feel somewhat embarrassed to post this but I can't get past the first
> post with Postgresql. I have installed onto a Debian testing system,
> created a space for the database cluster on /usr/local/pgsql/data,
> changed owner to postgres
On 6/17/07, Tom Allison <[EMAIL PROTECTED]> wrote:
Perl has a high entry barrier.
yeah right ;).
perl is time-tested better for sys admin than the web. and we all know how
sys admins want to use the same code for the web but it doesn't cut right.
*if anything* php is 'enhanced perl' for the w
On 6/18/07, John K Masters <[EMAIL PROTECTED]> wrote:
I feel somewhat embarrassed to post this but I can't get past the first
post with Postgresql. I have installed onto a Debian testing system,
created a space for the database cluster on /usr/local/pgsql/data,
changed owner to postgres and chang
On lau, 2007-06-16 at 18:58 -0700, Ottavio Campana wrote:
> Martijn van Oosterhout wrote:
> >
> > Cursors are attached to the transactio and session, if either ends, the
> > cursor dies with it...
> >
> > Have a nice day,
>
> another question:
>
> since they live in a transaction, how can they
I feel somewhat embarrassed to post this but I can't get past the first
post with Postgresql. I have installed onto a Debian testing system,
created a space for the database cluster on /usr/local/pgsql/data,
changed owner to postgres and changed permissions to 0700.
However, when I try `initdb -D
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All,
I've installed pgadmin3 1.6.3 from rpm, under Fedora 7
It runs ok, *except* when the tables have geometry fields! :O
When one tries to open/view the table it takes **forever** to display
the table's records! (?)
This is what I get when ps aux
On 06/17/07 00:19, Greg Smith wrote:
On Sat, 16 Jun 2007, Ron Johnson wrote:
Anyway... databases are always(?) IO bound. I'd try to figure out how
to make a bigger hose (or more hoses) between the spindles and the mobo.
What I keep waiting for is the drives with flash memory built-in to
mat
On Jun 16, 2007, at 7:51 PM, Leif B. Kristensen wrote:
On Saturday 16. June 2007 23:34, Erick Papadakis wrote:
How much value you derive from a language
depends on how you use it. After playing for years with Perl, and now
with Python and Ruby, I think PHP is still where it's at.
I too have
On Jun 16, 2007, at 4:12 PM, Uwe C. Schroeder wrote:
On Saturday 16 June 2007, John Smith wrote:
guys,
love both tools but php @ 2.5 *billion* google results is far more
popular than postgresql @ 25 million google results. *if* somebody's
gotto adapt it's not php. php does what it does best
On Jun 16, 2007, at 3:38 PM, John Smith wrote:
guys,
love both tools but php @ 2.5 *billion* google results is far more
popular than postgresql @ 25 million google results. *if* somebody's
gotto adapt it's not php. php does what it does best in a way that
stuffy academics don't get.
I would
Aha ... makes sense. Thank you, Tom.
Mark
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 16, 2007 11:21 AM
To: Mark Soper
Cc: 'John DeSoi'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dynamically generating DDL for postgresql object
"Mark Sop
24 matches
Mail list logo
