We're writing a large amount of data to a number of tables in PG 9.3 on Windows
Server 2012 R2 and then, immediately after, creating a number of indexes (there
are no indexes during the initial data write). The data we're writing exists in
files on the same drive as PG's data.
During the index c
he
world.
The more important bit would be to stop any further data loss.
Regards,
Russell Keane
INPS
Tel: +44 (0)20 7501 7277
Follow us<https://twitter.com/INPSnews> on twitter | visit
www.inps.co.uk<http://www.inps.co.uk/>
Registered nam
-Original Message-
From: Bruce Momjian [mailto:br...@momjian.us]
Sent: 15 August 2014 17:06
To: Russell Keane
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Upgrading 9.0 to 9.3 - permission denied to
pg_upgrade_utility.log
On Tue, Aug 12, 2014 at 10:59:16AM +0100, Russell
-Original Message-
From: Bruce Momjian [mailto:br...@momjian.us]
Sent: 07 August 2014 17:43
To: Russell Keane
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Upgrading 9.0 to 9.3 - permission denied to
pg_upgrade_utility.log
On Thu, Aug 7, 2014 at 09:42:13AM +0100, Russell
starts up fine and everything
seems to be in order. All the data exists and there are no errors in the PG log
at startup. I don't really want to simply ignore this error but it doesn't seem
to be causing any issues.
Any ideas?
Regards,
Russell K
But this works just fine when using libpq via c++.
From: davecra...@gmail.com [mailto:davecra...@gmail.com] On Behalf Of Dave
Cramer
Sent: 26 February 2013 12:23
To: Russell Keane
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] JDBC not returning update count from updateable view
As
q restart 1;
delete from msg_table;
insert into msg
(val)
values
(1),
(2),
(66);
select * from msg;
update msg
set val = 5
where id = 1;
select * from msg;
--PG END
Thanks for any help you can give me.
Regards,
Russell Keane
INPS
Follow us<https://twitter.com/INPSnews> on twitt
> > I have a simple void function:
> >
> > CREATE OR REPLACE FUNCTION myfn(myparam OUT int) AS $$ BEGIN
> >pnr := 1;
> > END;
> > $$ LANGUAGE plpgsql;
> >
> > How do I access myparam?
> > I thought this should work with 9.1/9.2: SELECT (myfn()).myparam; Or
> > inside another function?
>
> You
> select serial_no, count(*) as "restarts" from event_log where event_mesg
> ilike 'system sta%' and event_date > current_date - 7
> group by serial_no
> having count(*) > X
> order by restarts
I think having is the better option.
ad more than X
> restarts.
>
> Any ideas would be appreciated.
>
> --
> Stephen Clark
Could you not do:
Select * from
(
select serial_no, count(*) as "restarts" from event_log where event_mesg ilike
'system sta%' and event_date > current_date - 7 group by serial_no
>Moving the exclusion operation up a level seems to do the trick:
>
>testdb=# BEGIN ;
>BEGIN
>testdb=*# update tableA set f2 = (select array_agg(X.id) from (select f1,
>unnest(f2) id from tablea where f1 = 1) x WHERE x.id != 101) where f1=1;
>UPDATE 1 testdb=*# SELECT * from tablea ;
> f1 |
a set f2 = (select array_agg(X.id) from (select f1, unnest(f2) id from
>a where f1 = 1 except select 1 f1, 101 id) X) where f1 = 1;
And with the correct table name:
update tableA set f2 = (select array_agg(X.id) from (select f1, unnest(f2) id
from tableA where f1 = 1 except select 1 f1, 101
t f1, unnest(f2) id from a
where f1 = 1 except select 1 f1, 101 id) X) where f1 = 1;
Regards,
Russell Keane
INPS
Tel: +44 (0)20 7501 7277
[cid:image001.jpg@01CE0F8B.75C5EF60]
Follow us<https://twitter.com/INPSnews> on twitter | visit
www.inps.co.uk<http://www.inps.co.uk/>
<>
ecreate your table structure in MS Access and use its graphical query
builder to generate your SQL. It does allow for group by's, counts, etc.
Regards,
Russell Keane
INPS
Follow us on twitter | visit www.inps.co.uk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
etween the functionality or behaviour in 32 / 64 postgres for windows?
Thanks for your help,
Regards,
Regards,
Russell Keane
INPS
Tel: +44 (0)20 7501 7277
[cid:image001.jpg@01CE0546.44E37510]
Follow us<https://twitter.com/INPSnews> on twitter | visit
www.inps.co.uk<ht
15 matches
Mail list logo
