Adam Witney wrote: > > Something strange has just appeared in my database, can anyone explain this > duplication of columns: > > test=# \d plate_reporter > Table "plate_reporter" > Column | Type | Modifiers > -------------------+---------+-------------------------------------------- > plate_reporter_id | integer | not null, > plate_reporter_id | integer | not null, > plate_id | integer | not null > plate_id | integer | not null > well_address | text | not null > well_address | text | not null > reporter_id | integer | not null > reporter_id | integer | not null > dilution_factor | text | > dilution_factor | text |
What version of PostgreSQL are you using? Old versions could get duplicates in some system tables. Do you have a two row for 'plate_reporter' in pg_class? -- Bruce Momjian | http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
