"Grant Hutchins and Peter Jaros" writes:
> The unaccent(text) function supplied by contrib/unaccent is marked VOLATILE.
> This prevents it from being used in indexes. We believe that the function
> meets the requirements to be marked IMMUTABLE.
No, it most certainly doesn't. It depends on the be
Konstantin Nikiforov writes:
> Expected result: exception will be raised before deletion of rows is
> done.
> Real result: no exception occurs. One of rows is really deleted.
> The trigger is ignored.
I believe this is intentional, though not too well documented. If we
fired statement triggers
Version: postgresql 9.0.1
Step to reproduce: use following code. It creates two tables (parent
"xtest" and inherited "xtest_inh"), creates trigger function, creates
BEFORE INSERT/UPDATE/DELETE trigger.
*
CREATE TABLE xtest (id serial, data varchar, primary key(i
Hi all,
I am a master student on database systems and I'm working on a stress
testing methodology.
The goal is to stress testing PostgreSQL under different workloads.
Thus, I would like to discuss with you some results.
My methodology is based on the increment of two variables: complexity and
wor
The following bug has been logged online:
Bug reference: 5781
Logged by: Grant Hutchins and Peter Jaros
Email address: gr...@pivotallabs.com
PostgreSQL version: 9.0.1
Operating system: Mac OS X 10.6.4
Description:unaccent() function should be marked IMMUTABLE
Details:
