Hi All,
I've been working on a small module that I will be pluging into my
local PostreSQL 8.x database and am in need of doing some table locking.
At this time, I've used various other examples to no avail and was
wondering what the proper method for aquiring a table lock within the
module
Hi All,
I've been doing a code audit (review) for my own personal use of the
7.4.x series code base and have come across something that I'd like to get
more details on, if it is possible to do so.
I've been going over the communications section and am curious how this
segment of code is
Ahh, so it's not attempting to turn it into an acsii string, just storing
raw binary data... Ok that makes sense now, thanks for the help.
At 02:54 PM 7/19/2005, Korry wrote:
If I understand the code right, your trying to pass in to
appendBinaryStringInfo an address or reference to the n8,
Hi Tom,
good to hear from you. It was my miss-understanding of what the code was
doing, not the issue with the compiler :
At 03:22 PM 7/19/2005, Tom Lane wrote:
Chris Bowlby [EMAIL PROTECTED] writes:
I understand the concept of the code, to append binary values to a string
buffer (char
Hi All,
I've been attempting to recover some data from a data file that was
dumped and compressed using pg_dump. I've noticed that the pg_restore
application was supposed to have some work put into place to help it
continue of it ran into an error, but I've run into an issue here it is not
Hi Vishal,
Unfortunately, this is not an option for me, I'm working with a file that
has 400505294 of 400513265 bytes that it can read successfully, however at
that spot in the file, there is a block that is 3870 bytes long as opposed
to the expected 4096 bytes. Running the command you gave me
In that table I'm pretty sure there are no other records, but I'm hoping
there are some records for the tables stored after that particular table..
At 05:48 PM 6/15/2004, Tom Lane wrote:
Chris Bowlby [EMAIL PROTECTED] writes:
pg_restore: restoring data for table test_opens
pg_restore
Hi Everyone,
Is there a way to find out how many dead index nodes are in a btree based
index? I'm attempting to track down how much of my index is bloated because
of dead nodes...
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
Ahh, perfect, thank you..
On Tue, 2004-04-27 at 16:18, Alvaro Herrera wrote:
On Tue, Apr 27, 2004 at 09:26:38AM -0300, Chris Bowlby wrote:
I've been noticing that files in the pg_clog directory test to stay
around forever, I know they are used to determine the state of
transaction id's
for pg_clog: it is no longer
necessary to keep old pg_clog entries around forever.)
How does one determine which files are no longer neccessary? Is the
system configured to clear out stale ones during startup/shutdown?
--
Chris Bowlby [EMAIL PROTECTED]
PostgreSQL Inc
not.
Has anyone else run into this problem?, is it safe to remove these
tables from the pg_class table or is it safe to create the tables
themselves?
--
Chris Bowlby [EMAIL PROTECTED]
PostgreSQL Inc.
---(end of broadcast)---
TIP 2: you can get off
?
--
Chris Bowlby [EMAIL PROTECTED]
PostgreSQL Inc.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing
)---
TIP 7: don't forget to increase your free space map settings
--
Chris Bowlby [EMAIL PROTECTED]
PostgreSQL Inc.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
(unlike the updates, which do show up). If the
transaction is closed and a new one is reopened, after all of the
inserts have been completed, then we can see them.
Is this the standard behaviour associate to transactions?
--
Chris Bowlby [EMAIL PROTECTED]
PostgreSQL Inc
Hi Simon,
Thanks for the confirmation, I just wanted to make sure I was not going
ape over it and getting confused.
At 08:04 PM 1/28/04, Simon Riggs wrote:
Chris Bowlby writes
I'm looking for some details on how the locking system works in
relation to transactions dealing with INSERTs
a ton
of time to get the results I'm looking for...
Does anyone know if any of these issues have been addressed in 7.4? I
see some references to schema based changes, but no details on what
those changes were. If not, are there any plans to do something like
that?
--
Chris Bowlby [EMAIL PROTECTED
. I don't want to have to connect to the database machine via a
different means because it's a step that can be forgotten very easily.
If I had the option to be able to create a new pg_hba.conf entry then I
could remember to do it right after I create a new database, and a user
for it.
Chris
)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Chris Bowlby,
-
Web Developer @ Hub.org.
[EMAIL PROTECTED]
www.hub.org
1-902-542-3657
Where are the 7.1 rpms downloadable from? (even the RC based ones)?
Chris Bowlby,
-
Web Developer @ Hub.org.
[EMAIL PROTECTED]
www.hub.org
1-902-542-3657
candidate 2 has this issue.
Chris Bowlby,
-
Web Developer @ Hub.org.
[EMAIL PROTECTED]
www.hub.org
1-902-542-3657
-
---(end of broadcast)---
TIP
20 matches
Mail list logo
