function to_char

2021-04-17 Thread Fontana Daniel C. (Desartec S.R.L.)
Hi, using postgres 12.5. The to_char function has a problem with format length. Example, select length (to_char (1, '990')) returns 4 because? if the format has length 3? -- El software de antivirus Avast ha analizado este correo electrónico en busca de virus.

size windows editor pgadmin 4

2020-10-22 Thread Fontana Daniel C (Desartec S.R.L.)
Hello group, you can set a bigger size for the window for editing tables, functions, etc. of pgadmin 4. Every time I edit information I am widening the window, honestly the size is very small.

Local variable 'debugger_version' referenced before assignment

2020-08-04 Thread Fontana Daniel C (Desartec S.R.L.)
Hello: After enabling en file postgresql.conf shared_preload_libraries = '$ libdir/plugin_debugger.dll' and installing the pldbgapi extension. I try to debug a created function and pgadmin4 displays the following error. Local variable 'debugger_version' referenced before assignment. This

Variable 'debugger_version'

2020-07-31 Thread Fontana Daniel C (Desartec S.R.L.)
Hello: After enabling en file postgresql.conf shared_preload_libraries = '$ libdir/plugin_debugger.dll' and installing the pldbgapi extension. I try to debug a created function and pgadmin4 displays the following error. Local variable 'debugger_version' referenced before assignment. This

PGADMIN4 wrong password

2020-06-18 Thread Fontana Daniel C (Desartec S.R.L.)
After finishing installation Postgres12, I do the following steps. 1.- I enter PSQL and I connect to the base, that is postgres 2.- I create a new database with name test 3.- I connect to the test, to be able to rename postgres 4.- Rename postgres base to company_name 5.- I try to connect with

SLONY waiting por event tobe confirmed never end

2020-06-08 Thread Fontana Daniel C (Desartec S.R.L.)
Hi i am trying to do my first sync with slony 2.2.6. and PostgreSQL version 10 Server IP = 192.168.1.229 Slave IP = 192.168.1.252 Just a basic table CREATE TABLE dba.prueba ( id integer NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),