-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bastian Voigt a écrit :
> I did some further investigation on this one, and this is what I found out:
> 
> It seems that the scripts (11_create_addobj and 12_exec_addobj) generate
> bad return values, even though they executed successfully. When I leave
> out the "or die" in my perl script, both scripts are executed fine.
> 
> Any explanation for this behaviour?
> 
> 
> Cheers
> Bastian
> 
> 
> Am 04.05.2009 um 11:05 schrieb Bastian Voigt:
> 
>> Hi *,
>>
>> in my database I have one very large table wich is partioned using
>> PG's inheritance feature. To maintain this table, I have a cron script
>> that runs every month, creates a new table and modifies the insert
>> trigger. Now that my DB is being upgraded to a slony master-slave
>> setup I need to modify this monthly script, so that it adds the newly
>> created table to the repliation set.
>>
>> I tried to do this from perl:
>>
>> system("/opt/slony1-ctl/slony-ctl/outils/11_create_addobj.sh -c
>> vesseltracker -s 1 -f $filename") or die $!;
>> exec("/opt/slony1-ctl/slony-ctl/outils/12_exec_addobj.sh -c
>> vesseltracker -s 1") or die $!;
>>
>> The first script works, the second one gives me an error:
>>
>> "Inappropriate ioctl for device at /scripts/trackingtables.pl line 124"
>>
>> Any idea where that might come from?
>>

Hi,

I did some improvments in return codes in suscripts. Hope it may have solved
this problem. Just let me know.

These improvments may be found in version 1.1.3 package :
http://pgfoundry.org/frs/download.php/2250/slony1-ctl-1.1.3.tar.gz

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

iD8DBQFKJUVLA+REPKWGI0ERAgd6AJ9dE+4nnSRX/g+CNqZZYf+nZRJ7cwCfb8/p
4BwK1AnvTkZPYeK2wAG/f7g=
=lLIj
-----END PGP SIGNATURE-----