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 fo
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 cur
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
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 a
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 rowle
