Re: [GENERAL] How to distinguish serialization errors from others using pqxx

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-distinguis

[GENERAL] How to distinguish serialization errors from others using pqxx

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: http:/

[GENERAL] PostgreSQL using TLS v1.2 ciphers

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 = 'ECDHE-ECDSA-A

[GENERAL] Revoking access for pg_catalog schema objects

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 p

Re: [GENERAL] How to hide stored procedure's bodies from specific user

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 : > For clarification - I run the commands using psql program. > > 2015-02-11 12:54 GMT+03:00 Saimon Lim : > >> Hi >>

Re: [GENERAL] How to hide stored procedure's bodies from specific user

For clarification - I run the commands using psql program. 2015-02-11 12:54 GMT+03:00 Saimon Lim : > 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. >

[GENERAL] How to hide stored procedure's bodies from specific user

e's bodies from this user? Thanks in advance Saimon

[GENERAL] Transaction-level advisory lock unlocking and transaction end

ied 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