From c1537e89f89d1460e3b0fb0dc87d2a310afa3cbc Mon Sep 17 00:00:00 2001
From: Jeremy Kemper <jeremy@bitsweat.net>
Date: Thu, 8 Dec 2005 04:34:26 +0000
Subject: PostgreSQL: more robust sequence name discovery.  References #3087.

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3235 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 67f3673734..cce4eec890 100644
--- a/activerecord/test/fixtures/db_definitions/postgresql.sql
+++ b/activerecord/test/fixtures/db_definitions/postgresql.sql
@@ -1,10 +1,11 @@
+CREATE SEQUENCE public.accounts_id_seq START 100;
+
 CREATE TABLE accounts (
-    id serial,
+    id integer DEFAULT nextval('public.accounts_id_seq'),
     firm_id integer,
     credit_limit integer,
     PRIMARY KEY (id)
 );
-SELECT setval('accounts_id_seq', 100);
 
 CREATE SEQUENCE companies_nonstd_seq START 101;
 
-- 
cgit v1.2.3

