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
Hackers (especially Tom),
Would it be right to set the fast-root as true root during a VACUUM
FULL? This would free all pages between true root and fast root.
(I'm not advocating to do it, nor volunteering; I'm merely wondering).
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Ninguna manada de
Alvaro Herrera [EMAIL PROTECTED] writes:
Would it be right to set the fast-root as true root during a VACUUM
FULL? This would free all pages between true root and fast root.
Possibly okay, but why bother? It's hardly likely to free a meaningful
number of pages. And I think you'd need to
Carlos Guzman Alvarez wrote:
Hello:
Hello Carlos.
I continue to work in the implementation of the 3.0 protocol in C#, i'm
making a test that consist on:
- Create a database.
- Create a table in the new database.
- Start transaction.
- Insert 100 rows of data in the new table.
- Commit
Hi List
Out of some reason our data of our postgresql database has been corrupted. When we try
to connect to the database we get:
psql: ERROR: _mdfd_getrelnfd: cannot open relation pg_type_oid_index:
No such file or directory
REINDEX does not work. We get the same error.
pgfsck gives us:
Tatsuo Ishii wrote:
I have looked into my Linux box and found this in /usr/share/i18n/charmaps/BIG5.gz:
% Chinese charmap for BIG5 (CP950)
% version: 0.92
% Contact: Tung-Han Hsieh [EMAIL PROTECTED]
% Yuan-Chung Cheng [EMAIL PROTECTED]
% Distribution and use is free, even
So following modification seems to fixed all PG (7.3/7.3.3)crashes on
Solaris ( NON C LOCALE )
selfuncs.c line 2356:
I changed:
xfrmsize = strlen(val) + 32;/*arbitrary pad value here...*/
to
xfrmsize = strxfrm(NULL, val, 0) + 32;
so basically instead of wild guess of transformed string size