(05-21-05) postgresql
(05-21-05) postgresql
(05-21-05) postgresql
- If one table has a serial field, it's associated with a sequence. This sequence has a name started with the schema. i.e.
mm_45.edge_cor_vector_edge_id_seq. But if you change the schema's name to something else, likemm_44, the schema namemm_45in the sequence is not changed. When you submit entries to that table, it saysERROR: schema "mm_45" does not exist. BE CAREFUL. So either don't submit data to that table anymore or reload that table again.
Yu Huang 2006-03-25