[GENERAL] Will you please help with my research on OSS work...

2010-05-30 Thread Geoff Breach
Hi All, I'm Geoff, a long time postgresql user and been a reasonably regular participant on #gentoo and #postgresql on freenode for several years now, helping out new folks where I can. I'm a student (phd) at the University of Technology, Sydney in Australia. (I've also been a subscriber to this

Re: [GENERAL] Fedora 13 and yum.pgsqlrpms.org

2010-05-30 Thread Devrim GÜNDÜZ
On Sat, 2010-05-29 at 13:18 -0400, Jerry LeVan wrote: > > Will the repository be updated for Fedora 13 in the > near future :) > > I had to disable the repo because yumex croaks when it > cannot find the repository. FWIW, I pushed Fedora-13 packages to my repository: http://yum.pgrpms.org/news-

Re: [GENERAL] vulnerability of COPY command

2010-05-30 Thread Adrian von Bidder
Heyho! On Monday 31 May 2010 04.18:04 Dennis Gearon wrote: > One thing, can prepared statements be done, including the 'execute', > inside of a transaction, and what are the side effects? Semantically, the statement is exactly like a "not prepared" statement: it happens at execute time, the rest

Re: [GENERAL] vulnerability of COPY command

2010-05-30 Thread Dennis Gearon
Well, I will use COPY with some confidence, then. And really look into the proper escaping. For now, though, I will use prepared statements. One thing, can prepared statements be done, including the 'execute', inside of a transaction, and what are the side effects? BTW, speaking of SQL injectio

[GENERAL] PGCon 2010 pictures available

2010-05-30 Thread Oleg Bartunov
Hi there, I finally managed to publish selected pictures from developers meeting and PGCon 2010 closing session. The URL is http://www.flickr.com/photos/obartunov/sets/72157624042768831/ To see full size photo click on "All sizes", then "Original". I'd be happy to correct mistakes and add mis

[GENERAL] emitting custom INSERT, UPDATE, DELETE row_counts

2010-05-30 Thread Richard Broersma
I see it is possible in plpgsql to acquire a statments affect row_count: http://www.postgresql.org/docs/8.4/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS On the other hand, Is it possible to to emit row counts as well. I'm curious since I'm revisiting a problem with incorrectly di

Re: [GENERAL] Installing version 8.4

2010-05-30 Thread Ashesh Vashi
Hi Bob, On Sun, May 30, 2010 at 8:41 PM, Bob Pawley wrote: > Hi Ashesh > > Where would I find initcluster.vbs ? > Installer calls initcluster.vbs after creating user. I want to know the output of that script in the log file. -- Ashesh Vashi EnterpriseDB INDIA: www.enterprisedb.com > > Bob

[GENERAL] Re: [GENERAL] Re: [GENERAL] hi,for help!

2010-05-30 Thread zhenyang guo
hi ,it turn out i indeed deleted the postgres , and with the command "psql template1 create database postgres; " i got my postgres. Scott , Ashesh ,thanks for your both help . 2010/5/30 Scott Marlowe > On Sat, May 29, 2010 at 6:35 PM, zhenyang guo > wrote: > > hi ,i got a problem , kinda

Re: [GENERAL] Installing version 8.4

2010-05-30 Thread Bob Pawley
Hi Ashesh Where would I find initcluster.vbs ? Bob From: Ashesh Vashi Sent: Sunday, May 30, 2010 7:27 AM To: Bob Pawley Cc: adrian.kla...@gmail.com ; pgsql-general@postgresql.org Subject: Re: [GENERAL] Installing version 8.4 Hi Bob, On Sun, May 30, 2010 at 4:30 PM, Bob Pawley wrote:

Re: [GENERAL] Installing version 8.4

2010-05-30 Thread Ashesh Vashi
Hi Bob, On Sun, May 30, 2010 at 4:30 PM, Bob Pawley wrote: > Thanks for the vote of confidence Adrian. > > However, being 2 months shy of 68, there may be enough time left for me to > continue learning PostgreSQL/PostGIS and Delphi to accomplish what I want to > accomplish. > > I don't feel I sh

Re: [GENERAL] vulnerability of COPY command

2010-05-30 Thread Tom Lane
Pavel Stehule writes: > 2010/5/30 Dennis Gearon : >> If I build a text based, COPY file for bulk purposes, to be input via the >> command line, is Postgres vulnerable to SQL injection from that? > SQL database cannot be injected via NON SQL statemenst like COPY. Well, that depends. If you cons

[GENERAL] How do I elimitae ANY loggin to Windows Eventlog? 8.2.4.

2010-05-30 Thread Abraham, Danny
Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 danny_abra...@bmc.com

Re: [GENERAL] Installing version 8.4

2010-05-30 Thread Bob Pawley
Thanks for the vote of confidence Adrian. However, being 2 months shy of 68, there may be enough time left for me to continue learning PostgreSQL/PostGIS and Delphi to accomplish what I want to accomplish. I don't feel I should divert time to researching the intricacies of PostgreSQL install

Re: [GENERAL] vulnerability of COPY command

2010-05-30 Thread Martin Gainty
i have mixed feelings about parameterised statements. On the one hand a parameterised statement would be more difficult for a Wireshark criminal to insert their own c**p into a database because they would have to know the schema a-priori for example they would have to know the names of the da

Re: [GENERAL] vulnerability of COPY command

2010-05-30 Thread Pavel Stehule
Hello 2010/5/30 Dennis Gearon : > I'm trying to build a way to bulk load from a script to a Dbase, postgres. > > Using single, parameterized statements is a pretty good defense against SQL > injection, so I use Symfony as the main user input. > > But for this bulk loading, it's tooo slow. Ma