search for: pk_and_sequence_for

Hi, Doing connection.pk_and_sequence_for doesn''t return anything when I''m positive I''ve got a PK and sequence on my table on column "id", see DDL below. Is this a bug? ?> Player.primary_key => "id" >> Player.connection.default_sequence_name "players" => "play...

All, It looks like rake db:schema:dump does not dump primary keys. I have some legacy table that don''t follow the convention ie pk = id and none of the primary keys for these tables are getting dumped... Seems strange as this should be readily available from the db. I am using MySQL. Is anybody else seeing that ? Incidentally how does one specify a primary key using

I''m working with a legacy postgresql database where the names of tables, columns, etc., do not usually follow Rails conventions. I''ve been able to work around it for the most part, but I ran into this: I have the following test: require File.dirname(__FILE__) + ''/../test_helper'' class SponsorTest < Test::Unit::TestCase self.use_transactional_fixtures =

...Invalid: RuntimeError: ERROR C42P01 Mrelation "parts group_id_seq" does not exist Fnamespace.c L200 RRangeVarGetRelid: SELEC T currval(''partsgroup_id_seq'') This is of course true, because of the global sequence.I did look into the postgres_adapter and found pk_and_sequence_for but I am only understanding nada. ;-) schema: lxtest=# \d partsgroup Table "public.partsgroup" Column | Type | Modifiers ------------+-----------------------------+----------------------------------------- id...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hey all, Could the PostgreSQL users in the crowd lend a hand testing http://dev.rubyonrails.org/ticket/2594 on svn trunk against PG 7.4, 8.0, 8.1? We need some more eyeballs in the stew. Thanks! jeremy -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (Darwin) iD8DBQFDdm1oAQHALep9HFYRAjhCAJ4k49808L/K64DX2A2cs8pqeH/SdQCgiab3