I was just about to ask the same question...

med vï¿½nlig hï¿½lsning
/Dana

-----Original Message-----
From:	steve@thornet.co.uk [SMTP:steve@thornet.co.uk]
Sent:	Thursday, September 14, 2000 10:09 AM
To:	pgsql-general@postgresql.org; pgsql-hackers@postgresql.org
Subject:	[HACKERS] List funnies ?

Has something happened to the list server ?

I am only subscribed to the general list, but after two days of nothing I'm
now getting the hackers list stuff.

Steve


-- thorNET  - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax:   01454 854412
http://www.thornet.co.uk 

Thu, 14 Sep 2000 10:12:27 +0200
Dana.Reed@clinicaldatacare.com
RE: [HACKERS] List funnies ?
Me too, and I'm getting some stuff two times, like I'm double subscribed
(which I shouldn't be). Sometimes it takes few days for messages to appear
on list etc.

At 10:12 14.9.2000 , Dana.Reed@clinicaldatacare.com wrote:
>I was just about to ask the same question...
>
>med vï¿½nlig hï¿½lsning
>/Dana
>
>-----Original Message-----
>From:	steve@thornet.co.uk [SMTP:steve@thornet.co.uk]
>Sent:	Thursday, September 14, 2000 10:09 AM
>To:	pgsql-general@postgresql.org; pgsql-hackers@postgresql.org
>Subject:	[HACKERS] List funnies ?
>
>Has something happened to the list server ?
>
>I am only subscribed to the general list, but after two days of nothing I'm
>now getting the hackers list stuff.
>
>Steve
>
>
>-- thorNET  - Internet Consultancy, Services & Training
>Phone: 01454 854413
>Fax:   01454 854412
>http://www.thornet.co.uk 



Thu, 14 Sep 2000 12:49:18 +0200
Zeljko Trogrlic <zeljko@technologist.com>
RE: [HACKERS] List funnies ?

removed 

On Thu, 14 Sep 2000, Zeljko Trogrlic wrote:

> Me too, and I'm getting some stuff two times, like I'm double subscribed
> (which I shouldn't be). Sometimes it takes few days for messages to appear
> on list etc.
> 
> At 10:12 14.9.2000 , Dana.Reed@clinicaldatacare.com wrote:
> >I was just about to ask the same question...
> >
> >med v�nlig h�lsning
> >/Dana
> >
> >-----Original Message-----
> >From:	steve@thornet.co.uk [SMTP:steve@thornet.co.uk]
> >Sent:	Thursday, September 14, 2000 10:09 AM
> >To:	pgsql-general@postgresql.org; pgsql-hackers@postgresql.org
> >Subject:	[HACKERS] List funnies ?
> >
> >Has something happened to the list server ?
> >
> >I am only subscribed to the general list, but after two days of nothing I'm
> >now getting the hackers list stuff.
> >
> >Steve
> >
> >
> >-- thorNET  - Internet Consultancy, Services & Training
> >Phone: 01454 854413
> >Fax:   01454 854412
> >http://www.thornet.co.uk 
> 
> 
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Thu, 14 Sep 2000 09:39:08 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
RE: [HACKERS] List funnies ?
Thanks!

At 14:39 14.9.2000 , The Hermit Hacker wrote:
>
>removed 
>
>On Thu, 14 Sep 2000, Zeljko Trogrlic wrote:
>
>> Me too, and I'm getting some stuff two times, like I'm double subscribed
>> (which I shouldn't be). Sometimes it takes few days for messages to appear
>> on list etc.
>


Thu, 14 Sep 2000 16:04:55 +0200
Zeljko Trogrlic <zeljko@technologist.com>
RE: [HACKERS] List funnies ?
Forgive me if I am missing the obvious, but can someone please tell me how
to show a list of triggers, or the code in a specific trigger, via the pgsql
utility?

Thank you,
Bryan


Thu, 14 Sep 2000 09:13:16 -0600
"Bryan Field-Elliot" <bryan@netmeme.org>
Show triggers in psql?

You can get a list of all triggers in the system
as 
select * from pg_trigger;

You can get the source for a PL function a trigger
calls with:
select prosrc from pg_trigger,pg_proc where
 pg_proc.oid=pg_trigger.tgfoid
 and pg_trigger.tgname = '<name>'

[Note, in the case of C functions, I think this 
returns the name of the function.]


Stephan Szabo
sszabo@bigpanda.com

On Thu, 14 Sep 2000, Bryan Field-Elliot wrote:

> Forgive me if I am missing the obvious, but can someone please tell me how
> to show a list of triggers, or the code in a specific trigger, via the pgsql
> utility?
> 
> Thank you,
> Bryan
> 


Thu, 14 Sep 2000 09:02:19 -0700 (PDT)
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Show triggers in psql?


I've got a database I would like to upgrade from 6.3.2+phpfi 2.0 to
7.0.2+php 4.0. I've found the changes needed to be made to the php code,
and that should not be a problem. The real issue I'm having at this point
is getting the data into 7.0.2, or any newer release of PostgreSQL. I've
tried the pg_upgrade, but it does not seem to work for 6.3.2 -> 6.5.3.
Should I try 6.4 first, then 6.5.3, then 7.0? I've tried pg_dump and
pg_dumpall, but the data will not insert into the newer version
database.  Do I need to provide some err info here? What would be helpful? 

Notes on this setup: I've inherited the DBA position for this database. I
know the people who designed and built it, but cannot get any help from
them. They added some special charactor types and some compiled C code to
the postgres install, and I think that may be what's throwing the process
out. Any suggestions? 

Thank you,

Chris Sterling					
lemmy@eaze.net



Thu, 14 Sep 2000 11:44:26 -0500 (CDT)
Chris Sterling <lemmy@eaze.net>
Upgrading from 6.3.2 to 7.0.2