Assad Jarrahian wrote:
Sorry, I am a linux/OS X person. Was working on PGADMIN in windows and
thought their query tool was the same as psql.
Nope - psql is psql, pgadmin is pgadmin. All the backslash commands are
psql-only rather than being part of the backend. Of course, pgadmin can
duplicate them if they want.
> Just ran the script in psql
on my linux box and it worked.
And on Windows too. Not sure if you need to change the line-endings though.
My apologies.
Tom, I am not leaping to silly conclusions. Calm down please. We are all
trying to learn from people with knowledge. Be curtious.
The problem is Assad that your email saying \c doesn't work in psql is
now in the archive forever. In a couple of days Google will index it and
then the world at large will be coming across it. And it's not worded as
a question "I can't get \c to work in psql" - just says it doesn't work,
so it might be that a questioner doesn't look any further, assuming you
were right.
It's not the leaping to a conclusion that's done the damage, and it's
not the instant archiving, but the combination of the two.
Of course Tom could have been a little more gentle in his dressing down,
but since I'd guess he's been working pretty hard recently getting 8.1
out of the door (released today!) I'm prepared to cut him some slack.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
