From: | "Matt Friedman" <matt(at)daart(dot)ca> |
---|---|
To: | "Christopher Sawtell" <csawtell(at)xtra(dot)co(dot)nz>, "PgSql General List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Re: SELECT (sometimes) returning Zero Rows? |
Date: | 2001-02-14 03:59:48 |
Message-ID: | 008a01c0963a$93c98120$e8804318@mattq3h8budilr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> This has the same smell about it as the one a couple of days ago
> where the CR characters in a file loaded into the database using COPY were
> upsetting things.
I didn't use COPY but...
I used a dump created by pg_dump. We had some problems with the database a
while ago so I recreated it using a recent dump file.
To reimport it I had psql read it's commands from the file and do it's thing
that way. It ran smoothly and I didn't think anything of it.
The command I used would have been:
$psql -f /path/to/sql/file.sql
Could this be causing the problem? If so, how would I go about fixing it?
Many thanks,
Matt Friedman
----- Original Message -----
From: "Christopher Sawtell" <csawtell(at)xtra(dot)co(dot)nz>
To: "Matt Friedman" <matt(at)sprynewmedia(dot)com>
Cc: "PgSql General List" <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, February 13, 2001 6:58 PM
Subject: Re: Re: SELECT (sometimes) returning Zero Rows?
> On Wed, 14 Feb 2001 15:03, you wrote:
> > It's version 7.0.3
> >
> > Here's the output for the selects using explain below.
> > We had planned to do all of the optimization later. We just haven't had
> > time to get to it yet. Could that be the problem?
> >
> > Anyhow here's the info. Please let me know if you need more information.
>
>
> So, How did you populate your database?
>
> --
> Sincerely etc.,
>
> NAME Christopher Sawtell
> CELL PHONE 021 257 4451
> ICQ UIN 45863470
> EMAIL csawtell @ xtra . co . nz
> CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
>
> -->> Please refrain from using HTML or WORD attachments in e-mails to me
> <<--
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | mike | 2001-02-14 05:33:16 | postgres startup |
Previous Message | Christopher Sawtell | 2001-02-14 02:58:54 | Re: Re: SELECT (sometimes) returning Zero Rows? |