Re: Postgres on QNX

>> In particular, i have NUMERIC test failing with same 'ERROR: cannot
>> create unique index. Table contains noon-unique values'. Also CREATE
>> VIEW fails with 'cannot insert a duplicate key into unique index
>> pg_rewrite_rulename_index'

Hm.  Is this with current Postgres sources (7.1 or later)?

I had always assumed that the bizarre behavior in the QNX port was
caused by our old not-too-portable function call interface.  But if
you're seeing it with 7.1 or later then that theory is wrong ---
the new-style call interface doesn't use any unprototyped function
calls, so it adheres to all ANSI C rules.

At this point it seems that we must be dealing with either a compiler
bug (which compiler are you using?) or some so-far-unrecognized
portability mistake in the Postgres code.  If it's the latter then
I'd like to find and fix it.  Can you dig into it with a debugger and
try to determine where the code goes wrong?  The CREATE VIEW case would
probably be easier to analyze than the numeric index creation.

            regards, tom lane