#28 INSERT fails unless all columns are specified

open
nobody
None
5
2004-05-12
2004-05-12
Anonymous
No

Unable to specify a subset of a tables columns when
executing an insert. For instance, if a table T has
columns a, b, and c, the following will fail:
insert into T (a,b) values ('1','2')

The error message mentions the missing column (c, in
this example) as not being named.

Discussion

  • Logged In: YES
    user_id=118443

    Still true with the current version (Python 2.4. on Linux).