Re: [GENERAL] Running initdb while logged in as Administrator user (Windows)

2008-09-18 Thread Daniel Futerman
> Look at psexec from Microsoft (former sysinternals). > http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx > You'll have to verify what the license says, but given that it's free > and comes from the guys that make Windows, it seems reasonable that it > should be doable. This looks li

Re: [GENERAL] Running initdb while logged in as Administrator user (Windows)

2008-09-18 Thread Daniel Futerman
n Riggs <[EMAIL PROTECTED]> wrote: > > On Thu, 2008-09-18 at 19:29 +0200, Daniel Futerman wrote: > > > silent install of PostgreSQL > > Please shout about it, don't hide it. And look at stackbuilder. > > -- > Simon Riggs www.2ndQuadrant.com > PostgreSQL Training, Services and Support > >

[GENERAL] Running initdb while logged in as Administrator user (Windows)

2008-09-18 Thread Daniel Futerman
I'm trying to develop an automated PostgreSQL installer for Windows that uses a silent install of PostgreSQL and batch scripts to initialise the database cluster (i.e. run initdb) and start/stop the db server. The install shouldn't install as a service, so initdb needs to be run manually. The prob

[GENERAL] User-Defined Variables

2008-07-10 Thread Daniel Futerman
Hi, Is there a quick solution to implementing user-defined variables in PostgreSQL as they are used in MySQL? I have the following MySQL script which i want to implement in Postgres (NOTE : all ` have been changed to " for Postgres use): SET @OTHER_CONCEPT_ID = (SELECT "concept_id" FROM "concept

[GENERAL] Update Join Query

2008-06-23 Thread Daniel Futerman
Hi, Looking for the correct syntax for an UPDATE LEFT JOIN query in PostgreSQL. The equivalent MySQL query is : UPDATE Foo f LEFT JOIN Goo g on f.Foo_ID = g.Goo_ID SET f.Foo_ID = g.Goo_ID WHERE f.Foo_ID IS NOT NULL; When I try to run this in Postgres, i get