pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PGdump then PHP search
2+ messages / 2 participants
[nested] [flat]

* PGdump then PHP search
@ 1999-09-16 19:20  Mike Field <mike@fieldco.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Mike Field @ 1999-09-16 19:20 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org; pgsql-sql

    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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] PGdump then PHP search
@ 1999-09-16 20:12  tjk@tksoft.com <tjk@tksoft.com>
  parent: Mike Field <mike@fieldco.com>
  0 siblings, 0 replies; 2+ messages in thread

From: tjk@tksoft.com @ 1999-09-16 20:12 UTC (permalink / raw)
  To: mike@fieldco.com; +Cc: pgsql-sql

Mike,
If you query the new database with psql, can you see the 
transfered records, or only the new records?
If not, you missed some step in transfering the data
(like copy).

Troy


> 
> This is a multi-part message in MIME format.
> 
> ------=_NextPart_000_0072_01BF0056.F839FAC0
> Content-Type: text/plain;
> 	charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
> 
>     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
> 
> 
> ------=_NextPart_000_0072_01BF0056.F839FAC0
> Content-Type: text/html;
> 	charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
> 
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
> <HTML>
> <HEAD>
> 
> <META content=3Dtext/html;charset=3Diso-8859-1 =
> http-equiv=3DContent-Type>
> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT color=3D#000000 size=3D2>&nbsp;&nbsp;&nbsp; <FONT =
> color=3D#000000>Hi=20
> all-</FONT></FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2><FONT =
> color=3D#000000></FONT></FONT>&nbsp;</DIV>
> <DIV><FONT size=3D2>I've transferred a database using a pg_dump, and =
> everything=20
> transferred fine.&nbsp; But in my search engine (made with PHP3 =
> performing SQL=20
> queries using: WHERE fieldname LIKE keywords) the only documents that =
> seem to be=20
> searched are the ones that I've put in SINCE the pg_dump/db=20
> transfer.</FONT></DIV>
> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT size=3D2>Any ideas why?</FONT></DIV>
> <DIV><FONT size=3D2>Any way to fix it?</FONT></DIV>
> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT size=3D2>Mike</FONT></DIV>
> <DIV><FONT size=3D2><A=20
> href=3D"mailto:mike@fieldco.com">mike@fieldco.com</A></FONT></DIV>
> <DIV>&nbsp;</DIV></BODY></HTML>
> 
> ------=_NextPart_000_0072_01BF0056.F839FAC0--
> 
> 
> ************
> 
> 




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-09-16 20:12 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-16 19:20 PGdump then PHP search Mike Field <mike@fieldco.com>
1999-09-16 20:12 ` tjk@tksoft.com <tjk@tksoft.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox