search

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
536 stars 162 forks source link

The default functionality in create table is not working #48

Open ahsanhadi opened 9 years ago

ahsanhadi commented 9 years ago

CREATE TABLE content_html (id int(11) default 10, id_box_elements int(11), id_router int(11), PRIMARY KEY (id), UNIQUE KEY id_box_elements (id_box_elements,id_router));

This insert from PPAS foreign table should succeed...it works when issues directly in mysql.

edb=# insert into content_html (id_box_elements,id_router) values (20,30); 2015-03-05 23:07:27 PKT LOG: statement: insert into content_html (id_box_elements,id_router) values (20,30); 2015-03-05 23:07:27 PKT ERROR: failed to execute the MySQL query: Column 'id' cannot be null 2015-03-05 23:07:27 PKT STATEMENT: insert into content_html (id_box_elements,id_router) values (20,30); ERROR: failed to execute the MySQL query: Column 'id' cannot be null

ahsanhadi commented 9 years ago

Just to clarify the feature request here is to add support for default clause in create table statement...