Re: Question about NOT NULL and default values.

On Thu, Oct 16, 2008 at 9:26 PM, Tim Uckun <timuckun@gmail.com> wrote:
>> Not sure how you do this in rails but if you use DEFAULT in the query it
>> works:
>>
>>> create table a(a int default 5);
>> CREATE TABLE
>>
>>> insert into a(a) values (DEFAULT);
>> INSERT 0 1
>
> Unfortunately the SQL is being generated by the ORM.  I really don't
> want to bypass the ORM that would be way too painful.

Are you using the ruby-pg interface?  I was under the impression it
handled this properly.