[GENERAL] Is tab whitespace?

2000-08-19 Thread ellen
I was surprised to find that the tab character seems not to be treated as whitespace by psql (7.1). Is this a bug or a feature? Specifically, the following command fails if there is a tab (\t) between "bar" and "init":t:" ezmlm=> create table foo (bar int); ERROR: parser: parse error at

Re: [GENERAL] Linking legacy PHP stuff

2000-08-19 Thread Simon Brooke
Tom Lane wrote: > > Simon Brooke <[EMAIL PROTECTED]> writes: > > curr_conn = result->conn; > > if ((curr_conn == NULL) && (pgTypeRes==0)) { > > Get rid of curr_conn and the ensuing test on same, is my advice. > This code should never have been reaching inside PGresult to begin >

Re: [GENERAL] rebuilding a table from a datafile

2000-08-19 Thread brianb-pggeneral
Tom Lane writes: > [EMAIL PROTECTED] writes: > > This is with regards to Postgres 6.5. > > While trying to ALTER RENAME a large table (203MB data file), an error > > occured. > > Table RENAME is pretty risky under 6.5 :-(. 7.0 is a little better, > but RENAME will never be trustworthy until we

Re: [GENERAL] AS3AP Implementation for PostgreSQL/Linux ?

2000-08-19 Thread Ned Lilly
Correct... in fact, I think the demo runs all the tests. But its only good for a handful of users (you buy clumps of concurrent users to test), so you wouldn't be able to duplicate the entire test. You'd probably see the same trendlines, though. http://www.Quest.com/download.asp?body=/emaildata

[GENERAL] (maybe trivial) records questions

2000-08-19 Thread Froilan Mendoza
How can one know how many records are stored in a database? (all tables included) ... is there a / command for this? TIA --- Froilan C. Mendoza Tridel Technologies, Inc. http://www.tridel.net

[GENERAL] any C++ GUI for PgSql [like pgAdmin] ?

2000-08-19 Thread luc00
Hi Does anybody know a C++ GUI [eventually ported Linux/Win] for PgSQL server interfacing ? Thanks Lucian