Re: Re: SELECT (sometimes) returning Zero Rows?
От | Matt Friedman |
---|---|
Тема | Re: Re: SELECT (sometimes) returning Zero Rows? |
Дата | |
Msg-id | 008a01c0963a$93c98120$e8804318@mattq3h8budilr обсуждение исходный текст |
Ответ на | SELECT (sometimes) returning Zero Rows? ("Matt Friedman" <matt@daart.ca>) |
Список | 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 по дате отправления: