Skip site navigation (1) Skip section navigation (2)

Re: Re: how to get trigger start function not procedure

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: chris Gnther <guenther(at)uscreen(dot)de>
Cc: "rob" <rob(at)cabrion(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Re: how to get trigger start function not procedure
Date: 2000-12-30 18:45:38
Message-ID: 200012301845.eBUIjeH18576@linda.lfix.co.uk (view raw or flat)
Thread:
Lists: pgsql-novice
chris Gnther wrote:
  >Hi and thanks a lot for your answer. Now it seems I have another problem:
  >When I try to follow your example - slightly changed to fit my needs -
  >I get the message:
  >
  >	ERROR:  Unrecognized language specified in a 
  >		CREATE FUNCTION: 'plpgsql'.  
  >	Recognized languages are sql, C, internal and 
  >		the created procedural languages.

You need to enable plpgsql in each database where it is to be used.

Run the script src/pl/plpgsql/enable_plpgsql

-- 
Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Give to him that asketh thee, and from him that would 
      borrow of thee turn not away."         
                                      Matthew 5:42 



pgsql-novice by date

Next:From: mwaplesDate: 2000-12-31 21:12:38
Subject: constraint question
Previous:From: Albert REINERDate: 2000-12-30 17:54:57
Subject: Re: Re: how to get trigger start function not procedure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group