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

2008-09-18 Thread Merlin Moncure
On Thu, Sep 18, 2008 at 3:47 PM, Daniel Futerman <[EMAIL PROTECTED]> wrote: >> 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

Re: [GENERAL] Returning NEW in an on-delete trigger

2008-09-18 Thread Jeff Davis
On Thu, 2008-09-18 at 15:04 -0400, Tom Lane wrote: > This does seem like a bit of a gotcha for someone who writes RETURN NEW > instead of RETURN OLD or vice versa, but I'm not sure how much we can do > about that. Lots of people like to write triggers that fire on multiple > event types, so we cou

Re: [GENERAL] 8.3.3 stability ?

2008-09-18 Thread Robert Treat
On Thursday 18 September 2008 08:42:07 Gauthier, Dave wrote: > Great News. I just requested IS to get the 8.3.3 version. > One more question...Is there some sort of migration that I have to > do for existing DB's? Is it as drastic as a DB unload/load? Or > something simpler? > Upgrading fro

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
Thanks for the suggestion. Maybe i should rephrase my question : How does the Postgres (8.3) Installer manage to run initdb (when the installation is not installed as a service). When installing Postgres from the command line (the 'silent' install), initdb can only be run if installing as a servic

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

2008-09-18 Thread Magnus Hagander
Daniel Futerman wrote: > 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 need

Re: [GENERAL] Returning NEW in an on-delete trigger

2008-09-18 Thread Tom Lane
"Michael Nolan" <[EMAIL PROTECTED]> writes: > Recently I discovered a coding error of mine in a trigger that is called > only for deletes. > I was returning NEW instead of OLD. > Since NEW is undefined when deleting a row, it was failing and the row > wasn't being deleted. > However, it was failing

Re: [GENERAL] Returning NEW in an on-delete trigger

2008-09-18 Thread Jeff Davis
On Thu, 2008-09-18 at 14:21 -0400, Michael Nolan wrote: > Recently I discovered a coding error of mine in a trigger that is > called only for deletes. > > I was returning NEW instead of OLD. > > Since NEW is undefined when deleting a row, it was failing and the row > wasn't being deleted. In P

[GENERAL] Returning NEW in an on-delete trigger

2008-09-18 Thread Michael Nolan
Recently I discovered a coding error of mine in a trigger that is called only for deletes. I was returning NEW instead of OLD. Since NEW is undefined when deleting a row, it was failing and the row wasn't being deleted. However, it was failing silently. Shouldn't this have recorded an error or

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

2008-09-18 Thread Simon Riggs
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 -- Sent via pgsql-general mailing list (pgsql-gen

[GENERAL] Pg COnference: Call for Lightning Talks

2008-09-18 Thread Joshua Drake
While recently seeking feedback on the conference schedule from Josh Berkus and David Fetter I was asked, "Are there going to be lightning talks?". To which I replied, "What?". I know of lightning talks; in a similar manage of how I know of the existence of competitors to PostgreSQL. They are ther

[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

Re: [GENERAL] 8.3.3 stability ?

2008-09-18 Thread Gauthier, Dave
Great News. I just requested IS to get the 8.3.3 version. One more question...Is there some sort of migration that I have to do for existing DB's? Is it as drastic as a DB unload/load? Or something simpler? Thanks -Original Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] S

Re: [GENERAL] Backend timeout

2008-09-18 Thread Steve Clark
Scott Marlowe wrote: On Tue, Sep 16, 2008 at 7:21 AM, Dragan Ciric <[EMAIL PROTECTED]> wrote: Hi! We need some help. Sometimes we have broken connections with backend ( postgresql server ). When this occurs, we have "idle in transaction" indication on server side. Can you answer us, how long