Re: [ADMIN] postgresql questions

1998-06-02 Thread Mateus Cordeiro Inssa
Hi, I have this problem: when I send a "vacuum" I get this error: NOTICE: Ind pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (962) IS NOT THE SAME AS HEAP' (961) FATAL 1: btree: cannot split if start (2) >= maxoff (2) That line with FATAL is showed also when I add a function (usualy with

Re: [ADMIN] postgresql questions

1998-06-02 Thread The Hermit Hacker
On Tue, 2 Jun 1998, Chan Fook Sheng wrote: > 4) when I run "psql template1 " or "createdb test" I get the following: > > connection to database 'template1' failed. > PQexec() -- Request was sent to backend, but backend closed the channel > before responding. This probably means the backend termi

[ADMIN] postgresql questions

1998-06-02 Thread Chan Fook Sheng
Hello everybody, I have some questions on Postgresql, pls help me if you can. I have installed postgresql 6.2.1on FreeBSD 2.2.6. To start it, I must first start the postmaster running, so I : 1) su pgsql (this account I think was created during the installation) 2) postmaster (I get this messa

Re: [ADMIN] PostgreSQL questions

1998-05-17 Thread Bruce Momjian
> >>try: > >>template1=> \h copy > Command: copy > Description: copy data to and from a table > Syntax: > copy [binary] [with oids] > {to|from} {|stdin|stdout} [using delimiters ]; > >>you can use "\t" a HTab or "," a comma. that is what i general

Re: [ADMIN] PostgreSQL questions

1998-05-17 Thread rjreilly
>1. Is there a TCL extension to this database? I see you have a pgtksh, pktclsh > interpreter compiled with the package. I was thinking if I can have the > postgresql interfaces incorporated to our TCL/TK interpreter. >>I belive the tcl/tk shell is a full shell with the PG libraries compile

Re: [ADMIN] PostgreSQL questions

1998-05-17 Thread Peter Mount
On Sat, 16 May 1998, The Hermit Hacker wrote: > I just installed the postgresql database into our Sun enterprise 5000 machine. > I have a few questions to ask if you don't mind. > > 1. Is there a TCL extension to this database? I see you have a pgtksh, pktclsh >interpreter compiled with the

[ADMIN] PostgreSQL questions

1998-05-16 Thread The Hermit Hacker
Hi, I just installed the postgresql database into our Sun enterprise 5000 machine. I have a few questions to ask if you don't mind. 1. Is there a TCL extension to this database? I see you have a pgtksh, pktclsh interpreter compiled with the package. I was thinking if I can have the postg