Re: Triggers do not fire

Reiner Dassing <dassing@wettzell.ifag.de> writes:
> I have a table which has a lot of entries (some x millions) of the kind
> (id, timestamp, value)
> The access (selects) is concentrated to the timely last some thousands
> entries. 
> To adapt this fact I want to setup a "virtual" table - test in my
> example - which
> is accessed by the clients but in reality the entries are separated to
> different small
> tables. These table are dynamically created to hold the values
> distinguished by years.

Why bother?  Seems like you are just making life complicated for
yourself.  One big table with a suitable index ought to work fine.
        regards, tom lane