"Stéphane A. Schildknecht" stephane.schildknecht at postgresqlfr.org
Fri Apr 24 05:01:26 PDT 2009
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bastian Voigt a écrit :
> Hi *,
> 
> I tried to execute the following sql script using 42_exec_exec:
> 
> ----------------------
> ALTER TABLE aisclient ADD COLUMN date_sent_offlinemail timestamp without
> time zone;
> ALTER TABLE aisclient ADD COLUMN emails character varying(128);
> -----------------------
> 
> This is what I got:
> 
> 13:07:16 db02 outils # ./42_exec_exec.sh -c vesseltracker -s 1 -f
> /opt/slony1-ctl/slony-ctl/outils/aisclient.sql
> Executing /opt/slony1-ctl/slony-ctl/outils/aisclient.sql on set 1
> (replication vesseltracker)...
> An error occured.
> See /opt/slony1-ctl/slony-ctl/logs/vesseltracker_1_exec.log for details.
> 
> 13:05:50 db02 outils # less
> /opt/slony1-ctl/slony-ctl/logs/vesseltracker_1_exec.log
> /opt/slony1-ctl/slony-ctl/outils/slony_execute.sh: line 113:
> preamb_miss: command not found
> 
> 
> Cheers
> Bastian

Once again, corrected and commited.

Thanks for your tests.

Index: outils/slony_execute.sh
===================================================================
RCS file: /cvsroot/slony1-ctl/slony-ctl/outils/slony_execute.sh,v
retrieving revision 1.2
diff -r1.2 slony_execute.sh
113c113
< preamb_miss
- ---
> preamble_miss $INSTANCE

Best regards,
- --
Stéphane Schildknecht
PostgreSQLFr - http://www.postgresql.fr

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ8aoWA+REPKWGI0ERAk3BAJ915QG51yMYAkbWB+ENSaU0e8AmNgCaAyAF
DSaKZz6faG5Ttmx8rZsobxA=
=kNM9
-----END PGP SIGNATURE-----


More information about the Slony1-general mailing list