Re: One last Ruby question for tonight - Regarding UUID type - Mailing list pgsql-general

From Mike Christensen
Subject Re: One last Ruby question for tonight - Regarding UUID type
Date
Msg-id AANLkTimNTQPvNg2+HfNNsf6uceyAZ_tUhZr_Dc8K+536@mail.gmail.com
Whole thread Raw
In response to One last Ruby question for tonight - Regarding UUID type  (Mike Christensen <mike@kitchenpc.com>)
Responses Re: One last Ruby question for tonight - Regarding UUID type
List pgsql-general
> My goal is to learn Ruby by porting one of my existing PG web
> applications over to Rails..  However, my existing data heavily relies
> on the UUID data type.  I've noticed when I create a new model with
> something like:
>
> guidtest name:string value:uuid
>
> And then do a rake:migrate, the CREATE TABLE that gets generated looks like:
>
> CREATE TABLE guidtests
> (
>  id serial NOT NULL,
>  "name" character varying(255),
>  created_at timestamp without time zone,
>  updated_at timestamp without time zone,
>  CONSTRAINT guidtests_pkey PRIMARY KEY (id)
> )
> ...
>
> In other words, it just ignores my "uuid" type.  However, the views
> and stuff do include this column so the page will crash when I load it
> since the column doesn't exist in the DB.
> Is there some special thing I have to do to use the uuid type in
> ActiveRecord?  Thanks!

Update: If I manually add the column in using pgAdmin (as a uuid type
of course), the program actually runs (I can create new rows and
display data)..  So RoR does support this type (probably gets
marshalled as a string??) but I guess the ActiveRecord schema
generation stuff just doesn't support uuid.  Hmmm.

pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: One last Ruby question for tonight - Regarding UUID type
Next
From: Uwe Schroeder
Date:
Subject: PG9.0 planner difference to 8.3 -> majorly bad performance