Seems like you would be a lot better off enforcing this with a unique
index on (submitter_id, date_trunc('month',entry_timestamp)). The above
not only doesn't provide any feedback, it's got serious race-condition
problems.
Unfortunately, it didn't work.CREATE UNIQUE INDEX one_entry_per_submitter_per_month ON table_entry (submitter_id , date_trunc('month',entry_timestamp));
runs into ERROR: functions in index expression must be marked IMMUTABLE.If I'm reading this correctly, date_trunc is not IMMUTABLE and thus not usable in an index.
Dominic Jones, Ph.D. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
