pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
HELP: Trend reporting
3+ messages / 3 participants
[nested] [flat]

* HELP: Trend reporting
@ 2001-08-23 18:05  Jason Charette <jasonc@cadlink.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Jason Charette @ 2001-08-23 18:05 UTC (permalink / raw)
  To: pgsql-sql

Hello newsgroup buddies,

I am looking for information on trend reporting. We run Linux, PostreSQL,
Apache and PHP4. We have a series of scripts that track customer usage
through our sites, and give us similar information to what is found in the
Apache logs, but with more data.

I now find myself in the position of having to create "trend reports" or
"common routes through our site".

Any search I have done has yielded many commercial products that will do
this for me, but, unfortunately, I am looking more for a tutorial on how to
do this, rather than a product that will do it for me.

Essentially, I would like a tutorial(s) or article(s) that discusses this
topic, preferably something along the lines of my afforementioned setup (I
would like to minimize the amount of converting I have to do).

If anyone can help, in any way, shape or form, it would be greatly
appreciated.

Thanks in advance,

Jason





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

* Re: [SQL] HELP: Trend reporting
@ 2001-08-30 17:16  Oleg Lebedev <olebedev@waterford.org>
  parent: Jason Charette <jasonc@cadlink.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Oleg Lebedev @ 2001-08-30 17:16 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org

Hi,
I am trying to upgrade to 7.1.2 and when I use:
pg_dumpall -o > file.bac
I get an error saying:
dumpRules(): SELECT failed for table setmedias. Explanation from backend:
'ERROR: cache lookup of attribute 5 in relation 23945 failed"

As I understand setmedias table corresponds to relation 23945, but I dropped
it a long time ago. How should remove this relation pointer?
thanks,

Oleg





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

* Re: Re: [SQL] HELP: Trend reporting
@ 2001-08-30 19:12  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  parent: Oleg Lebedev <olebedev@waterford.org>
  0 siblings, 0 replies; 3+ messages in thread

From: Stephan Szabo @ 2001-08-30 19:12 UTC (permalink / raw)
  To: Oleg Lebedev <olebedev@waterford.org>; +Cc: pgsql-admin@postgresql.org


On Thu, 30 Aug 2001, Oleg Lebedev wrote:

> Hi,
> I am trying to upgrade to 7.1.2 and when I use:
> pg_dumpall -o > file.bac
> I get an error saying:
> dumpRules(): SELECT failed for table setmedias. Explanation from backend:
> 'ERROR: cache lookup of attribute 5 in relation 23945 failed"
> 
> As I understand setmedias table corresponds to relation 23945, but I dropped
> it a long time ago. How should remove this relation pointer?
> thanks,

It sounds like you have a rule that still refers to the dead table.




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


end of thread, other threads:[~2001-08-30 19:12 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-23 18:05 HELP: Trend reporting Jason Charette <jasonc@cadlink.com>
2001-08-30 17:16 ` Oleg Lebedev <olebedev@waterford.org>
2001-08-30 19:12   ` Stephan Szabo <sszabo@megazone23.bigpanda.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