I don't know if this is intentional, but the Postgres 10 manual started to use
lowercase IDs as anchors in the manual.
So, if I have e.g.: the following URL open in my browser:
https://www.postgresql.org/docs/current/static/sql-createindex.html#sql-createindex-concurrently
I cannot simply s
On 2017-10-14 16:32:33 Tom Lane wrote:
> More likely explanations for the OP's problem involve foreign key
> constraints that cause two different row updates to need to lock
> the same referenced row, or maybe he's using some index type that
> has greater locking demands than a btree, or he's using
Did you try using SELECT FOR NO KEY UPDATE instead of SELECT FOR UPDATE?
However:
Seamus Abshere wrote:
> My current theory is that, since the table is not clustered by id, rows
> with very distant ids get stored in the same page, and the whole page is
> locked during an update.
But we only lo
Seamus Abshere writes:
> I hesitate to share my query and indexes because it makes this question
> seem more esoteric than I think it really is... but here we go.
> * Version 9.6.3.
> * I don't have any foreign key constraints.
> * I don't use serializable.
> * My update query is very careful to s
In PG 9.6 or PG 10, is there a way to force only SSL based connections coming
from pgadmin or dbeaver.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hi All,
I wanted to find out how to use a substitution variable in an SQL statement
that would cause the user to be prompted for a value. Something similar to
the ampersand (&&) in ORACLE.
For example, given the SQL statement below:
SELECT ,,
FROM
WHERE = 35
I want the user to be p
rakeshkumar464 writes:
> In PG 9.6 or PG 10, is there a way to force only SSL based connections coming
> from pgadmin or dbeaver.
I think you could set that up with a custom pg_hba.conf entry or two.
Something like
hostnossl ... pgadmin ... reject
before the line that would normally accept the
On 16/10/2017 17:08, Osahon Oduware wrote:
Hi All,
I wanted to find out how to use a substitution variable in an SQL statement that would
cause the user to be prompted for a value. Something similar to the ampersand
(&&) in ORACLE.
For example, given the SQL statement below:
SELECT ,,
On Mon, Oct 16, 2017 at 7:08 AM, Osahon Oduware
wrote:
> Hi All,
>
> I wanted to find out how to use a substitution variable in an SQL
> statement that would cause the user to be prompted for a value. Something
> similar to the ampersand (&&) in ORACLE.
>
> For example, given the SQL statement be
Hi,
The postgresql crashed on friday due to IO errors. It seems that the
filesystem puked.
PANIC: could not fdatasync log file 000101760077: Input/output
error
LOG: database system was interrupted; last known up at 2017-10-13 15:26:28
EDT
WARNING: terminating connection because of cra
Just before we restart the server today, I found only one line as:
PANIC: could not fdatasync log file 000101760083: Input/output
error
the database system is in recovery mode
On Mon, Oct 16, 2017 at 10:43 AM said assemlal
wrote:
> Hi,
>
> The postgresql crashed on friday due to I
Thanks for the information.
On Mon, Oct 16, 2017 at 3:27 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Mon, Oct 16, 2017 at 7:08 AM, Osahon Oduware
> wrote:
>
>> Hi All,
>>
>> I wanted to find out how to use a substitution variable in an SQL
>> statement that would cause the us
> Seamus Abshere writes:
> > * I do have some exotic indexes [2]. gist, gin, postgis, fillfactor...
> On Mon, Oct 16, 2017, at 10:55 AM, Tom Lane wrote:
> I'd bet on the last one, especially since you found that the problem
> was a page-level lock. Did you look to see which relation the page
> l
Hi,
If have a view that I would like to sort where I divide the return in 3
different groups.
These 3 groups then should have a random sort order each.
As I am I using it with an offset, and limit, the randomness should be the
same.
For example:
SELECT user_id, age FROM view_users
ORDER BY CASE
Andreas,
On 10/15/2017 11:53 PM, Andreas Kretschmer wrote:
other solution, using the CTID-column: (rows with (1,1,1) and (5,5,5)
are identical)
test=*# select * from dubletten ;
c1 | c2 | c3
++
1 | 1 | 1
1 | 1 | 1
1 | 2 | 3
2 | 3 | 4
3 | 4 | 5
4 | 5 | 5
5
> > On Mon, Oct 16, 2017, at 10:55 AM, Tom Lane wrote:
> > I'd bet on the last one, especially since you found that the problem
> > was a page-level lock. Did you look to see which relation the page
> > lock was in?
On Mon, Oct 16, 2017, at 12:34 PM, Seamus Abshere wrote:
> The specific relation
FYI,
On 10/16/2017 8:58 AM, Igal @ Lucee.org wrote:
test=*# with keep as (select max(ctid) as ctid from dubletten group
by c1,c2,c3) delete from dubletten where ctid not in (select ctid
from keep);
I like this solution, but would using a subquery be much slower than
the implicit join o
Thanks a lot Jeremy, we ended up integrating the code you provided
into our software (just before you patent it) :)
Best regards,
Kkh
On Tue, Oct 3, 2017 at 7:58 PM, Schneider wrote:
> On Mon, Oct 2, 2017 at 10:27 AM, Khalil Khamlichi
> wrote:
>> we have records like this
>>
>> ccdb1=# select
I wasn't under the impression that open source meant "totally unsupported,
undocumented, and fix it yourself if it's broken." If your attitude is
going to be "it's good enough for my needs so I'll just rudely dismiss any
problems with it," why merge it at all?
And for what it is worth, postgresql
David G. Johnston wrote:
> You could at least fix the documentation bug since this superuser-only
> restriction doesn't show up and is in fact contradicted by the sentence
> "REASSIGN OWNED requires privileges on both the source role(s) and the
> target role." The error message that comes back
On Mon, Oct 16, 2017 at 11:47 PM, said assemlal wrote:
> Just before we restart the server today, I found only one line as:
>
> PANIC: could not fdatasync log file 000101760083: Input/output
> error
> the database system is in recovery mode
Ouch. I would not trust this host at this p
Hi all,
The largest PostgreSQL conference in Japan "PGConf.ASIA" will be held
in December 4th to 6th this year.
http://www.pgconf.asia/EN/2017/
If you are planning to join and you need a visa to enter Japan, please
contact me as soon as possible. I am in charge of issuing invitation
letters etc.
On Mon, May 29, 2017 at 3:58 PM, Ludovic Vaugeois-Pepin
wrote:
> < 2017-05-29 22:42:17.026 CEST > DEBUG: switched WAL source from
> archive to stream after failure
> ... (15 seconds later) ...
> < 2017-05-29 22:42:32.042 CEST > DEBUG: switched WAL source from
> stream to archive after failure
L
On 11 October 2017 at 20:38, rverghese wrote:
> I guess there is nothing at the database level.
Although not safe (as the user can reset this parameter), you could set
default_transaction_read_only for the application user.
postgres=# ALTER USER jdoe IN DATABASE postgres SET
default_transaction
Hi,
I am executing many "COPY" commands via psql serially from a bash script
from a compute node that accesses a mounted home directory located on a
remote server.
After about a thousand or so executions of the "COPY" command I get the
error "psql: could not get home directory to locate password f
rverghese schrieb am 11.10.2017 um 20:38:
> You mean at the user permissions level? Yes, I could, but would mean doing so
> table by table, which is not our current structure. I guess there is nothing
> at the database level.
Not at the database level, but at the schema level:
You can revoke thos
On Tue, Oct 17, 2017 at 09:06:59AM +0300, Allan Kamau wrote:
> Is there a way to instruct psql not to try reading ~/.pgpass file?
https://www.postgresql.org/docs/current/static/libpq-envars.html
PGPASSFILE behaves the same as the passfile connection parameter.
passfile
Specifies the name of the fi
It is not psql but libpq which uses .pgpass file, as per my knowledge
there is no way of preventing it unless you have your own customize version
of libpq which do not have such option in it. But there is a workaround to
prevent libpg from using default .pgpass file is to set 'PGPASSFILE'
environ
28 matches
Mail list logo
