[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] PGdump then PHP search
From:       "Mike Field" <mike () fieldco ! com>
Date:       1999-09-16 19:20:12
[Download RAW message or body]

Hi all-

I've transferred a database using a pg_dump, and everything transferred =
fine.  But in my search engine (made with PHP3 performing SQL queries =
using: WHERE fieldname LIKE keywords) the only documents that seem to be =
searched are the ones that I've put in SINCE the pg_dump/db transfer.

Any ideas why?
Any way to fix it?

Mike
mike@fieldco.com


[Attachment #3 (text/html)]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META content='"MSHTML 4.72.3110.7"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000 size=2>&nbsp;&nbsp;&nbsp; <FONT color=#000000>Hi 
all-</FONT></FONT></DIV>
<DIV><FONT color=#000000 size=2><FONT color=#000000></FONT></FONT>&nbsp;</DIV>
<DIV><FONT size=2>I've transferred a database using a pg_dump, and everything 
transferred fine.&nbsp; But in my search engine (made with PHP3 performing SQL 
queries using: WHERE fieldname LIKE keywords) the only documents that seem to be 
searched are the ones that I've put in SINCE the pg_dump/db 
transfer.</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>Any ideas why?</FONT></DIV>
<DIV><FONT size=2>Any way to fix it?</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>Mike</FONT></DIV>
<DIV><FONT size=2><A 
href="mailto:mike@fieldco.com">mike@fieldco.com</A></FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

************


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic