Thomas Hallgren wrote:
> Hi,
> I've made some very encouraging tests using The GNU version of Java known as
> GCJ together with my Pl/Java implementation . At present I use GCJ just like
> any other JVM, i.e. as an interpreter. This is not very optimal since GCJ
> can compile all Java code into sha
[EMAIL PROTECTED] wrote:
> I work at Coverity where we make a static analysis tool to find bugs in
> software at compile time. I think I found a security hole in
> postgresql-7.4.1, but I don't want to just report it to a public list. I
> sent email to [EMAIL PROTECTED], hoping that the address e
On Mon, Apr 26, 2004 at 09:36:26PM -0400, Rod Taylor wrote:
> The function format_type() fails only for interval when used on the
> interval type
>
> template1=# select format_type(oid, typlen) from pg_type;
select format_type(oid, typtypmod) from pg_type;
-- works
In fact, I believe this is the
On Mon, Apr 26, 2004 at 03:09:48PM -0400, Bruce Momjian wrote:
>
> OK, I worked with Alvaro via IM and it is fixed now.
It worked cleanly for me. Thanks.
Also, the thread flags look correct, but then I'm not a "threaded
person."
--
Alvaro Herrera ()
"Tiene valor aquel que admite que es un cob
The function format_type() fails only for interval when used on the
interval type
template1=# select format_type(oid, typlen) from pg_type;
ERROR: invalid INTERVAL typmod: 0xc
template1=# select format_type(oid, typlen) from pg_type where typname
!= 'interval';
-- Many results
On Mon, 2004-04-26 at 18:08, Bruce Momjian wrote:
> Simon Riggs wrote:
> >
> > Well, I guess I was fairly happy too :-)
>
> YES!
>
> > I'd be more comfortable if I'd found more bugs though, but I'm sure the
> > kind folk on this list will see that wish of mine comes true!
> >
> > The code is in
Simon Riggs wrote:
> On Mon, 2004-04-26 at 23:01, Alvaro Herrera wrote:
> > On Mon, Apr 26, 2004 at 05:05:41PM -0400, Bruce Momjian wrote:
> > > Simon Riggs wrote:
> > > > Transaction log files currently have timestamps, so that is
> > > > straightforward, but probably not the best we can do. We wo
On Mon, 2004-04-26 at 23:01, Alvaro Herrera wrote:
> On Mon, Apr 26, 2004 at 05:05:41PM -0400, Bruce Momjian wrote:
> > Simon Riggs wrote:
> > > Transaction log files currently have timestamps, so that is
> > > straightforward, but probably not the best we can do. We would
> > > rollforward until t
Merlin Moncure wrote:
> make clean appears to have fixed the initdb crash :)
> sorry to bother... :)
> > Are you sure you're using a clean build and a really current checkout?
>
> Yes, 100%.
Care to update that percentage? :-)
--
Bruce Momjian| http://candle.pha.pa.
On Mon, 2004-04-26 at 22:05, Bruce Momjian wrote:
> Simon Riggs wrote:
> > Transaction log files currently have timestamps, so that is
> > straightforward, but probably not the best we can do. We would
> > rollforward until the xlog file time > desired point in time.
> >
> > To make (2) work we wo
OK, I worked with Alvaro via IM and it is fixed now.
---
Alvaro Herrera wrote:
> On Mon, Apr 26, 2004 at 01:15:13PM -0400, Bruce Momjian wrote:
> > Alvaro Herrera wrote:
> > > The thread testing program is not nice to a vpat
Bruce Momjian wrote:
> Merlin Moncure wrote:
> > > > I'll check why the rmdir command is not working as expected.
> > >
> > > I just poked around and couldn't figure out the cause. Initdb
should
> > > either remove the directory if it created it, or remove everything
> > _in_
> > > the directory i
Hey,
First of all, who is this? I don't recognize the e-mail, and you haven't
been signing any of your posts.
> true, others, however, are very welcoming to direction.
AFAIK, this includes none of our major code contributors. So all you're
really talking about is manipulating the TODO list
Has this been resolved?
---
Andrew Sullivan wrote:
> On Mon, Apr 19, 2004 at 11:18:07AM -0400, Tom Lane wrote:
> >
> > What you'd need to do is determine which system headers are being
> > #include'd by that config test, an
> Hey,
>
> First of all, who is this? I don't recognize the e-mail, and you haven't
> been signing any of your posts.
I've been posting on hackers on and off for a few years. My name is Mark.
>
>> true, others, however, are very welcoming to direction.
>
> AFAIK, this includes none of our major
[EMAIL PROTECTED] wrote:
> If we want to make PostgreSQL a wildly popular product, there will be
> some pain. There should be a "Product Management" group. The
> leader(s) of this group should be chosen carefully, as he (they) must
> be free to define what PostgreSQL is. They must have a good feel
Hi, Mark,
Yes, I've seen your e-mails around. You should use a sig, though, they're
easy to create.
> I think I am talking about something different. In a company, the core
> team would be the CTO. I think some entity, one or more people, needs to
> define the product. Typically this is market
On Mon, Apr 26, 2004 at 05:05:41PM -0400, Bruce Momjian wrote:
> Simon Riggs wrote:
> > Transaction log files currently have timestamps, so that is
> > straightforward, but probably not the best we can do. We would
> > rollforward until the xlog file time > desired point in time.
>
> I was thinkin
make clean appears to have fixed the initdb crash :)
sorry to bother... :)
Merlin
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> My question is, "What can we learn from MySQL?" I don't know there is
> anything, but I think it makes sense to ask the question.
Dear Bruce,
Taking the example of pgAdmin III, which reached nearly one million hits in
December (http://www.pgadmin
Jean-Michel POURE wrote:
[ PGP not available, raw data follows ]
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> > My question is, "What can we learn from MySQL?" I don't know there is
> > anything, but I think it makes sense to ask the question.
>
> Dear Bruce,
>
> Taking the example of
On Mon, 2004-04-26 at 16:37, Simon Riggs wrote:
> I've now completed the coding of Phase 1 of PITR.
>
> This allows a backup to be recovered and then rolled forward (all the
> way) on transaction logs. This proves the code and the design works, but
> also validates a lot of the earlier assumption
Josh Berkus wrote:
Shachar,
I think the concensus was that the runtime part was aprox. four lines
where the case folding currently takes place. Obviously, you would have
to get a var, and propogate that var to that place, but not actually
change program flow.
That's only if you ignore th
> I want to come hug you --- where do you live? !!!
You're not the only one. But we don't want to smother the poor guy, at
least not before he completes his work :-)
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an
Shachar,
> I think the concensus was that the runtime part was aprox. four lines
> where the case folding currently takes place. Obviously, you would have
> to get a var, and propogate that var to that place, but not actually
> change program flow.
That's only if you ignore the system catalogs
Simon Riggs wrote:
> Transaction log files currently have timestamps, so that is
> straightforward, but probably not the best we can do. We would
> rollforward until the xlog file time > desired point in time.
>
> To make (2) work we would have to have a timestamp associated with each
> transactio
Josh Berkus wrote:
I also didn't follow the discussion of why a client-side implementation was
technically impossible; this seems like the most obvious course to me, and to
have *considerable* benefit.It's also consistent with our other statement
variables, such as datestyle, which are all c
On Mon, 26 Apr 2004 14:29:58 +0100, Simon Riggs <[EMAIL PROTECTED]>
wrote:
>> Now that FSM
>> covers free btree index pages this access pattern might be highly
>> nonsequential.
>
>I had considered implementing a mode where the index doesn't keep trying
>to reuse space that was freed by earlier d
The reason we are using pl/j instead of pl/java is that the word java is
protected by sun. We chose J, who knew there was a programming language
called J :(
--dc--
On Tue, 2004-04-20 at 15:19, Chris Browne wrote:
> [EMAIL PROTECTED] (Dave Cramer) writes:
> > Pl/J is a java procedural language for
Well, I guess I was fairly happy too :-)
I'd be more comfortable if I'd found more bugs though, but I'm sure the
kind folk on this list will see that wish of mine comes true!
The code is in a "needs more polishing" state - which is just the right
time for some last discussions before everything
I want to come hug you --- where do you live? !!!
:-)
---
Simon Riggs wrote:
> I've now completed the coding of Phase 1 of PITR.
>
> This allows a backup to be recovered and then rolled forward (all the
> way) on transac
Shalu Gupta wrote:
Hello,
We are trying to import the TPC-H data into postgresql using the COPY
command and for the larger files we get an error due to insufficient
memory space.
We are using a linux system with Postgresql-7.3.4
Is it that Postgresql cannot handle such large files or is there some
Since Phase1 is functioning and should hopefully soon complete, we can
now start thinking about Phase 2: full recovery to a point-in-time.
Previous thinking was that a command line switch would be used to
specify recover to a given point in time, rather than the default, which
will be recover all
Simon Riggs wrote:
>
> Well, I guess I was fairly happy too :-)
YES!
> I'd be more comfortable if I'd found more bugs though, but I'm sure the
> kind folk on this list will see that wish of mine comes true!
>
> The code is in a "needs more polishing" state - which is just the right
> time for s
On Mon, Apr 26, 2004 at 11:37:37AM -0400, Merlin Moncure wrote:
> > I have no idea what caused the pg_depend stuff to crash.
>
> The AV is in postgres.exe following the first SQL call in
> setup_depend(). The problem is not in initdb (it hasn't changed) but
> something in the backend. Changing t
> When all is said and done, I think the PostgreSQL project lacks a "Product
> Management" group which steers the public perception and defines
> usability. This is something *all* other systems have, including MySQL.
Well, NO, not a chance.
As one of the de-facto heads of our Advocacy group,
Alvaro Herrera wrote:
> The thread testing program is not nice to a vpath build. I see this
> error:
>
> checking for gmake... gmake
> checking thread safety of required library functions... Makefile:13:
> ../../../src/Makefile.global: No such file or directory
> gmake: *** No rule to make targe
Shachar,
> Now, I'm intending to do the best I can on my end. This does have a
> pretty heavy cost. It means that the OLE DB driver will parse in details
> each query, and perform replacements on the query text. This is bug
> prone, difficult, hurts performance, and just plain wrong from a
> softw
Josh Berkus wrote:
Shachar,
Now, I'm intending to do the best I can on my end. This does have a
pretty heavy cost. It means that the OLE DB driver will parse in details
each query, and perform replacements on the query text. This is bug
prone, difficult, hurts performance, and just plain wrong f
I'm certain you guys could do a far better installer than the one Oracle
has, which is very, very fragile. There's all kinds of wonkiness to try
and get it to work on a non-supported linux distro (gentoo in my case),
and from talking to people who've dealt with it on redhat it's no
better.
Also, i
Alvaro Herrera wrote:
> > The AV is in postgres.exe following the first SQL call in
> > setup_depend(). The problem is not in initdb (it hasn't changed)
but
> > something in the backend. Changing the SQL statement made no
> > difference: I'd venture a guess that postgres.exe crashes when *any*
>
Merlin Moncure wrote:
> > I have no idea what caused the pg_depend stuff to crash.
>
> The AV is in postgres.exe following the first SQL call in
> setup_depend(). The problem is not in initdb (it hasn't changed) but
> something in the backend. Changing the SQL statement made no
> difference: I'd
On Mon, Apr 26, 2004 at 01:15:13PM -0400, Bruce Momjian wrote:
> Alvaro Herrera wrote:
> > The thread testing program is not nice to a vpath build. I see this
> > error:
> > (Basically what I'm doing is create an empty directory, cd to it and
> > then call ../sourcedir/configure --enable-thread-s
On Wed, Apr 21, 2004 at 10:25:29PM -0400, Christopher Browne wrote:
>
> I'll point out one "fly in ointment" that has been noticed; on AIX,
> there are compilation tools that are difficult to live without, namely
> "mkldexport.sh", that lives pretty deep in the source tree.
That's just a problem
On Sun, Apr 25, 2004 at 05:15:19PM -0400, [EMAIL PROTECTED] wrote:
> (5) Programming languages. We need to make a programming language standard
> in PostgreSQL. plpgsql is good, but isn't someone working on a Java
> language. That would be pretty slick.
If there's going to be a single standard la
> > I'll check why the rmdir command is not working as expected.
>
> I just poked around and couldn't figure out the cause. Initdb should
> either remove the directory if it created it, or remove everything
_in_
> the directory if the directory already existed. I tried the rmdir/del
> /s /q comm
Shachar,
I've been giving this some more thought. Here are my contributions:
> 1. Setting should be on a per-database level. A per-server option is not
> good enough, and a per-session option is too difficult to implement,
> with no apparent justifiable return.
I disagree with this. I think do
> In an attempt to throw the authorities off his trail, [EMAIL PROTECTED]
> transmitted:
>> Is anyone really ready for this sort of commitment?
>
> By that, I presume you mean...
>
> "Are people prepared to stop working on the doubtless useful things
> that they are working on in favor of spending
Merlin Moncure wrote:
> > > I'll check why the rmdir command is not working as expected.
> >
> > I just poked around and couldn't figure out the cause. Initdb should
> > either remove the directory if it created it, or remove everything
> _in_
> > the directory if the directory already existed.
Tom Lane wrote:
>Personally I don't think that this is a "transitional issue" and we will
>someday all be happy in upper-case-only-land. Upper-case-only sucks,
>by every known measure of readability, and I don't want to have to put up
>with a database that forces that 1960s-vintage-hardware minds
>
>> When all is said and done, I think the PostgreSQL project lacks a
>> "Product
>> Management" group which steers the public perception and defines
>> usability. This is something *all* other systems have, including MySQL.
>
> Well, NO, not a chance.
>
> As one of the de-facto heads of our Advoc
> On Sun, Apr 25, 2004 at 05:15:19PM -0400, [EMAIL PROTECTED] wrote:
>> (5) Programming languages. We need to make a programming language
>> standard
>> in PostgreSQL. plpgsql is good, but isn't someone working on a Java
>> language. That would be pretty slick.
>
> If there's going to be a single s
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] transmitted:
> Is anyone really ready for this sort of commitment?
By that, I presume you mean...
"Are people prepared to stop working on the doubtless useful things
that they are working on in favor of spending their time i
Bruno Wolff III wrote:
On Fri, Apr 23, 2004 at 16:36:57 -0400,
[EMAIL PROTECTED] wrote:
Ease of use is VERY important, but few suggestions that address this are
ever really accepted. Yes, focusing on the functionality is the primary
concern, but "how" you set it up and deploy it is VERY importa
Bruno Wolff III wrote:
On Fri, Apr 23, 2004 at 16:36:57 -0400,
[EMAIL PROTECTED] wrote:
Ease of use is VERY important, but few suggestions that address this are
ever really accepted. Yes, focusing on the functionality is the primary
concern, but "how" you set it up and deploy it is VERY important
Bruce Momjian wrote:
Peter Eisentraut wrote:
Rob wrote:
But I think there is room to go further, I don't see any reason why
that default install can't include example DBs,
One reason is that a useful example database would likely have a
download footprint of 10 MB or more. Having this in the defa
Hello,
I have a project I'm moving from mysql to postgresql. It has both a
fair amount of code and a moderate amount of data. In MySQL the
identifiers are all MixedCase, but the query strings are never quoted.
I would like to change the default behaviour of postgresql to not fold
the case to lo
> > The specific details aren't especially relevant to this thread, though.
> > What is relevant is that we agree to a commitment that we will make
> > it easy to build modules outside the current Postgres build environment,
> > and that we will have an ongoing commitment to make sure that that ke
On Apr 23, 2004, at 8:35 AM, Christopher Kings-Lynne wrote:
My question is, "What can we learn from MySQL?" I don't know there is
anything, but I think it makes sense to ask the question.
Questions I have are:
I have already told Bruce at length about the single most common
complaint in the phpPg
Hi
I am working on a project in postgres..in which i designed customized data type
and operations on it.it requires a look up table..
I have three options regarding this table...
1. Every time a query is executed it creates table assigns values and after
execution destroys it...which is overhead..
The thread testing program is not nice to a vpath build. I see this
error:
checking for gmake... gmake
checking thread safety of required library functions... Makefile:13:
../../../src/Makefile.global: No such file or directory
gmake: *** No rule to make target `../../../src/Makefile.global'. S
Hi!
I face the following problem:
2 tables: tblperson and tblnotes
tblperson:
colums: personid (PK), name
tblnotes:
colums: noteid(PK), personid(references tblperson(personid)), note
tblnotes has notes stored written by a person from tblperson identified (FK)
by its personid.
I make a select o
> I have no idea what caused the pg_depend stuff to crash.
The AV is in postgres.exe following the first SQL call in
setup_depend(). The problem is not in initdb (it hasn't changed) but
something in the backend. Changing the SQL statement made no
difference: I'd venture a guess that postgres.exe
[EMAIL PROTECTED] ("Matthew T. O'Connor") wrote:
>> Bruce Momjian wrote:
>> Should pg_autovacuum be vacuuming temporary tables?
>
> This is a good question, and I would like some opinions from some other
> people more informed than I.
>
>> Secondly, why would
>> a temporary table for another sessio
[EMAIL PROTECTED] (Dave Cramer) writes:
> Pl/J is a java procedural language for postgres. We are looking for
> alpha testers to help us find bugs, and get feedback.
>
> The project can be found at
>
> http://plj.codehaus.org/
>
> Bugs can be reported at
>
> http://jira.codehaus.org/secure/BrowsePr
I've now completed the coding of Phase 1 of PITR.
This allows a backup to be recovered and then rolled forward (all the
way) on transaction logs. This proves the code and the design works, but
also validates a lot of the earlier assumptions that were the subject of
much earlier debate.
As noted
Hi Haim,
Is the PostgreSQL license (http://www.postgresql.org/licence.html) LGPL
compatible? I have adapted some code (for jdate manipulation) into the
OLE DB project (LGPL). I have copied over the copyright notice, but now
I'm thinking that this may not be enough.
On the front page of the site
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Tom Lane) wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> My personal opinion is that contrib should be removed entirely.
>
> That's not real workable for code that is tightly tied to the backend,
> such as the various GIST in
Thanks Janko!
I was hoping for a query-only solution (SQL only), but this will work just
great. :-)
If I switch database this code will give me some trouble.
I guess I'll have to stick to Postgresql. ;-)
Thanks.
Regards,
Erwin Moller
Janko Richter wrote:
> Perhaps this helps:
>
> CREATE
[Previously posted to General list]
I have an embedded system running FreeBSD (5.1) that does not have any local
(rotating) storage (i.e. disk drives).
PostgreSQL (7.3.2.1) also runs on this box and (at this point) has two
tables. It is an extremely simple PostgreSQL configuration with the table
Perhaps this helps:
CREATE AGGREGATE concat (
BASETYPE = text,
SFUNC= textcat, -- is function of operator 'text || text'
STYPE= text,
INITCOND = ''
);
SELECT
P.personid,
P.name,
concat( N.note ) AS allnotesbythisperson
FROM tblperson AS P
INNER JOIN tblnotes AS N ON N.per
Merlin Moncure wrote:
[sorry for the repost...lists down? Problem may or may not be on win32
version only]
The catalog number was updated, so it was time to run initdb.
Sometime over the weekend (or since the last initdb I ran, about a
week), the source was updated which caused an AV & CRASH during
On Mon, Apr 26, 2004 at 02:29:58PM +0100, Simon Riggs wrote:
> On Sun, 2004-04-25 at 22:34, Manfred Koizar wrote:
> > Is there a special reason for scanning the leaf pages in *logical*
> > order, i.e. by following the opaque->btpo_next links? Now that FSM
> > covers free btree index pages this ac
[sorry for the repost...lists down? Problem may or may not be on win32
version only]
The catalog number was updated, so it was time to run initdb.
Sometime over the weekend (or since the last initdb I ran, about a
week), the source was updated which caused an AV & CRASH during
initdb...specifical
[EMAIL PROTECTED] wrote:
> PostgreSQL. Maybe it is in the form of a web server like Samba's SWAT
> utility, I don't know (A SWAT type utility could run as the PostgreSQL
I've found webmin to be pretty good swat type tool...it's lacking some
things to be a full postgres administration system, but I
On Sun, 2004-04-25 at 22:34, Manfred Koizar wrote:
> On -performance we have been discussing a configuration where a bulk
> delete run takes almost a day (and this is not due to crappy hardware or
> apparent misconfiguration). Unless I misinterpreted the numbers,
> btbulkdelete() processes 85 inde
"Christopher Browne" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> In an attempt to throw the authorities off his trail, [EMAIL PROTECTED]
transmitted:
> > Is anyone really ready for this sort of commitment?
>
> By that, I presume you mean...
>
> "Are people prepared to stop workin
> -> PL/Java is well and interesting, but requires a barrel of non-free
>software, which makes installation and configuration anything but
>"slick."
>
I think it's a bit unfair to say that Pl/Java requires a "barrel of non-free
software".
Pl/Java doesn't require any software besides the Ja
On Mon, 26 Apr 2004, Andrew Dunstan wrote:
> Ideas still swirling a bit
Sure, I'm thinking in public as well. Not something you want to do if you
are afraid of being wrong and showing it :-) But I'm not.
> The constraint would in effect be on CASE WHEN quoted THEN name ELSE upper
> (name) END.
79 matches
Mail list logo
