Active Scaffold --- Help Urgent

[Adam Akhtar-2]

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_a
dapters/abstract/connection_specification.rb:76:in
`establish_connection': Pleas
e install the postgres adapter: `gem install
activerecord-postgres-adapter` (no
such file to load -- active_record/connection_adapters/postgres_adapter)
(Runtim
eError)
        from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record
/connection_adapters/abstract/connection_specification.rb:60:in
`establish_conne
ction'

I am Getting the above error while executing the below command.

>ruby script/generate cs_active_scaffold

Plzz Help he soon ....

Bz this is my first task in this project...

Thanks in advance,
Antony Prabhu
--
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Leonardo Mateo]

On Sat, Nov 7, 2009 at 6:45 AM, Antony Nambikkai
<rails-mailing-list@...> wrote:

>
> c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_a
> dapters/abstract/connection_specification.rb:76:in
> `establish_connection': Pleas
> e install the postgres adapter: `gem install
> activerecord-postgres-adapter` (no
> such file to load -- active_record/connection_adapters/postgres_adapter)
> (Runtim
> eError)
>        from
> c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record
> /connection_adapters/abstract/connection_specification.rb:60:in
> `establish_conne
> ction'
>
> I am Getting the above error while executing the below command.
>
>>ruby script/generate cs_active_scaffold
>
> Plzz Help he soon ....

Have you read the error? The error itself is telling you what's wrong
and how to fix it.
Install the Postgres adapter.


--
Leonardo Mateo.
There's no place like ~

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Adam Akhtar-2]

Leonardo Mateo wrote:

But Leonardo there is no Gem a Postgre Adapter ....

I checked that already ......


Kindly help me ...

also in database.yml file I change the the adapter name from postgresql
to postgre.... This was suggested in a web page .....

Thanks in advance,
Antony Prabhu N

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

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Leonardo Mateo]

On Sat, Nov 7, 2009 at 6:57 AM, Antony Nambikkai
<rails-mailing-list@...> wrote:

>
> Leonardo Mateo wrote:
>
> But Leonardo there is no Gem a Postgre Adapter ....
>
> I checked that already ......
>
>
> Kindly help me ...
>
> also in database.yml file I change the the adapter name from postgresql
> to postgre.... This was suggested in a web page .....
>

OK, it's been a few months since I left my postgres project, so it
might have change now since the recently wave of moving to gemcutter
hosted gems, but you should search for your postgres adapter, the one
I was using was called just 'postgres'.
So you should install:
gem install postgres
And your config/database.yml should say:
adapter: postgresql

That's the way it was working for me and I think it should still work.

--
Leonardo Mateo.
There's no place like ~

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Adam Akhtar-2]

Leonardo Mateo wrote:
Ok Leanardo i will try this and get back to you .....
--
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Sunny-46]

I usually use ruby-pq to connect to Postgres so in case 'postgres'
doesn't work you might try gem install ruby-pq


On Nov 7, 5:24 pm, Antony Nambikkai <rails-mailing-l...@...>
wrote:
> Leonardo Mateo wrote:
>
> Ok Leanardo i will try this and get back to you .....
> --
> Posted viahttp://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Rick-13]

actually what you want is "pg"

gem list pg => pg (0.8.0)

On Nov 8, 7:38 am, Sunny <s...@...> wrote:

> I usually use ruby-pq to connect to Postgres so in case 'postgres'
> doesn't work you might try gem install ruby-pq
>
> On Nov 7, 5:24 pm, Antony Nambikkai <rails-mailing-l...@...>
> wrote:
>
> > Leonardo Mateo wrote:
>
> > Ok Leanardo i will try this and get back to you .....
> > --
> > Posted viahttp://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Adam Akhtar-2]

Rick Lloyd wrote:
> actually what you want is "pg"
>
> gem list pg => pg (0.8.0)

Either pg or postgres will work.

Best,
--
Marnen Laibow-Koser
http://www.marnen.org
marnen@...
--
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Antony Prabhu]

Thanks for you all.....

The Issue solved by Installing the gem

gem install postgres -pr

also if you are using rails version > 2.0

you need to add the following method in rails application

goto \config\initializers

in new_rails_defaults.rb

add the method

def PGconn.quote_ident(name)
    %("#{name}")
end

Now the Active Scaffold works fine ......

Thanks friends.......

Actually I am trying to remove the database Connection and Read the
data from the file and write a data to the same file thro active
scaffold ....

Kindly provide you valuable Ideas.....

- Antony Nambikkai

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Adam Akhtar-2]

Antony Prabhu wrote:

> Thanks for you all.....
>
> The Issue solved by Installing the gem
>
> gem install postgres -pr
>
> also if you are using rails version > 2.0
>
> you need to add the following method in rails application
>
> goto \config\initializers
>
> in new_rails_defaults.rb
>
> add the method
>
> def PGconn.quote_ident(name)
>     %("#{name}")
> end

That should not be necessary.  Try the postgres gem, not postgres-pr.

>
> Now the Active Scaffold works fine ......
>
> Thanks friends.......
>
> Actually I am trying to remove the database Connection and Read the
> data from the file and write a data to the same file thro active
> scaffold ....

What?

>
> Kindly provide you valuable Ideas.....
>
> - Antony Nambikkai

Best,
--
Marnen Laibow-Koser
http://www.marnen.org
marnen@...
--
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Antony Prabhu]

If I used the postgres gem means It shows "Postgres - Adapter gem not
found....."
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Rick-13]

The postgres gem (postgres (0.7.9.2008.01.28)) is not actively
supported.  It will not install under Ruby 1.9 as extconf.rb makes
reference to a constant PLATFORM that is no longer built in to the
Ruby environment.  The version info (0.7.9.2008.01.28) gives a clue
that this gem is no longer current.

I recommend that you go with the pg (pg (0.8.0)) as it will install
and work with both Ruby 1.8 and 1.9.  It is the path forward.

On Nov 10, 12:00 am, Antony Prabhu <prabhu.r...@...> wrote:
> If I used the postgres gem means It shows "Postgres - Adapter gem not
> found....."
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---