Re: [ADMIN] VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2

1998-07-15 Thread Vadim Mikheev
Rob den Boer wrote: > > Hi all, > > I noticed that vacuum didnot run correctly, I got following message: > > VACUUM > NOTICE: BlowawayRelationBuffers(invoices, 26): block 27 is referenced > (private 0, last 0, global 1) > FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2 This

Re: [ADMIN] permissions to tuples

1998-07-29 Thread Vadim Mikheev
Jorge Maturana wrote: > > Hi all, > > How can i grant some privilege to a user on a tuple? > I found only grant and revoke to do this in a class. > Some help? You could use triggers (in C and TCL currently). Vadim

Re: [Fwd: RE: [ADMIN] create index and date type casting: howto?]

1999-06-03 Thread Vadim Mikheev
Terry Mackintosh wrote: > > P.S. > To the list maintainer: > Not having a "Reply-To:" mail header pointing back at the list is a > pain. Seems to me that it used to be there, what happened? Agreed!!! Mark? Vadim

Re: [ADMIN] record locking

1999-06-16 Thread Vadim Mikheev
Delain Huggins wrote: > > We are getting ready to set up a Postgres database w/Access frontend with > 15-25 users. What are the record locking concerns that we need to be aware What's PG version? 6.5? > of? Where is record locking set and what levels are there if any? Can In 6.5 writers loc

Re: [ADMIN] Crash revoery

1999-06-22 Thread Vadim Mikheev
Holger Mitterwald wrote: > > Good mornin, > > Last night my computer crashed and after restart the postgresql > database claims about an error. Yes, I DO have a backup, but this lacks > about 2 days which I like to recover. > > The error-message is: > ERROR: Index pg_proc_oid_index is not a bt

Re: [ADMIN] 6.5 hung

1999-07-07 Thread Vadim Mikheev
[EMAIL PROTECTED] wrote: > > Hi! > > I found a strange hunging of postgres 6.5. > In a few days working child process dumped to core but postmaster was runned it What does gdb say about this core? Vadim

Re: [ADMIN] Problem: PostgreSQL 6.5.1 backend crashing.

1999-08-03 Thread Vadim Mikheev
Anto Prijosoesilo wrote: > > #0 0x16f62 in _bt_isortcmpinit () > #0 0x16f62 in _bt_isortcmpinit () > #1 0x13c3c in btgettuple () _bt_isortcmpinit couldn't be called from btgettuple!!! This's static func in nbtsort.c used for index creation, not for querying. > Has anyone seen this problem? I

Re: [ADMIN] Elapsed time in vacuum?

1999-08-10 Thread Vadim Mikheev
"Bradford L. Barrett" wrote: > > Greetings all.. > > Quick question, hopefully someone can answer for me... We have been > running PostgreSQL for over a year now, using php3 to interface our > web site to the db.. current main db size consists of roughly 3 million > line items (electronic com