On Mon, Apr 10, 2006 at 10:02:25PM -0400, Bruce Momjian wrote:
>
> The patch wasn't ignored. It is just that I never got to applying it yet.
Neil's patch vs. psql supercedes this :)
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
On 2006-04-11, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> What does enabling plpgsql do via access that you can't just do from an
>> SQL query?
>
> SQL isn't Turing-complete
SQL with the ability to create recursive functions, as exists in pg, is
certain
On Tue, Apr 11, 2006 at 12:47:03AM -0400, Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > What does enabling plpgsql do via access that you can't just do from an
> > SQL query?
>
> SQL isn't Turing-complete
With all due respect, SQL *is* Turing-complete. Here's a little demo
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> What does enabling plpgsql do via access that you can't just do from an
> SQL query?
SQL isn't Turing-complete --- plpgsql is. So if our would-be hacker has
a need to do some computation incidental to his hack, he can certainly
get it done in plpgs
On Mon, 10 Apr 2006, Joshua D. Drake wrote:
Tom Lane wrote:
Andrew - Supernews <[EMAIL PROTECTED]> writes:
On 2006-04-10, Bruce Momjian wrote:
[ security ]
It actually is the reason I have heard.
And it was duly debunked.
That is the reasoning, and personally I agree with it. You don'
Jamie,
> I am trying to set up slony on a 10.4.5 and i am having a few issues
> with the installation process.
Please use the Slony mailing list:
http://gborg.postgresql.org/mailman/listinfo/slony1-general
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of
Hi,
I am trying to set up slony on a 10.4.5 and i am having a few issues
with the installation process.
command i have run
./configure --with-pgsourcethree=/usr/local/src/postgresql-8.0.7
make
but when i run make install i get the following message make: 'install'
is upto date.
Tom Lane wrote:
Andrew - Supernews <[EMAIL PROTECTED]> writes:
On 2006-04-10, Bruce Momjian wrote:
[ security ]
It actually is the reason I have heard.
And it was duly debunked.
That is the reasoning, and personally I agree with it. You don't leave
sharp objects sitting around if you ha
On 2006-04-11, Tom Lane <[EMAIL PROTECTED]> wrote:
> Andrew - Supernews <[EMAIL PROTECTED]> writes:
>> On 2006-04-10, Bruce Momjian wrote:
[ security ]
>>> It actually is the reason I have heard.
>
>> And it was duly debunked.
>
> That is the reasoning, and personally I agree with it. You do
Andrew - Supernews <[EMAIL PROTECTED]> writes:
> On 2006-04-10, Bruce Momjian wrote:
>>> [ security ]
>> It actually is the reason I have heard.
> And it was duly debunked.
That is the reasoning, and personally I agree with it. You don't leave
sharp objects sitting around if you have no need to
Tom Lane wrote:
> Bruce Momjian writes:
> > TODO has:
> > * Allow user-defined functions retuning a domain value to enforce domain
> > constraints
>
> > Is there something we should add to this?
>
> Yeah, a DONE marker ;-)
OK, marked as done. I assume that's what you mean, or are you
The patch wasn't ignored. It is just that I never got to applying it yet.
---
David Fetter wrote:
> On Sat, Mar 11, 2006 at 12:15:08PM -0500, Tom Lane wrote:
> > "Markus Bertheau" <[EMAIL PROTECTED]> writes:
> > > Why is it
On 2006-04-10, Bruce Momjian wrote:
> Peter Eisentraut wrote:
>> > This is similar to the fact we don't include plpgsql by default in
>> > databases, for the same reason,
[the reason being "security"]
>>
>> I doubt that that is really the reason.
>
> It actually is the reason I have heard.
And i
-Original Message-
From: "Peter Eisentraut"<[EMAIL PROTECTED]>
Sent: 10/04/06 22:43:05
To: "Bruce Momjian"
Cc: "Dave Page",
"pgsql-hackers@postgresql.org"
Subject: Re: [HACKERS] Remote administration contrib module
> If there are _security_ issues, they need to be fixed
> before thing
Tom Lane wrote:
> There are, however, a bunch of local bugs, including these:
>
> * On a symlink-less platform (ie, Windows), TablespaceCreateDbspace is
> #ifdef'd to be a no-op. This is wrong because it performs the essential
> function of re-creating a tablespace or database directory if needed
Bruce Momjian wrote:
> I think the issue was that adding these fuctions adds a potential
> security opening, so we didn't want it in core by default, but
> /contrib seems logical because anyone who needs it can just add it.
Well, if there are security issues, then this is a poor fix. A lot of
pe
Bruce Momjian writes:
> TODO has:
> * Allow user-defined functions retuning a domain value to enforce domain
> constraints
> Is there something we should add to this?
Yeah, a DONE marker ;-)
regards, tom lane
---(end of broadcast)--
Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > I think the issue was that adding these fuctions adds a potential
> > security opening, so we didn't want it in core by default, but
> > /contrib seems logical because anyone who needs it can just add it.
>
> Well, if there are security issues, th
Dave Page wrote:
> > Right now you have got plenty of time to get it in shape for inclusion in
> > core, so we might not even have to take the detour through a contrib module.
>
> As it stands it was previously rejected for inclusion in -core in it's
> current form. The main objector was Tom, but
TODO has:
* Allow user-defined functions retuning a domain value to enforce domain
constraints
Is there something we should add to this?
---
Tom Lane wrote:
> elein <[EMAIL PROTECTED]> writes:
> > On Mon,
pgsql-hackers！
Hi , I want to use eclipse to compiler the postgresql source code and
debug them on winxp . I have tried some times with fails . Is there anyone to
tell me how to do ?
thanks.
[EMAIL PROTECTED]
2006-04-10
---(end of bro
Is there a TODO here?
---
Peter Eisentraut wrote:
> Am Samstag, 25. M?rz 2006 16:10 schrieb Tom Lane:
> > No, the current implementation is a compromise between exact standards
> > compatibility and backwards compatibility w
Gregory,
On 4/9/06 2:04 PM, "Gregory Maxwell" <[EMAIL PROTECTED]> wrote:
> It increases Linux's maximum readahead from 128K to 1meg .. and it
> should be smart enough that you could crank it up further without too
> much risk of hurting performance elsewhere.
Interesting - we are now routinely u
Hannu,
On 4/10/06 2:23 AM, "Hannu Krosing" <[EMAIL PROTECTED]> wrote:
>> The cost of fetching a page from the OS is not really much of an
>> overhead,
>
> Have you tested this ?
I have - the overhead of fetching a page from Linux I/O cache to buffer
cache is about an additional 20% over fetchin
Hi,
On Mon, 2006-04-10 at 13:36 -0400, Alvaro Herrera wrote:
> An idea arising in chat with Joshua Drake: the retargetting code, if it
> turns out to work and not be excessively expensive, could also be useful
> to implement a server-side "connection pooling" of sorts: the postmaster
> could keep
Markus Schiltknecht wrote:
> On Mon, 2006-04-10 at 17:22 +0800, Qingqing Zhou wrote:
> > Check the code InitPostgres(). These global varaibles are scattered in many
> > places, so I am not sure if it is easy to write clean code to clear up these
> > variables. But if you can come up with a patch to
Tom Lane wrote:
> Right. I looked at this awhile back, though, and found multiple
> places that would break if you tried it :-( --- mainly assumptions
> about the meaning of resno in target lists. (The comments for the
> TargetEntry struct give some but not all of the details.) Given that
> OID
Martijn van Oosterhout writes:
> On Mon, Apr 10, 2006 at 04:40:50PM +0800, Qingqing Zhou wrote:
>> AFAIK if two rows are with the same OID, we will think these two rows are
>> different versions of the same tuple. So if we allow users to change OID
>> columns, we may encounter some inconsistency.
Bruce Momjian wrote:
* Allow EXPLAIN output to be more easily processed by scripts
Can I request an extension/additional point?
* Design EXPLAIN output to survive cut & paste on mailing-lists
Being able to paste into a web-form and get something readable formatted
back would be very
On Mon, 2006-04-10 at 17:22 +0800, Qingqing Zhou wrote:
> Check the code InitPostgres(). These global varaibles are scattered in many
> places, so I am not sure if it is easy to write clean code to clear up these
> variables. But if you can come up with a patch to do reconnect without
> disconnect,
Ühel kenal päeval, P, 2006-04-09 kell 18:26, kirjutas Martijn van
Oosterhout:
> The cost of fetching a page from the OS is not really much of an
> overhead,
Have you tested this ?
I remember having a case, where data load usin COPY into a table with
several indexes ran an order of magnitude fas
"Markus Schiltknecht" <[EMAIL PROTECTED]> wrote
> Hi Qingqing,
>
> >
> > As Tom pointed out, without big change, a backend on database "D1" can't
> > connect to "D2". This is because to connect to a database, we need to
> > initialize a lot of variables. So when you reconnect to another one on
the
On Sun, Apr 09, 2006 at 05:54:56PM -0400, Tom Lane wrote:
> Here's a detailed scenario:
>
> 1. Backend X reads page N of a table T, queues a request for N+1.
> 2. While processing page N, backend X gets an error and aborts
> its transaction, thereby dropping all its lmgr locks
Hi Qingqing,
On Mon, 2006-04-10 at 16:38 +0800, Qingqing Zhou wrote:
> > Why not? What would be needed to retarget a backend to operate in
> > another database?
>
> As Tom pointed out, without big change, a backend on database "D1" can't
> connect to "D2". This is because to connect to a database,
On Mon, Apr 10, 2006 at 04:40:50PM +0800, Qingqing Zhou wrote:
>
> "Peter Eisentraut" <[EMAIL PROTECTED]> wrote
> > Is there a reason for why you can't update the OID column other than that
> no
> > one has bothered to code up the support for it?
> >
>
> AFAIK if two rows are with the same OID, w
On Sun, 2006-04-09 at 17:11 +0800, Qingqing Zhou wrote:
> "Tom Lane" <[EMAIL PROTECTED]> wrote
> >
> > This is exactly the bit of optimism I was questioning. We've already
> > been sweating blood trying to reduce multiprocessor contention on data
> > structures in which collisions ought to be avoi
"Peter Eisentraut" <[EMAIL PROTECTED]> wrote
> Is there a reason for why you can't update the OID column other than that
no
> one has bothered to code up the support for it?
>
AFAIK if two rows are with the same OID, we will think these two rows are
different versions of the same tuple. So if we
"Markus Schiltknecht" <[EMAIL PROTECTED]> wrote
> Hi,
>
> On Sun, 2006-04-09 at 15:11 -0400, Tom Lane wrote:
> > You can't just retarget a backend to operate in another database, at
> > least not without major changes in that infrastructure.
>
> Why not? What would be needed to retarget a backend
Hi,
On Sun, 2006-04-09 at 15:11 -0400, Tom Lane wrote:
> You can't just retarget a backend to operate in another database, at
> least not without major changes in that infrastructure.
Why not? What would be needed to retarget a backend to operate in
another database?
Such a retargetting would b
Hi!
I've got some problems building a swedish snowball stemmer on win32.
FWIW, it works just fine on Linux, so the stemmer itself is fine. My
problems are:
1) There's no way to build "just the stemmer" without having built the
source from the same directory, from what I can tell? Since it links
w
Is there a reason for why you can't update the OID column other than that no
one has bothered to code up the support for it?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0, the pl
41 matches
Mail list logo
