Hi, I tried to use dynamic table names. But the problem is, that I have an refresh of 1 minute, but want to change the table once per day. I use these option keys:
sql_table: tcom_v5_%Y%m%d sql_table_version: 5 sql_table_schema: /etc/pmacct/tcom_v5_Ymd.sql sql_refresh_time: 60 sql_history: 1m sql_history_roundoff: m sql_dont_try_update: true 1. I always get the error: pmacctd[12236]: ERROR ( all/pgsql ): ERROR: relation "tcom_v5_20060502" already exists So I have to do this with an cronjob? 2. as the INSERT date is used for the % variables, the last minute of a day would get inserted in the table of the next day, right? Cheers, Sven -- Sven Anderson Institute for Informatics - http://www.ifi.informatik.uni-goettingen.de Georg-August-Universitaet Goettingen Lotzestr. 16-18, 37083 Goettingen, Germany _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
