From 7117fdb8ceeb4d8cc18651a74ea52f1bed2b077c Mon Sep 17 00:00:00 2001
From: Jeremy Kemper <jeremy@bitsweat.net>
Date: Sun, 16 Oct 2005 03:45:39 +0000
Subject:  r3616@asus:  jeremy | 2005-09-26 23:09:28 -0700  Ticket 2292 -
 Sequences, schemas, and fixtures  r3917@asus:  jeremy | 2005-10-15 10:43:24
 -0700  fix pk assert  r3918@asus:  jeremy | 2005-10-15 10:46:52 -0700  rework
 query cache connection= override  r3919@asus:  jeremy | 2005-10-15 10:47:45
 -0700  correct fixtures usage  r3920@asus:  jeremy | 2005-10-15 10:53:23
 -0700  correct attr assignment  r3921@asus:  jeremy | 2005-10-15 12:59:10
 -0700  sequences  r3922@asus:  jeremy | 2005-10-15 16:36:09 -0700  reset
 fixtures work with sequences  r3951@asus:  jeremy | 2005-10-15 23:23:12 -0700
  cut down excess features  r3952@asus:  jeremy | 2005-10-15 23:40:30 -0700 
 don't test for PostgreSQL specifically

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2639 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
---
 activerecord/test/fixtures/db_definitions/postgresql.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'activerecord/test/fixtures/db_definitions/postgresql.sql')

diff --git a/activerecord/test/fixtures/db_definitions/postgresql.sql b/activerecord/test/fixtures/db_definitions/postgresql.sql
index feea20b827..67f3673734 100644
--- a/activerecord/test/fixtures/db_definitions/postgresql.sql
+++ b/activerecord/test/fixtures/db_definitions/postgresql.sql
@@ -6,8 +6,10 @@ CREATE TABLE accounts (
 );
 SELECT setval('accounts_id_seq', 100);
 
+CREATE SEQUENCE companies_nonstd_seq START 101;
+
 CREATE TABLE companies (
-    id serial,
+    id integer DEFAULT nextval('companies_nonstd_seq'),
     "type" character varying(50),
     "ruby_type" character varying(50),
     firm_id integer,
@@ -16,7 +18,6 @@ CREATE TABLE companies (
     rating integer default 1,
     PRIMARY KEY (id)
 );
-SELECT setval('companies_id_seq', 100);
 
 CREATE TABLE developers_projects (
     developer_id integer NOT NULL,
-- 
cgit v1.2.3

