Confused and needing help on error: "access" has no primary key

[Curt Hesher]

DBI users,

            I’ve recently taken on a project of moving a large Perl based
application from one server to another.  In the process of setting things up
I’ve come across this error message which I do not know how to handle.  Over
the last 48 hours I’ve checked the mail list archive at google, checked the
search engines (google, yahoo, live), read some docs (perldoc DBI, perldoc
DBI::Pg), and couldn’t get the FAQ to load.  If someone could shed some
light on this matter I would greatly appreciate it.

 

The error message (found in the Apache web server error_log file) is:

 

index.cgi: "access" has no primary key at
/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Loader/Generic.pm line 166

 

This seems odd since the table “access” does have a primary key as evidenced
by the following PostgreSQL psql command:

 

 

 

mydb=> \d access

                                            Table "public.access"

         Column          |            Type             |
Modifiers                      

-------------------------+-----------------------------+--------------------
---------------------------------

 id                      | integer                     | not null default
nextval('access_id_seq'::regclass)

 login_attempt_id        | integer                     | not null

 access_time             | timestamp without time zone | 

 http_user_agent_type_id | integer                     | not null

 ip                      | inet                        | 

 url                     | character varying           | 

Indexes:

    "access_pkey" PRIMARY KEY, btree (id)

Foreign-key constraints:

    "$1" FOREIGN KEY (login_attempt_id) REFERENCES login_attempt(id)

"$2" FOREIGN KEY (http_user_agent_type_id) REFERENCES
http_user_agent_type(id)

 

 

 

Some details about the system that I’m running on are:

 

        # psql --version

psql (PostgreSQL) 8.1.8

contains support for command-line editing

 

 

# perldoc perllocal

Thu Apr 12 09:58:38 2007: "Module" DBI

 

       ·   "installed into: /usr/lib/perl5/site_perl/5.8.8"

 

       ·   "LINKTYPE: dynamic"

 

       ·   "VERSION: 1.54"

 

       ·   "EXE_FILES: dbiproxy dbiprof"

 

 

# perldoc perllocal

Thu Apr 12 12:18:50 2007: "Module" DBD::Pg

 

       ·   "installed into: /usr/lib/perl5/site_perl/5.8.8"

 

       ·   "LINKTYPE: dynamic"

 

       ·   "VERSION: 1.49"

 

       ·   "EXE_FILES: "

 

 

Thank you for your time.