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?
>
>
>
> Kind regards
> Bastian
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>