Re: [HACKERS] GNU readline and BSD license

2000-12-31 Thread Peter Eisentraut
Patrick Welche writes: > I had an attempt at fooling configure to look in libedit rather than > readline, and all was OK except our libedit doesn't have "rl_special_prefixes" > so tab-complete:105 is unhappy - I don't know what it is meant to do... I've removed the statement for now, since it wa

[HACKERS] Re: [DOCS] Inheritance docs error.

2000-12-31 Thread Peter Eisentraut
Tom Lane writes: > I am strongly inclined to rip out the pseudo-UNDER clause and support > only the old-style INHERITS syntax for 7.1. UNDER is adding no > functionality and I think we will eventually regret using an SQL keyword > for non-SQL semantics. I agree. -- Peter Eisentraut [EMAI

[HACKERS] PRIMARY KEY and INHERITANCE

2000-12-31 Thread Ferruccio Zamuner
Hi, some months ago I've asked for a suggestion for this bug: create table a ( id serial primary key, something text ); create table b ( morething text ) inherits (a); create table c ( trouble int references b; ); NOTICE: CREATE TABLE will create implicit trigger(s

Re: [HACKERS] PRIMARY KEY and INHERITANCE

2000-12-31 Thread Oliver Elphick
Ferruccio Zamuner wrote: >Hi, > >some months ago I've asked for a suggestion for this bug: > >create table a ( > id serial primary key, > something text >); > >create table b ( > morething text >) inherits (a); > >create table c ( > trouble int

Re: [HACKERS] PRIMARY KEY and INHERITANCE

2000-12-31 Thread Horst Herb
On Monday 01 January 2001 01:42, Ferruccio Zamuner wrote: > Hi, > > some months ago I've asked for a suggestion for this bug: > > create table a ( >id serial primary key, >something text > ); > > create table b ( >morething text > ) inherits (a); > > create table c ( >

[HACKERS] pg_dumpall (7.1beta1, current CVS)

2000-12-31 Thread Larry Rosenman
I noticed today that pg_dumpall from current CVS does *NOT* dump a password assiged to the postgres user. I consider this BAD, since if one has to restore from a pg_dumpall, one may forget to reset the password. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1

Re: [HACKERS] pg_dumpall (7.1beta1, current CVS)

2000-12-31 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001231 17:59]: > I noticed today that pg_dumpall from current CVS does *NOT* > dump a password assiged to the postgres user. > > I consider this BAD, since if one has to restore from > a pg_dumpall, one may forget to reset the password. > > LER And, it wa

Re: [HACKERS] Upper limit on number of buffers?

2000-12-31 Thread Andrew McMillan
Michael J Schout wrote: > > On Sun, 24 Dec 2000, Joe Conway wrote: > > On redhat 6.2 I know that you can use /etc/sysctl.conf to do this as well. > > Just add this to /etc/sysctl.conf. > > kernel.shmall = 134217728 > kernel.shmmax = 134217728 > > After this, your tunables will be restored eve

[HACKERS] Re: [DOCS] Inheritance docs error.

2000-12-31 Thread Hannu Krosing
Tom Lane wrote: > > Peter Eisentraut <[EMAIL PROTECTED]> writes: > They are all correct: UNDER is the new SQL99 syntax, INHERITS is the > traditional Postgres syntax. > >> > >> Current docs do appear to be erroneous: they claim the UNDER phrase goes > >> where INHERIT does, which is no

[HACKERS] Current Sources/UW7.1.1

2000-12-31 Thread Larry Rosenman
The planregress.sh tests generate errors. Attached is a tar of the planregress directory... -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 planre