Ross Johnson wrote:
That (the first column restriction) must be a limitation in the sdbc driver.
It certainly looks a bit like a bug. > I haven't found this problem with the JDBC driver from
PostgreSQL.org.
Ok.
It may be that the sdbc driver is still relying on the fact that earlier PostgreSQL releases automatically included an OID column in every table (usually the first column from memory) -
The table already had the OID before. I recreated the table with oid earlier just to be able to use pgAdmin to insert rows. pgAdmin also needs a way to identify rows, but if there is no regular primary key, it is happy with the OID.
> which provided the unique index
that the primary key is now required to provide in order for updates to work.
Knowing these limitations - wheather they are bugs or features - working with Base turned out to be quite interesting.
Cheers! GG --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
