Pavel Stehule
Pavel Stehule
po 9. 6. 2025 v 15:52 odesílatel Kirk Wolak ***@***.***> napsal: > *kirkw* left a comment (okbob/plpgsql_check#190) > > > Pavel, > Apologies. I unfortunately learn by making mistakes :-)...
po 9. 6. 2025 v 22:11 odesílatel Kirk Wolak ***@***.***> napsal: > *kirkw* left a comment (okbob/plpgsql_check#190) > > > I afraid so plpgsql_check_function with new content can be unreadable....
for function `foo` ``` (2025-07-17 14:36:47) postgres=# \sf+ foo CREATE OR REPLACE FUNCTION public.foo(a integer) RETURNS integer LANGUAGE plpgsql 1 AS $function$ 2 DECLARE n numeric; 3 BEGIN 4 n...
with 98c1e144fa27c3fe2f3264f7cd88b14cfab61fc2 I get ``` (2025-07-17 20:37:36) postgres=# SELECT * FROM plpgsql_check_function('foo', performance_warnings=>true); ┌─────────────────────────────────────────────────────────────────────────────────────────┐ │ plpgsql_check_function │ ╞═════════════════════════════════════════════════════════════════════════════════════════╡ │ performance:42804:4:assignment:target type is different type than source type │ │ Query:...
``` (2025-07-17 20:49:52) postgres=# \sf+ foo2 CREATE OR REPLACE FUNCTION public.foo2() RETURNS void LANGUAGE plpgsql 1 AS $function$ 2 DECLARE a int; b numeric; 3 BEGIN 4 SELECT 10.1, 10...
unfortunately I am not able repeat it. Usually is better to separate update of orafce from upgrade of Postgres. Orafce 4.2.2 should to support pg 11 and pg 15. So...
`Orafce` is just of set of functions and views created mostly in schema `oracle`. ``` (2024-10-22 20:54:57) postgres=# select * from pg_extension ; ┌───────┬─────────┬──────────┬──────────────┬────────────────┬────────────┬───────────┬──────────────┐ │ oid │ extname │ extowner...
The domain `oracle.date` was introduced in `orafce 3.6`, but update script `orafce--3.5--3.6` looks weird. Maybe if your one database was initialized before `orafce 3.6`, then probably the functionality related to...
This script should be executed before upgrade Dne út 22. 10. 2024 21:43 uživatel Post-User2024 ***@***.***> napsal: > Thanks for the quick response. > > This script we need to...