Any suggestions for architecture/implemenation in the following situation:?
- insert a new row
- primary key is an autoinc / sequence column
- no other column is sure to be unique
- need to continue working with the data of the row
after the insert and possibly do an update
Barry Lind wrote:
> Hanasaki,
>
> The driver is already 3.0 compliant for that. It correctly returns
> false to DatabaseMetaData.supportsGetGeneratedKeys() indicating that
> postgresql does not support this functionality. This isn't likely to
> change unless some significant new functionality is introduced in the
> server to do this. There isn't really anything the driver can do here
> since the functionality doesn't exist in the database to automatically
> return this information.
>
> thanks,
> --Barry
>