Re: database schemas support for postgresql psycopg2
On May 29, 2009, at 8:25 PM, david.schruth wrote: > > Hello, > > I'm trying to get this working for multiple (non public) schemas in > postgresql databases using the psycopg2 database driver. I'm using > the most current svn of django 1.01 (from today). > > ... > Does anybody have a solution for using django with more than one > schema in postgresql? I don't use the django ORM, but running the postgres command 'set search_path = some_schema,public' works for me. This sets the schema search path only for the connection on which the command is run. Jack --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
database schemas support for postgresql psycopg2
Hello, I'm trying to get this working for multiple (non public) schemas in postgresql databases using the psycopg2 database driver. I'm using the most current svn of django 1.01 (from today). I've tried both of the following two methods neither of which seem to work: db_schema = 'whatever' # in a model: http://code.djangoproject.com/ticket/6148 DATABASE_SCHEMAS # in settings.py http://code.djangoproject.com/ticket/1051 I was under the impression from these tickets that these changes have been incorporated into the current svn but when I grep for the word "[^ \/]schema[^^\/]" i get no hits to files in the db/backends/postgres* There has already been a post to this list about this problem. http://groups.google.com/group/django-users/browse_thread/thread/9d31ccc7b2f09eb7/654ebe349520ac02 Does anybody have a solution for using django with more than one schema in postgresql? Dave --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
