Open timwis opened 7 years ago
Another thing to keep in mind is that once we add the concept of "linked tables" (foreign key columns), we'll need the foreign table to have a primary key. So we may not be able to get around having primary keys in dataface after all.
@begriffs suggested that perhaps we can use the
ctid
value of a row to make changes to it, obviating the need for a primary key to be set.For example:
/foo?select=*,cid
/foo?ctid=eq.(0,3)
The nice thing about this is that end-users wouldn't need to know what primary keys are. Are there trade offs? If you're using it against a table that does have a primary key field(s), it should still work, I imagine...