Dennis Bjorklund said:
On Sun, 25 Apr 2004, Andrew Dunstan wrote:
Why do you want two names? Just keep the original casing, and a
boolean saying if it's quoted or not.
Sorry - brain malfunction - yes, original casing plus boolean would
work. In effect you could derive the canonical form
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.
- 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 Java
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 working on the
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 index
[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
[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 access
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
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
[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
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
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 index
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
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
[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
[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 session be visible
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
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
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'.
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..
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
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 keeps
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
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.
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
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
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
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, let
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 mindset on
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. I tried the
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
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
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 commands
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
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 to do
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-safety)
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
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*
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,
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
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
software
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 target
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, let
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 the
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 some last
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
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
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
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
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 deletes.
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
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
transaction.
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
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
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
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 assumptions
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 pgAdmin III,
-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
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]
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 thinking ---
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
[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 for
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 code
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, and then
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
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 if the directory
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 vpath
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 would have to
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.us
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 the xlog
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 would
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 a needs more
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, 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 (alvherre[a]dcc.uchile.cl)
Tiene valor aquel que
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
[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
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 shared
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
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
80 matches
Mail list logo
