Re: UserProfile Pattern (extending User model); Migrations; New fields/columns on models.

Hello,

did you run manage.py migrate?

When you add a ForeignKey or OneToOne to a model, what actually gets stored in the DB is the ID of the referenced object (in this case, a auth.models.User). So the user_id column should be created for you during the next makemigrations+migrate combo.

On a side note, giving a plural name to your models is bad practise, especially if you use the builtin admin site.

Best,
Gergely

On May 23, 2016 18:42, "McKinley" <seansmckinley@gmail.com> wrote:

I have a Users table inside of a postgresql database in which auth_user also lives. I want the Users objects to have a OneToOne to the auth_user model. I added a line to my models.py under my Users class:

user = models.OneToOneField(User, unique=True)

There are probably other things wrong, because at this point my basic template returns this traceback:

Exception Type: ProgrammingError at /scripts/users/

Exception Value: column users.user_id does not exist

LINE 1: SELECT "users"."id", "users"."user_id", "users"."email", "us..

 I know my Users table doesn't have the user_id column. I do not know how to add it. Do Django users prefer to write a migration for this? Migrations themselves are not detecting any changes per app at all so I am completely flummoxed on how to add this column properly. I was going to manually do it in postgres, but I didn't know how to make it conform to the corresponding field in auth_user. Thank you for your help.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/3e89ccba-dcb9-42ef-b084-c6cc4b7d6891%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CACczBULk4THu13xFBfP2je0XDBPgMCe-aBXjNxna%3DYkaf0Q_ZQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.