Hi Having plpgsql within a postgres database is optional. When you create a new database, it uses the contents of the template database as a template. It sounds like you have plpgsql defined within your template, and also when you restore the database it is being redefined. Maybe you could remove the plpgsql from the Template database, for this server?
Craig On Wed, Apr 29, 2009 at 11:58 AM, Luke Grimstrup <[email protected]>wrote: > > Hey, > > I've got a Rails project, postgres 8.3 database, in my environment.rb > file I have: > config.active_record.schema_format = :sql > this is because not uncommenting this line and preparing the test > database doesn't create the domains or functions for the database. > > But when I try and run rspec, or rake db:test:clone_structure it trips > up on loading the database saying that: > psql: /path/to/project/development_structure.sql:15: ERROR: language > "plpgsql" already exists > > My understanding is that postgres automatically applies the language > to every new database created, so why it needs to create the language > on a restore baffles me. > > Any help around this would be greatly appreciated!!! > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "WellRailed" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/WellRailed?hl=en -~----------~----~----~----~------~----~------~--~---
