Re: [GENERAL] primary index permits duplicates

this? Logging?               Tom Lane <[EMAIL PROTECTED]> wrote: H Hale <[EMAIL PROTECTED]>writes:> dsuuid is a custom data type for uuids with an external library with comparsion functions.Unless you can reproduce this with a standard dat atype, you shouldprobably file

[GENERAL] primary index permits duplicates

Hello, I am using Postgres 8.0.3 on Fedora Core 4. I may have found a bug in Postgres. I have a table as follows:   Table ".master"   Column  |  Type  | Modifiers --++---  objectid | dsuuid | not null  classid  | dsuuid | not null Indexes:     "master

[GENERAL] binary timestamp conversion

Hello, I have a table column TIMESTAMP (6) WITHOUT TIME ZONE that I am trying to read and write as binary. Postgres is configured to use int64 for timestamps (not double). I found tm2timestamp() in libpgtypes.so that seems to convert struct tm to a Postgres timestamp correctly (at least for the d

Re: [GENERAL] foreign key constraint not being respected with type created by CREATE TYPE

It is likely if the foreign key was in a base table. :) Fairly new with PG and missed this minor but significant detail (keys not inherited) --- Tom Lane <[EMAIL PROTECTED]> wrote: > H Hale <[EMAIL PROTECTED]> writes: > > I have created a new data type using CREATE T

[GENERAL] foreign key constraint not being respected with type created by CREATE TYPE

Hello, I have created a new data type using CREATE TYPE. Foreign keys constaints are not being respected with columns using the new type. As far as I can tell the new type is working correctly except for foreign keys. May be I have missed something when defining the new type. Is there something sp