2 Possibilities (assuming there is a single record with name == 'Alex' in
the drupal_users table; not counting uid 0)
1. There is a record with username = 'Alex' in the phpbb_users table
2. Username is not UNIQUE within phpbb_users
Write a select statement to extract username from phpbb_user for BOTH these
conditions.
Decide how you want to modify those records so that can be imported into
drupal_users.
David J.
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Alexander Farber
Sent: Wednesday, March 09, 2011 9:21 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Copying data from one table to another - how to
specify fields?
Oh it is called "INSERT INTO", thank you!
I still have a problem though:
# select uid, name, mail, created, access from drupal_users;
uid | name | mail | created | access
-----+------+----------------------------+------------+------------
0 | | | 0 | 0
1 | Alex | Alexander.Farber@gmail.com | 1299512207 | 1299751991
(2 rows)
# INSERT INTO drupal_users (uid, name, mail, created, access) SELECT
user_id, username, user_email, user_regdate, user_lastvisit
FROM phpbb_users
WHERE user_id > 50 and length(username) > 0;
ERROR: duplicate key value violates unique constraint
"drupal_users_name_key"
I don't understand, what is wrong with "name" here and how to find the
troublemaking record in my 4700 lines table
