On 02/26/2017 09:42 AM, Tom Lane wrote:
Adrian Klaver <adrian.kla...@aklaver.com> writes:
On 02/26/2017 08:50 AM, Tom Lane wrote:
I'm not entirely sure why the OP feels he needs an index on this
expression. If he's willing to restrict the column to have the
exact format '
On 02/26/2017 08:50 AM, Tom Lane wrote:
Geoff Winkless <pgsqlad...@geoff.dj> writes:
On 26 February 2017 at 16:09, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:
On 02/26/2017 07:56 AM, Geoff Winkless wrote:
On 26 February 2017 at 10:09, Sven R. Kunze <srku...@mail.
On 02/26/2017 08:15 AM, Geoff Winkless wrote:
On 26 February 2017 at 16:09, Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>wrote:
On 02/26/2017 07:56 AM, Geoff Winkless wrote:
> On 26 February 2017 at 10:09, Sven R. Kunze <srku...@mai
s it immutable I don't have a
solution at
this time.
>
> https://www.postgresql.org/message-id/4E039D16.20704%40pinpointresearch.com
>
> Geoff
>
>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-thunderx-dual-48-core-96-core-total-arm-benchmarks/
What would I get better results with 2X Cavium ThunderX processors with
96 cores or 2 × E5-2640 v3 with 16 cores?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
will either need to specify where the lib/ is in the
configuration process or create a symlink .
Diagnostic help appreciated.
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
-SUPERUSER-RESERVED-CONNECTIONS
So much for that idea.
See more comments inline below.
2017-02-25 12:17 GMT-03:00 Adrian Klaver-4 [via PostgreSQL] <[hidden
email] >:
On 02/25/2017 04:19 AM, lisandro wrote:
> Hi there! Please tell me if this isn't the place to post my
ques
at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
b Medicine
University of Washington Medical Center
1959 NE Pacific St, MS 357110
Seattle WA 98195
work: (206) 598-8544
email: tekb...@uw.edu
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
that the column it is pointing at actually has unique values. In
general
the idea of directly modifying system tables makes me nervous.
>
> ?
>
> This is on PostgreSQL 9.3.
>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@post
On 02/23/2017 06:08 AM, Ertan Küçükoğlu wrote:
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver
Sent: Thursday, February 23, 2017 3:55 PM
To: Ertan Küçükoğlu <ertan.kucuko...@1nar.com.tr>;
pgsql-g
ions.
Thanks.
Regards,
Ertan Küçükoğlu
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
without any problems?
>> 4- I am always open to other suggestions.
>>
>> Thanks.
>>
>> Regards,
>> Ertan Küçükoğlu
>>
>>
>>
>>
>
>
>
>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
:)
Thanks for the tip.
Jerry
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 02/22/2017 07:32 AM, Jerry LeVan wrote:
On Feb 22, 2017, at 9:20 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
On 02/22/2017 07:09 AM, Jerry LeVan wrote:
Sorry I accidentally posted this to pgsql-general-owners earlier today…
How can this happen ( from the postgres
On 02/22/2017 07:32 AM, Jerry LeVan wrote:
On Feb 22, 2017, at 9:20 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
On 02/22/2017 07:09 AM, Jerry LeVan wrote:
Sorry I accidentally posted this to pgsql-general-owners earlier today…
How can this happen ( from the postgres
ny problems (talking to the mac ).
Any suggestions would be appreciated.
Jerry
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 02/21/2017 02:49 PM, Arnold Somogyi wrote:
Ccing list.
I want OR.
I do not think that is possible, then again I have not used this feature
enough to know everything that is possible.
On Tue, Feb 21, 2017 at 12:33 AM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adri
successful transfer. To improve the
chances of successful transfer more smaller transfer batches rather then
larger transfers.
Regards,
Thomas Güttler
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
On 02/21/2017 03:41 PM, Patrick B wrote:
> 2017-02-22 11:11 GMT+13:00 Patrick B <patrickbake...@gmail.com
> <mailto:patrickbake...@gmail.com>>:
>
> 2017-02-22 10:59 GMT+13:00 Adrian Klaver <adrian.kla...@aklaver.com
> <mailto:adrian.kla...@aklaver.com>
file filled with 0(?)'s
Or if there are any considerations for memory usage…
--Rob
On 2/21/17, 4:38 PM, "Adrian Klaver" <adrian.kla...@aklaver.com> wrote:
On 02/21/2017 02:19 PM, Rob Brucks wrote:
> I did find a post a while back saying they were discar
a listen does not yet exist.
Seems the thing to do would be to monitor the size of :
$PG_DATA/pg_notify/
--Rob
*From: *"David G. Johnston" <david.g.johns...@gmail.com>
*Date: *Tuesday, February 21, 2017 at 3:38 PM
*To: *Adrian Klaver <adrian.kla...@aklaver.com>
*Cc
23
> Index definition: CREATE INDEX ix_filter_by_tree ON seg USING btree
> (full_path varchar_pattern_ops) WHERE (full_path IS NOT NULL)
>
>
>
> What is the real impact of a bloat index? If I reindex it, queries will
> be faster?
>
> Thanks
> Patrick
--
ssion that is preventing cleanup. In this case you
should make sure that this session ends its current transaction so that
cleanup can proceed."
Thank you,
Rob Brucks
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
EGATE - Accumulate changes from sharded database servers into a
Data Warehouse"
I have not used this capability yet, so others would have to comment on
its applicability.
Regards,
Thomas Güttler
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgs
On 02/21/2017 07:53 AM, Thomas Güttler wrote:
Am 21.02.2017 um 15:12 schrieb Adrian Klaver:
On 02/21/2017 12:53 AM, Thomas Güttler wrote:
I want to move table rows from one database to an central database.
You actually talking about moving from ~100 databases to the central
database
that sets things up for you.
Regards,
Thomas Güttler
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
at
the satellite database must happen.
- ...
How to solve this with PostgreSQL?
Regards,
Thomas Güttler
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
quot;
I read that as only one constraint_name.
The question then becomes whether you want:
table1_pkey, table1_name_key
to OR or AND?
>
> Regards,
> Arnold
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
his:
"TRUNCATE is not MVCC-safe. After truncation, the table will appear
empty to concurrent transactions, if they are using a snapshot taken
before the truncation occurred. See Section 13.5 for more details."
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general m
server?
--
Richard Brosnahan
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
m repo that has that version.
3 Make what I have work, somehow.
Any assistance would be greatly appreciated!
--
Richard Brosnahan
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
db) already exists.
Sent from my iPhone
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
out ?
What are you trying to achieve?
Thank you in advance
Jean-Michel Scheiwiler
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ut is there
any other
> way to do this using single COPY command?
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
--
Alexander Shchapov
--
Adrian Klaver
adrian.kla...@akl
/wal-configuration.html
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Jean-Philippe
Sent from ProtonMail <https://protonmail.ch>, encrypted email based in
Switzerland.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
FROM
pg_catalog.pg_index i) i ON (ct.oid = i.ind
This query is cut off so cannot say whether it is the issue or not.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql
On 02/16/2017 07:42 AM, pinker wrote:
Adrian Klaver-4 wrote
Exactly, they do not have it whereas:
https://www.postgresql.org/docs/9.6/static/sql-select.html#SQL-FOR-UPDATE-SHARE
Still not much. The documentation could be more verbose on this topic. I can
only presume that since
On 02/16/2017 06:52 AM, pinker wrote:
> Adrian Klaver-4 wrote
>> https://www.postgresql.org/docs/9.6/static/sql-truncate.html
>>
>> https://www.postgresql.org/docs/9.6/static/sql-delete.html
>
> There is nothing about FOR UPDATE clause on those pages...
Exactly,
--
View this message in context:
http://postgresql.nabble.com/Using-ctid-in-delete-statement-tp5944434p5944658.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general
feature
DETAIL: This functionality requires the server to be built with libxml
support.
HINT: You need to rebuild PostgreSQL using --with-libxml.
Sent from Outlook <http://aka.ms/weboutlook>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-g
(without FULL), ANALYZE, CREATE INDEX
CONCURRENTLY, and ALTER TABLE VALIDATE and other ALTER TABLE variants
(for full details see ALTER TABLE).
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
if you leave it in place where it is, the packages won't initialize
a new data directory.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
er it's
not starting...
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 02/15/2017 09:28 AM, Joshua D. Drake wrote:
On 02/15/2017 09:17 AM, Adrian Klaver wrote:
On 02/15/2017 09:03 AM, Shawn Thomas wrote:
/usr/lib/postgresql/9.4/bin/pg_ctl: No such file or directory
That should have been:
lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
On 02/15/2017 09:03 AM, Shawn Thomas wrote:
/usr/lib/postgresql/9.4/bin/pg_ctl: No such file or directory
That should have been:
lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:Ubuntu 16.04.2 LTS
Release:16.04
Codename: xenial
--
Adrian
ull stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
?
Any advice on how to best go about this? The official documentation seems a
bit thin:
https://www.postgresql.org/docs/9.4/static/backup-file.html
I’ve only worked with normal (pg_dump, pg_dumpall) backups in the past.
-Shawn
On Feb 15, 2017, at 6:35 AM, Adrian Klaver <adrian.
On 02/15/2017 06:53 AM, hubert depesz lubaczewski wrote:
On Wed, Feb 15, 2017 at 06:44:09AM -0800, Adrian Klaver wrote:
On 02/15/2017 06:27 AM, hubert depesz lubaczewski wrote:
On Wed, Feb 15, 2017 at 06:24:14AM -0800, Adrian Klaver wrote:
On 02/15/2017 06:05 AM, hubert depesz lubaczewski
On 02/15/2017 06:27 AM, hubert depesz lubaczewski wrote:
On Wed, Feb 15, 2017 at 06:24:14AM -0800, Adrian Klaver wrote:
On 02/15/2017 06:05 AM, hubert depesz lubaczewski wrote:
Hi,
I have a function, in PostgreSQL 9.6, which does:
INSERT INTO table () values (...)
ON CONFLICT DO UPDATE
gresql.conf”
So you are talking about:
/etc/init.d/postgresql
which then calls:
/usr/share/postgresql-common/init.d-functions
Or is there another setup on your system?
Any relevant information in the system logs?
Thanks, though.
-Shawn
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sen
that this is not
available. Or am I missing something?
All I can think of is to use:
RETURNING pk
and see if that changed or not.
Best regards,
depesz
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On 02/14/2017 05:00 PM, Adrian Klaver wrote:
On 02/14/2017 12:00 PM, Shawn Thomas wrote:
Yes that would be the standard approach. But the Debian package removes
pg_ctl from it normal place and wraps it with a perl script in a way
that makes it difficult to work with (it doesn’t accept the same
http://www.redpill-linpro.com/
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 02/14/2017 09:47 AM, Mimiko wrote:
> On 14.02.2017 17:30, Adrian Klaver wrote:
>>> Is there a way to change postgres behavior to name database folders by
>>> the database name? And table files in them by table's name? And not
>>> using OIDs.
>>
>> N
H-RANKING
Setting a normalization of 1:
test=# SELECT s, ts_rank(vector, query, 1) AS rank
FROM t, to_tsvector(s) vector, to_tsquery('hello') query
WHERE query @@ vector;
s | rank
-+---
hello | 0.0607927
hello world | 0.0383559
>
> Thanks for
On 02/14/2017 07:19 AM, Mimiko wrote:
Hello.
Is there a way to change postgres behavior to name database folders by
the database name? And table files in them by table's name? And not
using OIDs.
No.
Is there a particular problem you are trying to solve?
--
Adrian Klaver
adrian.kla
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
I will move it to the pgadmin subforum.
Thanks:)
--
View this message in context:
http://postgresql.nabble.com/Auto-Rollback-option-tp5943942p5944159.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via
way.
--
View this message in context:
http://postgresql.nabble.com/Auto-Rollback-option-tp5943942p5944047.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general
t;starting" and "ending" timestamp that
default to "-infinity"
and "infinity" respectively. Any function I have that outputs xml
containing those columns
have to have those values cast to text.
Lynn Dobbs
--
Chief Technical Office
CreditLink Corporation
858-496
On 02/13/2017 11:50 AM, François Beaulieu wrote:
>
>> On Feb 13, 2017, at 1:56 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
>>
>> On 02/13/2017 09:04 AM, François Beaulieu wrote:
>>>
>>>> On Feb 13, 2017, at 11:45 AM, Adria
On 02/13/2017 09:04 AM, François Beaulieu wrote:
On Feb 13, 2017, at 11:45 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
|
3) Are the first row and the second row in the same partition?
Doubtful, the p
Auto-Rollback click manualy in the Option
>> menu
>> or query editor window (because I can not be sure that the person who
>> will
>> run the patch would remember about this click).
>
> option? query editor window? what software are you talking about?
&
using 1.22.1 version.
1.22.1 version? PostgreSQL versions currently supported are 9.2.x to
See above.
9.6.x
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On 02/13/2017 07:59 AM, François Beaulieu wrote:
On Feb 13, 2017, at 10:28 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
On 02/10/2017 02:54 PM, François Beaulieu wrote:
Hi all,
I’m trying to feed a worker process on another server using pg_notify in a
trigger. I’m running
On 02/13/2017 07:52 AM, Stephen Frost wrote:
Greetings,
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
On 02/13/2017 06:04 AM, Stephen Frost wrote:
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
I am following this up to the point of not understanding what
exactly changed between 9.5
that TG_TABLE_NAME and NEW.userfield are part
of the INSERT, while NEW._id is actually a request for information from
another object.
Thanks,
-=François Beaulieu
SBK Telecom
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
file.
"
NOTE that you have to explicitly ROLLBACK a failed transaction though.
Thanks in advanced for the answear.
Best regards,
Malgorzata Pomykacz
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
On 02/13/2017 06:04 AM, Stephen Frost wrote:
Adrian,
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
I am following this up to the point of not understanding what
exactly changed between 9.5 and 9.6. Namely 9.5 does include the
default ACL's in the dump output and 9.6 does not.
Quite
frastructure.
That handwriting has been on the wall for years, but nobody's gotten
around to writing the necessary interface logic for Postgres.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@po
oice.
Apple would really like people to start using their SSL infrastructure.
That handwriting has been on the wall for years, but nobody's gotten
around to writing the necessary interface logic for Postgres.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
uggestions?
Not a suggestion, but a question:
What are the full command line invocations to configure for 9.3 and 9.6?
Now a suggestion, do you have the openssl devel package installed?
Thanks
Jerry
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgs
:
https://github.com/getredash/redash
Regards,
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Another
option would be to change getNamespaces() to run a special query
(perhaps as a UNION-ALL combination with the existing query) that is
just to get the info for the 'public' schema (and exclude the 'public'
schema from the first half of the query, of course).
Thanks for the report!
Stephen
On 02/11/2017 01:14 PM, Frank van Vugt wrote:
Hi Adrian,
Op zaterdag 11 februari 2017 13:02:29 schreef Adrian Klaver:
What version of Postgres?
Ah, sorry, missed copying that in:
postgres=# select version();
version
me | Owner | Access privileges | Description
> +------+--+
> public | postgres | postgres=UC/postgres+| standard public schema
> | | =UC/postgres |
> (1 row)
>
>
>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
(array['a','b','c','d','e','f']) u;
array_agg
---
{d,a,f,c,b,e}
To future proof your code follow the advice shown in the doc snippet in
the first answer to your SO question. This is what I showed in my
answers to your questions.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Se
'd','e','f']);
words_shuffle
---
{d,f,a,e,c,b}
(1 row)
postgres=> select * from words_shuffle(ARRAY['a','b','c','d','e','f']);
words_shuffle
---
{c,d,a,e,f,b}
(1 row)
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsq
gres=> select * from unnest(ARRAY['a','b','c','d','e','f']) order by
random();
unnest
d
c
a
f
e
b
(6 rows)
postgres=> select * from unnest(ARRAY['a','b','c','d','e','f']) order by
random();
unnest
----
b
d
e
c
a
f
(6 rows)
--
Adrian Klaver
adrian.kla...@ak
', [date.today()])
From Postgres log;
aklaver-2017-02-10 14:35:42.842 PST-0LOG: statement: BEGIN
aklaver-2017-02-10 14:35:42.842 PST-0LOG: statement: select
'2017-02-10'::date
2017-02-10 16:57 GMT-05:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>
ate
object. I am betting that what you will see in the logs is an integer.
2017-02-10 16:32 GMT-05:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
On 02/10/2017 07:17 AM, Roberto Balarezo wrote:
Hi, I would like to know why this is hap
ger and integer + date); we show only one of each such pair."
and:
test=# select current_date;
date
2017-02-10
(1 row)
test=# select current_date + 1;
?column?
2017-02-11
(1 row)
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-gen
the
datatype of the parameter??
What can I do to make it work?
For reference, I’m using PostgreSQL 9.2.15 and JDBC driver 9.4.1207.jre6.
Thanks for your advice!
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 02/10/2017 09:09 AM, Leonardo M. Ramé wrote:
Hi, is there a way to alter a view using *psql*?, something like what
\ef does for functions.
In 9.6:
https://www.postgresql.org/docs/9.6/static/app-psql.html
\ev [ view_name [ line_number ] ]
Regards,
--
Adrian Klaver
adrian.kla
because I got a very big spike with > 30 seconds web response
time.
Running PG 9.3
Thanks!
Patrick
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pg
zone_names and pg_timezone_abbrevs showed very different
results for the same code.
Thanks,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
the returned interval would be "2 mons
18 days 21:00:00" without using justiy_interval() on it.
I couldn't find a clear statement on that in the manual.
Thomas
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
for High Availability
Commits made when synchronous_commit is set to on or remote_write will
wait until the synchronous standby responds. The response may never
occur if the last, or only, standby should crash."
since the Slave is down while rollbacking on the Master.
--
Adrian Kla
this message in context:
http://postgresql.nabble.com/pgbouncer-increase-pool-size-reload-does-not-work-tp5942273.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general
string and how it is used in
multiple places?
What is your concern?
IIRC, the thing I read proposed defining a type AS IMPLICIT, but I’m not
sure. Mainly because the docs urge caution with using AS IMPLICIT.
Thoughts?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general
in located?
5) What OS are you using?
6) Have you looked at an OS packaging systems to do this?
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
//www.linkedin.com/company/trybooking-com>
On 30 January 2017 at 04:49, Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> wrote:
On 01/28/2017 11:23 PM, Brian Mills wrote:
I presume this is a binary log file for the database.
Am I able
c items could be stuffed into an
hstore typed table.
My answer to your stated question is: what happened when you tried
doing that? Documentation and a bit of experimentation goes a long
ways in learning.
David J.
--
--- Get your facts first, then you can distort them as yo
/postgresql/9.3/main
The log mentions this:
2017-01-27 20:36:18 AEDT LOG: last completed transaction was at log
time 2017-01-24 02:08:00.023064+11
(which is moments before, or possibly as the disk filled up doing a db
backup dump)
*Brian Mills*
CTO
--
Adrian Klaver
adrian.kla...@aklaver.com
I have a consistent sql dump from 24 hour previous.
The file level backup was done with rsync -a of full data directory
after the issue occurred so could reset as I learned.
Brian
On Sun, 29 Jan 2017 at 9:18 am, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian
S 0:00 su postgres
> 5221 pts/3S 0:00 /usr/lib/postgresql/9.3/bin/postgres -D
> /etc/postgresql/9.3/main
> 5222 ?Ss 0:10 postgres: startup process recovering
> 0001000500A3
> 11161 pts/4S+ 0:00 grep --color=auto post
oking-com>
On 28 January 2017 at 12:05, Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> wrote:
On 01/27/2017 01:31 PM, Brian Mills wrote:
Hi,
I have a Atlassian Confluence Wiki that depends on postgres, but I
haven't muc
tore the service for my team to use and suck up the lost last
day of updates.
Thanks,
Brian
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
401 - 500 of 4904 matches
Mail list logo