REFERENCES this_table ( oid )

See the ERROR and comments below...

create table photos (
filename varchar[128] not null,
filesize int default null,
width int default null,
height int default null,
origPhoto oid default null references photos ( oid ),
altDesc varchar[128] default null
);

psql:sid-sql:40: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
psql:sid-sql:40: ERROR: UNIQUE constraint matching given keys for referenced table "photos" not found

Am I not supposed to have self referencing 'reference' values? Or is the
oid field invisible to this function? (Maybe because the table has yet to
be created?) I don't see any reason why I shouldn't be able to make a
self-referencing ref.

I would try creating the table first, then altering the field later - but
you still can't 'alter column' that way. Should I just forget about using
the 'references' keyword?

--
Marques Johansson
postgresql(at)displague(dot)com

You may my glories and my state dispose,
But not my griefs; still am I king of those.
-- William Shakespeare, "Richard II"