"wangshj" <[EMAIL PROTECTED]> wrote > > oidtest=# COPY oidtest (name) WITH OIDS FROM stdin; > Enter data to be copied followed by a newline. > End with a backslash and a period on a line by itself. >>> 54513 copyname >>> \. > oidtest=# INSERT INTO oidtest ( name ) VALUES( 'name2' ) ; > INSERT 54513 1 > oidtest=# SELECT oid,name from oidtest ; > oid | name > -------+---------- > 54512 | name1 > 54513 | copyname > 54513 | name2 > (3 rows) > > oidtest=# > Then I got two records with same oid(54513). >
This is not a bug. You can specify any valid number here as Oids. If you don't want duplicated Oids or strange Oids, then don't specify WITH OIDS clause. Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
