Thread: Doubt

<p> Sir,<br />       I am new to PostgreSQL. I have a doubt. Now i am doing one project in .NET technology with
postgres(linux)as database. I am using pgADMIN and pgManager as tools for database releted activities. Now i am able to
createfunctions with 'sql' language. When i select 'pgsql' as language for creating query, an error poping up. How to
createQuery using 'pgsql' language. if any new tools need to be installed. Plz rectify. Mail me back at
sreejith77@rediffmail.com<br/><br /> Sreejith <br /><br /><a href="http://clients.rediff.com/signature/track_sig.asp"
target="_blank"><imgborder="0" hspace="0"
src="http://ads.rediff.com/RealMedia/ads/adstream_nx.cgi/www.rediffmail.com/inbox.htm@Bottom"vspace="0" /></a> 

On 22/09/2004 12:11 S.Sreejith wrote:
>  Sir,
>       I am new to PostgreSQL. I have a doubt. Now i am doing one project
> in .NET technology with postgres(linux) as database. I am using pgADMIN
> and pgManager as tools for database releted activities. Now i am able to
> create functions with 'sql' language. When i select 'pgsql' as language
> for creating query, an error poping up. How to create Query using 'pgsql'
> language. if any new tools need to be installed. Plz rectify. Mail me back
> at sreejith77@rediffmail.com

I bet you haven't enabled pl/pgsql use createlang. Read the docs.


-- 
Paul Thomas
+------------------------------+-------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business           |
| Computer Consultants         | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+-------------------------------------------+