pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHELP: 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