Re: Re: SELECT (sometimes) returning Zero Rows? - Mailing list pgsql-general

From Matt Friedman
Subject Re: Re: SELECT (sometimes) returning Zero Rows?
Date
Msg-id 008a01c0963a$93c98120$e8804318@mattq3h8budilr
Whole thread Raw
In response to SELECT (sometimes) returning Zero Rows?  ("Matt Friedman" <matt@daart.ca>)
List 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@xtra.co.nz>
To: "Matt Friedman" <matt@sprynewmedia.com>
Cc: "PgSql General List" <pgsql-general@postgresql.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
> <<--
>
>
>


pgsql-general by date:

Previous
From: Christopher Sawtell
Date:
Subject: Re: Re: SELECT (sometimes) returning Zero Rows?
Next
From: Bruce Momjian
Date:
Subject: Bad book review