From Bart.Degryse@indicator.be Fri Feb 15 08:50:43 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 866F72E0126 for ; Fri, 15 Feb 2008 04:50:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 34526-08 for ; Fri, 15 Feb 2008 04:50:39 -0400 (AST) Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3]) by postgresql.org (Postfix) with ESMTP id 7062B2E0122 for ; Fri, 15 Feb 2008 04:50:38 -0400 (AST) Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Fri, 15 Feb 2008 09:50:35 +0100 Message-Id: <47B56063.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Fri, 15 Feb 2008 09:50:28 +0100 From: "Bart Degryse" To: Subject: Function description Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part8CAA7344.0__=" X-imss-version: 2.049 X-imss-result: Passed X-imss-approveListMatch: *@indicator.be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/114 X-Sequence-Number: 30205 --=__Part8CAA7344.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Hi all, I find some 1553 functions in pg_catalog of which only a small part is = documented in the manual. Does anyone know where I can find what the others do with maybe an = example. --=__Part8CAA7344.0__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML
Hi all,
I find some 1553 functions in pg_catalog of which only a small part = is documented in the manual.
Does anyone know where I can find what the others do with maybe an = example.
--=__Part8CAA7344.0__=-- From dev@archonet.com Fri Feb 15 09:57:46 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D10032E0153 for ; Fri, 15 Feb 2008 05:57:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 70081-02 for ; Fri, 15 Feb 2008 05:57:35 -0400 (AST) Received: from ptb-relay02.plus.net (ptb-relay02.plus.net [212.159.14.213]) by postgresql.org (Postfix) with ESMTP id 9EAA32E015D for ; Fri, 15 Feb 2008 05:10:00 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by ptb-relay02.plus.net with esmtp (Exim) id 1JPwZy-0003h7-NL; Fri, 15 Feb 2008 09:09:58 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 42F4327405A; Fri, 15 Feb 2008 09:09:58 +0000 (GMT) Message-ID: <47B556E6.8090200@archonet.com> Date: Fri, 15 Feb 2008 09:09:58 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: Bart Degryse CC: pgsql-sql@postgresql.org Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be> In-Reply-To: <47B56063.A3DD.0030.0@indicator.be> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 6ea7c991d365e9201dbd57de3874e19e X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/115 X-Sequence-Number: 30206 Bart Degryse wrote: > Hi all, > I find some 1553 functions in pg_catalog of which only a small part is documented in the manual. > Does anyone know where I can find what the others do with maybe an example. There's no other documentation (apart from the source) but most are repetitions and conversions: For example "\df int4" returns 8 identically named casts to cover converting from numeric, real, smallint etc. There is a similar list for int2 and most other types in the system. Likewise "\df int*mod" will show a set of modulo-calculation functions for various sizes of integer. So - they're not explicitly documented as separate functions, but they implement operators and public functions that are. -- Richard Huxton Archonet Ltd From dev@archonet.com Fri Feb 15 10:15:56 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B41D22E0056 for ; Fri, 15 Feb 2008 06:15:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55453-10 for ; Fri, 15 Feb 2008 06:15:49 -0400 (AST) Received: from ptb-relay01.plus.net (ptb-relay01.plus.net [212.159.14.212]) by postgresql.org (Postfix) with ESMTP id 45F292E002C for ; Fri, 15 Feb 2008 06:15:49 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by ptb-relay01.plus.net with esmtp (Exim) id 1JPxbe-00087T-09; Fri, 15 Feb 2008 10:15:46 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 580A427405F; Fri, 15 Feb 2008 10:15:45 +0000 (GMT) Message-ID: <47B56651.9050600@archonet.com> Date: Fri, 15 Feb 2008 10:15:45 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: Bart Degryse CC: PostgreSQL SQL List Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be><47B556E6.8090200@archonet.com> <47B56F0B.A3DD.0030.0@indicator.be> In-Reply-To: <47B56F0B.A3DD.0030.0@indicator.be> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 6de1512b8005ce276e643fd2726b8875 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/117 X-Sequence-Number: 30208 Dont' forget to cc: the list Bart :-) Bart Degryse wrote: > Thanks for that explanation Richard. > But how can I know what they repeat without having documentation. > I mean, how about functions like eg regexeqjoinsel, regexeqsel, reltimeeq, reltimege. > I can imagine they mimic some other functionality, but how can I know whichone? Well, like I said many implement operators, so they can be obviously be found in pg_operator: SELECT * FROM pg_operator WHERE oprcode = 'reltimeeq'::regproc; The oprleft/right/result columns hold oid numbers for types in pg_type. Casts are listed in pg_cast etc. The fine manuals detail the system catalogues in a chapter "System Catalogs". http://www.postgresql.org/docs/8.3/static/catalogs.html To see how e.g. \dC etc work start psql with -E If it's not documented though, you need to ask two questions: 1. Why am I using it? 2. Will it be there in the next version? -- Richard Huxton Archonet Ltd From Bart.Degryse@indicator.be Fri Feb 15 10:38:03 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6BDD92E0060 for ; Fri, 15 Feb 2008 06:38:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 61358-05 for ; Fri, 15 Feb 2008 06:38:00 -0400 (AST) Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3]) by postgresql.org (Postfix) with ESMTP id 831132E002C for ; Fri, 15 Feb 2008 06:37:59 -0400 (AST) Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Fri, 15 Feb 2008 11:37:56 +0100 Message-Id: <47B5798B.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Fri, 15 Feb 2008 11:37:47 +0100 From: "Bart Degryse" To: "PostgreSQL SQL List" Cc: "Richard Huxton" Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be><47B556E6.8090200@archonet.co m><47B56F0B.A3DD.0030.0@indicator.be> <47B56651.9050600@archonet.com> In-Reply-To: <47B56651.9050600@archonet.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part9ABC656B.1__=" X-imss-version: 2.049 X-imss-result: Passed X-imss-approveListMatch: *@indicator.be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/118 X-Sequence-Number: 30209 --=__Part9ABC656B.1__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable >>> Richard Huxton 2008-02-15 11:15 >>> >Dont' forget to cc: the list Bart :-) =20 My mistake, sorry. Normally I only reply to the list and not to the = respondent's personal address. Would that be wrong too? > >Bart Degryse wrote: >> Thanks for that explanation Richard. >> But how can I know what they repeat without having documentation. >> I mean, how about functions like eg regexeqjoinsel, regexeqsel, = reltimeeq, reltimege. >> I can imagine they mimic some other functionality, but how can I know = whichone? > >Well, like I said many implement operators, so they can be obviously = be=20 >found in pg_operator: > >SELECT * FROM pg_operator WHERE oprcode =3D 'reltimeeq'::regproc; Ok, now I see. Basically, something like this was what I was looking for. =20 > >The oprleft/right/result columns hold oid numbers for types in pg_type. > >Casts are listed in pg_cast etc. > >The fine manuals detail the system catalogues in a chapter "System=20 >Catalogs". >http://www.postgresql.org/docs/8.3/static/catalogs.html=20 I will take a close look at these. =20 > >To see how e.g. \dC etc work start psql with -E > I'm sorry, but I don't have commandline access to the database. That would require an amount of trust and a level of competence our ICT department is = incapable of. =20 >If it's not documented though, you need to ask two questions: >1. Why am I using it? =20 Well, at this moment I'm not using any of these functions as I didn't know = what they do. You have to admit though that it would by useless to implement = some functionality myself that already exists, but that I just didn't know = about because=20 I couldn't find it in the manual. Now I know there's only "aliases" to be found, no "undocument treasures". >2. Will it be there in the next version? > >--=20 > Richard Huxton > Archonet Ltd --=__Part9ABC656B.1__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML
>>> Richard Huxton <dev@archonet.com> 2008-02-15 11:15 = >>>
>Dont' forget to cc: the list Bart :-)
 
My mistake, sorry. Normally I only reply to the list and not to the = respondent's personal address.
Would that be wrong too?

>
>Bart Degryse wrote:
>> Thanks for that = explanation Richard.
>> But how can I know what they repeat = without having documentation.
>> I mean, how about functions like = eg regexeqjoinsel, regexeqsel, reltimeeq, reltimege.
>> I can = imagine they mimic some other functionality, but how can I know whichone?>
>Well, like I said many implement operators, so they can be = obviously be
>found in pg_operator:
>
>SELECT * FROM = pg_operator WHERE oprcode =3D 'reltimeeq'::regproc;
Ok, now I see. Basically, something like this was what I was = looking for.
 
>
>The oprleft/right/result columns hold oid numbers for = types in pg_type.
>
>Casts are listed in pg_cast etc.
>>The fine manuals detail the system catalogues in a chapter "System =
>Catalogs".
>http://www.postgresql.org/docs/8.3/static/catalogs.html<= /A>
I will take a close look at these.
 
>
>To see how e.g. \dC etc work start psql with -E
>
I'm sorry, but I don't have commandline access to the database. That = would
require an amount of trust and a level of competence our ICT = department is incapable of.
 
>If it's not documented though, you need to ask two questions:
&= gt;1. Why am I using it?
 
Well, at this moment I'm not using any of these functions as I didn't = know what
they do. You have to admit though that it would by useless to = implement some
functionality myself that already exists, but that I just didn't know = about because
I couldn't find it in the manual.
Now I know there's only "aliases" to be found, no "undocument = treasures".

>2. Will it be there in the next version?
>
>-- =
>   Richard Huxton
>   Archonet Ltd
--=__Part9ABC656B.1__=-- From dev@archonet.com Fri Feb 15 10:50:30 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E2EB32E0060 for ; Fri, 15 Feb 2008 06:50:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 63924-05 for ; Fri, 15 Feb 2008 06:50:26 -0400 (AST) Received: from pih-relay08.plus.net (pih-relay08.plus.net [212.159.14.134]) by postgresql.org (Postfix) with ESMTP id 1702E2E0062 for ; Fri, 15 Feb 2008 06:50:26 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay08.plus.net with esmtp (Exim) id 1JPy98-0004B5-QN; Fri, 15 Feb 2008 10:50:22 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 9732E27405A; Fri, 15 Feb 2008 10:50:22 +0000 (GMT) Message-ID: <47B56E6E.2010303@archonet.com> Date: Fri, 15 Feb 2008 10:50:22 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: Bart Degryse CC: PostgreSQL SQL List Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be><47B556E6.8090200@archonet.co m><47B56F0B.A3DD.0030.0@indicator.be> <47B56651.9050600@archonet.com> <47B5798B.A3DD.0030.0@indicator.be> In-Reply-To: <47B5798B.A3DD.0030.0@indicator.be> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 95caa101053300f916dd4a267558a6f4 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/119 X-Sequence-Number: 30210 Bart Degryse wrote: >>>> Richard Huxton 2008-02-15 11:15 >>> >> Dont' forget to cc: the list Bart :-) > > My mistake, sorry. Normally I only reply to the list and not to the respondent's personal address. > Would that be wrong too? Well, some people prefer to reply directly from their inbox, others directly from the list. The convention on the PG lists is reply-to-all. Making sure the list is copied gives others the chance to add to the discussion. >> To see how e.g. \dC etc work start psql with -E >> > I'm sorry, but I don't have commandline access to the database. That would > require an amount of trust and a level of competence our ICT department is incapable of. Well, if you have access to prt 5432 (or whatever you are using) on the DB host you can run psql locally: psql -h As a last resort you can always see how they work on a local copy, then cut + paste the SQL. -- Richard Huxton Archonet Ltd From Bart.Degryse@indicator.be Fri Feb 15 11:05:54 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 547152E0096 for ; Fri, 15 Feb 2008 07:05:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 61057-05 for ; Fri, 15 Feb 2008 07:05:45 -0400 (AST) Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3]) by postgresql.org (Postfix) with ESMTP id 296212E0062 for ; Fri, 15 Feb 2008 07:05:50 -0400 (AST) Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Fri, 15 Feb 2008 12:05:48 +0100 Message-Id: <47B58012.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Fri, 15 Feb 2008 12:05:39 +0100 From: "Bart Degryse" To: "Richard Huxton" , "PostgreSQL SQL List" Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be><47B556E6.8090200@archonet.co m><47B56F0B.A3DD.0030.0@indicator.be> <47B56651.9050600@archonet.com><47B5798B.A3DD.0030.0@indicator.be><47B5798B .A3DD.0030.0@indicator.be><47B56E6E.2010303@archonet.com> In-Reply-To: <47B56E6E.2010303@archonet.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__PartFBDD0413.1__=" X-imss-version: 2.049 X-imss-result: Passed X-imss-approveListMatch: *@indicator.be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/120 X-Sequence-Number: 30211 --=__PartFBDD0413.1__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable >>>> Richard Huxton 2008-02-15 11:50 >>> >>> To see how e.g. \dC etc work start psql with -E >>> >> I'm sorry, but I don't have commandline access to the database. That = would >> require an amount of trust and a level of competence our ICT department = is incapable of. > >Well, if you have access to prt 5432 (or whatever you are using) on = the=20 >DB host you can run psql locally: psql -h =20 All I have is my desktop Windows pc. I work on the database using EMS SQL = Manager for PostgreSQL. There I can run whatever statement I want, but it's not psql. What do you exactly mean with "run psql locally"? Should I be able to run = some psql.exe from my windows cmd environment. Or should I start something else first? >As a last resort you can always see how they work on a local copy, = then=20 >cut + paste the SQL. Here too, I don't know what you mean exactly with "a local copy". --=__PartFBDD0413.1__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML
>>>> Richard Huxton <dev@archonet.com> 2008-02-15 = 11:50 >>>
>>> To see how e.g. \dC etc work start psql = with -E
>>>
>> I'm sorry, but I don't have commandline= access to the database. That would
>> require an amount of trust = and a level of competence our ICT department is incapable of.
>
&g= t;Well, if you have access to prt 5432 (or whatever you are using) on the =
>DB host you can run psql locally: psql -h <db-hostname>
=
 
All I have is my desktop Windows pc. I work on the database using EMS = SQL Manager for PostgreSQL.
There I can run whatever statement I want, but it's not psql.
What do you exactly mean with "run psql locally"? Should I be able to = run some psql.exe
from my windows cmd environment. Or should I start something else = first?

>As a last resort you can always see how they work on a = local copy, then
>cut + paste the SQL.
Here too, I don't know what you mean exactly with "a local copy".
<= /DIV> --=__PartFBDD0413.1__=-- From dev@archonet.com Fri Feb 15 11:18:03 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8ABAE2E005F for ; Fri, 15 Feb 2008 07:18:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69844-10 for ; Fri, 15 Feb 2008 07:17:58 -0400 (AST) Received: from pih-relay08.plus.net (pih-relay08.plus.net [212.159.14.134]) by postgresql.org (Postfix) with ESMTP id 9BE8C2E0056 for ; Fri, 15 Feb 2008 07:17:58 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay08.plus.net with esmtp (Exim) id 1JPyZo-0003yJ-2V; Fri, 15 Feb 2008 11:17:56 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id E171027405F; Fri, 15 Feb 2008 11:17:55 +0000 (GMT) Message-ID: <47B574E3.9070401@archonet.com> Date: Fri, 15 Feb 2008 11:17:55 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: Bart Degryse CC: PostgreSQL SQL List Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be><47B556E6.8090200@archonet.co m><47B56F0B.A3DD.0030.0@indicator.be> <47B56651.9050600@archonet.com><47B5798B.A3DD.0030.0@indicator.be><47B5798B .A3DD.0030.0@indicator.be><47B56E6E.2010303@archonet.com> <47B58012.A3DD.0030.0@indicator.be> In-Reply-To: <47B58012.A3DD.0030.0@indicator.be> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 3d1ae9d75fcc43e00f7b2a9124ce8f2a X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/121 X-Sequence-Number: 30212 Bart Degryse wrote: >>>>> Richard Huxton 2008-02-15 11:50 >>> >>>> To see how e.g. \dC etc work start psql with -E >>>> >>> I'm sorry, but I don't have commandline access to the database. That would >>> require an amount of trust and a level of competence our ICT department is incapable of. >> Well, if you have access to prt 5432 (or whatever you are using) on the >> DB host you can run psql locally: psql -h > > All I have is my desktop Windows pc. I work on the database using EMS SQL Manager for PostgreSQL. > There I can run whatever statement I want, but it's not psql. > What do you exactly mean with "run psql locally"? Should I be able to run some psql.exe > from my windows cmd environment. Or should I start something else first? Well, the windows installer comes with the backend database server, psql.exe, pgadmin, manuals etc. - I don't know if you can just install psql. From psql you can access local or remote databases. Same for the pg_dump/restore command-line tools. Unless EMS is accessing the server via ODBC or similar it should just work. >> As a last resort you can always see how they work on a local copy, then >> cut + paste the SQL. > Here too, I don't know what you mean exactly with "a local copy". Install PostgreSQL locally, copy the schema from your main server and add some test data. -- Richard Huxton Archonet Ltd From gavinb@eclinic.com.au Fri Feb 15 11:47:28 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id ADEFE2E0052 for ; Fri, 15 Feb 2008 07:47:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 72222-05 for ; Fri, 15 Feb 2008 07:47:18 -0400 (AST) Received: from panda.hostingbay.net (panda.hostingbay.net [74.86.150.75]) by postgresql.org (Postfix) with ESMTP id 4FC392E00D9 for ; Fri, 15 Feb 2008 07:47:23 -0400 (AST) Received: from cpe-121-223-230-214.static.vic.bigpond.net.au ([121.223.230.214] helo=[192.168.1.199]) by panda.hostingbay.net with esmtpa (Exim 4.68) (envelope-from ) id 1JPz2C-0007Bh-Rw; Fri, 15 Feb 2008 22:47:17 +1100 Message-ID: <47B57BA3.6040508@eclinic.com.au> Date: Fri, 15 Feb 2008 22:46:43 +1100 From: Gavin 'Beau' Baumanis Organization: PalCare Pty Ltd User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: Bart Degryse CC: Richard Huxton , PostgreSQL SQL List Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be><47B556E6.8090200@archonet.co m><47B56F0B.A3DD.0030.0@indicator.be> <47B56651.9050600@archonet.com><47B5798B.A3DD.0030.0@indicator.be><47B5798B .A3DD.0030.0@indicator.be><47B56E6E.2010303@archonet.com> <47B58012.A3DD.0030.0@indicator.be> In-Reply-To: <47B58012.A3DD.0030.0@indicator.be> Content-Type: multipart/mixed; boundary="------------040805020905070400060603" X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - panda.hostingbay.net X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - eclinic.com.au X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/123 X-Sequence-Number: 30214 This is a multi-part message in MIME format. --------------040805020905070400060603 Content-Type: multipart/alternative; boundary="------------050403020308070606050702" --------------050403020308070606050702 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi Bart, Bart Degryse wrote: > >>>> Richard Huxton 2008-02-15 11:50 >>> > >>> To see how e.g. \dC etc work start psql with -E > >>> > >> I'm sorry, but I don't have commandline access to the database. > That would > >> require an amount of trust and a level of competence our ICT > department is incapable of. > > > >Well, if you have access to prt 5432 (or whatever you are using) on the > >DB host you can run psql locally: psql -h > > All I have is my desktop Windows pc. I work on the database using EMS > SQL Manager for PostgreSQL. > There I can run whatever statement I want, but it's not psql. > What do you exactly mean with "run psql locally"? Should I be able to > run some psql.exe > from my windows cmd environment. Or should I start something else first? > The windows installer, available at; http://www.postgresql.org/ftp/win32/ Allows you to install the DB and / OR the tools including psql So you can just install the psql command line tool onto your local machine. Also, Could you ask for a restricted account on the box that runs the DB? Ie an account that only has access to the DB tools and DB you require to use? I use ssh with a limited account to access a postgesql DB running on debian. My account on the server only allows me access to my "home" directory (think your own documents and settings folder - if you're a windows only user...) on the server and the DB's that I have a requirement to use. > >As a last resort you can always see how they work on a local copy, then > >cut + paste the SQL. > Here too, I don't know what you mean exactly with "a local copy". Download the the whole PostreSQL package; http://www.postgresql.org/ftp/win32/ The following link however is a good place to start it contains some really good information and the same link above to download the windows version of PostgreSQL. http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html Then run an instance of PostgreSQL on your desktop PC. That way you have "local" access to the DB and all of it's tools too. You can "play around" with it to your hearts content, run SQL "scenarios" / test functions etc on your own copy of the DB. Then when you're happy - perform the "locally tested" SQL upon your production DB via your admin tool of choice. Hope this helps. -- If I can ever be of any further assistance, please contact me. Gavin 'Beau' Baumanis PalCare Pty Ltd 657 Nicholson Street Carlton North Victoria 3054 Australia P: +61 3 9381 4567 F: +61 3 9381 4657 M: +61 438 545 586 E: beau@palcare.com.au W: http://www.palcare.com.au --------------050403020308070606050702 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi Bart,

Bart Degryse wrote:
>>>> Richard Huxton <dev@archonet.com> 2008-02-15 11:50 >>>
>>> To see how e.g. \dC etc work start psql with -E
>>>
>> I'm sorry, but I don't have commandline access to the database. That would
>> require an amount of trust and a level of competence our ICT department is incapable of.
>
>Well, if you have access to prt 5432 (or whatever you are using) on the
>DB host you can run psql locally: psql -h <db-hostname>
 
All I have is my desktop Windows pc. I work on the database using EMS SQL Manager for PostgreSQL.
There I can run whatever statement I want, but it's not psql.
What do you exactly mean with "run psql locally"? Should I be able to run some psql.exe
from my windows cmd environment. Or should I start something else first?

The windows installer, available at;
http://www.postgresql.org/ftp/win32/

Allows you to install the DB and / OR the tools including psql
So you can just install the psql command line tool onto your local machine.

Also,
Could you ask for a restricted account on the box that runs the DB?
Ie an account that only has access to the DB tools and DB you require to use?

I use ssh with a limited account to access a postgesql DB running on debian.
My account on the server only allows me access to my "home" directory (think your own documents and settings folder - if you're a windows only user...) on the server and the DB's that I have a requirement to use.
>As a last resort you can always see how they work on a local copy, then
>cut + paste the SQL.
Here too, I don't know what you mean exactly with "a local copy".
Download the the whole PostreSQL package;
http://www.postgresql.org/ftp/win32/

The following link however is a good place to start it contains some really good information and the same link above to download the windows version of PostgreSQL.
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html

Then run an instance of PostgreSQL on your desktop PC.
That way you have "local" access to the DB and all of it's tools too.
You can "play around" with it to your hearts content, run SQL "scenarios" / test functions etc on your own copy of the DB.

Then when you're happy - perform the "locally tested" SQL upon your production DB via your admin tool of choice.

Hope this helps.

-- 
If I can ever be of any further assistance, please contact me.

Gavin 'Beau' Baumanis

PalCare Pty Ltd

657 Nicholson Street
Carlton North
Victoria 3054
Australia

P: +61 3 9381 4567
F: +61 3 9381 4657

M: +61 438 545 586
E: beau@palcare.com.au

W: http://www.palcare.com.au
--------------050403020308070606050702-- --------------040805020905070400060603 Content-Type: text/x-vcard; charset=utf-8; name="gavinb.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="gavinb.vcf" begin:vcard fn:Gavin 'Beau' Baumanis n:Baumanis;Gavin 'Beau' org:PalCare Pty. Ltd adr:;;657 Nicholson Street;Carlton North;;3054;Australia email;internet:beau@palcare.com.au title:Senior Application Developer tel;work:+61 -3 9381 4567 tel;cell:+61 -438 545 586 note;quoted-printable:Certified Novell Engineer (CNE)=0D=0A= Certified Microsoft Engineer (MCSE)=0D=0A= Post Graduate Certificate( IT Systems)=0D=0A= Trade Qualified: Electronics Technician x-mozilla-html:TRUE url:http://www.palcare.com.au version:2.1 end:vcard --------------040805020905070400060603-- From Bart.Degryse@indicator.be Fri Feb 15 12:19:05 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 700022E00DC for ; Fri, 15 Feb 2008 08:19:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 62145-07-2 for ; Fri, 15 Feb 2008 08:18:54 -0400 (AST) Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3]) by postgresql.org (Postfix) with ESMTP id 9D7EF2E00E5 for ; Fri, 15 Feb 2008 08:18:58 -0400 (AST) Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Fri, 15 Feb 2008 13:18:56 +0100 Message-Id: <47B59136.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Fri, 15 Feb 2008 13:18:47 +0100 From: "Bart Degryse" To: "PostgreSQL SQL List" Cc: "Richard Huxton" Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be><47B556E6.8090200@archonet.co m><47B56F0B.A3DD.0030.0@indicator.be> <47B56651.9050600@archonet.com><47B 5798B.A3DD.0030.0@indicator.be><47B5798B .A3DD.0030.0@indicator.be><47B56E6 E.2010303@archonet.com><47B58012.A3DD.0030.0@indicator.be><47B58012.A3DD.0030.0@indicator.be><47B574E3.9070401@archonet.com> In-Reply-To: <47B574E3.9070401@archonet.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part2E08D137.1__=" X-imss-version: 2.049 X-imss-result: Passed X-imss-approveListMatch: *@indicator.be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/125 X-Sequence-Number: 30216 --=__Part2E08D137.1__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable I can't install applications on my desktop pc ICT won't install that application on my desktop pc... that would require an amout of trust and... >>> Richard Huxton 2008-02-15 12:17 >>> Well, the windows installer comes with the backend database server,=20 psql.exe, pgadmin, manuals etc. - I don't know if you can just install=20 psql. From psql you can access local or remote databases. Same for the=20 pg_dump/restore command-line tools. Unless EMS is accessing the server=20 via ODBC or similar it should just work. >> As a last resort you can always see how they work on a local copy, = then=20 >> cut + paste the SQL. > Here too, I don't know what you mean exactly with "a local copy". Install PostgreSQL locally, copy the schema from your main server and=20 add some test data. --=20 Richard Huxton Archonet Ltd --=__Part2E08D137.1__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML
I can't install applications on my desktop pc
ICT won't install that application on my desktop pc... that would = require
an amout of trust and...

>>> Richard Huxton <dev@ar= chonet.com> 2008-02-15 12:17 >>>
Well, the windows = installer comes with the backend database server,
psql.exe, pgadmin, = manuals etc. - I don't know if you can just install
psql. From psql = you can access local or remote databases. Same for the
pg_dump/restore = command-line tools. Unless EMS is accessing the server
via ODBC or = similar it should just work.

>> As a last resort you can = always see how they work on a local copy, then
>> cut + paste = the SQL.
> Here too, I don't know what you mean exactly with "a = local copy".

Install PostgreSQL locally, copy the schema from your = main server and
add some test data.

--
   Richard = Huxton
   Archonet Ltd
--=__Part2E08D137.1__=-- From Bart.Degryse@indicator.be Fri Feb 15 12:21:39 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 012752E00DD for ; Fri, 15 Feb 2008 08:21:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 85634-01 for ; Fri, 15 Feb 2008 08:21:27 -0400 (AST) Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3]) by postgresql.org (Postfix) with ESMTP id EDE562E002D for ; Fri, 15 Feb 2008 08:21:28 -0400 (AST) Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Fri, 15 Feb 2008 13:21:26 +0100 Message-Id: <47B591CD.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Fri, 15 Feb 2008 13:21:17 +0100 From: "Bart Degryse" To: "PostgreSQL SQL List" Cc: "Richard Huxton" , "Gavin 'Beau' Baumanis" Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be><47B556E6.8090200@archonet.co m><47B56F0B.A3DD.0030.0@indicator.be> <47B56651.9050600@archonet.com><47B 5798B.A3DD.0030.0@indicator.be><47B5798B .A3DD.0030.0@indicator.be><47B56E6 E.2010303@archonet.com><47B58012.A3DD.0030.0@indicator.be><47B58012.A3DD.00 30.0@indicator.be><47B57BA3.6040508@eclinic.com.au> In-Reply-To: <47B57BA3.6040508@eclinic.com.au> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__PartB4924BAD.2__=" X-imss-version: 2.049 X-imss-result: Passed X-imss-approveListMatch: *@indicator.be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/126 X-Sequence-Number: 30217 --=__PartB4924BAD.2__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable >>> Gavin 'Beau' Baumanis 2008-02-15 12:46 >>> >The windows installer, available at; >http://www.postgresql.org/ftp/win32/=20 >Allows you to install the DB and / OR the tools including psql >So you can just install the psql command line tool onto your local = machine. I can't install applications on my desktop pc ICT won't install that application on my desktop pc... that would require an amout of trust and... >Also,=20 >Could you ask for a restricted account on the box that runs the DB? >Ie an account that only has access to the DB tools and DB you require to = use? =20 I can certainly ask, but I will not get it...that would require an amout of trust and... --=__PartB4924BAD.2__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML
>>> Gavin 'Beau' Baumanis <gavinb@eclinic.com.au> = 2008-02-15 12:46 >>>
>The windows installer, available = at;
>http://www.postgresql.org/ftp/win32/
>Allows you = to install the DB and / OR the tools including psql
>So you can just = install the psql command line tool onto your local machine.
I can't install applications on my desktop pc
ICT won't install that application on my desktop pc... that would = require
an amout of trust and...

>Also,
>Could you ask for a = restricted account on the box that runs the DB?
>Ie an account that = only has access to the DB tools and DB you require to use?
 
I can certainly ask, but I will not get it...that would require
an amout of trust and...

--=__PartB4924BAD.2__=-- From gavinb@eclinic.com.au Fri Feb 15 12:33:50 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 548382E0098 for ; Fri, 15 Feb 2008 08:33:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 11765-09 for ; Fri, 15 Feb 2008 08:33:36 -0400 (AST) Received: from panda.hostingbay.net (panda.hostingbay.net [74.86.150.75]) by postgresql.org (Postfix) with ESMTP id 4B3D72E0094 for ; Fri, 15 Feb 2008 08:33:43 -0400 (AST) Received: from cpe-121-223-230-214.static.vic.bigpond.net.au ([121.223.230.214] helo=[192.168.1.199]) by panda.hostingbay.net with esmtpa (Exim 4.68) (envelope-from ) id 1JPzl3-0002Vw-Kx; Fri, 15 Feb 2008 23:33:38 +1100 Message-ID: <47B58682.6040402@eclinic.com.au> Date: Fri, 15 Feb 2008 23:33:06 +1100 From: Gavin 'Beau' Baumanis Organization: PalCare Pty Ltd User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: Bart Degryse CC: PostgreSQL SQL List Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be><47B556E6.8090200@archonet.co m><47B56F0B.A3DD.0030.0@indicator.be> <47B56651.9050600@archonet.com><47B 5798B.A3DD.0030.0@indicator.be><47B5798B .A3DD.0030.0@indicator.be><47B56E6 E.2010303@archonet.com><47B58012.A3DD.0030.0@indicator.be><47B58012.A3DD.00 30.0@indicator.be><47B57BA3.6040508@eclinic.com.au> <47B591CD.A3DD.0030.0@indicator.be> In-Reply-To: <47B591CD.A3DD.0030.0@indicator.be> Content-Type: multipart/mixed; boundary="------------010505050501080207080606" X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - panda.hostingbay.net X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - eclinic.com.au X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/127 X-Sequence-Number: 30218 This is a multi-part message in MIME format. --------------010505050501080207080606 Content-Type: multipart/alternative; boundary="------------040602050305040405010603" --------------040602050305040405010603 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Bart, You just need to put forward an appropriate case. It isn't a case of I would like these things. It is, I MUST have these things in order to perform my job. I MUST have a local / development database for testing and educational / learning purposes - unless of course you would like me to use the production server for testing? It isn't up to ICT to tell you what you can and can't have... Sure, they have a role to play - to keep the servers / desktops running - but they don't make policy - just enforce it. you can bet that in order to perform their tasks they have a collection of tools and programs they use. You NEED / MUST have these things in order to successfully do yours. I would speak to my supervisor / manager and get him/her to direct the ICT group to perform the necessary tasks so as to allow you to competently complete your duties - if you don't get any joy out of talking to them yourself first. Always give them the benefit of doubt and ask first. You just may well be surprised. Not to mention it you gives some ammunition with your manager to say; "I have already asked ICT myself but they are unwilling to assist - can you direct them to provide the things I need?". Bart Degryse wrote: > >>> Gavin 'Beau' Baumanis 2008-02-15 12:46 >>> > >The windows installer, available at; > >http://www.postgresql.org/ftp/win32/ > >Allows you to install the DB and / OR the tools including psql > >So you can just install the psql command line tool onto your local > machine. > I can't install applications on my desktop pc > ICT won't install that application on my desktop pc... that would require > an amout of trust and... > > >Also, > >Could you ask for a restricted account on the box that runs the DB? > >Ie an account that only has access to the DB tools and DB you require > to use? > > I can certainly ask, but I will not get it...that would require > an amout of trust and... > -- If I can ever be of any further assistance, please contact me. Gavin 'Beau' Baumanis PalCare Pty Ltd 657 Nicholson Street Carlton North Victoria 3054 Australia P: +61 3 9381 4567 F: +61 3 9381 4657 M: +61 438 545 586 E: beau@palcare.com.au W: http://www.palcare.com.au --------------040602050305040405010603 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Bart,

You just need to put forward an appropriate case.

It isn't a case of I would like these things.
It is,
I MUST have these things in order to perform my job.

I MUST have a local / development database for testing and educational / learning  purposes - unless of course you would like me to use the production server for testing?

It isn't up to ICT to tell you what you can and can't have... Sure, they have a role to play - to keep the servers / desktops running - but they don't make policy - just enforce it.
you can bet that in order to perform their tasks they have a collection of tools and programs they use.

You NEED / MUST have these things in order to successfully do yours.

I would speak to my supervisor / manager and get him/her to direct the ICT group to perform the necessary tasks so as to allow you to competently complete your duties - if you don't get any joy out of talking to them yourself first.

Always give them the benefit of doubt and ask first. You just may well be surprised.
Not to mention it you gives some ammunition with your manager to say;
"I have already asked ICT myself but they are unwilling to assist - can you direct them to provide the things I need?".


Bart Degryse wrote:
>>> Gavin 'Beau' Baumanis <gavinb@eclinic.com.au> 2008-02-15 12:46 >>>
>The windows installer, available at;
>http://www.postgresql.org/ftp/win32/
>Allows you to install the DB and / OR the tools including psql
>So you can just install the psql command line tool onto your local machine.
I can't install applications on my desktop pc
ICT won't install that application on my desktop pc... that would require
an amout of trust and...

>Also,
>Could you ask for a restricted account on the box that runs the DB?
>Ie an account that only has access to the DB tools and DB you require to use?
 
I can certainly ask, but I will not get it...that would require
an amout of trust and...


-- 
If I can ever be of any further assistance, please contact me.

Gavin 'Beau' Baumanis

PalCare Pty Ltd

657 Nicholson Street
Carlton North
Victoria 3054
Australia

P: +61 3 9381 4567
F: +61 3 9381 4657

M: +61 438 545 586
E: beau@palcare.com.au

W: http://www.palcare.com.au
--------------040602050305040405010603-- --------------010505050501080207080606 Content-Type: text/x-vcard; charset=utf-8; name="gavinb.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="gavinb.vcf" begin:vcard fn:Gavin 'Beau' Baumanis n:Baumanis;Gavin 'Beau' org:PalCare Pty. Ltd adr:;;657 Nicholson Street;Carlton North;;3054;Australia email;internet:beau@palcare.com.au title:Senior Application Developer tel;work:+61 -3 9381 4567 tel;cell:+61 -438 545 586 note;quoted-printable:Certified Novell Engineer (CNE)=0D=0A= Certified Microsoft Engineer (MCSE)=0D=0A= Post Graduate Certificate( IT Systems)=0D=0A= Trade Qualified: Electronics Technician x-mozilla-html:TRUE url:http://www.palcare.com.au version:2.1 end:vcard --------------010505050501080207080606-- From Bart.Degryse@indicator.be Fri Feb 15 13:00:38 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E2AEF2E011E for ; Fri, 15 Feb 2008 09:00:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 06950-02-3 for ; Fri, 15 Feb 2008 09:00:23 -0400 (AST) Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3]) by postgresql.org (Postfix) with ESMTP id 3F1FB2E0118 for ; Fri, 15 Feb 2008 09:00:27 -0400 (AST) Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Fri, 15 Feb 2008 14:00:25 +0100 Message-Id: <47B59AF0.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Fri, 15 Feb 2008 14:00:17 +0100 From: "Bart Degryse" To: "Gavin 'Beau' Baumanis" Cc: "PostgreSQL SQL List" Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be><47B556E6.8090200@archonet.co m><47B56F0B.A3DD.0030.0@indicator.be> <47B56651.9050600@archonet.com><47 B 5798B.A3DD.0030.0@indicator.be><47B5798B .A3DD.0030.0@indicator.be><47B56 E6 E.2010303@archonet.com><47B58012.A3DD.0030.0@indicator.be><47B58012.A3DD .00 30.0@indicator.be><47B57BA3.6040508@eclinic.com.au><47B591CD.A3DD.0030. 0@indicator.be><47B591CD.A3DD.0030.0@indicator.be><47B58682.6040402@eclinic.com.au> In-Reply-To: <47B58682.6040402@eclinic.com.au> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__PartE7C118F1.1__=" X-imss-version: 2.049 X-imss-result: Passed X-imss-approveListMatch: *@indicator.be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/128 X-Sequence-Number: 30219 --=__PartE7C118F1.1__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable >>> Gavin 'Beau' Baumanis 2008-02-15 13:33 >>> >I MUST have a local / development database for testing and educational / = learning purposes - unless of course you would like me to use the = production server for testing? I do have a development database, but not locally. And I don't have psql. =20 >It isn't up to ICT to tell you what you can and can't have... Sure, they = have a role to play - to keep the servers / desktops running - but they = don't make policy - just enforce it. In our company they do. =20 >you can bet that in order to perform their tasks they have a collection = of tools and programs they use. =20 Of course they do. >You NEED / MUST have these things in order to successfully do yours. =20 Uptil now, I haven't felt that lacking the use of psql has prevented me in = doing my job. Of course sometimes it would be nice to=20 have it, but not necessary. >I would speak to my supervisor / manager and get him/her to direct the = ICT group to perform=20 >the necessary tasks so as to allow you to competently complete your = duties - if=20 >you don't get any joy out of talking to them yourself first. =20 Officially their manager and my manager have the same level in the = company's hierarchy. But in reality they run the company as far as anything related to = technology is concerned, and we are at best tolerated. And if you were to ask "So why do you stick to that company"... In the region I live there are very few companies offering jobs like mine. There is one very big one with lots of jobs, but since they are semi-gouver= nmental, they are not free in setting the wages, so basically they pay much less than private = companies. The alternative is to go work farther from home (meaning in the capital). = There are lots of jobs there, but they also imply that - I will spend some 2.5 to 3 hours in traffic jams per day. - I won't be able to bring my children to school each morning (I will have = to leave home much earlier to get to the capital in time) - I won't be able to pick up my children from school on wednesday noons = (too far) - I won't be able to walk my dog at noon (too far) - I will hardly see my children in the evening: by the time I get home, = it's bedtime for them So however annoying the situation on this job may be, it's hardly = impossible to find an=20 equally well paid job as close to home (a 5 minute drive) as this one. =20 --=__PartE7C118F1.1__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML
>>> Gavin 'Beau' Baumanis <gavinb@eclinic.com.au> = 2008-02-15 13:33 >>>
>I MUST have a local / development database for testing and = educational / learning  purposes - unless of course you would like me = to use the production server for testing?
I do have a development = database, but not locally. And I don't have psql.
 
>It isn't up to ICT = to tell you what you can and can't have... Sure, they have a role to play = - to keep the servers / desktops running - but they don't make policy - = just enforce it.
In our company they = do.
 
>you can bet that in = order to perform their tasks they have a collection of tools and programs = they use.
 
Of course they do.

>You NEED / MUST have = these things in order to successfully do yours.
 
Uptil now, I haven't = felt that lacking the use of psql has prevented me in doing my job. Of = course sometimes it would be nice to
have it, but not = necessary.

>I would speak to my supervisor / manager and get him/her to = direct the ICT group to perform
>the necessary tasks so as to allow you to competently complete = your duties - if
>you don't get any joy out of talking to them yourself first.
=
 
Officially their manager and my manager have the same level in the = company's hierarchy.
But in reality they run the company as far as anything related to = technology is concerned,
and we are at best tolerated.

And if you were to ask "So = why do you stick to that company"...
In the region I live there are very few companies offering jobs like = mine.
There is one very big one with lots of jobs, but since they are = semi-gouvernmental, they are not
free in setting the wages, so basically they pay much less than = private companies.
The alternative is to go work farther from home (meaning in the = capital). There are lots
of jobs there, but they also imply that
- I will spend some 2.5 to 3 hours in traffic jams per day.
- I won't be able to bring my children to school each morning (I will = have to leave home much earlier to get to the capital in time)
- I won't be able to pick up my children from school on wednesday = noons (too far)
- I won't be able to walk my dog at noon (too far)
- I will hardly see my children in the evening: by the time I get = home, it's bedtime for them
So however annoying the situation on this job may be, it's hardly = impossible to find an
equally well paid job as close to home (a 5 minute drive) as = this one.
 
--=__PartE7C118F1.1__=--