Josh Berkus wrote:
intagg: what does this module do which is not already available
through the built-in array functions and operators? Maybe I
don't understand what it does. Unnatributed in the README. Move
to pgfoundry?
Short summary:
Is there an equivalent of int_array_enum() built in?
elein wrote:
intarray: data_types/
what does this do that arrays do not?
It provides lossy indexes that work well on big arrays;
as well as some quite useful convenience functions that
work on arrays of ints.
---(end of broadcast)---
TIP 7:
On Wed, Jun 08, 2005 at 10:06:18AM +0530, Abhijit Menon-Sen wrote:
Are any PostgreSQL hackers planning to be at Linuxtag in Karlsruhe?
Yes and there will be a PostgreSQL booth organized by Peter.
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot
Tom Lane [EMAIL PROTECTED] writes
I very seriously doubt that there would be *any* win
I did a quick proof-concept implemenation to test non-concurrent batch
insertion, here is the result:
Envrionment:
- Pg8.0.1
- NTFS / IDE
-- batch 16 pages extension --
test=# insert into t
Am Dienstag, 7. Juni 2005 19:53 schrieb Josh Berkus:
I think it would also be helpful to users if we could create
subdirectories to organize contrib into categories. This would
help users and packagers find what they want. These
directories would be:
data_types/
functions/
utilities/
I
Mark Wong [EMAIL PROTECTED] writes
http://developer.osdl.org/markw/postgrescvs/
The last two jump points looks nice! They are pulled from CVS on 5.30 and
6.1. Where the performance improvements come from? I could remember:
* 5.30: avoid unnecessary foregin key check
Seems CRC patch is not
Abhijit Menon-Sen wrote:
Are any PostgreSQL hackers planning to be at Linuxtag in Karlsruhe?
I'll be at the booth.
Regards,
Andreas
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
The regression test file subselect.sql contains the following query under the
heading Correlated subselects:
SELECT '' AS five, f1 AS Correlated Field
FROM SUBSELECT_TBL
WHERE (f1, f2) IN (SELECT f2, CAST(f3 AS int4) FROM SUBSELECT_TBL
WHERE f3 IS NOT NULL);
It has been
David Fetter wrote:
On Tue, Jun 07, 2005 at 10:27:28PM +0900, Atsushi Ogawa wrote:
David Fetter wrote:
Ogawa-san,
I think that this would be a case for function overloading:
function regexp_replace(
string text, pattern text, replacement text
) RETURNS TEXT; /* First
Peter Eisentraut [EMAIL PROTECTED] writes:
The regression test file subselect.sql contains the following query under the
heading Correlated subselects:
SELECT '' AS five, f1 AS Correlated Field
FROM SUBSELECT_TBL
WHERE (f1, f2) IN (SELECT f2, CAST(f3 AS int4) FROM SUBSELECT_TBL
On K, 2005-06-08 at 21:32 +0900, Atsushi Ogawa wrote:
How about changing the function name of each usage?
regexp_replace:replace first
regexp_replace_all:replace all
regexp_ic_replace: replace first and case insensitive
regexp_ic_replace_all: replace all and case
Qingqing Zhou [EMAIL PROTECTED] writes:
What I did include:
make ReadPage(+empty_page) treat different of an empty page and non-empty
one to avoid unnecesary read for new pages, that is:
In other words, if FSM is wrong you will overwrite valid data? No
thanks ... this is guaranteed to fail
On Tue, Jun 07, 2005 at 02:53:32PM -0300, Josh Berkus wrote:
noupdate: this is a cool example of a simple C trigger and would
be lovely to have in a doc somewhere. However, its
functionality is easily replicated through a simple PL/pgSQL
trigger so it seems unnecessary as a contrib module.
Peter,
Packagers should simply build all contrib items. No extra options are
needed.
No, they shoudn't. 3 of the packages currently in /contrib are GPL.
Building them makes all of PostgreSQL GPL.
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of
Peter,
I think this is out of the question both because these categories are fuzzy
and it would destroy the CVS history. It might be equally effective to
organize the README file along these lines.
Ach, I forgot about this lovely property of CVS. Well, scratch that proposal.
SVN is
Josh Berkus josh@agliodbs.com writes:
Packagers should simply build all contrib items. No extra options are
needed.
No, they shoudn't. 3 of the packages currently in /contrib are GPL.
Building them makes all of PostgreSQL GPL.
The fix for that is to remove or relicense those packages,
Tom,
The fix for that is to remove or relicense those packages, not to
complicate the build process.
OK. Then we'll make BSD licensing an absolute requirement for /contrib?
Also, we'll add --build-all-contrib to ./configure?
--
Josh Berkus
Aglio Database Solutions
San Francisco
On Wed, Jun 08, 2005 at 08:45:42AM -0700, Josh Berkus wrote:
Peter,
Packagers should simply build all contrib items. No extra options are
needed.
No, they shoudn't. 3 of the packages currently in /contrib are GPL.
Building them makes all of PostgreSQL GPL.
No, it means the
Josh Berkus josh@agliodbs.com writes:
Tom,
The fix for that is to remove or relicense those packages, not to
complicate the build process.
OK. Then we'll make BSD licensing an absolute requirement for /contrib?
That's been the intention for a very long time: everything in the core
tarball
On Wed, Jun 08, 2005 at 08:59:37AM -0700, Josh Berkus wrote:
Peter,
I think this is out of the question both because these categories are fuzzy
and it would destroy the CVS history. It might be equally effective to
organize the README file along these lines.
Ach, I forgot about this
On Wednesday 08 June 2005 12:05, Alvaro Herrera wrote:
On Wed, Jun 08, 2005 at 08:45:42AM -0700, Josh Berkus wrote:
Peter,
Packagers should simply build all contrib items. No extra options are
needed.
No, they shoudn't. 3 of the packages currently in /contrib are GPL.
Building
People:
No, it means the distributors are illegally distributing software they
don't have permission to distribute. The GPL doesn't make everything
else GPL right away, that's a myth.
I'm not talking out of my hat here. I consulted a staff member of the FSF
about it (will give name as
I've took a look at the TODO item
Allow objects to be moved to different schemas
I've done some code so far which implements the syntax
ALTER [OBJECT] name SET SCHEMA name
where OBJECT currently is
SEQUENCE
TABLE
Josh Berkus josh@agliodbs.com writes:
I will point out that all three GPL modules are currently unmaintained.
I don't know that anyone has seen Massimo in years. Simply dropping them
seems the easiest answer.
The original authors of the backend code haven't been seen on this list
in a
On Wed, Jun 08, 2005 at 08:25:12PM +0200, Bernd Helmle wrote:
One issue that comes to my mind is what to do when dealing with tables that
have assigned triggers and sequences (serials). Do we want to move them as
well or leave them in the source namespace?
I'd think it's important that the
Bernd Helmle [EMAIL PROTECTED] writes:
You can find a preliminary patch attached to this posting and i'm looking
for comments, critics and perhaps some proposals for improvements /
necessary changes i didn't consider yet.
The code seems fairly schizoid about whether the operation is an alter
On Wed, Jun 08, 2005 at 11:13:01AM -0700, Josh Berkus wrote:
People:
No, it means the distributors are illegally distributing software they
don't have permission to distribute. The GPL doesn't make everything
else GPL right away, that's a myth.
I'm not talking out of my hat here.
On Wed, 8 Jun 2005, Josh Berkus wrote:
Peter,
Packagers should simply build all contrib items. No extra options are
needed.
No, they shoudn't. 3 of the packages currently in /contrib are GPL.
Building them makes all of PostgreSQL GPL.
Then they should be removed ...
Marc G.
On Wed, 8 Jun 2005, Peter Eisentraut wrote:
Am Dienstag, 7. Juni 2005 19:53 schrieb Josh Berkus:
I think it would also be helpful to users if we could create
subdirectories to organize contrib into categories. This would
help users and packagers find what they want. These
directories would
Hello,
Does it look like it is going to make it for 8.1?
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG -
Hi,
I was searching for some information about the storage of the user data
in postgresql. As far as I know there is one dictionary table for
storeing all the users of any known database, right?
As we'd like to provide a postgresql database service to our students
we'd like to create one
Marc G. Fournier [EMAIL PROTECTED] writes:
On Wed, 8 Jun 2005, Peter Eisentraut wrote:
I think this is out of the question both because these categories are fuzzy
and it would destroy the CVS history.
Why would it destroy the history? Its easy enough to move the files to a
subdirectory
On Wed, Jun 08, 2005 at 04:21:46PM -0300, Marc G. Fournier wrote:
On Wed, 8 Jun 2005, Peter Eisentraut wrote:
Am Dienstag, 7. Juni 2005 19:53 schrieb Josh Berkus:
I think it would also be helpful to users if we could create
subdirectories to organize contrib into categories. This would
Joshua D. Drake wrote:
Does it look like it is going to make it for 8.1?
I certainly hope so. However, I don't have much time to put towards it
between now and July 1. Also, I will need significant help from someone
to get past some of the issues that I'm not really capable of. I am
On Wed, 8 Jun 2005, Alvaro Herrera wrote:
On Wed, Jun 08, 2005 at 04:21:46PM -0300, Marc G. Fournier wrote:
On Wed, 8 Jun 2005, Peter Eisentraut wrote:
Am Dienstag, 7. Juni 2005 19:53 schrieb Josh Berkus:
I think it would also be helpful to users if we could create
subdirectories to
On Tue, 07 Jun 2005 14:53:32 -0300, Josh Berkus wrote:
[Discussion snipped]
xml and xml2: both by John Gray ([EMAIL PROTECTED]). John, why do we have
two of these? Otherwise, data_types/.
contrib/xml2 is a lot better than /xml. When I submitted the new code,
Bruce felt that /xml should be
On Wed, Jun 08, 2005 at 06:50:06PM -0300 I heard the voice of
Marc G. Fournier, and lo! it spake thus:
On Wed, 8 Jun 2005, Alvaro Herrera wrote:
On Wed, Jun 08, 2005 at 04:21:46PM -0300, Marc G. Fournier wrote:
Why would it destroy the history? Its easy enough to move the files to a
Atsushi Ogawa said:
How about changing the function name of each usage?
regexp_replace:replace first
regexp_replace_all:replace all
regexp_ic_replace: replace first and case insensitive
regexp_ic_replace_all: replace all and case insensitive
That's just horrible. The
On Wed, Jun 08, 2005 at 05:54:08PM -0500, Matthew D. Fuller wrote:
That's why you COPY the files in the repo, cvs rm the old locations
(so they still exist on older tags/branches), and do some surgery on
Hmm, while we are at the subject of playing with our CVS server, could
we fix some other
On Wed, 8 Jun 2005, Matthew D. Fuller wrote:
On Wed, Jun 08, 2005 at 06:50:06PM -0300 I heard the voice of
Marc G. Fournier, and lo! it spake thus:
On Wed, 8 Jun 2005, Alvaro Herrera wrote:
On Wed, Jun 08, 2005 at 04:21:46PM -0300, Marc G. Fournier wrote:
Why would it destroy the history?
Marc G. Fournier [EMAIL PROTECTED] writes:
On Wed, 8 Jun 2005, Matthew D. Fuller wrote:
That's why you COPY the files in the repo, cvs rm the old locations
(so they still exist on older tags/branches), and do some surgery on
the new locations to remove the old tags (though you can't remove
Robert Treat wrote:
On Tuesday 07 June 2005 10:57, David Fetter wrote:
On Tue, Jun 07, 2005 at 10:27:28PM +0900, Atsushi Ogawa wrote:
My idea is opposite. I think that the regexp_replace() should make
replace all a default. Because the replace() of pgsql replaces all
string, and
On Tuesday 07 June 2005 10:57, David Fetter wrote:
On Tue, Jun 07, 2005 at 10:27:28PM +0900, Atsushi Ogawa wrote:
My idea is opposite. I think that the regexp_replace() should make
replace all a default. Because the replace() of pgsql replaces all
string, and regexp_replace() of oracle10g
Tom Lane wrote:
That's been the intention for a very long time: everything in the core
tarball should be under the same license. Someone's got to do the
legwork of contacting the module authors involved to see if they're
willing to relicense ... and so far it just hasn't gotten to the top
of
Andrew Dunstan wrote:
Atsushi Ogawa said:
How about changing the function name of each usage?
regexp_replace:replace first
regexp_replace_all:replace all
regexp_ic_replace: replace first and case insensitive
regexp_ic_replace_all: replace all and case insensitive
On 08/06/2005 21:57:29, Bruce Momjian wrote:
Andrew Dunstan wrote:
Atsushi Ogawa said:
How about changing the function name of each usage?
regexp_replace:replace first
regexp_replace_all:replace all
regexp_ic_replace: replace first and case insensitive
Done.
---
Simon Riggs wrote:
On Mon, 2005-06-06 at 22:09 -0400, Bruce Momjian wrote:
After months of being behind, I have gone through my entire mailbox and
addressed all the patches held over from 8.0beta. I have
aAndreas Pflug wrote:
Abhijit Menon-Sen wrote:
Are any PostgreSQL hackers planning to be at Linuxtag in Karlsruhe?
I'll be at the booth.
Sorry, I will not be there this year. The past two years that I
attended were great and I encourage others to attend.
--
Bruce Momjian
I will post tomorrow on a plan for this.
---
Matthew T. O'Connor wrote:
Joshua D. Drake wrote:
Does it look like it is going to make it for 8.1?
I certainly hope so. However, I don't have much time to put towards
How are ppl using this? I'm trying to use it to re-configure, having
tried both tcsh and bash, and neither seem to 'work':
# ./configure `pg_config --configure`
configure: error: invalid variable name: '--with-libraries
So, is there another way I can use the output from pg_config to pass to
One issue that comes to my mind is what to do when dealing with tables
that have assigned triggers and sequences (serials). Do we want to move
them as well or leave them in the source namespace?
They should all be moved. Remember nasties like indexes should be moved
as well as toast tables.
I usually just look at config.log, and copy and
paste...but I am guessing you are trying to automate
this. Looks like pg_config adds '' around each option
when specifying --configure (i.e. '--with-libraries'),
at least on my system (Linux, PG803). You can try to
get rid of the ''. This seems to
Tom Lane [EMAIL PROTECTED] writes
In other words, if FSM is wrong you will overwrite valid data? No
thanks ... this is guaranteed to fail under simple concurrent usage,
let alone any more interesting scenarios like FSM being actually out of
date.
You are welcome ;-). The FSM
On Wed, 8 Jun 2005, Brett Schwarz wrote:
I usually just look at config.log, and copy and
paste...but I am guessing you are trying to automate
this. Looks like pg_config adds '' around each option
when specifying --configure (i.e. '--with-libraries'),
at least on my system (Linux, PG803). You
Tom Lane [EMAIL PROTECTED] writes
This is not an issue except if the system might actually try to recover;
which is not the case in the postmaster snippet you mention.
Yeah, you are right. I scratched elog/ereport(FATAL/PANIC), only found this
one might be a suspect:
In
On Thu, Jun 09, 2005 at 12:26:06AM -0300, Marc G. Fournier wrote:
pgsql74# ./configure `pg_config --configure | tr ' `
configure: WARNING: you should use --build, --host, --target
configure: error: unrecognized option: -rpath=/usr/lib:/usr/local/lib
Try `./configure --help' for more
Yann,
As we'd like to provide a postgresql database service to our students
we'd like to create one database for each user. This user should be able
to create new accounts for other users but only for his/her database.
That's on the TODO list. As far as I know, nobody is currently working on
Neil,
I've volunteered to do this in the past, and the response was that it is
something that only members of core are in a position to do this. That
is perfectly reasonable, but that was quite some time ago -- it would be
nice to see some movement on this...
I thought I *was* moving on
On Wed, Jun 08, 2005 at 10:25:18PM -0400, Bruce Momjian wrote:
I will post tomorrow on a plan for this.
If you need developer time, I'm available to work on this as it seems
higher priority to me that shared dependencies.
--
Alvaro Herrera (alvherre[a]surnet.cl)
Hay que recordar que la
Marc G. Fournier wrote:
On Wed, 8 Jun 2005, Brett Schwarz wrote:
./configure `pg_config --configure | tr ' `
Thought of that too, still blows up:
How about
./configure `pg_config --configure|sed s/\'//g`
Cheers
Mark
---(end of
I've been making a bit of progress on adding a day field to the
Interval struct (thanks to the help of this list and the find folks
on IRC). Selects and basic math seem to be working, and the code is
passing more regression tests than it was before.
I'm running into a bit of a problem with
Qingqing Zhou [EMAIL PROTECTED] writes:
Yeah, you are right. I scratched elog/ereport(FATAL/PANIC), only found this
one might be a suspect:
In _hash_expandtable():
if (!_hash_try_getlock(rel, start_nblkno, HASH_EXCLUSIVE))
elog(PANIC, could not get lock on supposedly new bucket);
Or
Michael Glaesemann [EMAIL PROTECTED] writes:
I've been making a bit of progress on adding a day field to the
Interval struct (thanks to the help of this list and the find folks
on IRC). Selects and basic math seem to be working, and the code is
passing more regression tests than it was
Marc G. Fournier wrote:
# ./configure `pg_config --configure`
configure: error: invalid variable name: '--with-libraries
The intended mode of usage is
eval ./configure `pg_config --configure`
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
* Tom Lane ([EMAIL PROTECTED]) wrote:
It's essential IMHO that we provide pg_shadow and pg_group as reasonably
backward-compatible views on the new pg_roles catalog. It's not at all
negotiable that CREATE USER and CREATE GROUP have to still work in a
sane fashion --- to say otherwise is to
65 matches
Mail list logo