[rt-users] 4.0.1RC2 upgrade errors from 3.8.7

John D Groenveld jdg117 at elvis.arl.psu.edu
Thu Jun 16 21:39:35 EDT 2011


In message <20110617011915.GL912 at 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
groenveld at 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





More information about the rt-users mailing list