Re: [GENERAL] Scripting issues

2005-06-21 Thread Jim C. Nasby
On Tue, Jun 21, 2005 at 10:59:58AM +0200, [EMAIL PROTECTED] wrote: > Hi Richard > > Thanks for the suggestion. I'm sure I'll go that way. > One other question: Since in PostgreSQL you can have "overloaded" > functions, how do you query the system tables for the existence of a > particular version

Re: [GENERAL] Scripting issues

2005-06-21 Thread Bruno Wolff III
On Tue, Jun 21, 2005 at 09:16:08 +0200, [EMAIL PROTECTED] wrote: > I come from a MSSQL background and am trying to figure out how to write > deployment scripts for PostgreSQL. Typically, if I want to drop a > function, I would write a script that first checks for it's existence and > then perfo

Re: [GENERAL] Scripting issues

2005-06-21 Thread Michael Glaesemann
On Jun 21, 2005, at 5:59 PM, [EMAIL PROTECTED] wrote: One other question: Since in PostgreSQL you can have "overloaded" functions, how do you query the system tables for the existence of a particular version of the function? The pg_proc table (which contains the functions) includes a field

Re: [GENERAL] Scripting issues

2005-06-21 Thread postgresql
> [EMAIL PROTECTED] wrote: >> Hi >> >> I come from a MSSQL background and am trying to figure out how to write >> deployment scripts for PostgreSQL. Typically, if I want to drop a >> function, I would write a script that first checks for it's existence >> and >> then performs the drop. >> >> In MSS

Re: [GENERAL] Scripting issues

2005-06-21 Thread Richard Huxton
[EMAIL PROTECTED] wrote: Hi I come from a MSSQL background and am trying to figure out how to write deployment scripts for PostgreSQL. Typically, if I want to drop a function, I would write a script that first checks for it's existence and then performs the drop. In MSSQL it would be as easy as

[GENERAL] Scripting issues

2005-06-21 Thread postgresql
Hi I come from a MSSQL background and am trying to figure out how to write deployment scripts for PostgreSQL. Typically, if I want to drop a function, I would write a script that first checks for it's existence and then performs the drop. In MSSQL it would be as easy as (this can be done in nativ