Because in trigger where table fpbackup.fp_vpn_data_2021w12 has
been created there are several DDL commands:
EXECUTE 'CREATE TABLE "' || fp_schema_name || '"."' || fp_table_name || '"
(LIKE '|| fp_parent_table_name || ' INCLUDING DEFAULTS INCLUDING CONSTRAINTS
INCLUDING INDEXES) WITHOUT O
On 3/25/21 1:25 AM, Андрей Сычёв wrote:
Because in trigger where table fpbackup.fp_vpn_data_2021w12 has
been created there are several DDL commands:
EXECUTE 'CREATE TABLE "' || fp_schema_name || '"."' || fp_table_name || '"
(LIKE '|| fp_parent_table_name || ' INCLUDING DEFAULTS INCLUDING
Hi
>From this blog:
>https://wiki.postgresql.org/wiki/A_Guide_to_CVE-2018-1058%3A_Protect_Your_Search_Path
Do you think that this is just a mitigation, not a real fix, is there any plan
to fix it?
Thanks
Extra tables is not something that will work out in my workflow...
I've managed to cut the time in half already, but perhaps there's more to
be won.
In one of the calculations done on the st_area, I used a log(base,value),
but since the only 2-param log function present in postgres takes numerics
a
On 3/25/21 12:49 PM, Carlos Montenegro wrote:
Hello dear Adrian and Ray.
Good day !
Thank you both for helping me.
It has worked and have installed pgadmin4, but have this issue when try
to open the server:
What packages did you install?
Define open server.
What is the complete text of the
Hi All,
PostgreSQL version : 12.5
When we are compiling View definition into database , the where clause on
the Character Columns is getting internally typecasted to text.
Example : Source Code being Applied :
" FROM tms_vessel_visit_aggregate a, tms_vessel_visit v
LEFT OUTER JOIN tms_vsl_svc s
> On Mar 25, 2021, at 10:32 PM, Jagmohan Kaintura
> wrote:
>
>
> Hi All,
>
> PostgreSQL version : 12.5
>
> When we are compiling View definition into database , the where clause on the
> Character Columns is getting internally typecasted to text.
> Example : Source Code being Applied :
>
Hi Jagmohan,
The issue is reproducible in my environment.
postgres=# SELECT version();
version
PostgreSQL 13.0, compiled by Visual C++ build 1900, 64-bit
(1 row)
postgres=# CREATE TABLE public.test(t *varchar
Jagmohan Kaintura writes:
> When we are compiling View definition into database , the where clause on
> the Character Columns is getting internally typecasted to text.
That's normal. In Postgres, varchar has no operators of its own;
everything you might do with it involves a (no-cost) cast to te
