the_threshold?
select count(distinct relation) + count(distinct (classid, objid)) from
pg_locks
Best regads
Alexey Bashtanov
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
s two lines for the locks on the same object
when the pids or the granted differ.
Alexey Bashtanov
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi all,
I am searching for a proper database schema version management system.
My criteria are the following:
0) Open-source, supports postgresql
1) Uses psql to execute changesets (to have no problems with COPY,
transaction management or sophisticated DDL commands, and to benefit
from scripti
me lock
conflicting with AccessExclusiveLock you can use this table
<http://www.postgresql.org/docs/9.4/static/explicit-locking.html#TABLE-LOCK-COMPATIBILITY>
to determine what locks are conflicting one with another Regards, Alexey
Bashtanov
On 14/04/16 18:34, Kevin Burke wrote:
Unfortunately *I'm still seeing a very slow query which is affecting
our tests. *It's happening with roughly the same frequency as the
previous error.
*
*
The query log is here:
https://gist.github.com/kevinburkeshyp/f1a4f73f8933e027aebbc53283acced2**
*
On 14/04/16 18:34, Kevin Burke wrote:
Unfortunately *I'm still seeing a very slow query which is affecting
our tests. *It's happening with roughly the same frequency as the
previous error.
*
*
The query log is here:
https://gist.github.com/kevinburkeshyp/f1a4f73f8933e027aebbc53283acced2**
*
extension to
postgres core is not too easy
and normally requires an extension to become popular and to be included
in postgres distribution as a contrib module first.
Regards,
Alexey Bashtanov
On 19/05/16 04:04, Tom Smith wrote:
It would really save all the troubles for many people if postgresql
has
Hello, Saimon,
I propose the following (ugly) solution.
--
/*as some privileged user: */
begin;
create table hidden_function_foo as select $code$
create function pg_temp.foo(p_input text) returns text as $$
select /*nodoby knows we are using
md5*/md5('the_salt_nobody_can_see'