Where can this template database???
On Apr 29, 12:10 pm, Craig Hawkes <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
