For (unit) testing, I have often had the need to override the current
timestamp in the database system. For example, a column default,
function, or views would make use of the current timestamp in some way,
and to test the behavior, it's sometimes useful to tweak the current
What might be a good way to do that?
Just overwrite xactStartTimestamp? Is that safe? If it weren't static,
a user-loaded function could do it.
Overwrite pg_catalog.now() in the test database?
Some semi-official support for this sort of thing would be good.
pgsql-hackers by date
|Next:||From: Peter Geoghegan||Date: 2012-02-23 11:09:18|
|Subject: Re: pg_stat_statements normalization: re-review|
|Previous:||From: Kyotaro HORIGUCHI||Date: 2012-02-23 10:14:03|
|Subject: Re: Speed dblink using alternate libpq tuple storage|