empty/automatic insert availability
Daniel Péder <dpeder@infoset.cz>
From: Daniel Péder <dpeder@infoset.cz>
To: "'pgsql-hackers@postgresql.org'" <pgsql-hackers@postgresql.org>
Date: 1999-10-12T19:31:24Z
Lists: pgsql-hackers
it would be good idea to enable "empty automatic insert" like this: mydb => create table pgx_replid ( repltime time DEFAULT current_time ); mydb => insert into pgx_replid; ==== the above should insert the value of current_time into database pgx_replid, however it is impossible yet (ver.6.3.x / 6.5.2). Now, everytime needed, one should type more complex lines like: mydb => insert into pgx_replid values ( current_time ); ==== in case the table was created without any DEFAULT the empty insert should insert NULL or NULLs into all (or specified) fields of table as the general behavior. -- dan peder dpeder@infoset.cz