Can't add new record with a null in a field linking to another table

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Try to add a record to a table where a field links to another table, but 
leave that field null (there's no data to select from in the other table yet!)
2. Get the following error message when you submit the new record form:

Unable to add that record. Check the data conforms to the schema.
The error was: org.postgresql.util.PSQLException: ERROR: relation "people" does 
not exist. You may be trying to add a row to the table using a value from a 
foreign key. Though you can view foreign relations, table additions using them 
is currently not supported.

3.

What is the expected output? What do you see instead?
Nulls in linked fields should be allowed (assuming that the database schema 
doesn't dictate otherwise).

Please use labels and text to provide additional information.
Using Chrome Dev 0.10.beta - 3449

Original issue reported on code.google.com by jajwil...@gmail.com on 30 Jul 2014 at 1:31

[GoogleCodeExporter]

Just tried this again with a different table and db structure. Got the error: 
Unable to add that record. Check the data conforms to the schema.
The error was: org.postgresql.util.PSQLException: ERROR: relation 
"contracts_id_seq" does not exist Position: 15. You may be trying to add a row 
to the table using a value from a foreign key. Though you can view foreign 
relations, table additions using them is currently not supported.

This is slightly strange in that there is nothing in my database called 
'contracts_id_seq'. Maybe this is something internal to the ORDS?

Original comment by jajwil...@gmail.com on 30 Jul 2014 at 1:39

[GoogleCodeExporter]

This should now be fixed, wait until Jenkins has rebuilt and give it a go.

Original comment by marxjohn...@gmail.com on 30 Jul 2014 at 1:44

• Changed state: Fixed

[GoogleCodeExporter]

Yes - working now thanks!

Original comment by jajwil...@gmail.com on 30 Jul 2014 at 1:51