Opened 10 years ago

Closed 8 years ago

Last modified 8 years ago

#77 closed enhancement (wontfix)

The PostgreSQL code should use schemas instead of prefixes for namespaces.

Reported by: RahmCoff@… Owned by: adrian
Component: Database layer (models, ORM) Version:
Severity: minor Keywords:
Cc: Triage Stage: Ready for checkin
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:

Description

Rather than append App_ before every table in PostgreSQL, you should use Schemas http://www.postgresql.org/docs/8.0/static/ddl-schemas.html. That's what they're there for, and it makes the database much more readable.

Change History (6)

comment:1 Changed 10 years ago by adrian

  • Resolution set to wontfix
  • Status changed from new to closed

This isn't a big enough problem to merit the special-casing of PostgreSQL. We've used the current method for a couple of years and haven't had any problems.

comment:2 Changed 8 years ago by j.states@…

  • priority changed from normal to high
  • Resolution wontfix deleted
  • Severity changed from normal to major
  • Status changed from closed to reopened
  • Type changed from defect to enhancement

Both PostgreSQL and Oracle support schemas, it should also be supported by django. I want to use this application but can not in it's current form.

comment:3 Changed 8 years ago by adrian

  • priority changed from high to normal
  • Severity changed from major to normal

Please provide an implementation if you'd like to see this feature in Django.

comment:4 Changed 8 years ago by Oliver Beattie <oliver@…>

  • priority changed from normal to lowest
  • Severity changed from normal to minor

comment:5 Changed 8 years ago by SmileyChris

  • Triage Stage changed from Unreviewed to Accepted

Adrian has asked for a patch, will YOU be the one that writes it? ;)

comment:6 Changed 8 years ago by jacob

  • Resolution set to wontfix
  • Status changed from reopened to closed
  • Triage Stage changed from Accepted to Design decision needed

Using schemas for each app would make little sense as you'd just end up with a bunch of schemas. Optional support for schemas -- a la #1051 -- is a much better idea.

Note: See TracTickets for help on using tickets.
Back to Top