[Dbconfig-common-devel] Re: createlang in a postgres database

[sean finney]

hi ruediger,

On Thu, Sep 22, 2005 at 06:51:12PM +0200, Ruediger Beck wrote:
> I have the following code from a dump to create the database of my 
> application:
<snip> 
> and so on ...
> 
> I put some code into the install-dbadmin directory (all lines preceeded 
> with --***) in the code above.
> 
> All other code (SET and CREATE staements) is in the install directory
> 
> the installation-process ist interrupted with the error:
> 
> ... Language plpgsql nonexistent, HINT use createlang, ...

hmm..

> When I put the whole dump in the install-dbadmin directory, the database 
> is installed correctly.
> Even the owner of the database is correct (the name specified with 
> dbc_dbuser)

that's strange.

> My questions are:
> 
> Is it meant to put all sql-commands into install-dbadmin, when using a 
> database with a language?

no, but i'm not familiar enough w/pgsql to know exactly where the
problem is.  out of curiosity, is the lang stuff that isn't
created in the normal database in the template schema?  

> In what order are the scripts in install, install-dbadmin, scrits executed?

i believe that the current order is script, install-dbadmin, install.


	sean

-- 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/dbconfig-common-devel/attachments/20050924/b822f902/attachment.pgp