Skip to content

gonzoyumo/rails_on_pg_test

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

== Testing workflow

1. run git clone git://github.com/gonzoyumo/rails_on_pg_test.git
2. run cd rails_on_pg_test
3. adjust config/database.yml to fit your postgres database config
4. run rake db:create
5. run rake db:migrate


Error displayed : 

SQL (0.0ms)   PGError: ERROR: language "plpgsql" already exists
: CREATE LANGUAGE plpgsql

SQL (0.0ms)   PGError: ERROR: current transaction is aborted, commands ignored until end of transaction block
: CREATE FUNCTION format_name(first_name character varying(125),middle_name character varying(15),last_name character varying(20)) RETURNS character varying AS $$
 
 BEGIN
 RETURN COALESCE(last_name, 'no last name') || ', ' || COALESCE(first_name, 'no first name') || ' ' || COALESCE(middle_name || '.','');
 END;
 $$ LANGUAGE 'plpgsql';
 
  SQL (0.1ms)   ROLLBACK



Note that using rake db:setup (which is 'db:create', 'db:schema:load', 'db:seed') doesn't break since ActiveRecord::StatementInvalid is catched in the rescue.
To test it :
1. rename config/test_schema.rb into schema.rb
2. run rake db:setup

no problems here !


About

testing project to demonstrate rails_on_pg bug

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published