postgresql bug

[ml]

Hallo, 

there is a postgresql bug

/usr/local/bin/postgres -V
ld-elf.so.1: Shared object "libicui18n.so.70" not found, required by
"postgres"

Installed Version:
postgresql14-server-14.1

find / -name "*libicui*"
/usr/local/lib/libicuio.a
/usr/local/lib/libicui18n.so.71
/usr/local/lib/libicuio.so.71.1
/usr/local/lib/libicui18n.so.71.1
/usr/local/lib/compat/pkg/libicui18n.so.68.2
/usr/local/lib/compat/pkg/libicuio.so.68
/usr/local/lib/compat/pkg/libicuio.so.68.2
/usr/local/lib/compat/pkg/libicui18n.so.68
/usr/local/lib/libicui18n.so
/usr/local/lib/libicuio.so.71
/usr/local/lib/libicuio.so
/usr/local/lib/libicui18n.a
/compat/linux/usr/lib64/libicuio.so.50
/compat/linux/usr/lib64/libicui18n.so.50
/compat/linux/usr/lib64/libicui18n.so.50.2
/compat/linux/usr/lib64/libicuio.so.50.2
/compat/linux/usr/lib/libicui18n.so.50.2
/compat/linux/usr/lib/libicuio.so.50.2
/compat/linux/usr/lib/libicui18n.so.50
/compat/linux/usr/lib/libicuio.so.50

What should I do?

Franz

pkg: two postgresql clients

[ml]

Hello,

1.
pkg upgrade show this result:

New packages to be INSTALLED:
postgresql13-client: 13.7
postgresql15-client: 15.b1_1

Installed packages to be UPGRADED:
firefox: 103.0.1,2 -> 103.0.2,2
nspr: 4.34 -> 4.34.1
opencore-amr: 0.1.5 -> 0.1.6
py39-psutil: 5.9.1_1 -> 5.9.1_2

There are two different PG clients. Is this correct?

2.
The command 
pkg install  firefox
New packages to be INSTALLED:
postgresql15-client: 15.b1_1
Installed packages to be UPGRADED:
firefox: 103.0.1,2 -> 103.0.2,2

PG is not a dependent package of firefox?

I use version:
postgres -V 
postgres (PostgreSQL) 14.1

Franz

type bug?

[ml]

Hello,

there is a bug with types in functions. Here is an example:

--drop type  xyz; 
create type xyz as ( x numeric,  y numeric,  z numeric );

--drop table  test_xyz ; 
create table test_xyz (  a int,  b xyz, c xyz );
insert into  test_xyz values
( 1,(11.1, 12.3, 14.5 ), (22.2, 22.3, 24.5 ) ) ;

--drop  function test_xyz() ;
create function test_xyz() returns table ( a xyz, b xyz)  as
$$
 select b, c from test_xyz ;
$$ language sql ; 

--drop   function test_xyz2() ;
create function test_xyz2() returns table ( b xyz)  as
$$
 select  b from test_xyz  ;
$$ language sql ; 

--drop   function test_xyz3() ;
create function test_xyz3() returns table ( b xyz)  as
$$
declare
  bb xyz;
  cc xyz;
begin
  select b, c into bb, cc from test_xyz ;
  return bb ;
end;  
$$ language plpgsql ; 
-- -- 
select * from test_xyz() ; 
select * from test_xyz2() ; -- 3 columns, but 1 should be correct?
select b from test_xyz2() ; -- error
select x from test_xyz2() ; -- never declared column
select * from test_xyz3() ; -- compiling error
-- -- 

(I am not a member of the pg-developer mailinglist. )

Franz

Re: type bug?

[ml]

On Wed, 2021-10-06 at 00:21 -0500, Ron wrote:
> 
> What version of Postgresql do you think has the bug?
> Where did you get the Postgresql binaries from?
> What platform?
FreeBSD
pkg install postgresql ...
Version 13.3

a friend use Debian unstable with PG version 14 and have the same
problem.

> 
> On 10/5/21 10:50 PM, m...@ft-c.de wrote:
> > Hello,
> > 
> > there is a bug with types in functions. Here is an example:
> > 
> > --drop type  xyz;
> > create type xyz as ( x numeric,  y numeric,  z numeric );
> > 
> > --drop table  test_xyz ;
> > create table test_xyz (  a int,  b xyz, c xyz );
> > insert into  test_xyz values
> > ( 1,(11.1, 12.3, 14.5 ), (22.2, 22.3, 24.5 ) ) ;
> > 
> > --drop  function test_xyz() ;
> > create function test_xyz() returns table ( a xyz, b xyz)  as
> > $$
> >   select b, c from test_xyz ;
> > $$ language sql ;
> > 
> > --drop   function test_xyz2() ;
> > create function test_xyz2() returns table ( b xyz)  as
> > $$
> >   select  b from test_xyz  ;
> > $$ language sql ;
> > 
> > --drop   function test_xyz3() ;
> > create function test_xyz3() returns table ( b xyz)  as
> > $$
> > declare
> >    bb xyz;
> >    cc xyz;
> > begin
> >    select b, c into bb, cc from test_xyz ;
> >    return bb ;
> > end;
> > $$ language plpgsql ;
> > -- --
> > select * from test_xyz() ;
> > select * from test_xyz2() ; -- 3 columns, but 1 should be correct?
> > select b from test_xyz2() ; -- error
> > select x from test_xyz2() ; -- never declared column
> > select * from test_xyz3() ; -- compiling error
> > -- --
> > 
> > (I am not a member of the pg-developer mailinglist. )
> > 
> > Franz
> > 
> > 
> > 
>