On Wed, Oct 20, 2004 at 12:31:11AM -0400, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Better, use mktemp(1). The thread testing script already does it IIRC.
>
> There are only two uses of mktemp(1) in our source tree: configure and
> config.guess. Both were gotten from elsew
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Better, use mktemp(1). The thread testing script already does it IIRC.
There are only two uses of mktemp(1) in our source tree: configure and
config.guess. Both were gotten from elsewhere, and both jump through
some seriously unreadable hoops in order
Neil Conway <[EMAIL PROTECTED]> writes:
> On Wed, 2004-10-20 at 06:18, Rod Taylor wrote:
>> http://secunia.com/advisories/12860/
> This seems like a rather inconsequential problem,
Indeed, since ordinary users have no use for make_oidjoins_check.
It's surely very implausible that anyone would run
On Wed, Oct 20, 2004 at 12:52:57PM +1000, Neil Conway wrote:
> On Wed, 2004-10-20 at 06:18, Rod Taylor wrote:
> > http://secunia.com/advisories/12860/
>
> This seems like a rather inconsequential problem, but it should be
> fixed. The first two ideas that come to mind: use temporary files in
> $PW
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Has a MySQL backend unfortunately - maybe I can convert them :)
We might not let you back otherwise! :)
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200410192349
-BEGIN PGP SIGNATURE-
iD8DBQFBdeDBvJuQZxSWSsgR
On Wed, 2004-10-20 at 06:18, Rod Taylor wrote:
> http://secunia.com/advisories/12860/
This seems like a rather inconsequential problem, but it should be
fixed. The first two ideas that come to mind: use temporary files in
$PWD rather than /tmp, or create a subdirectory in /tmp to use for the
tempo
On Tue, 19 Oct 2004, Sailesh Krishnamurthy wrote:
> > "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
>
> Tom> One huge advantage is that the actual heap visiting becomes
> Tom> efficient, eg you never visit the same page more than once.
> Tom> (What you lose is the ability to retrie
Enjoy the break :) Hints as to the 'other stuff' that is more
intersting then PostgreSQL? :) Or is it secret ... ?
It's probably just a joke. Can you imagine something more interesting
than PostgreSQL?!?
www.planeshift.it
(Sorry for the sucky flash intro :/)
I've been wanting to get into some 3
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> One huge advantage is that the actual heap visiting becomes
Tom> efficient, eg you never visit the same page more than once.
Tom> (What you lose is the ability to retrieve data in index
Tom> order, so this isn't a replacement
At 04:20 AM 20/10/2004, Tom Lane wrote:
Nope. I can break that trivially, eg:
Thats why in my first message I mentioned escaping and unescaping all '%'
in the deinition.
There's also the nontrivial matter of how pg_dump would decide where to
insert the %%tablespace%% string into the CREATE INDE
>Alvaro Herrera
> On Tue, Oct 19, 2004 at 11:22:31PM +0100, Simon Riggs wrote:
>
> > I was thinking about this recently, then realised that building the
bitmap
> > would not be as easily, since PostgreSQL doesn't index null values. That
> > would mean that the sets of CTIDs in each index would be d
> Tom Lane
> "Simon Riggs" <[EMAIL PROTECTED]> writes:
> > How would you dynamically build the bit maps from the indexes?
>
> > Or would you:
> > - copy aside and sort the indexes on CTID
> > - merge join them all to find matching CTIDs
> > - probe into the main table
>
> I've been taking "bitmap"
On Tue, 19 Oct 2004, Josh Berkus wrote:
> Tom,
>
> > I've been taking "bitmap" to be a rather handwavy way of saying "a
> > compact representation of sets of CTIDs that is readily amenable to
> > being ANDed and ORed with other sets".
>
> Well, actually I think we're talking about two different fe
Nurlan M. Mukhanov wrote:
> I wrote this css file 2 years ago. It's very useful when using docs.
> Can you add it in mainstream?
http://jigsaw.w3.org/css-validator/ should be your first stop. After
that, you can write to [EMAIL PROTECTED] with an explanation
about what your stylesheet does and
Tom,
> I've been taking "bitmap" to be a rather handwavy way of saying "a
> compact representation of sets of CTIDs that is readily amenable to
> being ANDed and ORed with other sets".
Well, actually I think we're talking about two different features:
1) a way to use more than one index per op
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> I was thinking about this recently, then realised that building the bitmap
> would not be as easily, since PostgreSQL doesn't index null values.
As Alvaro already pointed out, this statement is bogus; and I'm not sure
what it has to do with the topic any
Simon Riggs wrote:
I believe that the benefit of on-disk bitmap indexes is supposed to be
reduced storage size (compared to btree).
The main problem is the need for the table to be read-only. Until we have
partitioning, we wouldn't be able to easily guarantee parts of a table as
being (effect
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> I was wondering whether my_exec_path might need to be marked DLLIMPORT.
>> Not sure about the other symbol though.
> Is this going to be fixed? Right now tsearch2 is totally busted for
> Windows. I would fix it but my attempt (markin
On Tue, Oct 19, 2004 at 11:22:31PM +0100, Simon Riggs wrote:
> I was thinking about this recently, then realised that building the bitmap
> would not be as easily, since PostgreSQL doesn't index null values. That
> would mean that the sets of CTIDs in each index would be disjoint. My
> thinking ab
Tom Lane wrote:
Info: resolving _my_exec_path by linking to __imp__my_exec_path (auto-import)
fu01.o(.idata$3+0xc): undefined reference to `libpostgres_a_iname'
nmth00.o(.idata$4+0x0): undefined reference to `_nm__my_exec_path'
I was wondering whether my_exec_path might need to be
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> AFAICS, your info shows that the standard's definition of DETERMINISTIC is
> confusing and contradictory. Most people's interpretation would be that
> DETERMINISTIC was the same as IMMUTABLE, so we should make the former a
> synonym for the latter and doc
>Mark Kirkwood wrote
> > Tom Lane wrote:
> >
> >I believe that the term "bitmap index" is also used with a different
> >meaning wherein it actually does describe a particular kind of on-disk
> >index structure, with one bit per table row.
> >
> >IMHO building in-memory bitmaps (the first idea) is a
>Tom Lane wrote
> In any case, whether or not you think DETERMINISTIC means IMMUTABLE,
Tom, Your knowledge of the confusing bits of the standard puts us all to
shame.
Troels did have a point, which was to do with standards conformance and
compatibility. The main point at issue is whether someone
Hello Josh,
I will take a look at pgFoundry and register a new project for index
selection. I will also look for other projects there that we may help
somehow. About the tutorial, I will send you the presentation we used
to generate the web pages so that you can see it with OpenOffice. ;)
Th
Hello!
I wrote this css file 2 years ago. It's very useful when using docs.
Can you add it in mainstream?
Thanks.
Nurlan MukhanovBODY { font-family : Tahoma; font-size : 8pt; color : #33; background: #FF; }
A:LINK { color : #66; }
A:HOVER { color : #CC;text-decoration : underline
http://secunia.com/advisories/12860/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Oct 19, 2004, at 2:05 PM, Joshua D. Drake wrote:
There comes the time in every hackers life when he discovers that
even unsuccessfully chasing girls can be more fun than debugging
kernel modules or interface libraries. Some get over that phase
without greater collateral damage, some become su
On Tue, 19 Oct 2004, Jan Wieck wrote:
On 10/19/2004 12:11 PM, Andreas Pflug wrote:
Marc G. Fournier wrote:
Enjoy the break :) Hints as to the 'other stuff' that is more intersting
then PostgreSQL? :) Or is it secret ... ?
It's probably just a joke. Can you imagine something more interesting than
Philip Warner <[EMAIL PROTECTED]> writes:
> DEFINITION: CREATE TABLE fred ... %%tablespace%% ...
> TABLESPACE: ' TABLESPACE t'
> pg_restore would read these, and use the settings from the command line to
> either substitute an empty string or the TABLESPACE text for %%tablespace%%
> in the DEFIN
At 03:25 AM 20/10/2004, Tom Lane wrote:
Maybe there's something I don't understand. How are you expecting
pg_restore to control whether it outputs the command with a TABLESPACE
clause embedded or not, if pg_dump has already built the command string
that way?
This will only work if we modify the du
There comes the time in every hackers life when he discovers that even
unsuccessfully chasing girls can be more fun than debugging kernel
modules or interface libraries. Some get over that phase without greater
collateral damage, some become successfull in the chasing, some then get
caught by t
GB:
> I would like to know if there are any discussions about
> creating an embedded version on postgresql. My thoughts
> go towards building/porting a sqlite equivalent of pg.
Not that I personally know of.While it would be nice to have an embeddable
database which was syntax-compatible wit
On 10/19/2004 11:41 AM, Andrew Sullivan wrote:
On Tue, Oct 19, 2004 at 01:28:52PM +0100, Ben Osborne wrote:
Postgres 7.0.2 Problem
---
Yikes. That's old.
(only) database which is running (other than template1). I suspect that the
files in the data directory have
On 10/19/2004 12:11 PM, Andreas Pflug wrote:
Marc G. Fournier wrote:
Enjoy the break :) Hints as to the 'other stuff' that is more
intersting then PostgreSQL? :) Or is it secret ... ?
It's probably just a joke. Can you imagine something more interesting
than PostgreSQL?!?
There comes the time i
Philip Warner <[EMAIL PROTECTED]> writes:
> At 03:06 AM 20/10/2004, Tom Lane wrote:
>> I think the tricky part of that would be inserting the tablespace clause
>> in the right place; for CREATE INDEX this seems to require nontrivial
>> parsing. (Both the index column definitions and the WHERE clau
At 03:06 AM 20/10/2004, Tom Lane wrote:
I think the tricky part of that would be inserting the tablespace clause
in the right place; for CREATE INDEX this seems to require nontrivial
parsing. (Both the index column definitions and the WHERE clause could
be arbitrarily complicated expressions.) If
Philip Warner <[EMAIL PROTECTED]> writes:
> To solve this, we should dump the table definition as a format string and
> dump the tablespace clause (ie. ' TABLESPACE ts') as a separate part of the
> table definition TOC entry. If the user wants the tablespace to be dumped,
> then we substitute th
"Ben Osborne" <[EMAIL PROTECTED]> writes:
> Postgres 7.0.2 Problem
> I am having a rather big problem with an installation of postgres 7.0.2 on
> cobalt, in that the db server is unable to see any of the data stored in the
> (only) database which is running (other than template1).
The symptoms s
On Thu, Oct 14, 2004 at 09:49:47AM +0200, [EMAIL PROTECTED] wrote:
> Dear Sirs,
>
> I would like to know if there are any discussions about
> creating an embedded version on postgresql. My thoughts
> go towards building/porting a sqlite equivalent of pg.
The discussion comes up occasionally. Afte
Marc G. Fournier wrote:
Enjoy the break :) Hints as to the 'other stuff' that is more
intersting then PostgreSQL? :) Or is it secret ... ?
It's probably just a joke. Can you imagine something more interesting
than PostgreSQL?!?
Regards,
Andreas
---(end of broadcast)
Neil Conway <[EMAIL PROTECTED]> writes:
> Granted, but I think you've mostly conceded my point: every _subsequent_
> time TAS() is invoked, the non-locking test is a clear win (with the
> possible exception of PPC).
I'm not real sure. One point here is that the standard advice about
this stuff is
On Tue, Oct 19, 2004 at 01:28:52PM +0100, Ben Osborne wrote:
> Postgres 7.0.2 Problem
> ---
Yikes. That's old.
> (only) database which is running (other than template1). I suspect that the
> files in the data directory have been conrrupted or otherwise lost
> in
Am Montag, 18. Oktober 2004 19:43 schrieb Tom Lane:
> An alternative possibility is to stop pretending that pgport is agnostic
> about whether it is in backend or frontend. This might mean some
> duplication of code between src/port/ and src/backend/port/, but if
> that's what it takes to have san
On 10/12/2004 4:02 PM Tom Lane could be overheard saying::
Marcos A Vaz Salles <[EMAIL PROTECTED]> writes:
In order to make index selection possible, we
have extended the PostgreSQL DBMS to allow the simulation of
hypothetical indexes. We believe these server extensions may be of
value for addit
> >>o fix shared memory on Win2k terminal server
> >>
> >>We might be able to just mark this as not supported.
> >
> >I have attached a patch that I think fixes this. The problem I saw
> >and fixed is, that the shmem created in a terminal services client is not
> >visible to the console
The command-line argument parsing in pg_ctl is not portable. This is the
output on a glibc system:
$ pg_ctl start stop
pg_ctl: too many command-line arguments (first is "start")
But:
$ POSIXLY_CORRECT=1 pg_ctl start stop
pg_ctl: too many command-line arguments (first is "stop")
This is probab
On Tue, Oct 19, 2004 at 08:47:20AM -0400, Andrew Dunstan wrote:
> But maybe we can just live with what we have and advertise that 8.0's
> plperl is more secure.
The release notes should point out that 7.4's plperl is unsecure unless
the correct version of Safe.pm is installed. Maybe it works to
Neil Conway wrote:
On Tue, 2004-10-19 at 02:45, Andrew Dunstan wrote:
*shrug* OK. Then plperl should probably not be regarded as being as
"trusted" as we would like. Note that old versions of Safe.pm have been
the subject of security advisories such as this one
http://www.securityfocus.com/
Enjoy the break :) Hints as to the 'other stuff' that is more intersting
then PostgreSQL? :) Or is it secret ... ?
On Tue, 19 Oct 2004, Christopher Kings-Lynne wrote:
To stop everyone asking me - I will still be working on phpPgAdmin, no need
to panic :)
Next release of phpPgAdmin should be a
Postgres 7.0.2
Problem
---
I am having a rather
big problem with an installation of postgres 7.0.2 on cobalt, in that the db
server is unable to see any of the data stored in the (only) database which is
running (other than template1). I suspect that the fi
Hallo!
I would like to know if there are any discussions
about managing directories from Postgresql Datnbank
System. Or knows anybody how to manage it?
Thanks
___
Gesendet von Yahoo! Mail - Jetz
To stop everyone asking me - I will still be working on phpPgAdmin, no
need to panic :)
Next release of phpPgAdmin should be at the same time as 8.0 PostgreSQL.
Chris
Christopher Kings-Lynne wrote:
Hi everyone,
I think I'll be taking some time off from the PostgreSQL project, to
work on other st
>>I'm trying to modify the storage manager now.
>
> Um ... why?
Because I want to add my new storage manager.
It is not just for (single) magnetic disk.
> If anyone had wanted to add a new storage manager in the last fifteen
> years, we'd doubtless have tried to clean this up some, but no one h
Satoshi Nagayasu <[EMAIL PROTECTED]> writes:
> I'm trying to modify the storage manager now.
Um ... why?
There is no doubt that the current smgr interface leaves a lot to be
desired, but the reason that it's in such sad shape is that there is
absolutely no modern-day use for an API at that partic
On Tue, 2004-10-19 at 02:45, Andrew Dunstan wrote:
> *shrug* OK. Then plperl should probably not be regarded as being as
> "trusted" as we would like. Note that old versions of Safe.pm have been
> the subject of security advisories such as this one
> http://www.securityfocus.com/bid/6111/info/
55 matches
Mail list logo