[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