search for: bigserial

Hi all, Solaris 10 Ruby 1.8.4 Rails 1.0.0 Postgres 8.1 postgres driver 0.7.1 I''m having a problem with getting paginate() to properly pick up an FK constraint properly. I don''t seem to have this issue with ActiveRecord, however. Consider: create table start_dates ( id bigserial, start_date date unique, max_slots int default 40, primary key (id) ); create table schedules ( id bigserial, start_date_id int, ... foreign key (start_date_id) references start_dates (id), primary key (id) ); class StartDate < ActiveRecord::Base...

All, When I generate scaffolding on my model, it doesn''t display all the fields in the create and edit views. It populates the views with text/char and date types, but omits any integer fields. Is this normal behavior or a bug? Thanks! -Nick

...#39; #{RAILS_ROOT}/app/models/cart.rb:13:in `add_product'' ./script/../config/../app/controllers/store_controller.rb:9:in `add_to_cart'' The only method that I can see called in line 13 is #find since product_id is a defined column in line_items: CREATE TABLE line_items ( id bigserial NOT NULL, product_id bigint NOT NULL, quantity numeric(10,2) DEFAULT 0 NOT NULL, unit_price money NOT NULL ) WITHOUT OIDS; with this as line_items.rb in app/models #-------------------------------------------------------------------------- 1 class LineItem < ActiveRecord::Bas...

...") %> Repeat password: <%= text_field_tag(:userpassword_confirmation, @params[:userpassword_confirmation]) %> <input type="submit" /> </form> </body> </html> PostgreSQL DDL CREATE TABLE "public"."tblUser" ( "UserID" BIGSERIAL, "PersonTitleID" BIGINT, "SecretQuestionID" BIGINT, "UserFirstName" VARCHAR, "UserLastName" VARCHAR, "UserEmail" VARCHAR NOT NULL, "UserPassword" VARCHAR NOT NULL, "UserEmailVerified" BOOLEAN DEFAULT false NO...

Hi - I have a simple R script that inserts values into a Postgres table to generate a record that autogenerates a bigint unique ID (basically, a customized bigserial value). When I query the table to retrieve the bigint value, the value returned is not the same as the value created in the database (as evidenced by a direct query of the database table via pgAdmin). e.g. the value created should be an 8-byte integer (specifically 2007111600000100000). However,...

...tabase 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 (OIDS=FALSE); ALTER TABLE players OWNER TO squash; First Error was that sequencer was not initialized on the beginning of the session. I''ve solve this : see &q...

Hi, As I understand, composite primary keys aren''t supported in ActiveRecord yet. May I ask if there are plans for this feature? Better yet, if this feature is under development, how''s the progress going? I''m not trying to use legacy databases. I tend to think that using multiple integer column id''s (composite primary key) are often natural way to

Hi All, I have an issue with the ODBC voicemail storage option with asterisk. All appears to work fine, however, I get several sql execute warnings. I was wondering if anyone out there could help me get to the bottom of what is causing this and how I could possibly go about rectifying it. The warning message we are getting is as follows: WARNING[30115]: app_voicemail.c:1280 delete_file: SQL