previous Windows installations. Would that be something to try?
I'm running out of ideas for what else to try. Any help will be much
appreciated.
Regards,
Martin
Update: I've just tried with version 12.6-1 and works perfectly fine.
Clearly, there is some bug in the 13.2-1 published version.
On 2021-03-31 16:35, Martin wrote:
Hello,
I'm trying to install 13.2-1 on Windows 10. Previous version was 10.5, installed using the EnterpriseDB
event garbage?
If there’s no natural PK, at least a synthetic one will allow very quick record
identification if used.
Martin.
Using pgAdmin 4 2.0 on pg 9.6 and 10 I get div/0 error.
On 05/03/2018, 14:22, "Adrian Klaver" wrote:
On 03/05/2018 06:05 AM, Łukasz Jarych wrote:
> Hi Guys,
>
> what is wrong with my pgAdmin?
>
> I am creating wrong query:
>
> select 1/0 but still this is ex
I have a very primitive question about division to which I can’t find an
obvious answer in the documentation.
Given two values defined as integers, how do I divide one by the other and get
an answer with two decimals, e.g 3 /4 = 0.75.
This is very simple in mysql and seems to be oddly contorted
.
From: "David G. Johnston"
Date: Wednesday, March 7, 2018 at 11:23 AM
To: Martin Mueller
Cc: "pgsql-general@lists.postgresql.org"
Subject: Re: a very primitive question about division
On Wed, Mar 7, 2018 at 10:21 AM, Martin Mueller
mailto:martinmuel...@northwestern.edu>&g
progressed much beyond
8th grade math.
From: "David G. Johnston"
Date: Wednesday, March 7, 2018 at 11:43 AM
To: Martin Mueller
Cc: "pgsql-general@lists.postgresql.org"
Subject: Re: a very primitive question about division
On Wed, Mar 7, 2018 at 10:30 AM, Martin Muelle
about the problem of
decimals in division, together with an example of how to do 4/9 in different
formats, and a reference to the fuller discussion.
From: "David G. Johnston"
Date: Wednesday, March 7, 2018 at 12:11 PM
To: Martin Mueller
Cc: "pgsql-general@lists.postgresql.org&q
PG10
Is there an operator to determine if a box and circle intersect?
I can only see box && box and can use centre+rad and distance to calculate
circle:circle.
Thanks.
Am 16.03.2018 um 11:00 schrieb Martin Moore:
> PG10
>
> Is there an operator to determine if a box and circle intersect?
> I can only see box && box and can use centre+rad and distance to
> calculate circle:circle.
>
> Thanks.
>
>
please don't hijack other mai
Hi
I am just setting up a postgres server, details
Host 192.168.0.3
pg_hba.conf
# TYPE DATABASEUSERADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
Is this possible, eg
Substring(field, regex include other field name)
Thanks
value.
Is there a way of doing this in a single-step procedure or can you chain the
two parts together in one query? This goes beyond my SQL competence.
Martin Mueller
Hi
I am looking for suggestions about the best way to resolve this problem.
Scenario
I have entries for files in database which lack specific values (xml files
not generated)
These values can be obtained by what are called DTC read files, where the
values are the same in the last DTC read file be
I made a stupid mistake with a backup and would be grateful for some advice on
how to extricate myself.
I created a dumpfile from a 10.3 postgres installation on a Mac and tried to
restore it on another Mac 1,000 miles away, but forgot that that machine runs
Postgres 9.6.
The command
/Applica
Many thanks for your generous help, and on a Sunday afternoon as well.
This is a wonderful listserv, and I am deeply indebted to it.
MM
On 7/15/18, 2:17 PM, "Tom Lane" wrote:
Martin Mueller writes:
> I created a dumpfile from a 10.3 postgres installation on a Mac
I have followed this list for a couple of years, have benefited several times
from quick and helpful advice, and wonder whether all this code of conduct
stuff is a solution in search of a problem. Or, if there is a problem now and
then, whether an elaborate code does a better job than reminding
On 9/14/18, 12:50 PM, "Joshua D. Drake" wrote:
On 09/14/2018 07:41 AM, James Keener wrote:
> > Community is people who joined it
>
> We're not a "community."
I do not think you are going to get very many people on board with that
argument. As anyone who knows me w
What counts as foul language has changed a great deal in the last two decades.
You could always tie it to what is printable in the New York Times, but that
too is changing. I could live with something like “Be considerate, and if you
can’t be nice, be at least civil”.
From: Melvin Davidson
Da
again "Where is the problem that needs solving?"
On 9/15/18, 11:32 AM, "Bruce Momjian" wrote:
On Sat, Sep 15, 2018 at 04:24:38PM +, Martin Mueller wrote:
> What counts as foul language has changed a great deal in the last two
decades.
> You coul
As long as subscribers to the list or attendants at a conference do not violate
explicit or implicit house rules, what business does Postgres have worrying
about what they do or say elsewhere? Some version of an 'all-of-life' clause
may be appropriate to the Marines or federal judges, but it s
I’ve looked at the documentation to find where to find some data that are very
to find Mysql: the creation and modification data of a table and the size of
particular tables.
Where do I find an answer to the question “which is the last table I created”
or “when did I last modify this table?”
El 05/10/18 a las 06:50, Rijo Roy escribió:
> Hello Experts,
>
> I have a server rhel 6.9 installed with barman 2.3 which is configured
> to take backup from Postgresql 10 installed in a remote host and the
> same is working.
You should upgrade to 2.4, although I can't see anything relevant in th
El 10/10/18 a las 04:00, magodo escribió:
>
> Hello,
>
> I know there is a tool `pg_archivecleanup`, but it only accepts wal
> filename. What if I want to clean up all archived wal before a
> specified datetime?
>
> Though I could check the ctime fo each wal and figure out which to
> remove, but
I have a question on logging strategy
I have loggin set to
log_statement = 'all' on a network database with logging set to csv so I
can import it to a logging table
However the database is populated via a nightly routine downloading data
via REST APIusing prepared statements
This results in enor
I suppose the ideal would be to log the prepared statement once and detail
only if error rather than one per execution
On Thu, 11 Oct 2018 at 11:33, Rob Sargent wrote:
>
>
> > On Oct 11, 2018, at 4:26 AM, Mike Martin wrote:
> >
> > I have a question on logging strate
Thanks!
On Fri, 12 Oct 2018 at 14:33, David Steele wrote:
> On 10/11/18 11:26 AM, Mike Martin wrote:
> >
> > This results in enormous log files which take ages to import using copy
> > becuase each execute statement is logged with the parameters chosen
> >
>
El 16/10/18 a las 12:12, Nicola Contu escribió:
> 2492534808 | dev | 7355 | 1833427130 | pgbouncer |
> | 10.151.2.145 | | 60570 |
> 2018-10-16 14:13:05.151015+00 | |
> 2018-10-16 15:10:40.309993+00 | 2018-10-1
I created a primary key with the following commands
Add id serial
Add primary key (id)
I cannot figure out from the documentation how to drop that column.
ified table. Which is
really useful if you have a bad memory, as I do, and can't remember the name of
a particular table that I worked on last Wednesday.
Are those capabilities hidden somewhere in Postgres? There isn't an obvious
section in the documentation. At least I can't find
Leaving aside the question of money, a frontend like AquaData Studio or the
equivalent program by Jetbrains would be a much better solution. I used to work
with Access a lot and quite liked it. But AquaData Studio is not any more
difficult to learn and gives you access to everything Postgress ca
n Klaver
> Sent: Saturday, November 30, 2019 01:52 PM
> To: Jason L. Amerson ; 'Martin Gainty'
> ; PostgreSQL
> Subject: Re: MS Access Frontend
>
> On 11/30/19 11:04 AM, Jason L. Amerson wrote:
>> Thanks Martin. I have decided to go another route. I have nothing but
>&
i dont know how to do with elastic-search
according to programcreek you can create an index from a jdbc
source
https://www.programcreek.com/java-api-examples/?code=SeldonIO/semantic-vectors-lucene-tools/semantic-vectors-lucene-tools-master/src/main/java/io/seldon/semvec/CreateLuceneIndexFromDb.j
On the topic of what other databases do better: I much prefer Postgres to Mysql
because it has better string functions and better as well as very courteous
error messages. But MySQL has one feature that sometimes makes me want to
return it: it stores the most important metadata about tables in a
Hello,
I recently tried to write a wrapper function to calculate the difference
between two dates, mainly as a convenience. I'd essentially be emulating
EXTRACT( FROM date1 - date2), in various ways. I got a bit stuck on
allowing specification of the : is this possible in function
definitions?
cant you use keytool ?
assume server certificate is called server.crt
assume truststore file is called server.truststore.jks
cd %JRE_HOME%/lib/security
keytool -import -alias %ALIAS% -file server.crt -keystore server.truststore.jks
m.
From: Shankar Bhaskaran
Sent
Hi
I am having difficulty with returning clause and stored procedure. This is
an (edited) example of where I am
CREATE OR REPLACE PROCEDURE public.arrcopy1(
dataarr anyarray,
tblname text,
cols text DEFAULT NULL::text,
selstr text DEFAULT NULL::text,
INOUT outarr text[] DE
Is this possible?
Basically I want to manage temp table status for use in a procedure.
The procedure looks at pg_catalog to get information for processing.
So basically I would like to be able to know what namespace a temp table is
created in, so that I can constrain lookup.
example
CREATE TEMP
Thanks , exactly what I was looking for
On Thu, 10 Sep 2020 at 13:16, Christoph Moench-Tegeder
wrote:
> ## Mike Martin (redt...@gmail.com):
>
> > So basically I would like to be able to know what namespace a temp table
> is
> > created in, so that I can constrain lookup.
s.
Regards,
M.
--
Martin Goodson
Whatever you've got planned, forget it. I'm the Doctor.
I'm 904 years old. I'm from the planet Gallifrey in the
constellation of Kasterborous. I am The Oncoming Storm,
the Bringer of Darkness and you are ... basically just a
rabbit, aren&
On 29/11/2020 18:10, Adrian Klaver wrote:
On 11/29/20 10:06 AM, Martin Goodson wrote:
Hello.
I wonder if anyone can assist with this?
Some of my developers are reporting that they are getting the
following message when attempting to connect to the database using jdbc:
Caused by
On 29/11/2020 18:28, Adrian Klaver wrote:
On 11/29/20 10:22 AM, Martin Goodson wrote:
On 29/11/2020 18:10, Adrian Klaver wrote:
On 11/29/20 10:06 AM, Martin Goodson wrote:
Hello.
I wonder if anyone can assist with this?
Some of my developers are reporting that they are getting the
On 29/11/2020 18:46, David G. Johnston wrote:
On Sun, Nov 29, 2020 at 11:06 AM Martin Goodson
wrote:
Hello.
I wonder if anyone can assist with this?
Some of my developers are reporting that they are getting the following
message when attempting to connect to the database using jdbc:
Caused
On 02/12/2020 23:46, Dave Cramer wrote:
On Sun, 29 Nov 2020 at 14:09, Martin Goodson
wrote:
On 29/11/2020 18:46, David G. Johnston wrote:
On Sun, Nov 29, 2020 at 11:06 AM Martin Goodson
Hello.
I wonder if anyone can assist with this?
Some of my developers are reporting that they are
Nota Bene:
Almost all official interfaces to/from Oracle are coded in Java
FWIK google's implementations are 95% python
(although you would need to understand JSON formatting for import/export
requirements)
for those reasons i tread lightly before disparaging either language
Going Forward:
try to
Hello,
I know that since the launch of pgAdmin 4 in 2016, pgAdmin has been using a
web-based model, as announced as early as 2014. You only need to do a
little research on the Web to understand all the reasons behind this
choice, which I do not seek to question.
However, I wonder if it would be r
a PgAdmin 3) functional in parallel to
the newer Hosted Web Version of PgAdmin (aka PgAdmin 4).
regards, gm
Le sam. 6 févr. 2021, à 14 h 26, Tom Lane a écrit :
>
> Gabriel Martin writes:
> > Do you think there's a possibility that people could fix pgAdmin 3, even if
> >
than a
couple, but less than 50 or so, then best to give them all separate
schemas. If there are thousands of tenants (like an internet application)
then security barrier views are usually the easiest option to manage.
Martin Ritchie
*Geotab*
Senior DBA
Direct +1 (519) 741-7660
Toll-free +1 (877
51 ms
I would like to see a function like this inside the intarray extension.
Is there any way to get to this point? How is the process to deal with
such proposals?
Best regards,
Martin Kalcher
Source code of extension mentioned above:
#include "postgres.h"
#include &q
Am 16.07.22 um 18:53 schrieb Mladen Gogala:
On 7/15/22 04:36, Martin Kalcher wrote:
Dear list,
i am dealing with an application that processes fairly large arrays of
integers. It makes heavy use of the intarray extension, which works
great in most cases. However, there are two requirements
We have a replication slot set up on a database in Postgres 12.8. For one
of the tables, when a row is created, we see a series of records come
through - an INSERT followed by a handful of UPDATEs. All of these messages
in the WAL files show all columns, except for the last UPDATE message,
which is
My apologies. Read that in the mailing list instructions, and still
forgot. Thanks for the reminder.
On Wed, Aug 3, 2022 at 11:12 AM Adrian Klaver
wrote:
> On 8/3/22 08:09, Kevin Martin wrote:
>
> Please reply to list also
> Ccing list
>
> I don't have answers to be
Thanks for the response, Tom. I think that's exactly what's going on here.
On Wed, Aug 3, 2022 at 11:28 AM Tom Lane wrote:
> Adrian Klaver writes:
> > On 8/3/22 08:09, Kevin Martin wrote:
> >> I thought that any UPDATE message in the replication logs is designed
Our Postgres recently started reporting considerably different
execution times for the same query. When executed from our JDBC
application the Postgres logs report an average execution time of 1500
ms but when the query is manually executed through `psql` it doesn't
take longer than 50 ms.
With a
> On 2022-Aug-30, Matheus Martin wrote:
>
> > Our Postgres recently started reporting considerably different
> > execution times for the same query. When executed from our JDBC
> > application the Postgres logs report an average execution time of 1500
> > ms but whe
The threshold for `auto_explain` was changed to 500 ms and explain plans
are still not being logged.
On Tue, 30 Aug 2022 at 13:30, Julien Rouhaud wrote:
> Hi,
>
> On Tue, Aug 30, 2022 at 01:16:43PM +0200, Alvaro Herrera wrote:
> > On 2022-Aug-30, Matheus Martin wrote:
> &g
rt it?
On Tue, 30 Aug 2022 at 17:45, Alvaro Herrera
wrote:
> On 2022-Aug-30, Matheus Martin wrote:
>
> > Good idea on using an actual prepared statement but unfortunately it
> didn't
> > produce any different result.
>
> I should have also mentioned to try the EXPLA
ic we have, we cannot lower the
threshold for the auto_explain.
`log_lock_waits` is turned on and the logs do not indicate any locks
related to the tables in the query.
On Fri, 2 Sept 2022 at 05:49, Julien Rouhaud wrote:
> Hi,
>
> On Thu, Sep 01, 2022 at 08:20:13PM +0100, Matheus Martin
`auto_explain.log_min_duration` is set to 500 ms.
On Mon, 5 Sept 2022 at 12:35, Peter J. Holzer wrote:
> On 2022-09-02 10:58:58 +0100, Matheus Martin wrote:
> > Yes, we do see some plans logged by the auto_explain. We couldn't find a
> > `auto_explain.log_min_duration
:38 PM Matheus Martin <
> matheus.mar...@voidbridge.com> wrote:
>
>> Our Postgres recently started reporting considerably different execution
>> times for the same query. When executed from our JDBC application the
>> Postgres logs report an average execution time o
category)::text = 'CASH'::text))
Filter: ((currency)::text =
(users.real_base_currency)::text)
Buffers: shared hit=67
Planning:
Buffers: shared hit=859
Planning Time: 50.833 ms
Execution Time: 5.480 ms
(85 rows)
On Fri, 9 Sept 2022 at 22:06, Max
Are there any limits on the number of records in
the postgresql/12/main/pg_multixact/members directory? We have a database
that has grown to tens of thousands of files in this directory during an
autovacuum after a large data purge. It shrank after the autovacuum
completed.
Martin Ritchie
*Geotab
ng.
I am assuming there must be something wrong with the box/our
configuration somewhere, but where to look? If anyone can help - even if
it's to tell me I'm an idiot for missing one or more incredibly basic
things somehow - I would be very grateful.
Many thanks.
Regards,
M.
--
On 12/03/2023 21:52, Tom Lane wrote:
Martin Goodson writes:
So I simply removed the --with-gssapi, and tried again.
AND IT FAILED AGAIN.
This time it failed claiming it couldn't find the ldap library. Which is
most -definitely- present.
Hard to debug this sort of thing remotely when you
On 13/03/2023 00:02, Adrian Klaver wrote:
On 3/12/23 14:43, Martin Goodson wrote:
Hello.
For reasons I won't bore you with, we compile PostgreSQL from source
rather than use the standard packages for some of our databases.
So a fairly basic script that has been used for years sud
Is this possible?
I have a script which imports csvlogs into a table, and it would be useful
to truncate the log files after import
thanks
Mike
I have the following function
-- FUNCTION: public.update_log()
-- DROP FUNCTION public.update_log();
CREATE OR REPLACE FUNCTION public.update_log(
)
RETURNS void
LANGUAGE 'sql'
COST 100
VOLATILE
AS $BODY$
truncate table postgres_log_tmp ;
COPY postgres_log_tmp FROM '/mnt/pgdata
I have used Aqua Data Studio for several years. Jetbrains recently released a
similar product. Academic licensing is affordable (~ $200 a year) and very
cheap if considered in terms of the time it saves you.
From: David Gauthier
Date: Tuesday, October 30, 2018 at 2:06 PM
To: "pgsql-gene...@post
Then maybe I can get replication started.
I've read that logical replication can be used to migrate from 9.6 to 11,
but haven't found any documentation on doing that.
Chuck Martin
e to find where Centos 7, or Postgres 9.6, stores
the path to the config/data directory outside the data/postgresql.conf
file. But I agree there must be something somewhere.
Chuck
On Sat, Nov 3, 2018 at 6:06 PM Adrian Klaver
wrote:
> On 11/3/18 2:56 PM, Charles Martin wrote:
>
> P
Adtrian said:
>> pg_dump: Error message from server: server closed the connection
>> unexpectedly
>Is this error the client reporting?
>Is this the same that is showing up in the server log?
Yes, that's the client message, i.e. what appeared in the terminal window
that gave the command. The serve
emory when trying to dump this table. The "old"
server has 4GB of ram, the "new" server 20GB.
On Sun, Nov 4, 2018 at 3:13 PM Adrian Klaver
wrote:
> On 11/4/18 8:38 AM, Charles Martin wrote:
> >
> > Adtrian said:
> >>> pg_dump: Error message from ser
Sun, Nov 4, 2018 at 8:16 PM Adrian Klaver
wrote:
> On 11/4/18 2:55 PM, Charles Martin wrote:
> > Yep, you called it:
> >
> > Nov 2 20:30:45 localhost kernel: Out of memory: Kill process 30438
> > (postmaster) score 709 or sacrifice child
> > Nov 2 20:30:45 localhost
gresql.org/docs/10/static/runtime-config-resource.html
>set to?
Ok, thanks for explaining this. Here is the current value:
"shared_buffers" "131072" "8kB"
On Mon, Nov 5, 2018 at 9:06 AM Adrian Klaver
wrote:
> On 11/5/18 5:56 AM, Charles Martin wrote:
> &
l, that's 1GB, which might be ambitious inside a VM with a hard
restriction to 4GB total RAM. Postgres can get by with a *lot* less.
>Try knocking it down to a tenth of that and see if it makes a difference
I think I also based this on a rule-of-thumb that it should be no more than
25%
7;d have made a 4GB swap file.)
I have a spare drive that is 230G, so I have enough space. I suppose I can
set swapoff, delete the swapfile, create a new 4G one, and set swapon. Or
is there a better way?
On Mon, Nov 5, 2018 at 11:56 AM Ron wrote:
> On 11/05/2018 10:50 AM, Charles Martin w
, I might be able to delete them. If I can find them.
On Mon, Nov 5, 2018 at 12:54 PM Daniel Verite
wrote:
> Charles Martin wrote:
>
> > SELECT max(length(docfilecontents::text)) FROM docfile;
> > and after a very long time, got:
> > ERROR: invalid memory alloc
I've
Adrian, I'll try changing shared_buffers the next time I can restart
postgres, at least if deleting the largest records and adding VM hasn't
worked.
On Tue, Nov 6, 2018 at 6:47 AM Daniel Verite
wrote:
> Charles Martin wrote:
>
> > but the second one
, that which can be adequately explained by
> stupidity"
> - Hanlon's Razor
>
>
> Original Message
> Subject: Re: Trouble Upgrading Postgres
> From: Tom Lane
> Date: Tue, November 06, 2018 11:53 am
> To: Adrian Klaver
> Cc: Daniel Verite , Charl
Functions. But there isn’t.
The documentation of string functions is exemplary. The documentation of
mathematical less so. Remember that it may be used by folks like me whose math
is shaky. The MySQL documentation is better on this simple operation.
-
Martin Mueller
Professor emeritus of
I didn't formulate my question properly, because the query went like
"select alldefects /wordcount"
where alldefects and wordcount are integers. But none of the different ways
of putting the double colon seemed to work.
The Postgres notation of this simple procedure is very unintuitive. I ha
e. If you didn't know the root form, the dictionary was
no use.
In this, single stop shopping for the three most common problems of simple
division makes life easier for users.
On 12/4/18, 3:06 PM, "David G. Johnston" wrote:
On Tue, Dec 4, 2018 at 1:57 PM Martin Muell
I take the point that two decades of backward compatibility should and will
win. That said, it's an easy enough thing to right the balance for novices and
put in a really obvious place in the documentation what you should do if you
want to divide two integers and get the results with the number
Hi
For a particular sequence I needed to do (schedule 2nd monday in month for
coming year) I created the following query
select to_char(min(date::date) + interval '1 week','DD/MM/') date
--gets first date for day of month (monday in this case) then adds week and
finally formats it to desi
I have a situation where I need to update dates in a primary table from
regular imports of data, eg: this is the base select query
select d.row_id,
fname||lname,'joineddate',d.joineddate,'joineddate',s.joineddate,0 as bool1
from import s join members d on d.contact_id=s.contact_id where
cast(nul
ND usr.Backup_fkey = backup.Usr_pkey
AND ombcase.Status_fkey = status.Status_pkey
AND event.InsBy::int = usr.Usr_pkey
AND event.Event_pkey = 1060071
ORDER BY EventDone, DateTime DESC
Chuck Martin
Avondale Software
19/12/2018 à 11:41, Mike Martin a écrit :
> > cast(nullif(d.joineddate,NULL) as timestamp) !=
> cast(nullif(s.joineddate,'') as timestamp)
> Try with
> d.joineddate IS DISTINCT FROM s.joineddate
>
> https://www.postgresql.org/docs/current/functions-comparison.html
>
> Cheers
> --
> Arnaud
>
>
On Thu, Dec 20, 2018 at 10:12 PM Adrian Klaver
wrote:
> On 12/20/18 5:51 PM, Chuck Martin wrote:
>
> Please reply to list also.
> Ccing list.
>
> >
> >
> > On Thu, Dec 20, 2018 at 7:56 PM Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote:
&
G 11
replication? Everything I find online is very old.
Chuck Martin
Avondale Software
On Sun, Dec 30, 2018 at 11:20 AM Peter Eisentraut <
peter.eisentr...@2ndquadrant.com> wrote:
> On 29/12/2018 20:04, Chuck Martin wrote:
> > I thought I knew how to do this, but I apparently don't. I have to set
> > up a new server as a standby for a PG 11.1 server. The
he same GB
ethernet network.
Chuck Martin
Avondale Software
On Sun, Dec 30, 2018 at 3:28 PM Jeff Janes wrote:
> On Sat, Dec 29, 2018 at 2:05 PM Chuck Martin
> wrote:
>
>> I thought I knew how to do this, but I apparently don't. I have to set up
>> a new server as a st
On Mon, Dec 31, 2018 at 12:05 PM Jeff Janes wrote:
> On Sun, Dec 30, 2018 at 6:17 PM Chuck Martin
> wrote:
>
>> Maybe I need to rethink ths and take Jeff's advice. I executed this:
>>
>> pg_basebackup -h [main server's URL] -U postgres -P -v -X s -D
>>
s difficult to parse out since in
the real world, many more tables and columns are involved.
Chuck Martin
Avondale Software
On Thu, Jan 3, 2019 at 3:46 PM Stephen Frost wrote:
> Greetings Chuck,
>
> * Chuck Martin (clmar...@theombudsman.com) wrote:
> > Using iperf, the transfer speed between the two servers (from the main to
> > the standby) was 938 Mbits/sec. If I understand the units correctly,
I have come across a problem which I cant seem to solve in a nice way
Basically I have a (small) table of tags
What I need to is combine two concatenated fields with a literal value as
an array element.
First thought was using array_agg with a pre-created array as
select array_agg(ARRAY['-metadat
OIN status
ON status_fkey = status_pkey
AND lower(statusid) NOT LIKE ('closed%')
AND coalesce ( age(ombcase.insdatetime), age(statuschange.insdatetime) ) >
'2 months'
But this query will return all statuschange records for an ombcase record
that has multiple ones.
Any suggestio
On Sat, Jan 26, 2019 at 6:30 PM Ron wrote:
> On 1/26/19 5:04 PM, Chuck Martin wrote:
>
> I'm having trouble formulating a query. This is a simplified version of
> the tables:
>
> ombcase
>
> case_pkey integer, primary key
> casename varchar
>
Chuck Martin
Avondale Software
On Sun, Jan 27, 2019 at 2:55 PM Adrian Klaver
wrote:
> On 1/26/19 3:04 PM, Chuck Martin wrote:
> [snip]
> Outline form:
>
> 1) If a record is in ombcase it has a status('in a status') by definition.
>
> From query below you are
On Sun, Jan 27, 2019 at 8:07 AM Peter J. Holzer wrote:
> On 2019-01-26 18:04:23 -0500, Chuck Martin wrote:
> [snip]
> > The idea should be obvious, but to explain, insdatetime is set when a new
> > record is created in any table. All records in ombcase have a foreign
> k
On Sun, Jan 27, 2019 at 5:27 PM Chuck Martin
wrote:
> On Sun, Jan 27, 2019 at 8:07 AM Peter J. Holzer wrote:
>
>> On 2019-01-26 18:04:23 -0500, Chuck Martin wrote:
>> [snip]
>> > The idea should be obvious, but to explain, insdatetime is set when a
>> new
&g
1 - 100 of 195 matches
Mail list logo
