Alex Lau <[EMAIL PROTECTED]> writes: > CREATE TABLE mytesting ( dosnotmatter text ); > CREATE INDEX myunique ON mytesting oid;
> will this help to make sure the oid is unique? No, but CREATE UNIQUE INDEX myunique ON mytesting (oid); would do the trick. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html