W dniu 2020-10-21 o 13:54, Matthias Apitz pisze:
Hello,
I've found the following problem using psql 11.4 against a server 13.0:
you may install a separate 13.0 psql binary and use that one against the 13.0
server
W dniu 2020-09-30 o 14:11, luis.robe...@siscobra.com.br pisze:
Hi!
I'm trying to use this query to get table sizes, however I'm getting a strange
error:
select tablename,pg_relation_size(tablename::text)
from pg_tables;
In PG 13:
SQL Error [42P01]: ERROR: relation "sql_implementation_info"
W dniu 2020-09-28 o 13:39, Matthias Apitz pisze:
El día lunes, septiembre 28, 2020 a las 12:17:26p. m. +0200, Paul Förster
escribió:
$ psql -Usisis -dsisis
SET
psql (11.4, server 13.0)
WARNING: psql major version 11, server major version 13.
Some psql features might not work.
Type "he
W dniu 2020-07-21 o 17:30, Mohamed Wael Khobalatte pisze:
we are planning to move some primary keys from int to bigint because we are
approaching the type limit
If that does not break your business logic, you might arrange to use the negative half of the ::int
value range. Ugly, but this might
ursday, 27 February, 2020, 07:39:13 pm IST, Ireneusz Pluta/wp.pl
wrote:
W dniu 2020-02-27 o 14:37, sivapostg...@yahoo.com
<mailto:sivapostg...@yahoo.com> pisze:
> Hello,
>
> I'm saying isolation will not work out to my requirement. The steps.
>
> 1. On completion o
ldn't pg_advisory_lock() in step 2, and pg_advisory_unlock() in step 6, make the process work
in the way you expect?
https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS
On Thursday, 27 February, 2020, 06:29:00 pm IST, Ireneusz Pluta/wp.pl
wrote:
W dniu 2020-02-
W dniu 2020-02-27 o 12:35, sivapostg...@yahoo.com pisze:
I need to prevent other users from entering any transaction till I finish taking reports from my
application. All users will be using the same application, from which this report is supposed to
be printed.
maybe advisory lock is what y
W dniu 2019-06-11 o 19:45, Igal Sapir pisze:
I'm doing a presentation about Postgres to SQL Server users this weekend, and I want to showcase
some of the big names that use Postgres, e.g. MasterCard, Government agencies, Banks, etc.
You might be interested in this:
https://www.theguardian.com/