.postgresql.org/docs/10/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
Basically the functions act differently in transactions, which will
affect the time returned.
--
Adrian Klaver
adrian.kla...@aklaver.com
ROR: null value in column "filler" violates not-null constraint
DETAIL: Failing row contains (null, 1, test).
primary key. Of course, you could amend the policy to say a "non-NULL
primary key".
--
I have a theory that it's impossible to prove anything, but I can&#x
ipt, and it says:
$ pg_dumpall --schema-only > globals.sql
That's not good.
Well it would dump the globals, but also the schema definitions for all
the objects in the cluster. Though at this point we are only half way
through the process. What is you restore procedure?
--
Ang
On 03/01/2018 09:59 AM, Ron Johnson wrote:
On 03/01/2018 11:46 AM, Adrian Klaver wrote:
[snip]
Hmmm. I just looked at the script, and it says:
$ pg_dumpall --schema-only > globals.sql
That's not good.
Well it would dump the globals, but also the schema definitions for
all the ob
m makes the world go 'round.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/01/2018 01:26 PM, Ron Johnson wrote:
On 03/01/2018 03:14 PM, Adrian Klaver wrote:
On 03/01/2018 01:03 PM, Ron Johnson wrote:
On 03/01/2018 02:32 PM, David G. Johnston wrote:
There's always the "account number", which is usually synthetic.
Credit Card numbers are
lto:cont...@stephane-klein.info>>
blog: http://stephane-klein.info
cv : http://cv.stephane-klein.info
Twitter: http://twitter.com/klein_stephane
--
Adrian Klaver
adrian.kla...@aklaver.com
ow": 7, "value": 2,
"letter": "С"}, {"col": 4, "row": 7, "value": 1, "letter": "О"}, {"col":
5, "row": 7, "value": 2, "letter": "П"}, {"col": 6, "r
OR REPLACE FUNCTION words_play_game(
in_uid integer,
in_gid integer,
in_tiles jsonb
) RETURNS table (
out_uid integer, -- the player to be notified
out_fcm text,
out_apns text,
out_adm text,
out_body text
) AS
--
Adrian Klaver
adrian.kla...@aklaver.com
id handlePlay(int gid, String tiles) throws SQLException,
IOException {
LOG.info("handlePlay: {} -> {} {}", mUid, gid, tiles);
try (Connection db = DriverManager.getConnection(DATABASE_URL,
DATABASE_USER, DATABASE_PASS);
PreparedStatement st =
db.prepareStatement(SQL_PLAY_GAME)) {
st.setInt(1, mUid);
st.setInt(2, gid);
st.setString(3, tiles);
runPlayerAction(st, gid);
}
}
--
Adrian Klaver
adrian.kla...@aklaver.com
, out_fcm AS fcm, out_apns AS apns,
out_adm AS adm, out_body AS body FROM words_play_game($1::int,
$2::int, $3::jsonb)
where is $3::jsonb coming from?
--
Adrian Klaver
adrian.kla...@aklaver.com
much about pgTap, but my first instinct would be to change:
BEGIN;
SELECT plan(1);
\i /test/init.sql
SELECT ok(
(SELECT COUNT(host_id) FROM db2.hosts) = 1,
'foobar'
);
to:
BEGIN;
\i /test/init.sql
SELECT plan(1);
SELECT ok(
(SELECT COUNT(host_id) FR
On 03/02/2018 10:04 AM, David G. Johnston wrote:
On Friday, March 2, 2018, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 03/02/2018 06:42 AM, Alexander Farber wrote:
2018-03-02 15:30:33.646 CET [16693] LOG: duration: 0.058 ms bind
: SELECT out_ui
ay length of a scalar
LOCATION: jsonb_array_length, jsonfuncs.c:1579
Which means only some data is bad, but how to find it please?
What is? :
select count(*) from words_moves where gid=609;
A simplistic approach would be:
select mid, jsonb_array_length(tiles) from words_moves where gid=609
order by mid limit x;
where you increment x until you trigger the error.
A more sophisticated approach would be to use plpgsql EXCEPTION handling:
https://www.postgresql.org/docs/10/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
and create a function that loops through:
select jsonb_array_length(tiles) from words_moves where gid=609 ;
and RAISES a NOTICE for each incorrect value along with its mid value.
--
Adrian Klaver
adrian.kla...@aklaver.com
be I should always check for the "action" column first (acts as
enum) - before accessing "tiles" column
Regrads
Alex
--
Adrian Klaver
adrian.kla...@aklaver.com
RE "ImageFilename" LIKE 'D:%';
If you want case insensitive then ILIKE. For more info:
https://www.postgresql.org/docs/10/static/functions-matching.html#FUNCTIONS-LIKE
I feel so dumb... This can't be that hard, but I am exhausted and
running out of ideas. I n
.
Same from curl:
$ curl http://momjian.us/
curl: (7) Failed to connect to momjian.us port 80: Connection timed out
Igal
--
Adrian Klaver
adrian.kla...@aklaver.com
://wiki.postgresql.org/wiki/Apt
"2018-01-17: Ubuntu zesty (17.04) is unsupported now, Ubuntu removed it
from their mirrors "
At the below I do see packages for 18.04:
http://apt.postgresql.org/pub/repos/apt/pool/main/p/pgadmin4/
--
Adrian Klaver
adrian.kla...@aklaver.com
=# select 1/0;
ERROR: division by zero
Also:
1) What version of pgAdmin4 are you running?
2) What version of Postgres is it running against?
why?
Best wishes,
Jacek
--
Adrian Klaver
adrian.kla...@aklaver.com
Hi Guys,
what is wrong with my pgAdmin?
I am creating wrong query:
select 1/0 but still this is executed!
why?
Best wishes,
Jacek
--
Adrian Klaver
adrian.kla...@aklaver.com
oes the app throwing the error having the permissions to 'see' the
file/directory?
Please guide me how to resolve the above error and let me know does this
has any relation with vacumm full or reindexing operation which are
performed by me.
--
Regards,
Raghavendra Rao J S V
--
Adrian Klaver
adrian.kla...@aklaver.com
to which to save the selected content of the SQL Editor panel.
Best,
Jacek
--
Adrian Klaver
adrian.kla...@aklaver.com
-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
Virus-free. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
Adrian Klaver
adrian.kla...@aklaver.com
stgresql.org/gitweb/?p=postgresql.git&a=search&h=HEAD&st=commit&s=+ACL
Someone with more knowledge of this will need to confirm or deny.
--
Adrian Klaver
adrian.kla...@aklaver.com
for 10.16.10.12. In other
words it is not seeing the ',' as a separator for the two IP's'.
Can you provide more information about the JDBC version you are using
and the app code you are using?
/
Thanks in advance for the help.
//
--
Adrian Klaver
adrian.kla...@aklaver.com
6.10.13:5432" as the port number for 10.16.10.12. In other
words it is not seeing the ',' as a separator for the two IP's'.
Time to clean the glasses:)
It looks like the first IP address has disappeared or is not set right./
/
Thanks in advance for the help.
//
--
Adrian Klaver
adrian.kla...@aklaver.com
/2018 02:27 PM, Adrian Klaver wrote:
On 03/08/2018 01:12 PM, chris wrote:
Hi,
I have a JDBC temping to connect to 2 postgres nodes in a hot standby
configuration. Running postgres 9.4 on centos6.
What we are trying to accomplish is in an event of a failover, to
first try to connect to the maste
Thanks.
Charlin
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/09/2018 02:22 PM, Adrian Klaver wrote:
On 03/09/2018 12:08 PM, Charlin Barak wrote:
Hi,
I can find sequences owned by a schema from
information_schema.sequences and pg_class but how do I find sequences
owned by a user/role? What pg table should I be looking at?
https
service name in pg_service.conf that holds additional connection
parameters. This allows applications to specify only a service name so
connection parameters can be centrally maintained. See Section 33.16.
--
Adrian Klaver
adrian.kla...@aklaver.com
e since 8.4 to look for further gotchas.
Is there any dependency or limitation of applications in 9.6 after
upgrading from these versions ? OS platforms we are using are in Linux
5, 6.7. 6.8 and Windows 10, 12.
I am happy to provide more information if need.
Regards,
Amitabh
PostgreSQL D
rom: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
l query
features or something else?
2) When you refer to a design document are talking about one that deals
with adding features to the code or one that provides ways of working
with the existing features?
Thanks,
Lin
--
Adrian Klaver
adrian.kla...@aklaver.com
l) to update
the stats?
Thanks,
--
Adrian Klaver
adrian.kla...@aklaver.com
issue on the Apartment gem for
context: https://github.com/influitive/apartment/issues/532
Thanks in advance.
--
Adrian Klaver
adrian.kla...@aklaver.com
(having the same issues
as Apartment library).
http://guides.rubyonrails.org/v3.2.9/migrations.html#types-of-schema-dumps
This is outside the realms of this mail group though.
Cheers,
Matt.
--
Adrian Klaver
adrian.kla...@aklaver.com
, how would we go about
debugging that it's not seeing the comma?
On 03/08/2018 02:27 PM, Adrian Klaver wrote:
On 03/08/2018 01:12 PM, chris wrote:
Hi,
I have a JDBC temping to connect to 2 postgres nodes in a hot
standby configuration. Running postgres 9.4 on centos6.
What we are
H &&)
Any direction here would be much appreciated.
Right now, I am forced to create a redundant btree index UNIQUE, btree
(id, lower(as_of_date)) in order to have a primary key on the table.
Thanks!
Jeremy
--
Adrian Klaver
adrian.kla...@aklaver.com
you could do as this post suggests:
https://www.postgresql.org/message-id/CADK3HHJgdio_TZ-fpk4rguWaA-wWZFNZrjBft_T4jLBK_E_c8w%40mail.gmail.com
That is install driver version 42.2.1.
On 03/13/2018 05:48 PM, Adrian Klaver wrote:
On 03/13/2018 04:46 PM, chris wrote:
I'm sorry that took a few
ves where gid=656 and
action='play' order by played desc limit 5) x;
ERROR: 42883: operator does not exist: record ->> unknown
LINE 1: select string_agg(x->>'letter', ' ') from (select jsonb_arra...
^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
LOCATION: op_error, parse_oper.c:728
I am probably missing something obvious?
Do you still have non-arrays in the tile field?:
https://www.postgresql.org/message-id/CAADeyWgYKKaArJb6JK_xEtSO%3D7aeNaYqBu_ef-D5W7s8EFPfpQ%40mail.gmail.com
Regards
Alex
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/14/2018 10:12 AM, Adrian Klaver wrote:
On 03/14/2018 10:02 AM, Alexander Farber wrote:
Thank you, Ivan! I am trying to apply your suggestion to my table -
On Wed, Mar 14, 2018 at 5:34 PM, Ivan E. Panchenko
mailto:i.panche...@postgrespro.ru>> wrote:
Hi Alex,
SELECT stri
On 03/14/2018 11:10 AM, Jeremy Finzel wrote:
On Wed, Mar 14, 2018 at 8:33 AM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 03/14/2018 06:19 AM, Jeremy Finzel wrote:
Hello! From all that I can tell, it is not possible using a
btree_gist index as a p
.
Still I would the think the place to start would be the connection code
itself. Another way would be examining CLASSPATH:
https://jdbc.postgresql.org/documentation/head/classpath.html
On 03/14/2018 09:44 AM, Adrian Klaver wrote:
On 03/14/2018 07:51 AM, chris wrote:
I believe its Postgresql
TE TABLE
INSERT INTO tbl_test VALUES (1, 'dog'), (2, 'cat');
INSERT 0 2
DROP TABLE tbl_test;
DROP TABLE
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
no flag to unset this.
With best regards:
Bill
--
Adrian Klaver
adrian.kla...@aklaver.com
shared_buffers | 384MB
work_mem | 384MB
Server configuration
RHEL 6.5
RAM : 16Go
2 CPUs
Thanks for your feedback
Is there anything in the Postgres and/or system logs from the same time
that might shed on this?
--
Adrian Klaver
adrian.kla
/.psqlrc, but that
throws an error about not a valid path (again, likely due to the Pg root environment?).
Suggestions? Thank you.
======
--
Adrian Klaver
adrian.kla...@aklaver.com
dance?
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
om/questions/4480381/postgres-sql-fail-on-script-error>
Regards
Pavel
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
res, hence the need to manually run it in the postgres shell, prior to launching
psql.
======
--
Adrian Klaver
adrian.kla...@aklaver.com
://www.sql-workbench.eu/manual/dbexplorer.html
4) Selected all the objects in a schema and used Create DDL Script to
generate a file with the objects. The objects where not created with a
schema qualifier.
Bill
--
Adrian Klaver
adrian.kla...@aklaver.com
b| I find the file
pg_similarity.sql.How can I fix this problem?
But do you see pg_similarity.control which what the error is complaining
about?
|
--
Adrian Klaver
adrian.kla...@aklaver.com
hare/extension/'
The pg_similarity.control was installed and the extension was installed
in ~/share/extension.
More importantly I could CREATE the extension:
test=# CREATE EXTENSION pg_similarity;
CREATE EXTENSION
--
Adrian Klaver
adrian.kla...@aklaver.com
ed to be
* processed in the RESTORE_PASS_MAIN pass. (In practice, that's all
* PRE_DATA items other than ACLs.) Entries we can't process now are
* added to the pending_list for later phases to deal with.
*/
--
Adrian Klaver
adrian.kla...@aklaver.com
lowing page and choose a new password:
https://www.postgresql.org/account/reset/ODIzMA-4uk-1d498cb7a2655b5e69ac/
Your username, in case you've forgotten, is aklaver.
"
When I'd stopped using PG for a while, the simplest solution was to send
them to the Trash.
--
Adrian Klaver
adrian.kla...@aklaver.com
many of those cases it involves a serial field. In at least one
case in involved a citext field with a unique constraint.
Now just wonder how logical replication between the two servers can
produce such errors if the constraints on both sides are the same? Is
this a bug?
Regards
Johann
few dead tuples.
Best regards,
Jimmy AUGUSTINE
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/19/2018 10:04 AM, Jimmy Augustine wrote:
2018-03-19 17:45 GMT+01:00 Adrian Klaver <mailto:adrian.kla...@aklaver.com>>:
On 03/19/2018 09:31 AM, Jimmy Augustine wrote:
Dear Friends,
I am newbie to postgresql.
I have 162 GB on my database but whe
s disappointed by the gap
between the two queries, so I checked pgAdmin 4 and I saw this value.
In what section of pgAdmin4?
Or do you know what query it used?
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
FROM pg_database
ORDER BY datname;
*
--
*Melvin Davidson**
Maj. Database & Exploration Specialist**
Universe Exploration Command – UXC***
Employment by invitation only!
--
Adrian Klaver
adrian.kla...@aklaver.com
reSQL Support Company
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/19/2018 10:27 AM, Jimmy Augustine wrote:
I tried this query and my database size is equal to 162GB.
Well you can always look in $DATA directly. The database will be under
$DATA/base/.
You can find the like this:
select oid, datname from pg_database where datname='';
not
interpreted as the end-of-data marker. If you are loading a file created
by another application that has a single unquoted column and might have
a value of \., you might need to quote that value in the input file."
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
hil Horder
Database Mechanic
Thales
Land and Air Systems
Horizon House, Throop Road, Templecombe, Somerset, BA8 0DH, UK
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/20/2018 12:08 AM, francis cherat wrote:
Hello,
there is no message in /var/log/messages
How about the Postgres logs?
Regards
--
Adrian Klaver
adrian.kla...@aklaver.com
where are
missing data at?
First of all you are using pg_statio_user_tables which does not count
system tables.
Second pretty sure the use of current_schema is limiting the results to
only one schema in the database.
|
2018-03-19 19:32 GMT+01:00 Adrian Klaver <mailto:adrian.kla..
obviously be required by an application, but one transaction
would be cancelled by the deadlock exception, and the demonstrator would
rollback the other.
Phil Horder
Database Mechanic
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: 20 March 2018 13:51
To
store as a PostgreSQL superuser.
Firstly I supposed that data copy somehow could start the triggers - but
how?
Which triggers? Or how they fired with this order?
Or they remains as disabled AFTER the backup for next, by hand
manipulations?
So please light my mind a little!
Thank you!
Regards
dd
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/20/2018 07:56 AM, Durumdara wrote:
Dear Adrian!
2018-03-20 15:47 GMT+01:00 Adrian Klaver <mailto:adrian.kla...@aklaver.com>>:
When it would be useful?
https://www.postgresql.org/docs/10/static/app-pgrestore.html
<https://www.postgresql.org/docs/1
esty (17.04) is unsupported now, Ubuntu removed it
from their mirrors "
Is Pgdg 10.3 even available for ubuntu 17.10? How the heck does
one upgrade to it?
18.04 LTS (Bionic Beaver)?:
http://apt.postgresql.org/pub/repos/apt/dists/bionic-pgdg/
--
Adrian Klaver
adrian.kla...@aklaver.com
ction is established for
each user mapping.
"
Guessing that conn.close() is not closing the internal FDW connection
properly. Not sure how to fix, I will ponder some though.
Thanks in advance,
Albrecht.
--
Adrian Klaver
adrian.kla...@aklaver.com
iable.
"
Thanks a lot.
Best regards
--
JotaComm
http://jotacomm.wordpress.com
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/20/2018 02:25 PM, Stuart McGraw wrote:
On 03/20/2018 02:19 PM, Christoph Berg wrote:
> Re: Adrian Klaver 2018-03-20
<4c40e7c5-efa7-00d7-b891-acc9c1ec7...@aklaver.com>
>>> However I need to upgrade to 10.3 and the normal "apt update;
>>> apt upgrade"
Maybe this will help someone else.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/21/2018 02:41 AM, Durumdara wrote:
Dear Adrian!
2018-03-20 16:33 GMT+01:00 Adrian Klaver <mailto:adrian.kla...@aklaver.com>>:
On 03/20/2018 07:56 AM, Durumdara wrote:
pg_dump --disable-triggers -d test -U aklaver -t
disable_trigger_test -a -f disable_trigger_test
owner of the table, fails at parse time."
^^^
It is not the user that is doing the INSERT that matters it is the user
that owns the table that matters.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/21/2018 10:59 AM, Stuart McGraw wrote:
On 03/21/2018 07:02 AM, Adrian Klaver wrote:
On 03/20/2018 10:52 PM, Stuart McGraw wrote:
Looks like these posts are coming through a news group to me.
I am Ccing list to get response back there.
Is this something I am doing wrong? I am posting
rrectly, this needs to be addressed in
postgres_fdw, and there is nothing I can fix in my setup (except for
suppressing LOG messages) to get rid of the message?
Thanks again,
Albrecht.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/21/2018 01:31 PM, Stuart McGraw wrote:
On 03/21/2018 12:14 PM, Adrian Klaver wrote:
On 03/21/2018 10:59 AM, Stuart McGraw wrote:
On 03/21/2018 07:02 AM, Adrian Klaver wrote:
On 03/20/2018 10:52 PM, Stuart McGraw wrote:
[...]
If it where me I would simplify the above for the moment to
now?
we downloaded the current version JDBC 4.1 Driver 42.2.1.jre7
We are still having the same problem.
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
ency will be other Postgres software e.g.
psycopg2, etc. That means you will need to build them from source also,
though that is helped along by pg_config which will find your source
install and build the other software to match. It also means
uninstalling the Ubuntu Postgres packages so you don&#x
the latest:
https://jdbc.postgresql.org/download.html
On 03/21/2018 02:44 PM, Adrian Klaver wrote:
On 03/21/2018 01:16 PM, chris wrote:
I wasnt able to find what version we had installed so we went ahead
and reinstalled it
Maybe I am missing something, but if you could not find the version
On 03/22/2018 11:08 AM, Albrecht Dreß wrote:
Hi Adrian:
Am 21.03.18 19:25 schrieb(en) Adrian Klaver:
Does it also happen when you open a psql session and do?:
psql>select * from ext_table limit 1;
No messages are printed whilst the session is open. However, when I
quit the session
ction “import
foreign schema” that I used.
How can I deal with this ?
https://github.com/EnterpriseDB/mysql_fdw/issues/38
I read about the pgloader with can manage this king of problem, but
can’t figure out how to use it with FDW.
Thanks for your help.
--
Adrian Klaver
adria
rmation in real time. AFAIK that is not possible.
-Message d'origine-
De : Adrian Klaver
Envoyé : vendredi 23 mars 2018 13:52
À : Patricia DECHANDOL ;
pgsql-general@lists.postgresql.org
Objet : Re: Use pgloader with FDW
On 03/23/2018 03:55 AM, Patricia DECHANDOL wrote:
Hello,
I
On 03/24/2018 11:03 AM, HORDER Phil wrote:
I'm running Postgres 9.6.1 (I think)
To find out for sure do:
psql> select version();
Phil Horder
Database Mechanic
--
Adrian Klaver
adrian.kla...@aklaver.com
hat scares me. The fact is that a virtual user has been created
called 'postgreSQL' which has appropriated all the functions of the
administrator user. Can I kindly ask you why and how did this happen?
Gian Mario Caggiu
--
Adrian Klaver
adrian.kla...@aklaver.com
specific, with error messages
if possible?
Gian Mario Caggiu
Il giorno 27 mar 2018, alle ore 06:03, Adrian Klaver
ha scritto:
On 03/26/2018 04:41 AM, Gian mario Caggiu wrote:
Hi, I'm a student and I downloaded postgreSQL to my Mac but I found a problem.
The program does not start,
on
host "127.0.0.1" and accepting TCP/IP connections on port 5432?
Note that the postgresql.conf file does list 5432 as the port number.
I hope someone has the patience to look this over and suggest remedies. --
Ken Beck
Liberty, Utah, USA
--
Adrian Klaver
adrian.kla...@aklaver.com
provide an answer.
Il giorno 27 mar 2018, alle ore 18:01, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> ha scritto:
On 03/27/2018 07:18 AM, Gian mario Caggiu wrote:
Please reply to list also.
Ccing list.
I downloaded the first time 9.6 version, and when i saw that it
doesn’t work i dow
screwed things up? (I dont remember the commands I used to do that, sorry)
Ken Beck
Liberty, Utah, USA
--
Adrian Klaver
adrian.kla...@aklaver.com
$SHELL <
Could it be that pg_stat_activity shows nothing because the DML has
completed when you look?
Does the data find its way into the database?
Any suggestions how to approach this/make it better/monitor ?
Thanks
-- Armand
--
Adrian Klaver
adrian.kla...@aklaver.com
you might think are important from here:
https://www.postgresql.org/docs/10/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW
Sent from my iPhone
On Mar 27, 2018, at 6:03 PM, Adrian Klaver wrote:
On 03/27/2018 03:36 PM, armand pirvu wrote:
Hi all
I have a process of some data
On 03/27/2018 07:21 PM, armand pirvu wrote:
On Mar 27, 2018, at 6:49 PM, Tom Lane <mailto:t...@sss.pgh.pa.us>> wrote:
Adrian Klaver <mailto:adrian.kla...@aklaver.com>> writes:
On 03/27/2018 04:07 PM, armand pirvu wrote:
As long as the connection stays up yes data g
of an installer. Open the app, and you have a
PostgreSQL server ready and awaiting new connections. Close the app, and
the server shuts down.
http://postgresapp.com/
Il giorno 27 mar 2018, alle ore 20:44, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> ha scritto:
Which of th
On 03/28/2018 09:24 AM, Moreno Andreo wrote:
Il 27/03/2018 22:57, Adrian Klaver ha scritto:
On 03/27/2018 01:46 PM, Ken Beck wrote:
I am working on two systems, one running in Oracle VirtualBox on my
laptop, the other in a DigitalOcean droplet. I know on one of them I
tried to remove the
wrote:
Il 28/03/2018 18:28, Adrian Klaver ha scritto:
On 03/28/2018 09:24 AM, Moreno Andreo wrote:
Il 27/03/2018 22:57, Adrian Klaver ha scritto:
On 03/27/2018 01:46 PM, Ken Beck wrote:
I am working on two systems, one running in Oracle VirtualBox on my
laptop, the other in a DigitalOcean
ere, the system user and
the database one. Which one are you referring to?
--
Adrian Klaver
adrian.kla...@aklaver.com
ttp://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
On 03/31/2018 05:17 PM, pinker wrote:
Adrian Klaver-4 wrote
https://www.postgresql.org/docs/10/static/monitoring-stats.html#PG-STAT-USER-FUNCTIONS-VIEW
"...But if you want to see new results with each query, be sure to do
the queries outside any transaction block. Alternatively, you can i
1 - 100 of 4882 matches
Mail list logo
