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 yo
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 ov
> 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 ha
Is there a good reason why the attribute name limit is 31 chars? It would
be nice to extend it to 255 characters or so...
Chris
--
Christopher Kings-Lynne
Family Health Network (ACN 089 639 243)
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...
"xuyifeng" <[EMAIL PROTECTED]> writes:
> you should use psql -\? to get help screen, this sucks,
> "?" shouldn't be used as a help screen argument.
I tend to agree, given csh's unhelpful (ahem) behavior.
At the very least, it seems that "psql -h" ought to produce
the full help message, not just
On Mon, Nov 20, 2000 at 10:47:32AM +0800, xuyifeng wrote:
> "?" shouldn't be used as a help screen argument.
generally, code doesn't explicitly look for a '?'.
rather, the code notes that the character is not mapped to any argument,
and prints out a usage statement.
--
[ Jim Mercer
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
I decided that perhaps it was time to toss the current OpenACS datamodel
at PG 7.1 to see what would happen (it's a bit shy of 10K lines, including
comments and white space).
All went well except for a handful of occurances of the following error:
ERROR: SS_finalize_plan: plan shouldn't referen
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 dyn
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 handli
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
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.
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:
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
longes
Vince Vielhaber writes:
> $ psql -U
> psql: option requires an argument -- U
> Try -? for help.
> $ psql -?
> psql: No match.
Friggin' csh. Try 'psql -\?'.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
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 ta
$ psql -U
psql: option requires an argument -- U
Try -? for help.
$ psql -?
psql: No match.
$
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup
[ Charset ISO-8859-1 unsupported, converting... ]
> > There are two parts to transaction commit. The first is writing all
> > dirty buffers or log changes to the kernel, and second is fsync of the
>
> Backend doesn't write any dirty buffer to the kernel at commit time.
Yes, I sus
> > > 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
> There are two parts to transaction commit. The first is writing all
> dirty buffers or log changes to the kernel, and second is fsync of the
Backend doesn't write any dirty buffer to the kernel at commit time.
> log file.
The first part is writing commit record into WAL buffer
"Mikheev, Vadim" wrote:
>
> > > > > No. Checkpoints are to speedup after crash recovery and
> > > > > to remove/archive log files. With WAL server doesn't write
> > > > > any datafiles on commit, only commit record goes to log
> > > > > (and log fsync-ed). Dirty buffers remains in memory long
> >
22 matches
Mail list logo
