Re: [HACKERS] psql: anyone ever notice?

2000-11-19 Thread Tom Lane
Vince Vielhaber [EMAIL PROTECTED] writes: $ psql -? psql: No match. Odd --- I get the right thing: $ psql -? This is psql, the PostgreSQL interactive terminal. Usage: psql [options] [dbname [username]] Options: -a Echo all input from script -A Unaligned table

Re: [HACKERS] psql: anyone ever notice?

2000-11-19 Thread Dominic J. Eidson
On Sun, 19 Nov 2000, Tom Lane wrote: Vince Vielhaber [EMAIL PROTECTED] writes: $ psql -? psql: No match. Odd --- I get the right thing: $ psql -? This is psql, the PostgreSQL interactive terminal. It has something to do with certain shell's expansion of ? - for the longest time I'd

Re: [HACKERS] psql: anyone ever notice?

2000-11-19 Thread Ross J. Reedstrom
It's a shell thing: Vince is running csh (or a derivative thereof) while Tom (and I) are running some sort of Bourne derived shell. Vince, try: psql -\? Which works more universally. Ross On Sun, Nov 19, 2000 at 02:44:01PM -0500, Tom Lane wrote: Vince Vielhaber [EMAIL PROTECTED] writes:

[HACKERS] Final proposal for resolving C-vs-newC issue

2000-11-19 Thread Tom Lane
If you care about the nitty-gritty details, see http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/utils/fmgr/README particularly the final section "Telling the difference between old- and new-style functions". regards, tom lane

Re: [HACKERS] Final proposal for resolving C-vs-newC issue

2000-11-19 Thread Philip Warner
At 17:16 19/11/00 -0500, Tom Lane wrote: If you care about the nitty-gritty details, see http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/utils/fmgr/README particularly the final section "Telling the difference between old- and new-style functions". There is no mention of the handling

Re: [HACKERS] Final proposal for resolving C-vs-newC issue

2000-11-19 Thread Tom Lane
Philip Warner [EMAIL PROTECTED] writes: At 17:16 19/11/00 -0500, Tom Lane wrote: http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/utils/fmgr/README There is no mention of the handling of toasted values for old C functions. Did you not read to the end? : To allow old-style dynamic

Re: [HACKERS] psql: anyone ever notice?

2000-11-19 Thread xuyifeng
all you guy unix? under some shells, both * and ? are expanded to matched file names in current directory by shell, for example FreeBSD's csh. you should use psql -\? to get help screen, this sucks, "?" shouldn't be used as a help screen argument. Regards, XuYifeng - Original Message

Re: [HACKERS] PG 7.1 pre-beta bug ...

2000-11-19 Thread Tom Lane
Don Baccus [EMAIL PROTECTED] writes: All went well except for a handful of occurances of the following error: ERROR: SS_finalize_plan: plan shouldn't reference subplan's variable This is probably my fault --- will look at it. Appreciate the self-contained example...

[HACKERS] Re: [COMMITTERS] pgsql/src/backend/utils/adt (cash.c)

2000-11-19 Thread Thomas Lockhart
Modify locale code to defend against possibility that it was compiled with an -fsigned-char/-funsigned-char setting opposite to that of libc, thus breaking the convention that 'undefined' values returned by localeconv() are represented by CHAR_MAX. It is sheer stupidity that gcc even has

[HACKERS] Table/Column Constraints

2000-11-19 Thread Christopher Kings-Lynne
Hi, I was looking at the ALTER TABLE DROP CONSTRAINT bit of PostgreSQL, and I started thinking about trying to implement it (as a bit of mental exercise). (And because it's highly annoying not being able to remove the damn things! Please comment on all of this, and tell me if it's going to be

Re: [HACKERS] Final proposal for resolving C-vs-newC issue

2000-11-19 Thread Philip Warner
At 21:31 19/11/00 -0500, Tom Lane wrote: Philip Warner [EMAIL PROTECTED] writes: At 17:16 19/11/00 -0500, Tom Lane wrote: http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/utils/fmgr/README There is no mention of the handling of toasted values for old C functions. Did you not read

Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/transam (xact.c xlog.c)

2000-11-19 Thread Vadim Mikheev
Ok, so with CHECKPOINTS, we could move the offline log files to somewhere else so that we could archive them, in my undertstanding. Now question is, how we could recover from disaster like losing every table files except log files. Can we do this with WAL? If so, how can we do it?

Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/transam (xact.c xlog.c)

2000-11-19 Thread Don Baccus
At 07:05 PM 11/19/00 +0100, [EMAIL PROTECTED] wrote: Cam I ask what BAR is ? Backup and recovery, presumably... - Don Baccus, Portland OR [EMAIL PROTECTED] Nature photos, on-line guides, Pacific Northwest Rare Bird Alert Service and other goodies at http://donb.photo.net.