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 tomca
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 s
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
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 Service
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 B
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
M
--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 fo
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 poin
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
>
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.
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?
Thank
[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 her
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 use
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 w
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 PROTECTE
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)
I
16 matches
Mail list logo
