Thread: RE: [HACKERS] List funnies ?
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
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
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
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. >
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
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 >
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