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 w
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 str
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 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 ac
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 "
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
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
con
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 comman
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
storage method 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 PRO
t. That was when
I noticed that these ones did 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 broa
s on optimizing?
--
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 t
regards, tom lane
>
> ---(end of broadcast)-------
> 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
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 dealin
otion (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]>
Pos
s for. If I've got 10,000 clients, that's going to take 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, a
. 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
nd of broadcast)---
> 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.
[EM
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
lease candidate 2 has this issue.
Chris Bowlby,
-
Web Developer @ Hub.org.
[EMAIL PROTECTED]
www.hub.org
1-902-542-3657
-
---(end of broadcast)--
?
Chris Bowlby,
-
Web Developer @ Hub.org.
[EMAIL PROTECTED]
www.hub.org
1-902-542-3657
-
---(end of broadcast)---
TIP 1: subscribe and
21 matches
Mail list logo