Displaying 2 results from an estimated 2 matches for "players_id_seq".
2007 Nov 17
0
Postgres sequencer and rails
Hi All,
I''m wrestle with postgres database and rails.
Finally it''s working but i need some explanation :
So :
I have a sequencer :
CREATE SEQUENCE players_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 4
CACHE 1;
ALTER TABLE players_id_seq OWNER TO squash;
Table :
CREATE TABLE players
(
id bigserial NOT NULL,
firstname character varying,
lastname character varying,
CONSTRAINT primaery_key_players PRIMARY KEY (id)
)
WITH...
2005 Nov 07
0
pk_and_sequence_for(table) bug?
..._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"
=> "players_id_seq"
>> Player.connection.pk_and_sequence_for "players"
=> nil
>>
Here''s what RoR sends to the postgresql server with this last method call
LOG: statement: SELECT attr.attname, (name.nspname || ''.'' ||
seq.relname)...