Michael Paquier wrote:
> On Tue, Sep 27, 2016 at 2:13 PM, raf 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't, what else co
heck the status. And the problem still occurs.
In case you're wondering what else the 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 runnin
ence is stored in an interval variable to allow it to happen?
Q2) when it happens, why is the number of days stored in the interval as seconds
rather 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
(round away from zero if last 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-g
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 ac
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 so
Tom Lane wrote:
> raf 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
>
> &g
quot; server has lc_messages="en_AU.utf8" which may
be relevant but i can't 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
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.
> >
> > --
> > Re
for the core
distribution detected and happily upgraded the existing
standard 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
Tom Lane wrote:
> raf 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 fin
ood
reason for that.
so it probably has 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
me of a column in the table.
so, what's this behaviour for, and, is there an equivalent
way to do it when "name" is the name of a column? i doubt
that i need this behaviour for anything. i'm just curious
and didn't see any mention of this in the documentation for
the se
Dave Page wrote:
> On Tue, Dec 1, 2009 at 1:52 AM, raf 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 wa
ed. should i install 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 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;
>
> > s
. time to write some ugly 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 [...
t your maths is wrong.
>
> There are 9 possible cases. In 3 of them you return 1. In 2 of them you
> return 2. In the remaining 4 cases you return 3.
>
> If you were to run this 72451 times I'd expect to see
> 1: 24150 = 72451 * 3/9
> 2: 16100 = 72451 * 2/9
> 3:
Dave Page wrote:
> On Mon, Feb 23, 2009 at 7:55 AM, raf 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
appening. it seems i
can only run postgres on windows with ssl=off and i want to
force the use of ssl.
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 se
20 matches
Mail list logo
