Michael Paquier wrote:
> On Tue, Sep 27, 2016 at 2:13 PM, raf <r...@raf.org> wrote:
> > So, my qestion is, is it possible that "pg_ctl status" could be
> > removing postgres's semaphores and can I stop it? It seems
> > extremely unlikely. So, if it isn'
e cronjob does, the first
thing it does is:
/etc/init.d/postgresql-9.4 status | grep -q 'server is running' && exit 0
So it's not doing anything else if postgres is running.
Any idea what I've done wrong? (apart from the obvious) :-)
cheers,
raf
--
Sent via pgsql-genera
than days?
Q3) is a bug in plpgsql?
cheers,
raf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
significant digit is 0 or 5,
rest towards zero)
ROUND_HALF_DOWN (round 5 towards zero, rest to nearest)
ROUND_HALF_EVEN (round 5 to even, rest to nearest)
are there any plans to support any other rounding methods natively?
cheers,
raf
--
Sent via pgsql-general mailing list (pgsql-general
Peter Eisentraut wrote:
On tis, 2011-01-18 at 10:33 +1100, raf wrote:
p.s. if anyone in debian locale land is listening,
'E' does not sort before ','. what were you thinking? :-)
What is actually happening is that the punctuation is sorted in a second
pass after the letters. Which
raf wrote:
Peter Eisentraut wrote:
On tis, 2011-01-18 at 10:33 +1100, raf wrote:
p.s. if anyone in debian locale land is listening,
'E' does not sort before ','. what were you thinking? :-)
What is actually happening is that the punctuation is sorted in a second
pass after
successfully alter these
values (i.e. postgres doesn't restart after i try)
so i'm hoping it's not relevant.
can anyone explain what i've done wrong here and
suggest what i can do to fix it?
cheers,
raf
p.s. the postgres installation was PostgresPlus/8.4SS that
was subsequently upgraded via postgres
Tom Lane wrote:
raf r...@raf.org writes:
the behaviour i expect (and see on macosx-10.6.6) is:
id | name
+---
4 | CLARK
2 | CLARK, PETER
3 | CLARKE
1 | CLARKE, DAVID
the behaviour i don't expect but see anyway (on debian-5.0
Tom Lane wrote:
raf r...@raf.org writes:
i'm having a little openssl problem with pg_dump over a wireless
lan with postgres-8.4SS (on linux) from enterprisedb and
a macosx-10.6 client.
when i run pg_dump from a wired linux client it's always fine
but since i switched from a macosx
server installation. yay enterprisedb!
cheers,
raf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
raf wrote:
Sachin Srivastava wrote:
the latest enterprisedb standard server is only 8.4.1 (New! 13-Oct-09) :-)
By using the StackBuilder Plus application, you can upgrade your server
to 8.4.4.
--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com
something to do with openssl on the mac.
any ideas?
cheers,
raf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
that i need this behaviour for anything. i'm just curious
and didn't see any mention of this in the documentation for
the select statement.
cheers,
raf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
Dave Page wrote:
On Tue, Dec 1, 2009 at 1:52 AM, raf r...@raf.org wrote:
hi,
i just tried to upgrade libpq.dll on windows and couldn't
work out how to do it. in the past, with 8.3.x, i knew i had
to download the entire server even though i only wanted
the client but at least i
the server and client
software and then uninstall the server software?
cheers,
raf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Tom Lane wrote:
raf r...@raf.org writes:
declare
pay_group_rec pay_group;
balance decimal(10,2)[];
begin
select g.* into pay_group_rec from pay_group g where g.id =
pay_group_id;
select
sum(p.balance_period[1
code...
cheers,
raf
--- full error message
error 'ERROR: syntax error at or near [
LINE 1: ...sum(p.balance_period[1]), sum(p.balance_period[2])[1], $1 [...
^
QUERY: select sum
Dave Page wrote:
On Mon, Feb 23, 2009 at 7:55 AM, raf r...@raf.org wrote:
hi,
i've been getting nonsensical error messages all day with
postgres 8.3 on winxpsp3. i tried upgrading to 8.3.6
(enterprisedb) and fresh installs.
Please clarify what you have done. You cannot upgrade from
/Monty_Hall_problem
except that there's no goat :(
cheers,
raf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
i'd also like the pg_ctl start/stop commands to work again
because they give actual error messages unlike the net
start/stop commands. are they supposed to work with
enterprisedb? i've seen them working on another windows
enterprisedb installation that i set up a while ago.
cheers,
raf
--
Sent
20 matches
Mail list logo