As I undersand, the only way to determine serialization errors is to parse
pqxx::sql_error exceptions' messages for keywords like could not serialize
etc.
Or am I wrong?
Thanks in advance
Saimon
--
View this message in context:
http://postgresql.nabble.com/How-to-distinguish-serialization
Hi
Is there any way to distinguish serialization errors from others using pqxx?
As far as I understand there is no way to get sql error code within pqxx
lib.
Ability to detect serialization errors is important to implement retrying
logic for this cases.
--
View this message in context:
Hi
I want to setup postgres to encrypt all connections to my db using ssl.
My settings:
pg_hba.conf:
# TYPE DATABASEUSERADDRESS METHOD
hostsslmy_db all 0.0.0.0/0md5
postgresql.conf:
ssl = on
ssl_ciphers =
Hi
I want to restrict access for some user for tables and views in pg_catalog
schema.
After the following command in psql:
REVOKE ALL ON SCHEMA pg_catalog FROM PUBLIC;
Access, for example, for table pg_proc was restricted:
SELECT * from pg_catalog.pg_proc;
ERROR: permission denied for schema
will fail to select procedure's body from pg_catalog.pg_proc and
using psql \sf of \ef.
Is this method correct?
2015-02-12 11:53 GMT+03:00 Saimon Lim aimon.s...@gmail.com:
For clarification - I run the commands using psql program.
2015-02-11 12:54 GMT+03:00 Saimon Lim aimon.s...@gmail.com:
Hi
this
user?
Thanks in advance
Saimon
For clarification - I run the commands using psql program.
2015-02-11 12:54 GMT+03:00 Saimon Lim aimon.s...@gmail.com:
Hi
I want to hide my own stored procedures' bodies from the specific user.
As far as I know, procedure's body is visible in the pg_catalog.pg_proc
table.
So, I did
at first and the lock would be unlocked
after it or vice versa?
Or any order in this case is not guaranteed?
Thanks a lot for your help.
Saimon