In message <20110617011915.gl...@jibsheet.com>, Kevin Falcone writes: >Can you show \d on acl and acl_id_seq
When did the sequence for ACL.ID rename from ACL_SEQ to ACL_ID_SEQ? John groenv...@acm.org *** rt4=> \d acl Table "public.acl" Column | Type | Modifiers ---------------+-----------------------------+-------------------- id | bigint | not null principaltype | character varying(25) | not null principalid | bigint | not null rightname | character varying(25) | not null objecttype | character varying(25) | not null objectid | bigint | default 0 creator | integer | not null default 0 created | timestamp without time zone | lastupdatedby | integer | not null default 0 lastupdated | timestamp without time zone | Indexes: "acl_pkey" PRIMARY KEY, btree (id) "acl1" btree (rightname, objecttype, objectid, principaltype, principalid) rt4=> \d acl_id_seq Did not find any relation named "acl_id_seq". rt4=> \d acl_seq Sequence "public.acl_seq" Column | Type | Value ---------------+---------+--------------------- sequence_name | name | acl_seq last_value | bigint | 466 start_value | bigint | 466 increment_by | bigint | 1 max_value | bigint | 9223372036854775807 min_value | bigint | 1 cache_value | bigint | 20 log_cnt | bigint | 1 is_cycled | boolean | f is_called | boolean | f