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
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
[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
[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
[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
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
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
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