Dear Magnus,

Oh.  Hmm ... wouldn't it be easier and safer to launch "psql <script"
as a subprocess?

I'd say no. Executing processes from the installer environment can be a headache (we've had enough problems with initdb already..). And you have to go through all the weirdness with the commandline quoting etc on win32... It's a lot easier to execute a SQL script line-by-line. Which also lets us trap the errors easier etc.

Maybe you're suggesting that psql and other commands functionnalities should be made into some kind of a dynamic library to be loaded and called from the installer, if using an external program is so difficult on win32?

I used to think that windows was posix somehow, so that it should provide
some 'exec*' functions which do not rely on shell scripting and should
not require much quoting.

Partially replicating functionnalities and adding bugs or limitations to
them does not seem so good a idea from a software engineering perspective.

Well, just my 0.02 EUR. I think it is a good thing that pg is available on windows, so thanks for that anyway!

Have a nice day,


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to