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