[GENERAL] vulnerability of COPY command

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. If I build a text based, COPY file for bulk p

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

On Sat, May 29, 2010 at 6:35 PM, zhenyang guo wrote: > hi ,i got a problem , kinda don't know how to deal with it ,hoping can get > help here ,thanks ! >  also to Ashesh  ,firstly, thanks for every favor you did. and  the postgres > must exist ,maybe just present itself for some reason. when i giv

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

Hi, Looks like, you accidentally deleted the postgresql database. It can work without the postgres database, you just need to specify the database name to work with. i.e. psql test1 -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On

Re: [GENERAL] Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking

On Sat, May 29, 2010 at 8:21 PM, Richard Broersma wrote: > The following email was my first discovery that these kinds of > update-able view were not get-along well with client side optimistic > locking. > > http://archives.postgresql.org/pgsql-odbc/2006-12/msg00029.php Actually this link better

Re: [GENERAL] Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking

On Sat, May 29, 2010 at 6:25 PM, David Fetter wrote: >> I wondering if write-able CTE's will be the silver bullet that will >> make rule based update-able views based multiple vertically >> partitioned table robust.  By robust, I mean to elimination the >> update anomalies that can occur from the

Re: [GENERAL] Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking

David Fetter wrote: > On Sat, May 29, 2010 at 09:38:30PM -0400, Bruce Momjian wrote: > > David Fetter wrote: > > > On Sat, May 29, 2010 at 01:29:50PM -0700, Richard Broersma wrote: > > > > This might be a premature question considering write-able CTEs > > > > are not in core, but... > > > > > > >

Re: [GENERAL] Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking

On Sat, May 29, 2010 at 09:38:30PM -0400, Bruce Momjian wrote: > David Fetter wrote: > > On Sat, May 29, 2010 at 01:29:50PM -0700, Richard Broersma wrote: > > > This might be a premature question considering write-able CTEs > > > are not in core, but... > > > > > > I wondering if write-able CTE's

Re: [GENERAL] Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking

David Fetter wrote: > On Sat, May 29, 2010 at 01:29:50PM -0700, Richard Broersma wrote: > > This might be a premature question considering write-able CTEs are not > > in core, but... > > > > I wondering if write-able CTE's will be the silver bullet that will > > make rule based update-able views b

Re: [GENERAL] Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking

On Sat, May 29, 2010 at 01:29:50PM -0700, Richard Broersma wrote: > This might be a premature question considering write-able CTEs are not > in core, but... > > I wondering if write-able CTE's will be the silver bullet that will > make rule based update-able views based multiple vertically > parti

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

hi ,i got a problem , kinda don't know how to deal with it ,hoping can get help here ,thanks ! also to Ashesh ,firstly, thanks for every favor you did. and the postgres must exist ,maybe just present itself for some reason. when i give the command " psql -l template1 " it was there. <<<

Re: [GENERAL] Installing version 8.4

in windows you'll want to make sure you have at least read access to the binary %PG_HOME%\bin>attrib pg_ctl.exe make sure you implement the postgres binaries with the same username that postgres used to install the binary.. %PG_HOME%\bin>cacls.exe pg_ctl.exe Martin Gainty _

Re: [GENERAL] Installing version 8.4

On 5/29/2010 6:26 PM, Bob Pawley wrote: > Found it in XP it doesn't seem to exist in Windows 7. I can't even > find Doc and Settings in 7. > > It's a large file. I'm not sure what is needed but here is the latter > part of the file. > > Bob > ***Snip*** Windows 7 and vista move lots of things ar

Re: [GENERAL] Installing version 8.4

On Saturday 29 May 2010 4:26:08 pm Bob Pawley wrote: > Found it in XP it doesn't seem to exist in Windows 7. I can't even find Doc > and Settings in 7. > > It's a large file. I'm not sure what is needed but here is the latter part > of the file. > > Bob > Actually I was thinking you might want to

Re: [GENERAL] Installing version 8.4

Found it in XP it doesn't seem to exist in Windows 7. I can't even find Doc and Settings in 7. It's a large file. I'm not sure what is needed but here is the latter part of the file. Bob -- From: "Adrian Klaver" Sent: Saturday, May 29, 2010 3:

Re: [GENERAL] Installing version 8.4

On Saturday 29 May 2010 3:09:05 pm Bob Pawley wrote: > Hi > > I'm having problems installing PostgreSQL 8.4 on Windows 7. (See below) > > I downloaded the install from Enterprise DB. > > I attempted to install the same app on Windows XP. > > Both installs gave the same error message. > > Can anyone

[GENERAL] Installing version 8.4

Hi I'm having problems installing PostgreSQL 8.4 on Windows 7. (See below) I downloaded the install from Enterprise DB. I attempted to install the same app on Windows XP. Both installs gave the same error message. Can anyone point me to a PostgreSQL installation for Windows that works? Can an

Re: [GENERAL] Out of Memory and Configuration Problems (Big Computer)

Thanks Bill, That sounds like good advice. I am rerunning my query with the python function peppered with plpy.notice("msg") call. Hopefully that'll shed some light on which inputs it's crashing on. Does anyone know of a way to measure the memory being consumed by the function/query so that

[GENERAL] Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking

This might be a premature question considering write-able CTEs are not in core, but... I wondering if write-able CTE's will be the silver bullet that will make rule based update-able views based multiple vertically partitioned table robust. By robust, I mean to elimination the update anomalies th

Re: [GENERAL] child/parent creation

On Sat, May 29, 2010 at 11:05 AM, Dennis Gearon wrote: > Can the whole three level, 4 member hierarchy be created in one, prepared > statement(to avoid SQL injection), transaction without shuttling any > information back and forth between the database and the calling script? Not yet, but possi

Re: [GENERAL] child/parent creation

On 5/29/2010 1:05 PM, Dennis Gearon wrote: > Is it possible to create a complex schema object in one transaction, I'm not sure i understand what you mean by schema object > using prepared statements to protect(somewaht) against SQL injection? > In short no Prepared statements do not pro

[GENERAL] child/parent creation

Is it possible to create a complex schema object in one transaction, using prepared statements to protect(somewaht) against SQL injection? Example: A 'family tree object' (having obvious relationships) consisting of: Table grandparent Table parent table childA table childB If I have all the inf

Re: [GENERAL] Out of Memory and Configuration Problems (Big Computer)

On 5/28/10 8:43:48 PM, Tom Wilcox wrote: I ran this query: EXPLAIN ANALYZE UPDATE nlpg.match_data SET org = org; And I got this result: "Seq Scan on match_data (cost=0.00..9762191.68 rows=32205168 width=206) (actual time=76873.592..357450.519 rows=2961 loops=1)" "Total runtime: 8028212.36

[GENERAL] Fedora 13 and yum.pgsqlrpms.org

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. Jerry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

Re: [GENERAL] there is a way to deactivate type validation on 8.3.1????

On 05/28/2010 04:58 PM, Adrian Klaver wrote: On Friday 28 May 2010 1:34:24 pm erobles wrote: On 05/28/2010 03:18 PM, alvherre wrote: Excerpts from erobles's message of vie may 28 16:08:23 -0400 2010: it did'nt work :-( , because the script is for pg 8.2 and i have pg 7.

Re: [GENERAL] Error of text2ltree

Vu Hong Thuan writes: > I can't use text2ltree. Any suggestion? Thanks. > SELECT text2ltree('abc'). It's okay. But, got error if: > SELECT text2ltree(to_char(243, '0999')) > Error ** > ERROR: syntax error at position 0 SQL state: 42601 I think ltree doesn't allow spaces in the

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

[Adding pgsql-general...] Please CC to pgsql-general.. (Use reply-all...) On Sat, May 29, 2010 at 2:31 PM, zhenyang guo wrote: > hi,Ashesh, i did as you said ,it still gives problem. information from the > terminal is following: > > " postg...@guo-desktop:~$ psql -l > > psql: FATAL: databa

Re: [GENERAL] sintax error in script

On 29 May 2010, at 3:09, Luis Daniel Lucio Quiroz wrote: > pgsql is telling me /-- END has a sintax error, > just to confirm, is it okay if i get rid of that line? Yes, that's a syntax error alright, what did you intend to write there? A comment maybe? You should be fine just removing the '/' a