[SQL] Installing pgplsql on postgresql ver. 7.4 on os x 10.3

2003-12-29 Thread beyaRecords - The home Urban music
HI, after my initial message yesterday asking how to use stored procedures in postgresql, it has become clear to me that I need to run a script called createlang to install pgplsql into template 1 database. I am running postgresql 7.4 on os x 10.3. Postgresql is situated in directory /usr/local/

Re: [SQL] Installing pgplsql on postgresql ver. 7.4 on os x 10.3

2003-12-29 Thread Michael Fuhr
On Mon, Dec 29, 2003 at 03:13:56PM +, beyaRecords - The home Urban music wrote: > > after my initial message yesterday asking how to use stored procedures > in postgresql, it has become clear to me that I need to run a script > called createlang to install pgplsql into template 1 database. c

[SQL] 7.4.1 install problems on OS X 10.3

2003-12-29 Thread beyaRecords - The home Urban music
Hi, I have been forced to re-buid postgresql 7.4.1 but am encountering a problem when i do the following: 1. /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data the error I get is as follows: fixing permissions on existing directory /usr/local/pgsql/data... ok creating directory /usr/local/pgs

Re: [SQL] 7.4.1 install problems on OS X 10.3

2003-12-29 Thread Tom Lane
beyaRecords - The home Urban music <[EMAIL PROTECTED]> writes: > I have been forced to re-buid postgresql 7.4.1 but am encountering a > problem when i do the following: > creating template1 database in /usr/local/pgsql/data/base/1... FATAL: > could not create shared memory segment: Cannot alloc

[SQL] Get x from path/polygon?

2003-12-29 Thread Daniel Lau
Hi all, I succeed in extracting x and y value from POINT. Is it also possible to extract x and y value from PATH and POLYGON? I tried to get x and y from PATH using the similar method. However, the machine says the PATH is not an array and does not allow me to do so. Any hints on this? Thanks i