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:/
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
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
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
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
e's bodies from 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 :
> 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.
>
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
>>
