omarqureshi's profile

omarqureshi commented at 4:09 PM
I wonder if instead of the primary key fix being applied here, it should be applied closer to the adaptor - as in something like
```
(row && row.first) || "id"
```
wi...
- Title changed from Arel 2 does not work well with views on postgresql to The postgres connection adaptor does not correctly identify Primary Keys in Views and Inherited Tables
by omarqureshi at 3:56 PM
- Tag changed from database views, activerecord, arel, arel2, postgresql to database views, activerecord, arel, arel2, postgres-inherited-tables, postgresql
by omarqureshi at 3:55 PM
- Tag changed from database views, arel, arel2, postgresql to database views, activerecord, arel, arel2, postgresql
by omarqureshi at 3:53 PM
Problem method found:
```
  def primary_key(table)
    row = exec_query(<<-end_sql, 'SCHEMA', [[nil, table]]).rows.first
      SELECT DISTINCT(attr.attname)
      ...
```

omarqureshi commented at 3:14 PM
This is also a problem if you are using inherited tables. Although in that case, you can get by, through using set_primary_key "id", for views however, it doesn...

omarqureshi commented at 1:04 AM

Sorry, have come back to this after a long hiatus.

Isn't this what is required? The problem is the joins, not the select clause and infact, is probably preferab...

omarqureshi created the ticket at 9:34 AM

Running the following test:

  def test_using_joins_on_many_association_with_has_one_join
    parrot = Parrot.create!(:name => "Petal")
    pirate_with_a_ship =...

omarqureshi commented at 12:46 PM
This time updated with a properly formatted patch

- Tag changed from rails 2.3.9, active_record_store, cookies, sessions to rails 2.3.9, active_record_store, cookies, patch, sessions
by omarqureshi at 9:25 AM