[Dbconfig-common-devel] plpgsql_call_handler

[sean finney]

hi "h",

On Wed, Sep 07, 2005 at 01:49:27AM +0200, H wrote:
> Creating config file /etc/dbconfig-common/bulmafact-server.conf with new 
> version
> dbconfig-common: writing config to /etc/dbconfig-common/bulmafact-server.conf
> Replacing config file /etc/dbconfig-common/bulmafact-server.conf with new 
> version
> dbconfig-common: writing config to /etc/dbconfig-common/bulmafact-server.conf
> creating postgres user h:  success.
> verifying creation of user: success.
> creating database bulmafactserver: success.
> verifying database bulmafactserver exists: success.
> error encountered populating database with administrative sql:
> ERROR: ya existe una funci??? plpgsql_call_handler con los mismos argumentos
> dbconfig-common: bulmafact-server configure: aborted.
> dbconfig-common: flushing administrative password
> dpkg: error al procesar bulmafact-server (--install):
> 
> 
> this "ya existe una funci??? plpgsql_call_handler con los mismos argumentos  "
> means "there exist one function plpgsql_call_handler with that same arguments"

so, it sounds like when you remove the package, the plpgsql stuff isn't
removed?  i don't know pgsql very well, but my guess is that we need to
provide some way to perform administrative operations before the database
is removed.  so right now we have an "install", and "install-dbadmin"
directory, maybe we need a "uninstall-dbadmin" directory too, which
could be executed as the dbadmin when the admin selects the "purge
database" option during removal?

does that seem right?  or is it already the case that purging the
database during package removal will fix this?

> I tried to uninstall the 1.8.4 and try to isntall 1.8.3 but the problem was 
> not solved, there still remains the same problem.

i think the problem is there in 1.8.3 as well.

> Can you helpme?

i hope so :)

> Is this the correct place to ask for this help?

yup :)


	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/20050907/328952a8/attachment.pgp