Forum OpenACS Development: Response to OIDs optional in current Postgres - whose idea was it to use them for email confirmation anyway...

Collapse
5: Response to OIDs optional in current Postgres - whose idea was it to use them for email confirmation anyway... (response to 1)
Posted by Mark Aufflick on 06/15/02 03:32 PM
Are you using Oracle or Postgres? Under Postgres, you don't get OIDs on views (whereas under Oracle you do get rowid on views) so how did you handle this?

I modified cc_users to have a column "u.oid as ora_rowid" and modified the query to look at ora_rowid.