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
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**
*
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
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
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
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
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'
