"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> writes:
> This means that a table with a timestamp column defaulted to now() and a
> unique constraint on that column will have a very high chance of
> constraint violations. This might happen when reading in values from a
> script, and it works fine on Linux.
Any application that assumes it will get unique results from now() is
broken by definition. The fact that it manages not to fail on some
platforms doesn't make it less broken.
regards, tom lane