[pkg-bacula-devel] Bug#1114916: bacula-director-pgsql: make_postgresql_tables script fails due to bad shell quoting

[Dmitry Afanasiev]

Package: bacula-director-pgsql
Version: 15.0.3-3
Severity: normal

Dear Maintainer,

A problem, which is described in bug 1108272, also exists in the make_postgresql_tables file.
This script also contains unquoted $$ in here doc text on lines 77 and 89.

Here is the required patch for this file:
--- make_postgresql_tables.orig 2025-09-11 17:06:24.531200577 +0300
+++ make_postgresql_tables      2025-09-11 16:52:31.106404596 +0300
@@ -74,7 +74,7 @@
 
 -- Need to add postgresql-contrib to the dependency list
 
-do $$
+do \$\$
 declare
   selected_ext pg_extension%rowtype;
 begin  
@@ -86,7 +86,7 @@
   if not found then
      CREATE EXTENSION pg_trgm;
   end if;
-end $$;
+end \$\$;
 
 CREATE INDEX meta_emailowner on MetaEmail (EmailTenant, EmailOwner);
 CREATE INDEX meta_emailtime on MetaEmail (EmailTime);

-- System Information:
Debian Release: 13.1
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 6.12.43+deb13-amd64 (SMP w/4 CPU threads; PREEMPT)
Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages bacula-director-pgsql depends on:
ii  bacula-common-pgsql                       15.0.3-3
ii  dbconfig-pgsql                            2.0.25
ii  debconf [debconf-2.0]                     1.5.91
ii  postgresql-client                         17+278
ii  postgresql-client-17 [postgresql-client]  17.6-0+deb13u1

Versions of packages bacula-director-pgsql recommends:
ii  postgresql  17+278

Versions of packages bacula-director-pgsql suggests:
pn  gawk  <none>

-- debconf information excluded