SCM

[#1011337] Insert into table with primary key only.

View Trackers | Bugs | Download .csv | Monitor

Date:
2013-05-27 17:39
Priority:
3
State:
Open
Submitted by:
Francisco Figueiredo jr. (fxjr)
Assigned to:
Nobody (None)
Npgsql Version:
None
Category:
None
Group:
None
Resolution:
None
Summary:
Insert into table with primary key only.

Detailed description

From: https://github.com/franciscojunior/Npgsql2/issues/20
github user: maxbundchen

Using EF the Npgsql generates an invalid insert command when the table have only one column and this column is the primary key with auto-generation:

{create table Participant ( id serial, primary key(id) );}

The correct insert statement is:

insert into Participant values (default)

But the generated statement is:

insert into Participant() values()

This statement is not a valid PostgreSQL command.

Followup

No Followups Have Been Posted

Attached Files:

Changes:

No Changes Have Been Made to This Item

Powered By FusionForge