Forum OpenACS Q&A: What mean his messages?

Collapse
1: What mean his messages?
Posted by Dayra Munoz on 03/15/02 06:50 PM
Hi firends:

I have OpenACS 4.0 with AOLServer 3.2 and PostgreSQL 7.3.1. over
Linux 7.2.

When i use acs__add_user( ...) function for create account in OpenACS
(from promt to database), these messages apears.. but whea i test the
account for registered, it worked succesfull (of course, OpenACS said
that reseat the password but it is normal)

Have i to worry me for these messages?

psql:crear.sql:1: NOTICE:
identifier "acs_object__initialize_attributes" will be truncated
to "acs_object__initialize_attribut"
psql:crear.sql:1: NOTICE:  Adding missing FROM-clause entry for
table "acs_object_id_seq"
psql:crear.sql:1: NOTICE:
identifier "acs_object_type_get_tree_sortkey" will be truncated
to "acs_object_type_get_tree_sortke"
psql:crear.sql:1: NOTICE:
identifier "acs_object_type_get_tree_sortkey" will be truncated
to "acs_object_type_get_tree_sortke"
psql:crear.sql:1: NOTICE:
identifier "acs_permission__grant_permission" will be truncated
to "acs_permission__grant_permissio"
psql:crear.sql:1: NOTICE:
identifier "acs_permission__grant_permission" will be truncated
to "acs_permission__grant_permissio"
acs__add_user
---------------
          2667
(1 row)

Collapse
2: Response to What mean his messages? (response to 1)
Posted by Don Baccus on 03/15/02 08:24 PM
Postgres is telling you two things:

1. Some of the identifiers are longer than 32 characters so they're truncated.  We use the long names for readability and you can ignore these NOTICEs.

2. Postgres doesn't require the FROM clause in select queries, but issues a NOTICE when we make use of the feature because it is not standard SQL.  You can ignore this NOTICE, too.