Re: [ADMIN] Cursor keys not working, repost.

2001-05-09 Thread Grant
> (1) Did you remove config.cache and rerun configure after installing the > headers? Maybe your problem is just that configure is caching the > not-found result ... Yes I did remove config.cache, this was not the problem see below. > (2) readline 2.2.1 is really ancient; the current release is

Re: [ADMIN] Cursor keys not working, repost.

2001-05-09 Thread Tom Lane
Grant <[EMAIL PROTECTED]> writes: > I have installed all the header files from: > /usr/src/redhat/SOURCES/readline-2.2.1 temporarily into > /usr/local/include. (1) Did you remove config.cache and rerun configure after installing the headers? Maybe your problem is just that configure is caching t

[ADMIN] Cursor keys not working, repost.

2001-05-09 Thread Grant
Hi I'm still having problem with my cursors working in psql connecting to postgresql v7.1 server. I have this problem on Linux Mandrake v7.1, v7.2, Linux Redhat v6.2, v7.1. I have installed all the header files from: /usr/src/redhat/SOURCES/readline-2.2.1 temporarily into /usr/local/include. M

RE: [ADMIN] Adding columns to existing tables

2001-05-09 Thread John Pagakis
Stephan - Thanks for the reply and good information. I was afraid it was going to involve learning more about the internal tables I was hoping to avoid that as I have a tight deadline. For the time being, I resolved this problem by taking a slightly different tact with the intermediate tab

Re: [ADMIN] Adding columns to existing tables

2001-05-09 Thread Stephan Szabo
On Tue, 8 May 2001, John Pagakis wrote: > I have a table - suppose it is called company: > > CREATE TABLE ( company_id char(36) NOT NULL UNIQUE PRIMARY KEY, > . > . > . > ); > > I want to add the following field: >

Re: [ADMIN] Restoring a pg_dump fails with

2001-05-09 Thread Tom Lane
Reiner Dassing <[EMAIL PROTECTED]> writes: > Sorry for coming up again with the same problem: > COPY FROM fails with "Memory exhausted in AllocSetAlloc(40)" > CREATE TABLE "wetter" ( > "sensor_id" int4 NOT NULL REFERENCES sensoren_an_orten, > "epoche" datetime NOT NULL, > "wert"

Re: [ADMIN] Restoring a pg_dump fails with

2001-05-09 Thread Reiner Dassing
Hello Tom! Sorry for coming up again with the same problem: COPY FROM fails with "Memory exhausted in AllocSetAlloc(40)" After inserting all the data fields by INSERTs I activated the following script by 'psql -e wetter < wetter.sql': wetter.sql contains the following: COPY wetter to '/Postgr