Patch applied to 7.3.X. Thanks. ---------------------------------------------------------------------------
[EMAIL PROTECTED] wrote: > Hi There's a bug in the clusterdb script where it looks like the arguments > to the psql command are being passed in the wrong order, so it fails when > you run it on a database that is not on localhost. > Here's the output from the command: > > 133 anands-Computer:bin/scripts> clusterdb -h wooster -U rr granada > psql: warning: extra option wooster ignored > psql: warning: extra option -U ignored > psql: warning: extra option rr ignored > psql: warning: extra option -F: ignored > psql: warning: extra option -P ignored > psql: warning: extra option format=unaligned ignored > psql: warning: extra option -t ignored > psql: warning: extra option -c ignored > psql: warning: extra option SELECT nspname, pg_class.relname, > pg_class_2.relname FROM pg_class, pg_class AS pg_class_2 JOIN pg_namespace > ON (pg_namespace.oid=relnamespace), pg_index WHERE > pg_class.oid=pg_index.indrelid AND pg_class_2.oid=pg_index.indexrelid AND > pg_index.indisclustered AND pg_class.relowner=(SELECT usesysid FROM > pg_user WHERE usename=current_user) ignored > psql: FATAL: user "-h" does not exist > > > > I'm attaching a patch that fixes the problem. The diff was run on > postgresql 7.3.4 > > Thanks a lot. > Anand Ranganathan > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com Content-Description: clusterdb.patch [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(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