Re: [BUGS] BUG #6246: character encoding for 64 bit

2011-10-14 Thread bushcraftrelf
Surely the windows installation of psql ought to be set up to work with the terminal already? -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-6246-character-encoding-for-64-bit-tp4888531p4902052.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

Re: [BUGS] BUG #6246: character encoding for 64 bit

2011-10-14 Thread bushcraftrelf
I think I've figured it out - thanks all for your help. Craig Ringer appears to be right. >From documentation for psql 9.1 under Usage>Connecting to a database "If at least one of standard input or standard output are a terminal, then psql sets the client encoding to "auto", which will detect the

Re: [BUGS] Tablespace files deleted in continuous run

2011-10-14 Thread Robert Haas
On Fri, Oct 14, 2011 at 12:29 AM, Vishnu S. wrote: > The application deletes the contents of tables in the tablespace using > DELETE TABLE query. There's no DELETE TABLE command. Do you mean DELETE, or DROP TABLE? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreS

Re: [BUGS] Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view

2011-10-14 Thread Daniel Cristian Cruz
How about a warning in docs for uncautious DBA's? 2011/10/13 Bruce Momjian > > I assume this should _not_ be added as a TODO. -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [BUGS] psql's \copy incompatible with :variables

2011-10-14 Thread Josh Berkus
> \copy is different because it uses OT_WHOLE_LINE mode to read the > argument, and that doesn't expand :variable references. I'd be a bit > leery of changing that. So, doc warning then? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-bugs mailing list (pgsql-bu

Re: [BUGS] psql's \copy incompatible with :variables

2011-10-14 Thread Bruce Momjian
Josh Berkus wrote: > > > \copy is different because it uses OT_WHOLE_LINE mode to read the > > argument, and that doesn't expand :variable references. I'd be a bit > > leery of changing that. > > So, doc warning then? I don't think enough people have hit this problem to warrant that. -- Bru