[support] Drupal 6.2 / PostgreSQL 8.2 installation failure

[Jesper K. Pedersen]

Trying to install a fresh clean Drupal version 6.2 on my webserver ended
up with these error messages :

Drupal installation complete
------------------------------
warning: pg_query() [function.pg-query]: Query failed: ERROR: column "uid"
does not exist LINE 1: SELECT * FROM users u WHERE uid = 1 ^ in
/www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138.
user warning: query: SELECT * FROM users u WHERE uid = 1 in
/www_root/drupal.famped.dk/modules/user/user.module on line 167.
warning: pg_query() [function.pg-query]: Query failed: ERROR: column "uid"
does not exist LINE 1: SELECT * FROM users WHERE uid = 1 ^ in
/www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138.
user warning: query: SELECT * FROM users WHERE uid = 1 in
/www_root/drupal.famped.dk/modules/user/user.module on line 527.
warning: pg_query() [function.pg-query]: Query failed: ERROR: column
"name" of relation "users" does not exist LINE 1: INSERT INTO users (name,
mail, pass, init, status, created) ... ^ in
/www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138.
user warning: query: INSERT INTO users (name, mail, pass, init, status,
created) VALUES ('jkp', 'jesper at famped.dk',
'cb32154ec178b88cb055c4b8f50aeaae', 'jesper at famped.dk', 1, 1207916857) in
/www_root/drupal.famped.dk/modules/user/user.module on line 325.
warning: pg_query() [function.pg-query]: Query failed: ERROR: column
"name" does not exist LINE 1: SELECT * FROM users u WHERE LOWER(name) =
LOWER('jkp') AND p... ^ in
/www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138.
user warning: query: SELECT * FROM users u WHERE LOWER(name) =
LOWER('jkp') AND pass = 'cb32154ec178b88cb055c4b8f50aeaae' AND status = 1
in /www_root/drupal.famped.dk/modules/user/user.module on line 167.
---------

When checking my PostgreSQL backend I can see the problem.
The "users" table do not contain the columns "uid", "name" and "pass" but
have the following definition :

                                   Table "public.users"
   Column    |         Type          |                     Modifiers
-------------+-----------------------+----------------------------------------------------
 id          | integer               | not null default
nextval('users_id_seq'::regclass)
 user_name   | character varying(25) | not null
 user_passwd | character varying(25) | not null
Indexes:
    "users_pkey" PRIMARY KEY, btree (id)


Any ideas of what the problem is?

Thanks
  Jesper K. Pedersen