Opened 17 years ago
Closed 17 years ago
#7748 closed (invalid)
inspectdb on PostgreSQL database missing type for 'real' column
| Reported by: | Owned by: | nobody | |
|---|---|---|---|
| Component: | django-admin.py inspectdb | Version: | dev |
| Severity: | Keywords: | ||
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
I have several columns of type 'real' in a legacy database. 'inspectdb' is not detecting their type correctly. psycopg2's introspection.py maps type 701 to FloatField, but these columns appear to be type 700.
Database is PostgreSQL 8.2 on Win32, using current SVN copy of Django, connecting with psycopg2.
Attachments (1)
Change History (2)
by , 17 years ago
| Attachment: | inspectdb.diff added |
|---|
comment:1 by , 17 years ago
| Resolution: | → invalid |
|---|---|
| Status: | new → closed |
It seems that the PostgreSQL backend maps FloatField to the "double precision" type, so mapping a "real" (single precision) isn't really correct here.
Note:
See TracTickets
for help on using tickets.
map type 700 to FloatField