The following bug has been logged online: Bug reference: 1224 Logged by: David Maggard
Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.3 Operating system: Redhat Enterprise Linux ES 3.0 Update 1 Description: Restarting postgres appends extra -D argument Details: I installed from the src, I am using /postgresql-7.4.3/contrib/startup-scripts/linux, I have found that restarting postgresql via the sysV script or pg_ctl like either of the following: service postgres restart pg_ctl restart -D /usr/local/pgsql/data results in an extra '-D /usr/local/pgsql/data' being appended each time it is done, you can see this by running either of the following after each restart: service postgres status pg_ctl status -D /usr/local/pgsql/data this isn't a problem for me, but I thought it might be a potential problem for someone else ---------------------------(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