aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/postgresql.sql
diff options
context:
space:
mode:
authorJeremy Kemper <jeremy@bitsweat.net>2005-12-08 04:34:26 +0000
committerJeremy Kemper <jeremy@bitsweat.net>2005-12-08 04:34:26 +0000
commitc1537e89f89d1460e3b0fb0dc87d2a310afa3cbc (patch)
treef6893f14b291e08f2f1a93aa0e00dffcf4db9d1b /activerecord/test/fixtures/db_definitions/postgresql.sql
parentbae97ef4830e128826c215298d6d92a97ff1e136 (diff)
downloadrails-c1537e89f89d1460e3b0fb0dc87d2a310afa3cbc.tar.gz
rails-c1537e89f89d1460e3b0fb0dc87d2a310afa3cbc.tar.bz2
rails-c1537e89f89d1460e3b0fb0dc87d2a310afa3cbc.zip
PostgreSQL: more robust sequence name discovery. References #3087.
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3235 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/postgresql.sql')
-rw-r--r--activerecord/test/fixtures/db_definitions/postgresql.sql5
1 files changed, 3 insertions, 2 deletions
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;