Ken Ashcraft [EMAIL PROTECTED] writes:
I work at Coverity where we use static analysis to find bugs in
software. I ran a security checker over postgresql-7.4.1 and I think I
found a security hole.
In the code below, fld_size gets copied in from a user specified file.
It is passed as the
Simon Riggs [EMAIL PROTECTED] writes:
Currently, recovery loops until end of xlogs. There is no exit condition
from the loop. There is not currently a timestamp on the xlogs -
anywhere apart from the file date on each xlog.
Sure there is: every transaction commit record (and I think abort as
On Tue, 2004-05-11 at 16:33, Bruce Momjian wrote:
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm ... I think it should be forbidden to quote a subtrans Xid as
rollforward point. Not sure if that can be done though, or how to do
it.
Seems like a nonissue, unless the
OK, DELETE added:
* Add MERGE command that does UPDATE/DELETE, or on failure,
INSERT (rules, triggers?)
---
Bricklen wrote:
Alvaro Herrera wrote:
snip
Oh, I see. Complex stuff ... I wonder how
A few questions may help to speed up my work
I need to send a signal from a backend to the archiver process.
1. What signal should I use?
2. How do I give the processid of the archiver to the backend? The
archiver may restart at any time, so its pid could change after a
backend is forked.
I
Simon Riggs wrote:
A few questions may help to speed up my work
I need to send a signal from a backend to the archiver process.
1. What signal should I use?
You can use any unused signal. I would suggest looking at what the
stats processes uses, and use something else like SIGUSR1.
2.
Thomas Hallgren [EMAIL PROTECTED] writes:
The PGSQL_MAJOR_VER and PGSQL_MINOR_VER does not exist today. Ideally,
I'd like to find them in src/Makefile.global. Only thing present seems
to be the VERSION. I'd like to see something like:
PGSQL_MAJOR_VER := 7
PGSQL_MINOR_VER := 5
Simon Riggs wrote:
During recovery, we would search for a timestamp. If found exactly,
stop. If exceeded, stop. Any transactions not committed at that point
are, as we say, out of luck. This approach has a certainty about it
that I think is much better than the error prone Xid hunting
On Tue, May 11, 2004 at 09:25:37PM +0100, Simon Riggs wrote:
On Tue, 2004-05-11 at 16:33, Bruce Momjian wrote:
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm ... I think it should be forbidden to quote a subtrans Xid as
rollforward point. Not sure if that can be done
Simon Riggs [EMAIL PROTECTED] writes:
I need to send a signal from a backend to the archiver process.
1. What signal should I use?
SIGUSR1 or SIGUSR2 would be the safest choices.
2. How do I give the processid of the archiver to the backend? The
archiver may restart at any time, so its pid
Hi all,
strange errors with a empty table:
kalman=# create table test();
CREATE TABLE
kalman=# select * from test t union select * from test t1;
ERROR: invalid memory alloc request size 0
I think this have to return:
--
(0 rows)
Regards
Gaetano Mendola
---(end of
Alvaro Herrera [EMAIL PROTECTED] writes:
Both xact commit and abort have timestamps in the XLog. I think valid
recovery points are transaction commit/abort, not transaction start.
A transaction abort cannot be an interesting stop point either; you may
as well stop at the latest preceding
On Tue, 2004-05-11 at 21:29, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
Currently, recovery loops until end of xlogs. There is no exit condition
from the loop. There is not currently a timestamp on the xlogs -
anywhere apart from the file date on each xlog.
Sure there is:
On Tue, 2004-05-11 at 22:15, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
I need to send a signal from a backend to the archiver process.
1. What signal should I use?
SIGUSR1 or SIGUSR2 would be the safest choices.
2. How do I give the processid of the archiver to the
On Tue, 2004-05-11 at 22:01, Bruce Momjian wrote:
Anyway, I though we agreed to just get total recovery working for 7.5
and we can deal with recovery to a particular point later.
Back on target now! Regards, Simon
---(end of broadcast)---
TIP 1:
Bruce Momjian [EMAIL PROTECTED] writes:
Many transactions are going to have the same timestamp because that just
isn't precise enough to choose a particular transaction.
I think this argument is largely a red herring ... but if it makes you
feel better, we could change the contents of the
Thanks to all of you for such swift advice and correction!
Have a good evening...
On Tue, 2004-05-11 at 22:26, Alvaro Herrera wrote:
On Tue, May 11, 2004 at 09:25:37PM +0100, Simon Riggs wrote:
On Tue, 2004-05-11 at 16:33, Bruce Momjian wrote:
Tom Lane wrote:
Alvaro Herrera [EMAIL
Tom Lane wrote:
Ken Ashcraft [EMAIL PROTECTED] writes:
I work at Coverity where we use static analysis to find bugs in
software. I ran a security checker over postgresql-7.4.1 and I think I
found a security hole.
In the code below, fld_size gets copied in from a user specified file.
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Many transactions are going to have the same timestamp because that just
isn't precise enough to choose a particular transaction.
I think this argument is largely a red herring ... but if it makes you
feel better, we could change the
Tom Lane wrote:
Thomas Hallgren [EMAIL PROTECTED] writes:
The PGSQL_MAJOR_VER and PGSQL_MINOR_VER does not exist today. Ideally,
I'd like to find them in src/Makefile.global. Only thing present seems
to be the VERSION. I'd like to see something like:
PGSQL_MAJOR_VER := 7
PGSQL_MINOR_VER := 5
Alvaro Herrera [EMAIL PROTECTED] writes:
On Tue, May 11, 2004 at 09:25:37PM +0100, Simon Riggs wrote:
Another way of putting it - if it was worth writing before a crash, it
is worth recovering after a crash. Surely?
Right.
Wrong. Only actions that were *committed* before the crash, or in
On Tue, May 11, 2004 at 11:07:47PM +0100, Simon Riggs wrote:
On Tue, 2004-05-11 at 22:26, Alvaro Herrera wrote:
Right. What I was saying is that we don't need pg_subtrans info,
because that's only needed while the subtransaction is marked as
subcommitted but it's parent hasn't committed
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
I think this argument is largely a red herring ... but if it makes you
feel better, we could change the contents of the commit timestamp to
be gettimeofday() output (seconds+microseconds) instead of just time()
output. That should be
Bruce Momjian [EMAIL PROTECTED] writes:
Should we be thinking about a 7.4.3?
I'm not panicking over this particular bug ... but it does seem like
we've accumulated enough fixes since 7.4.2 that it may be time to start
thinking about another dot-release. Maybe set a date towards the end of
the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
DBD::Pg uses pg_config --version and parses the output to set the
version information before compiling. It finds pg_config by using
PG envrironment variables, or looks in the path. Once running, it
does a SELECT version() to find out what server
WITH LOCATION would be great, That way you could distribute your
databases across multiple physical disks a lot easier than looking up
oid's
and moving the db after it's been created, mounting it over the top of the
cluster directory
Actually WITH LOCATION already exists, but it
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
I think this argument is largely a red herring ... but if it makes you
feel better, we could change the contents of the commit timestamp to
be gettimeofday() output (seconds+microseconds) instead of just time()
Fresh checkout of CVS HEAD yesterday, updated today :
$ ./configure --prefix=/usr/local/pgsql/7.5
$ make
gmake[4]: Entering directory
`/usr/home/postgres/develop/c/pgsql/src/backend/access/nbtree'
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations
Tom Lane wrote:
Thomas Hallgren [EMAIL PROTECTED] writes:
PGSQL_MAJOR_VER := 7
PGSQL_MINOR_VER := 5
PGSQL_PATCH_VER := devel
VERSION := $(PGSQL_MAJOR_VER).$(PGSQL_MINOR_VER).$(PGSQL_PATCH_VER)
To be used in CPPFLAGS as: -DPGSQL_MAJOR_VER=$(PGSQL_MAJOR_VER) etc.
Wouldn't it be better to just put
Sorry for the confusion because Rod asked a question
and I answered too quickly. This is what I mean.
15x Slower:
---
Client --TCP-- PgPool --UNIX-- PostgreSQL
Client --TCP-- PgPool --TCP-- PostgreSQL
5x Faster:
--
Client --UNIX-- PgPool --UNIX-- PostgreSQL
Gaetano Mendola wrote:
Hi all,
someone of you sent me an example of a new data type
called tinyint.
Hi.
I seen that is using a well directory structure just
for compile a tinyint.c.
Yes. The idea was to have it do more than just this one type. Maybe a
bad idea, on retrospect.
Is there any
On Tue, 2004-05-11 at 04:05, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
A simple idea would be to add the committed subxact Xids to the
xl_xact_commit and xl_xact_abort structs. However, this will be a
variable length array, and those structs already have variable length
Bruce Momjian kirjutas T, 11.05.2004 kell 00:26:
Hannu Krosing wrote:
Bruce Momjian kirjutas E, 10.05.2004 kell 06:58:
Added to TODO:
* Add MERGE command that does UPDATE, or on failure, INSERT
perhaps the issue raised about BEFOR/AFTER INSERT/UPDATE TRIGGERS and
RULES should
Hannu Krosing wrote:
Bruce Momjian kirjutas T, 11.05.2004 kell 00:26:
Hannu Krosing wrote:
Bruce Momjian kirjutas E, 10.05.2004 kell 06:58:
Added to TODO:
* Add MERGE command that does UPDATE, or on failure, INSERT
perhaps the issue raised about BEFOR/AFTER
On Tue, May 11, 2004 at 07:44:53AM +0100, Simon Riggs wrote:
Tom Lane wrote:
Just means you have to do some address arithmetic instead of being able
to reference the additional data as a struct member. Tedious but hardly
difficult. See for instance the handling of move data in
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm ... I think it should be forbidden to quote a subtrans Xid as
rollforward point. Not sure if that can be done though, or how to do
it.
Seems like a nonissue, unless the XLOG trace makes a subtrans look the
same as a main trans, which it'd not do
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm ... I think it should be forbidden to quote a subtrans Xid as
rollforward point. Not sure if that can be done though, or how to do
it.
Seems like a nonissue, unless the XLOG trace makes a subtrans look the
same as a main
On Tue, May 11, 2004 at 10:37:49AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm ... I think it should be forbidden to quote a subtrans Xid as
rollforward point. Not sure if that can be done though, or how to do
it.
Seems like a nonissue, unless the XLOG trace
Tom Lane wrote:
The sort of semantic funny I am thinking of is like this:
* postgresql.conf contains pljava::var = somegoodvalue
* ALTER DATABASE SET supplies pljava::var = somebadvalue
For builtin variables the ALTER DATABASE value would be rejected on
sight and the end result would be that the
After takin a swig o' Arrakan spice grog, Anonymous [EMAIL PROTECTED] belched out:
Does anybody here know how to hack into a mysql database?
You might want to visit a mailing list devoted to MySQL; they might
know...
--
output = reverse(gro.gultn @ enworbbc)
Alvaro Herrera wrote:
snip
Oh, I see. Complex stuff ... I wonder how will it work with sequences
-- if one insertion fails and we have to try again, there's a chance a
sequence could be advanced more than once. Note the article skips the
signal-statement symbol (is it present in SQL99? What
hello!
i want to insert jpeg pictures into a bytea field and i implemented a
SPI extension. this function reads the jpeg-file from the filesystem,
converts it into a octal-coded string to pass the sql-parser, and then
exec's the insert statement. this is rather slow, and i'd like to insert
I'm sorry to keep bringing this up, but I keep thinking that PostgreSQL is
a PITA to configure. It isn't that I don't know how, or can't read the
documents, it's just that there is too many things that can go wrong or
leave me with the How does that work? feeling where I need to test
before I
Christopher Browne wrote:
After takin a swig o' Arrakan spice grog, Anonymous [EMAIL PROTECTED] belched out:
Does anybody here know how to hack into a mysql database?
You might want to visit a mailing list devoted to MySQL; they might
know...
And possibly even care, too.
I'd like to make a small suggestion that would enable external modules
to manage dependencies to PostgreSQL versions. Consider the following code:
#if PGSQL_MAJOR_VER 7 || (PGSQL_MAJOR_VER == 7 PGSQL_MINOR_VER 4)
result = HeapTupleGetDatum(tuple);
#else
/* PostgreSQL 7.4 or earlier
Wolfgang Reichart wrote:
hello!
i want to insert jpeg pictures into a bytea field and i implemented a
SPI extension. this function reads the jpeg-file from the filesystem,
converts it into a octal-coded string to pass the sql-parser, and then
exec's the insert statement. this is rather
46 matches
Mail list logo