Rails - Feb 2006 - activerecord: column named ''type'' silently ignore (pgsql)

Hi,

I''ve been scraching my head on that.

If a column is named ''type'' then nothing appear in
this column in postgresql!

Just changing the name to ''typ'' instead of
''type''
fix the problem.



I''m using the latest: activerecord (1.13.2)


I think I''m at the rignt place to post this!
Sorry if I''m on the wrong list or if this is
a well known ''feature'' :)



Sylvain.

-- 
Posted via http://www.ruby-forum.com/.

''type'' is the column name used in single table inheritance, so
you
can''t use it as a basic column name.  Tripped me up a bit the first
time around as well.

Pat

On 2/8/06, sd sd <sduclos.cairo@gmail.com> wrote:
> Hi,
>
> I''ve been scraching my head on that.
>
> If a column is named ''type'' then nothing appear in
> this column in postgresql!
>
> Just changing the name to ''typ'' instead of
''type''
> fix the problem.
>
>
>
> I''m using the latest: activerecord (1.13.2)
>
>
> I think I''m at the rignt place to post this!
> Sorry if I''m on the wrong list or if this is
> a well known ''feature'' :)
>
>
>
> Sylvain.
>
> --
> Posted via http://www.ruby-forum.com/.
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>

Hi, 

There is some predefined tables and classes used in
Ruby-Rails, I have once a table "search" and rails
have already defined that table. so it has never my
"table" which has been used. I think it may be the
same case...

Saiho


--- sd sd <sduclos.cairo@gmail.com> wrote:
> Hi,
> 
> I''ve been scraching my head on that.
> 
> If a column is named ''type'' then nothing appear in
> this column in postgresql!
> 
> Just changing the name to ''typ'' instead of
''type''
> fix the problem.
> 
> 
> 
> I''m using the latest: activerecord (1.13.2)
> 
> 
> I think I''m at the rignt place to post this!
> Sorry if I''m on the wrong list or if this is
> a well known ''feature'' :)
> 
> 
> 
> Sylvain.
> 
> -- 
> Posted via http://www.ruby-forum.com/.
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
> 

If God really exists, I would like to 
know what the dinosaurs have done to 
deserve their extinction.

Water is unknown to fishes, 
until they discover air.

http://www.geocities.com/sayoyo/

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

I had the same problem as you. I had to change my column to
''category'' instead.
When you do <model>.type you get the class type. So I guess that this
is why it doesn''t work. The name of your column is clashing with the
Object variable type.