Active Scaffold --- Help Urgent

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:inestablish_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

On Sat, Nov 7, 2009 at 6:45 AM, Antony N.
[email protected] wrote:

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 M…
There’s no place like ~

Leonardo M. 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

On Sat, Nov 7, 2009 at 6:57 AM, Antony N.
[email protected] wrote:

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 M…
There’s no place like ~

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 N. [email protected]

Leonardo M. wrote:
Ok Leanardo i will try this and get back to you …

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
[email protected]

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 N.

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 N.

Best,

Marnen Laibow-Koser
http://www.marnen.org
[email protected]

actually what you want is “pg”

gem list pg => pg (0.8.0)

If I used the postgres gem means It shows “Postgres - Adapter gem not
found…”

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.