Re: [GENERAL] Help with Database Recovery

2000-11-30 Thread Tom Lane
"Hancock, David (DHANCOCK)" [EMAIL PROTECTED] writes: Sorry I didn't give more detail. OS is Linux 2.2 kernel, PostgreSQL is 6.5.3. The problem is that I copied the .../base/* directories elsewhere in preparation for making base a symlink to a different filesystem with more space. I then

Re: [GENERAL] Help needed : temp tables.

2000-10-09 Thread Tom Lane
"Vilson farias" [EMAIL PROTECTED] writes: I'm having problems with temporary tables in postgre. I've been using Postgre 7.02 in a red hat 6.2 and I'm accessing using Delphi 5 + Winzeos Postgre Components. I've been using for some mounths and now I checked that there are lots of temp tables in

Re: [GENERAL] Help on analyzing performance problem.

2000-08-26 Thread Tom Lane
"Travis Bauer" [EMAIL PROTECTED] writes: I have a problem with a _very_ slow query. I'm not sure how to understand the explain output. There's some basic info about EXPLAIN in the "understanding performance" section of the user manual (at least today, it's at

Re: [GENERAL] help -- cursor inside a function

2000-07-08 Thread Alex Bolenok
hello , i have a procedure as below. -- --- create function retrec(integer) returns integer as 'declare uid alias for $1; begin declare retrec_cur cursor for

Re: [GENERAL] Help: How to store query output in a file !!!

2000-06-14 Thread selkovjr
Does anyone knows how do you send query output to a file??? Welcome to Unix(TM): psql database -c "select * from table name, etc." file name See also: http://www.isu.edu/departments/comcom/unix/workshop/io.html or, type "unix tutorial" in any web search engine. --Gene I tried

Re: [GENERAL] Help: How to store query output in a file !!!

2000-06-14 Thread Len Morgan
ED] [EMAIL PROTECTED] To: NEERAJ BANSAL [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, June 14, 2000 2:46 AM Subject: Re: [GENERAL] Help: How to store query output in a file !!! Does anyone knows how do you send query output to a file??? Welcome to Unix(TM): psql database

Re: [GENERAL] HELP needed : COPY datas from file

1999-06-16 Thread Anonymous
Hi! On Wed, 16 Jun 1999, Ming-Hung Eng wrote: I have a problem to copy datas from unix file, I get the following message when I try to import a file with more 20 lines : pgReadData() -- backend closed the channel unexpectedly This probably means the backend terminated abnormally

<    4   5   6   7   8   9