[HACKERS] locking mechanism
hi, 1)If the same PROCLOCK has some already-granted locks and be waiting for more, how do we know? I currently use the holding array of PROCLOCK to figure out what lockmodes a transaction(process) has been granted on LOCK,and if holdings sum comes to 0 that means this PROCLOCK is waiting for its associate LOCK. But how if the PROCLOCK has already been granted a lock and is waiting for another lock on the same object( LOCK), how do figure that out? 2)Is tuple level locks the same as row level locks? Thanks!! Jenny MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.
Re: [HACKERS] static dumper idea
On Thu, 2003-07-10 at 02:28, Christopher Kings-Lynne wrote: > How's this for an idea? We release a statically compiled version of pg_dump > (from the 7.4 tree say) that is able to dump 7.3, 7.2 databases etc. We > recommend to people that they use that to dump their existing database? Out of curiosity, what does the 7.4 pg_dump do better than the 7.3 version? signature.asc Description: This is a digitally signed message part
Re: [HACKERS] sugsestions
On Wed, 9 Jul 2003, Rod Taylor wrote: > On Tue, 2003-07-08 at 21:31, ivan wrote: > > What do you think about : > > > > 1. OPTION RETURNS NULL ON NULL INPUT (when function is created) change to > > RETURNS ON NULL INPUT ??? > > I personally think this should be up to the specific function to > capture. This way it could be a complex result. > > > 2. CREATE TYPE .. with INHERITS (..) like in CREATE TABLE > > but type should be normaly with including base type > > create type A AS (A INT,B INT); > > and > > create type B AS (C INT, D INT) INHERITS( A ); == > > create type B AS (A INT, B INT, C INT, D INT ); > > can be ?? > > I like this. The equivalent table syntax for absorbing table structure > into another table is LIKE: > > CREATE TABLE othertable (acol integer); > CREATE TABLE a (col integer, LIKE othertable, anothercol integer); > > I could see: > > CREATE TYPE a AS (a integer, b integer); > CREATE TYPE b AS (LIKE a, c integer, d integer); > This way is very good !! I see i thing : CREATE TABLE a AS (a int, b int); CREATE TABLE b AS (x a.a%ROWTYPE, a int, b a.b%ROWTYPE); like in plpgsql... May be there should be others word , but i want to show my view .. :> ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] Possible psql bug
On Thu, Jul 10, 2003 at 10:35:04AM +0800, Christopher Kings-Lynne wrote: > When I run psql on freebsd/alpha with latest CVS and no postmaster running, > I get this: > > bash-2.03$ psql test > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "ùÿÿÿØ`"? This is probably getnameinfo() not supporting AF_UNIX, which I already was afraid of. And the return value of getnameinfo() isn't checked either. My suggestion was to make our own getnameinfo_unix() like we have a getaddrinfo_unix() for exactly the same reason. It should be rather easy to write since we already have a getnameinfo() in it that supports it. Kurt ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] table-level and row-level locks.
Iam trying to acquire rowlevel locks in postgresql. I try doing this: 'select * from students where name='Larry' for update; But by looking at the holding array of proclock , I've noticed that by doing this only AccessShareLock gets acquired which is a table level lock. How do I acquire rowlevelock and what fields of Lock or Proclock datastructures indicate it. Thanks JennyHelp STOP SPAM with the new MSN 8 and get 2 months FREE*
