Re: bug regclass::oid

2019-06-17 Thread John Mikel
l occur if i run this query in other database will work fine I tested this on pg 11.1 , pg 10.3, pg 9.6 PS:Sorry if this message is duplicated i canceled the previous message by mistake by clicking on link Le jeu. 13 juin 2019 à 17:33, Adrian Klaver a écrit : > On 6/13/19 8:14 AM, John Mik

Re: bug regclass::oid

2019-06-16 Thread John Mikel
if i run this query in other database work fine I tested this on pg 11.1 , pg 10.3, pg 9.6 Le jeu. 13 juin 2019 à 17:33, Adrian Klaver a écrit : > On 6/13/19 8:14 AM, John Mikel wrote: > > * hi , > > i am here to tell you that this test in query is not working when th

bug regclass::oid

2019-06-13 Thread John Mikel
* hi , i am here to tell you that this test in query is not working when the table name in the database or schema name contain space a.table_name::regclass=b.attrelid a is information_schema.columns b is pg_attribute trying this in two different databases the first database contain table with

About SSL connection

2019-01-06 Thread John Mikel
Hi, i was trying to enable SSL on postgresql 10 and 11 Servers after searching on postregsql documentation i found this : ALTER SYSTEM SET *configuration_parameter* { TO | = } { *value* | '*value*' | DEFAULT } on https://www.postgresql.org/docs/10/sql-altersystem.html i used ALTER SYSTEM SET SSL