Re: problem calling psql from another program - Mailing list pgsql-general

From Scott Marlowe
Subject Re: problem calling psql from another program
Date
Msg-id 1119624315.8208.70.camel@state.g2switchworks.com
Whole thread Raw
In response to problem calling psql from another program  (Frank Rittinger <gis@schnegg.net>)
List pgsql-general
On Fri, 2005-06-24 at 01:57, Frank Rittinger wrote:
> Hello list,
>
> I have PostgreSQL 8.0 on Windows Server 2000, and wrote a small .NET
> program that creates a subprocess that executes psql with a sql script
> as input (psql -U user -f script.sql).
>
> This script runs well if I start psql from the command line and execute
> it there.  But within the .NET program it behaves strange:  it never
> finishes but the server doesn't do anything.  When I kill the program
> with CTRL-C than it seams as if the script gets executed. (BTW this
> works fine under WinXP Pro!)

I'm guessing you have an authentication problem.  Make sure you're got
logging turned on for postgresql, then tail the logs (or whatever the
equivalent is in windowsland) and watch for errors when you run your
.net app.

But why are you using the .net connector for postgresql?

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Non-unique index performance
Next
From: Omachonu Ogali
Date:
Subject: create rule ... as on insert