On 04/22/2013 03:15 PM, Jamie Wilkinson wrote:
I suppose postgres has restricted what a timestamp can be since this
was created. However that doesn't make sense to make the insertion
date default to the year 0000.
"stamp_inserted timestamp without time zone NOT NULL DEFAULT '0000-01-01
00:00:00',"
That line is straight from
/usr/share/doc/pmacct/sql/pmacct-create-table_v7.pgsql in the installed
package.
It's also in the other pmacct-create-table .pgsql files for different
table versions.
I set it to '2001-01-01 00:00:00' for my table creation and postgres
took it without any complaints.
Perhaps now() would be more appropriate? Maybe then, the stamp_inserted
field will default to the time that the record is actually inserted into
the table? I've just started using postgres myself and I'm loving it.
The pmacct package is also extremely useful to me.
Thanks for your time,
-David
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org