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
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
-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
-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
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
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
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
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/>
<>
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
>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 |
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
> 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.
> > 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
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
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
15 matches
Mail list logo
