Re: [GENERAL] Getting rid of duplicate tables.

2004-01-20 Thread Jared Carr
Tom Lane wrote: Jared Carr [EMAIL PROTECTED] writes: Item 2 -- Length: 148 Offset: 6860 (0x1acc) Flags: USED XID: min (46034931) CMIN|XMAX: 2 CMAX|XVAC: 0 Block Id: 27 linp Index: 2 Attributes: 23 Size: 28 infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

[GENERAL] postGresql Consulting ??

2004-01-20 Thread Thapliyal, Deepak
Hi Guys, Do you know any companies in the San Diego Area(or nearby) who can give consulting expertise. This is for getting us up and running with postGresql I would appreciate if I can get emails addresses/compnaies names who do this .. Thx Deep -Original Message- From: [EMAIL

Re: [GENERAL] Getting rid of duplicate tables.

2004-01-20 Thread Tom Lane
Jared Carr [EMAIL PROTECTED] writes: Tom Lane wrote: Could you check out what pg_clog has for transaction 46034931? This would be pg_clog/002B (which dates your problem to Dec 29 BTW), byte at offset 39BFC hex or 236540 decimal. I forget which way the bits run within the byte but will look

Re: [GENERAL] Detecting database corruption

2004-01-20 Thread Andrew Sullivan
On Mon, Jan 19, 2004 at 02:45:27PM -0500, Jack Orenstein wrote: If this means, Does the database usually check for corruption? the answer is, Not as a matter of course. Do you mean that this happens in a few select situations? Or that there are configuration flags that can be used to

Re: [GENERAL] Transaction id

2004-01-20 Thread Jan Wieck
[EMAIL PROTECTED] wrote: Is it possible to find system change ID in SQL or stored procedures? By system change ID I understand an internal serialized number which could be used to serialize all SQL submitted into the database? Thank you in advance, Laimis Not sure what you exactly envision here.

[GENERAL] Accessing template0 tables

2004-01-20 Thread Dylan Milks
Hi. Could someone please tell me how to access the template0 tables through PgAdmin. I'm using PgAdmin 1.4.12 and Postgres 7 something. If I log in as "postgres",and click on the template0 table, it won't expand and a big red "X" goes over the icon. How can I get around this? Thanks,

Re: erServer (was: Re: [GENERAL] Postgress and MYSQL)

2004-01-20 Thread Andrew Sullivan
On Tue, Jan 20, 2004 at 09:16:45AM +0200, Devrim GUNDUZ wrote: In fact we would announce it next week, but I and Nicolai Tufar patched eRServer current CVS version last week, since it fails to configure and compile on most systems. Bug reports are welcome. I look forward to the patches. A

Re: [GENERAL] Getting rid of duplicate tables.

2004-01-20 Thread Tom Lane
Jared Carr [EMAIL PROTECTED] writes: Tom Lane wrote: Yes, it does appear that there was a backend crash/(operator stupidly kill -9 'ing possibly) on the 29th. Hmm ... could you send me that area of the log? Dec 29 16:31:54 penguin postgres[1714]: [3-1] LOG: received smart shutdown

Re: [GENERAL] SCO Extortion

2004-01-20 Thread Marc G. Fournier
On Tue, 20 Jan 2004, Gavin M. Roy wrote: I'm currently one of the targets of SCO's linux licensing extortion business plan, and am contemplating switching to one of the BSD's to avoid any potential problems. I'm curious which BSD people prefer for large scale databases and why. Any

Re: [GENERAL] SCO Extortion

2004-01-20 Thread Larry Rosenman
--On Tuesday, January 20, 2004 14:06:35 -0800 Gavin M. Roy [EMAIL PROTECTED] wrote: I'm currently one of the targets of SCO's linux licensing extortion business plan, and am contemplating switching to one of the BSD's to avoid any potential problems. I'm curious which BSD people prefer for

Re: [GENERAL] SCO Extortion

2004-01-20 Thread Gavin M. Roy
Thanks for the feedback thus far. I should also mention I use freebsd for other stuff, but I am mainly asking in peoples experience, which is the best for PostgreSQL to live on specifically. In terms of a nice smp high end scsi system. Sorry for the lack of specifics on that before. Gavin

Re: [GENERAL] SCO Extortion

2004-01-20 Thread Stephen Robert Norris
On Wed, 2004-01-21 at 11:55, Marc G. Fournier wrote: On Tue, 20 Jan 2004, Gavin M. Roy wrote: I'm currently one of the targets of SCO's linux licensing extortion business plan, and am contemplating switching to one of the BSD's to avoid any potential problems. I'm curious which BSD

Re: [GENERAL] SCO Extortion

2004-01-20 Thread Marc G. Fournier
On Wed, 21 Jan 2004, Stephen Robert Norris wrote: Of course SCO is planning to sue the BSD users, too, so it's not really a solution. We figure that SCO will either be bought out, or go bankrupt, before we have to worry about them :) Marc G. Fournier Hub.Org Networking Services

Re: [GENERAL] SCO Extortion

2004-01-20 Thread Marc G. Fournier
On Tue, 20 Jan 2004, Gavin M. Roy wrote: Thanks for the feedback thus far. I should also mention I use freebsd for other stuff, but I am mainly asking in peoples experience, which is the best for PostgreSQL to live on specifically. In terms of a nice smp high end scsi system. Sorry for the

Re: [GENERAL] SCO Extortion

2004-01-20 Thread Jim Mercer
On Tue, Jan 20, 2004 at 06:16:46PM -0800, Gavin M. Roy wrote: Thanks for the feedback thus far. I should also mention I use freebsd for other stuff, but I am mainly asking in peoples experience, which is the best for PostgreSQL to live on specifically. In terms of a nice smp high end scsi

Re: [GENERAL] SQL Exception Relation xxx does not exist

2004-01-20 Thread Alex
Kris, thanks for the reply. I dont actually use temp tables in the function (not that I know of) but I did truncated and reloaded a few tables incl. recreating indices the previous day, however the line no. indicated in the serverlog does not point to these sql calls. I am now re-starting