[GENERAL] Error code when trying to insert non-unique value

Hello, How can I check if the error that has occurred during an insert is because the inserted value is not unique when there are a unique error. I'm using PHP. Thanks in advance, Jonas Bengtsson ---(end of broadcast)--- TIP 5: Have you ch

RE: Re: [GENERAL] OID as Primary Key

2 March 2001 16:36 >> To: [EMAIL PROTECTED] >> Subject: Re: Re: [GENERAL] OID as Primary Key >> >> >> --- Jonas Bengtsson <[EMAIL PROTECTED]> wrote: >> > Can't you do a dump with the oid's? >> >> Yes, but I would never suggest i

Re: Re: [GENERAL] OID as Primary Key

Can't you do a dump with the oid's? But when I want to know the primary key of the inserted row I have to do an extra select query. If I use oid I just use pg_getlastoid() in php. And it is redundant data to store another integer. Comments? /Jonas B > Jonas Bengtsson <

[GENERAL] OID as Primary Key

wrong? Is it to prefer to use oid as PK? Or should I use SERIAL instead? I thought it might be more efficient to use oid and a waste of space to add another integer as PK. Thanks in advance, Jonas Bengtsson ---(end of broadcast)--- TIP 1: sub