Re: [GENERAL] pg-9.1 for fedora 15 available?

2011-09-21 Thread Stuart McGraw
On 09/21/2011 02:25 AM, Devrim GÜNDÜZ wrote: > I just could not find time to upload F-15 - x86 packages. I just built > them. You can install via yum. Thanks! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

[GENERAL] pg-9.1 for fedora 15 available?

2011-09-20 Thread Stuart McGraw
I tried to use yum to install postgresql-9.1 on my Fedora 15 box by installing the yum conf file: rpm -ivh http://yum.pgrpms.org/reporpms/9.1/pgdg-fedora-9.1-3.noarch.rpm That was fine but when I then try to install postgresql, I get: http://yum.postgresql.org/9.1/fedora/fedora-15-i386/repoda

Re: [GENERAL] FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.?

2011-08-07 Thread Stuart McGraw
Hello Fernando, I was sorry to read the harsh responses your request got here. The thing that has always appealed to me about the free software movement is the spirit of cooperation and mutual help that many involved exhibit. You quite rightly point out the hypocrisy of those who call someo

Re: [GENERAL] FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.?

2011-08-06 Thread Stuart McGraw
Hello Fernando, I was sorry to read the harsh responses your request got here. The thing that has always appealed to me about the free software movement is the spirit of cooperation and mutual help that many involved exhibit. You quite rightly point out the hypocrisy of those who call someo

Re: [GENERAL] alter table add column - specify where the column will go?

2010-11-24 Thread Stuart McGraw
On 11/24/2010 03:32 AM, Peter Bex wrote: > On Wed, Nov 24, 2010 at 09:37:02AM +, Grzegorz Jaśkiewicz wrote: >> just never use SELECT *, but always call columns by names. You'll >> avoid having to depend on the order of columns, which is never >> guaranteed, even if the table on disk is one orde

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Stuart McGraw
On 11/21/2010 06:04 AM, Alban Hertroys wrote: > On 21 Nov 2010, at 24:17, Trevor Talbot wrote: > >>> I can't explain it any clearer, your email response goes to the mailing >>> list and that mailing list sends a copy to the original person thats how a >>> mailing list works. It also sends a copy

Re: [GENERAL] building a c function

2010-03-18 Thread Stuart McGraw
On 03/17/2010 01:56 PM, Carsten Kropf wrote: > I think, what you probably want to do is something like that: > MODULE_big = my_funcs > OBJS = myfunc.o mysubs.o > PG_CONFIG=/usr/local/pgsql/bin/pg_config > PGXS := $(shell $(PG_CONFIG) --pgxs) > include $(PGXS) > > Then you will get a shared library

[GENERAL] building a c function

2010-03-17 Thread Stuart McGraw
Hello all, I know this is a very elementary question, but my excuse is I have not programmed in C or written makefiles for 15+ years... I am trying to write a C-language function, call it my_func. But I also have a my_subs.o that does the heavy lifting for my_func.c. My makefile is: MODULES

Re: [GENERAL] Any justification for sequence table vs. native sequences?

2009-08-18 Thread Stuart McGraw
On 08/18/2009 01:14 PM, Doug Gorley wrote: I just stumbled across this table in a database developed by a collegue: field_name | next_value | lock +-+ id_alert| 500010 | FREE id_page | 500087 | FREE id_group| 500021 | FREE These "id

[GENERAL] 8.4 rpm packaging problem?

2009-08-16 Thread Stuart McGraw
Two problems installing the postgresql doc package,,, I just tried to install the 8.4 postgresql-docs and postgresql-contrib packages from the pgdg84 Fedora-11 yum repository and yum tried to install postresql-docs-8.4rc1 (rather than 8.4.0) from the pgdg repo. The exact sequence of events was t

Re: [GENERAL] psql language

2009-07-10 Thread Stuart McGraw
Hiroshi Saito wrote: > Is the state where you wish this? > > example > C:\Program Files\PostgreSQL\8.4\bin>psql -p 5433 postgres postgres > psql (8.4.0) > "help" でヘルプを表示します. > > C:\Program Files\PostgreSQL\8.4\bin>set LANG=C > > C:\Program Files\PostgreSQL\8.4\bin>psql -p 5433 postgres

[GENERAL] psql language

2009-07-09 Thread Stuart McGraw
Hello, I just installed pg-8.4 on Windows XP but ran into some unexpected problems. I am working on some tools to aid English-speaking learners of Japanese. This of course requires me to regularly display and enter Japanese text on my machine, so I have the Regional setting, "Language for no

Re: [GENERAL] Windows installer for pg-8.4 confusion

2009-07-06 Thread Stuart McGraw
Andreas Wenk wrote: > Stuart McGraw schrieb: >> First, thanks to everyone who contributed >> to 8.4 -- the new features list looks great! >> >> In the past I have always installed the >> Windows binary installer from postgresql.org. >> For pg-8.4 I see t

[GENERAL] Windows installer for pg-8.4 confusion

2009-07-06 Thread Stuart McGraw
First, thanks to everyone who contributed to 8.4 -- the new features list looks great! In the past I have always installed the Windows binary installer from postgresql.org. For pg-8.4 I see that the download directory now has a pointer to the EnterpriseDB "one click" installer. Has the Enterpri

Re: [GENERAL] Running untrusted sql safely?

2009-02-15 Thread Stuart McGraw
Scott Marlowe wrote: On Sun, Feb 15, 2009 at 3:09 PM, Stuart McGraw wrote: John R Pierce wrote: Stuart McGraw wrote: What is the best way to run an arbitrary query received from an untrusted source, safely? (I want a web page form with a textbox that a user can enter an arbitrary sql

Re: [GENERAL] Running untrusted sql safely?

2009-02-15 Thread Stuart McGraw
John R Pierce wrote: Stuart McGraw wrote: What is the best way to run an arbitrary query received from an untrusted source, safely? (I want a web page form with a textbox that a user can enter an arbitrary sql statement, then run it . just keep http://xkcd.com/327/ in mind. Yes

[GENERAL] Running untrusted sql safely?

2009-02-15 Thread Stuart McGraw
What is the best way to run an arbitrary query received from an untrusted source, safely? (I want a web page form with a textbox that a user can enter an arbitrary sql statement, then run it but I want to prevent therm from changing anything or escaping postgresql and executing system comman