You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a legacy database table without a primary key.
Firebird is using RDB$DB_KEY as alternative internal primary key.
I tried to model it in Django.
But when I execute a SELECT statement, I receive following error message: ('Error while preparing SQL statement:\n- SQLCODE: -206\n- Dynamic SQL Error\n- SQL error code = -206\n- Column unknown\n- testtable.RDB$DB_KEY\n- At line 1, column 18', -206, 335544569)
I've tried it with Django 2.2, but got the same error message.
myappmodels.py
from django.db import models
# Create your models here.
class MyModel(models.Model):
db_key = models.CharField(primary_key=True, db_column='rdb$db_key', max_length=10)
test_field= models.CharField(max_length=15, blank=True, null=True)
class Meta:
managed = False
db_table = 'testtable'
Version
Django: 3.2
django-firebird: 2.2.1
django-utils-six 2.0
fdb 2.0.2
$ python -V
Python 3.9.15
The SELECT statement with via fdb package works perfectly.
The text was updated successfully, but these errors were encountered:
I have a legacy database table without a primary key.
Firebird is using
RDB$DB_KEY
as alternative internal primary key.I tried to model it in Django.
But when I execute a SELECT statement, I receive following error message:
('Error while preparing SQL statement:\n- SQLCODE: -206\n- Dynamic SQL Error\n- SQL error code = -206\n- Column unknown\n- testtable.RDB$DB_KEY\n- At line 1, column 18', -206, 335544569)
I've tried it with
Django 2.2
, but got the same error message.myappmodels.py
Version
Django: 3.2
django-firebird: 2.2.1
django-utils-six 2.0
fdb 2.0.2
The SELECT statement with via
fdb
package works perfectly.The text was updated successfully, but these errors were encountered: