Re: [GENERAL] Creating a temporary table isn't working

1999-11-09 Thread Paul Branston
On Tue, 9 Nov 1999, Darvin Zuch wrote: > Good Morning All! > > Really simple question. > I put in the following command and I get a parse error but when I get rid of > the optional TEMP it works okay. The docs seem to say this is how its done. > > gammamatrix=> CREATE TEMP TABLE Start (VatiI

[GENERAL] ERROR: cannot read block 122600 of gt

1999-11-09 Thread Jim Mercer
i'm getting the following error on one of my tables: error: SQL: FETCH FORWARD 500 IN cur_NON_110916; error: database (7) ERROR: cannot read block 122600 of gt there are no messages from the OS about disk read failures. this is postgres-6.5.2 on FreeBSD-3.3-STABLE -- [ Jim Mercer

Re: [GENERAL] Postgres on Linux Alpha

1999-11-09 Thread Ryan Kirkpatrick
On Tue, 9 Nov 1999, Bruce Momjian wrote: > > Without these patches, pgsql will not run out of the box on > > Linux/Alpha. Hopefully it will in 7.0 a few (?) months from now. > > Why don't we apply this to 6.5.*. Not to sound annoyed here (long, long day), but we have been down this

Re: [GENERAL] Postgres on Linux Alpha

1999-11-09 Thread Bruce Momjian
> On Tue, 9 Nov 1999, Bruce Momjian wrote: > > > > Without these patches, pgsql will not run out of the box on > > > Linux/Alpha. Hopefully it will in 7.0 a few (?) months from now. > > > > Why don't we apply this to 6.5.*. > > Not to sound annoyed here (long, long day), but we have bee

Re: [GENERAL] Postgres on Linux Alpha

1999-11-09 Thread Bruce Momjian
> Yea, run over to http://www.rkirkpat.net/software/ (my site) and > grab the Linux/Alpha patches for 6.5.2. They apply cleanly to the 6.5.3 > tarball, and when compiled, produce binaries that work great. Either that, > or go to http://www.ramifordistat.net/postgres/ and grab the SRPM and >

Re: [GENERAL] Postgres on Linux Alpha

1999-11-09 Thread Ryan Kirkpatrick
On Mon, 8 Nov 1999, Fabrice Scemama wrote: > I'm currently trying to install Postgres 6.5.3 on my Alpha ev56 > proc. I'm using gcc 2.95.2, and this is a glibc 2.1.2 system (RH6). > Everything's brand new, so as to maximize chances (hope). > I've configured --with-template=linux_alpha, and the mak

Re: [GENERAL] Creating a temporary table isn't working

1999-11-09 Thread Bruce Momjian
[Charset iso-8859-1 unsupported, filtering to ASCII...] > Good Morning All! > > Really simple question. > I put in the following command and I get a parse error but when I get rid of > the optional TEMP it works okay. The docs seem to say this is how its done. > > gammamatrix=> CREATE TEMP TABL

[GENERAL] Creating a temporary table isn't working

1999-11-09 Thread Darvin Zuch
Good Morning All! Really simple question. I put in the following command and I get a parse error but when I get rid of the optional TEMP it works okay. The docs seem to say this is how its done. gammamatrix=> CREATE TEMP TABLE Start (VatiID int NOT NULL, TrimID int, BodyID int, GVWRID int, Driv

Re: [GENERAL] Alter table possibility

1999-11-09 Thread amy cheng
and there are some work-arounds in the archive of this mailing list. basically use a temporary table. >From: Alain TESIO <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Edouard DESSIOUX <[EMAIL PROTECTED]>, [EMAIL PROTECTED] >Subject: Re: [GENERAL] Alter table possibility >Date: Tue, 9 Nov

Re: [GENERAL] About Date field

1999-11-09 Thread amy cheng
sure. PG's datetime and timespan are the best, even better than Okle! there are "now", "current_date" etc. see the doc and archive of this list (search datetime). Just a remind: unless you really want "date" (nobody need to save disk for that reason!), use datetime/timespan. >From: Edouard D

Re: [GENERAL] pgaccess in RPM

1999-11-09 Thread Bruce Momjian
[Charset iso-8859-1 unsupported, filtering to ASCII...] > I have just downloaded the current postgres RPM (6.5.2.1) and installed the > RPM. Pgaccess does not seem to be included. Can pgaccess be installed by > RPM, or do I have to compile the source? Thanks. Please get 6.5.3. pgaccess is in the

Re: [GENERAL] Alter table possibility

1999-11-09 Thread Alain TESIO
--- Edouard DESSIOUX <[EMAIL PROTECTED]> wrote: > I've just seen that alter allow to add a column > But how can I do if I want to delete a column ? Scroll down a bit on the same page in the manual and you'll read that this feature (alter table drop column) is not yet supported. Alain _

[GENERAL] Alter table possibility

1999-11-09 Thread Edouard DESSIOUX
I've just seen that alter allow to add a column But how can I do if I want to delete a column ? -- Edouard DESSIOUX Proverbe chien : "Si ca se mange pas, Si ca se baise pas, Pisse dessus !!"

[GENERAL] pgaccess in RPM

1999-11-09 Thread Bruce Bantos
I have just downloaded the current postgres RPM (6.5.2.1) and installed the RPM. Pgaccess does not seem to be included. Can pgaccess be installed by RPM, or do I have to compile the source? Thanks. - Bruce

[GENERAL] About Date field

1999-11-09 Thread Edouard DESSIOUX
Hello, I use a simple table, in which i've a field of type date. Is is possible to insert the current date in this field, I mean using a special variable that has the systeme date. -- Edouard DESSIOUX Proverbe chien : "Si ca se mange pas, Si ca se baise pas, Pisse dessus !!"