[HACKERS] Re: Various silliness in heap_getnext and related routines

2001-06-09 Thread Robert E. Bruccoleri
Dear Tom, > > > Robert Bruccoleri ([EMAIL PROTECTED]) wrote: > > It's not clear to me why the spinlock needs be grabbed at the > > beginning of RelationGetBufferWithBuffer, > > I believe you are right: the spinlock doesn't need to be grabbed, > because if a valid buffer is passed in, it must al

[HACKERS] Re: [JDBC] unlink large objects

2001-06-09 Thread Tom Lane
Philip Crotwell <[EMAIL PROTECTED]> writes: > I was vacuuming, but as the owner of the database. When I do that there > are messages that should have clued me in, lke > NOTICE: Skipping "pg_largeobject" --- only table owner can VACUUM it > From now on I will vacuum as user postgres, but I wonder

[HACKERS] Re: Various silliness in heap_getnext and related routines

2001-06-09 Thread Tom Lane
[EMAIL PROTECTED] (Robert E. Bruccoleri) writes: > For my immediate problem, would removing the spinlock acquisition > be OK? It'd be interesting to remove the marked lines: bufHdr = &BufferDescriptors[buffer - 1]; - SpinAcquire(BufMgrLock); if (bufHdr->tag.bloc

Re: [HACKERS] ERROR: Memory exhausted in AllocSetAlloc(909324558)

2001-06-09 Thread Tom Lane
[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes: > charcardnum[48]; > ... > newval = CStringGetDatum(cardnum); And you are trying to assign this datum to what kind of column? (Hint: there isn't any kind for which a plain C string is valid data.) regards, tom l

Re: [HACKERS] ERROR: Memory exhausted in AllocSetAlloc(909324558)

2001-06-09 Thread Tom Lane
[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes: > Do I have to manually create a varlena? I'll try that next. The best way to get from a C string to a valid datum is to invoke the datatype's input conversion routine. If you know you want text, you could do #define _textin(str) DirectFunctionCall1

Re: [HACKERS] grant and SQL92

2001-06-09 Thread Vince Vielhaber
On Sat, 9 Jun 2001, Peter Eisentraut wrote: > Vince Vielhaber writes: > > > I can grant a series of privileges (comma separated) on a series of > > objects (comma separated) to either a user, group or public NOT a > > comma separated list of users or groups. > > I should have this finished today

Re: [HACKERS] Baby girl

2001-06-09 Thread Vince Vielhaber
On Sat, 9 Jun 2001, Bruce Momjian wrote: > > I had a baby girl on Tuesday. I am working through my backlogged emails > today. Congrats papa! Enjoy a cigar for me (either real or chocolate, your choice :) Vince. -- == Vin

Re: [HACKERS] cstring datatype

2001-06-09 Thread Tom Lane
Alex Pilosov <[EMAIL PROTECTED]> writes: > Anything came out of this discussion? Nothing's been done yet, but it still seems like a good idea. There are a number of related issues that I'd want to see tackled at the same time, all arising from the overuse of type OID zero to mean several differe