Re: duplicating records

2004-02-17 Thread Jeremy March
> I tried this and doesn't work unforunately. I get "ERROR: Duplicate > entry..." that occurs when copying from the temporary table back into > the original table. > Is there a way to do this, to copy a single record, without moving the > primary key into the temporary table so I can avoid this

Re: duplicating records

2004-02-17 Thread Ari Denison
I tried this and doesn't work unforunately. I get "ERROR: Duplicate entry..." that occurs when copying from the temporary table back into the original table. Is there a way to do this, to copy a single record, without moving the primary key into the temporary table so I can avoid this error? Ar

Re: duplicating records

2004-02-17 Thread Sasha Pachev
Ari Denison wrote: I have a need to duplicate individual records in a table with a large number of fields. This is not part of a backup or restore process. I simply need to be able to duplicate a record or two on occasion. Is there an efficient way to do this? I obviously don't want to duplic