From: | "Johnny Jørgensen" <johnny(at)halfahead(dot)dk> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | last OID and connections? |
Date: | 2001-10-17 13:27:17 |
Message-ID: | 200110171527170784.01357C60@mail.halfahead.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
Once I get a current project to production state, I'm going to get a heap of users performing updates simultaneously through the same update.php, and that raises a few questions:
1. will pg_getlastoid() return the last oid inserted *by this user*, *on this page*, *on this connection*, or is there a possibility for them to get mixed up, because the database gets a connection from the same user (php), and reuses connections or something?
e.g. If a user changes his profile, and an administrator changes some other row at the same time?
2. I find oid's pretty clever, but are they good for unique keys? It seems, foreign key constraints won't use oid's in the current release, should i use serials instead?
thanks,
Mvh,
Johnny Jørgensen
johnny(at)halfahead(dot)dk
+45 6315 7328
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2001-10-17 15:51:39 | Re: last OID and connections? |
Previous Message | Alessandro Ferrarin | 2001-10-17 09:08:32 | Re: Retrieving a list of tables |