Ed Loehr <[EMAIL PROTECTED]> writes: > Maybe someone can confirm what looks like a long-name-truncation bug in > 7.0.0? I see no bug here; it told you what name it planned to use for the sequence: > psql:/home/ed/pgbug:8: NOTICE: CREATE TABLE will create implicit > sequence 'process_state_subscripti_id_seq' for SERIAL column > 'process_state_subscription.id' so this is not surprising: > DROP SEQUENCE process_state_subscription_id_seq; > psql:/home/ed/pgbug:10: NOTICE: identifier > "process_state_subscription_id_seq" will be truncated to > "process_state_subscription_id_s" > psql:/home/ed/pgbug:10: ERROR: Relation > 'process_state_subscription_id_s' does not exist It's not a bug that the sequence name is formed with a rule more complex than "truncate table_field_seq at the right" ... if we did that, you'd have a problem with sequences for tables with names longer than 32 characters ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster