>> Schema handling - ready? interfaces? client apps?
> status for JDBC or ODBC; any comments? The other interface libraries
> probably don't care.
What about DBD::Pg?
--
Kaare Rasmussen--Linux, spil,--Tlf:3816 2582
Kaki Datatshirts, merchandize
...
> But ... my recollection is that we've had a *huge* number of complaints
> about the initlocation behavior, at least by comparison to the number
> of people using the feature. No one can understand how it works,
> let alone how to configure it so that it works reliably. I really
> fail to u
Hannu Krosing <[EMAIL PROTECTED]> writes:
> On Wed, 2002-07-31 at 10:22, Tom Lane wrote:
>> Hm. How about
>>
>> ERROR: Cannot insert into a view
>> You need an unconditional ON INSERT DO INSTEAD rule
> Seems more accurate, but actually you may also have two or more
> conditional rules that cov
On Tue, 30 Jul 2002, Thomas Lockhart wrote:
> The "no envar" camp has not thought through the issues yet, though the
> issues can be found in the threads. Better to decide what the
> requirements are before throwing out the solution.
Ok, so what issues has the "no envvar" camp not yet dealt with
...
> I agree that if we could quickly come to a resolution about how this
> ought to work, there's plenty of time to go off and implement it. But
> (1) we failed to come to a consensus before, so I'm not optimistic
> than one will suddenly emerge now; (2) we've got a ton of other issues
> that w
On 31 Jul 2002, Hannu Krosing wrote:
> An it is often easier to map OO languages to OOR database when you dont
> have to change your mindset when going through the interface.
But you have to anyway! Adding this inheritance does not remove the
relational model; it's still there right in front of
> This is great, we thought we may go for code changes, we will go with this
> solution instead.
But you did catch Stephan's point that an outer join is not required to
produce the result you apparently want? The equivalent inner join will
be at worst just as fast, and possibly faster, both for P
Hannu Krosing <[EMAIL PROTECTED]> writes:
> Of course we could go the other way and remove support for VIEW's as
> they can be done using a table and a ON SELECT DO INSTEAD rule.
Two points for Hannu ;-)
Seriously, this entire thread seems a waste of bandwidth to me.
Inheritance as a feature is
On Wed, 2002-07-31 at 10:22, Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > On Wed, 31 Jul 2002, Tom Lane wrote:
> >> Well, to my mind that's what the error message says now. The reason
> >> it didn't help you was that you *did* have a rule ... but it didn't
> >> completely overri
...
> Agreed. Consistency argues for the postgresql.conf solution, not
> security. Also, I would like to see initlocation removed as soon as we
> get a 100% functional replacement. We have fielded too many questions
> about how to set it up.
Hmm. I'm not sure the best way to look, but I was ab
On Wed, 2002-07-31 at 04:35, Curt Sampson wrote:
> On 31 Jul 2002, Hannu Krosing wrote:
>
> > I would not rush to drop advanced features, as they may be hard to put
> > back later.
>
> If they are hard to put back, it's generally because the other code
> in the system that relates to it has chan
Thomas Lockhart <[EMAIL PROTECTED]> writes:
> ... The behavior of initlocation has
> been absolutely no burden on -hackers for the nearly *5 years* that it
> has been available, and that is the best evidence that we're just
> talking through hats. Let's get on with it, or at least get back to
> be
> Whether you think that there is a potentially-exploitable security hole
> here is not really the issue. The point is that two different arguments
> have been advanced against using environment variables for configuration
> (if you weren't counting, (1) possible security issues now or in the
> f
On Wed, 31 Jul 2002, Tom Lane wrote:
> ERROR: Cannot insert into a view
> You need an unconditional ON INSERT DO INSTEAD rule
Sounds great to me!
cjs
--
Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light
Curt Sampson <[EMAIL PROTECTED]> writes:
> On Wed, 31 Jul 2002, Tom Lane wrote:
>> Well, to my mind that's what the error message says now. The reason
>> it didn't help you was that you *did* have a rule ... but it didn't
>> completely override the view insertion.
> Right, like I said, my model
> > Dependency - pg_dump auto-create dependencies for 7.2.X data?
>
> Huh?
Taking a bunch of CREATE CONSTRAINT TRIGGERS and turning them into the
proper pg_constraint entries...
Chris
---(end of broadcast)---
TIP 5: Have you checked our extensive
On Wed, 31 Jul 2002, Tom Lane wrote:
> Well, to my mind that's what the error message says now. The reason
> it didn't help you was that you *did* have a rule ... but it didn't
> completely override the view insertion.
Right, like I said, my model was wrong. I didn't think of the error
message
On Wed, 31 Jul 2002, Tom Lane wrote:
> * libpqxx is not integrated into build process nor docs. It should
> be integrated or reversed out before beta.
I've requestsed that Jeorgen(sp?) move this over to GBorg ... its
something that can, and should be, built seperately from the base
distribution
I'll ask my contract what they paid
On Wed, 2002-07-31 at 00:00, Marc G. Fournier wrote:
>
> the only thing I've found so far (I've email'd their sales guy, but
> haven't heard back yet) on their site is a 'calculator' that depends on
> number of users ... for the University I work out, I
Curt Sampson <[EMAIL PROTECTED]> writes:
> ERROR: Cannot insert into a view without an appropriate rule
>> Perhaps the error message could be phrased better --- any thoughts?
> Maybe a message that says something along the lines of "cannot insert
> into views; you need to override this behaviou
add in 'fix pg_hba.conf / password issues' to that too :)
On Tue, 30 Jul 2002, Bruce Momjian wrote:
>
> Here are the open items for 7.3. We have one more month to address them
> before beta.
>
> ---
>
>
the only thing I've found so far (I've email'd their sales guy, but
haven't heard back yet) on their site is a 'calculator' that depends on
number of users ... for the University I work out, I believe the cost came
out to something like $99kUS, and I went low on my figures for # of users
:)
Than
> * pg_conversion stuff --- do we understand this thing's behavior under
> failure conditions?
As far as I know, automatic encoding conversion behaves well under
failure conditions.
> Does it work properly with namespaces and
> dependencies?
Yes.
--
Tatsuo Ishii
---(end
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 30, 2002 9:50 PM
> To: Bruce Momjian
> Cc: PostgreSQL-development
> Subject: Re: [HACKERS] Open 7.3 items
[snip]
> > Win32 - timefame?
I may be able to contribute the Win32 stuff we have done here. (
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Here are the open items for 7.3.
Some comments ...
> Socket permissions - only install user can access db by default
I do not agree with this goal.
> NAMEDATALEN - disk/performance penalty for increase, 64, 128?
> FUNC_MAX_ARGS - disk/performance pen
This is great, we thought we may go for code changes, we will go with this
solution instead.
Thanks
Yuva
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 9:31 PM
To: Yuva Chandolu
Cc: '[EMAIL PROTECTED]'
Subject: Re: [HACKERS] Outer join diff
On Wed, 31 Jul 2002, Lamar Owen wrote:
> On Tuesday 30 July 2002 11:51 pm, Tom Lane wrote:
> > Lamar Owen <[EMAIL PROTECTED]> writes:
> > >> CREATE DATABASE foo WITH LOCATION = 'BAR'
> > > And requires you to be a database superuser anyway.
>
> > CREATE DATABASE does not require superuser privs,
On Tue, 30 Jul 2002, Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > CREATE VIEW test AS ...
> > CREATE RULE test_insert AS
> > ON INSERT TO test
> > DO ...
> > INSERT INTO test VALUES (1, 'one', 'onemore');
> > ERROR: Cannot insert into a view without an appropriate rule
On Tue, 30 Jul 2002, Lamar Owen wrote:
> On Tuesday 30 July 2002 07:46 pm, Curt Sampson wrote:
>
> > Ah. See, we already have a failure in a security analysis here. This
> > command:
>
> > CREATE DATABASE foo WITH LOCATION = 'BAR'
>
> > uses a string that's in the environment.
>
> And require
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> ... My own opinion is
> >> that there is nothing broken there; certainly nothing so broken that
> >> we need to force a change under schedule pressure.
>
> > I don't feel we are under pressure. We have time to d
> > When I run the query "select yt1_name, yt1_descr, yt2_name,
> yt2_descr from
> > yuva_test1 left outer join yuva_test2 on yt1_id=yt2_id and yt2_name =
> > '2-name2'" on postgres database I get the following results
Probaly if you change your postgres query to this, it will give the same
answe
On Tue, 30 Jul 2002, Yuva Chandolu wrote:
> Hi,
>
> I see different results in Oracle and postgres for same outer join queries.
> Here are the details.
Those probably aren't the same outer join queries.
> When I run the query "select yt1_name, yt1_descr, yt2_name, yt2_descr from
> yuva_test1 l
On Tue, 30 Jul 2002, Bruce Momjian wrote:
> Curt Sampson wrote:
> > On Tue, 30 Jul 2002, Bruce Momjian wrote:
> >
> > > You can add children without modifying your code. It is classic C++
> > > inheritance; parent table accesses work with the new child tables
> > > automatically.
> >
> > I don'
Hi Tom,
Thanks for your prompt reply, after second thought(before receiving your
reply) I realized that postgres is doing more logically - i.e if the outer
join condition returns false then replace by nulls for right table columns.
We may change our code accordingly :-(.
Thanks
Yuva
-Origi
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> ... My own opinion is
>> that there is nothing broken there; certainly nothing so broken that
>> we need to force a change under schedule pressure.
> I don't feel we are under pressure. We have time to discuss and address
> it.
Well
Tom Lane wrote:
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > Bruce, is the config file location stuff not being addressed? ...
> > If Peter or someone else doesn't beat me to it I might try my hand at that
> > one, as I would dearly love to be able to decouple the config files from
> > PGDATA.
Lamar Owen <[EMAIL PROTECTED]> writes:
> Bruce, is the config file location stuff not being addressed? ...
> If Peter or someone else doesn't beat me to it I might try my hand at that
> one, as I would dearly love to be able to decouple the config files from
> PGDATA. It has been discussed; con
Lamar Owen wrote:
> On Tuesday 30 July 2002 11:50 pm, Bruce Momjian wrote:
> > Here are the open items for 7.3. We have one more month to address them
> > before beta.
>
> > Source Code Changes
> > ---
>
> Bruce, is the config file location stuff not being addressed? I remember
Lamar Owen wrote:
> On Tuesday 30 July 2002 11:51 pm, Tom Lane wrote:
> > Lamar Owen <[EMAIL PROTECTED]> writes:
> > >> CREATE DATABASE foo WITH LOCATION = 'BAR'
> > > And requires you to be a database superuser anyway.
>
> > CREATE DATABASE does not require superuser privs, only createdb
> > whi
Yuva Chandolu <[EMAIL PROTECTED]> writes:
> I see different results in Oracle and postgres for same outer join queries.
I believe you are sending your bug report to the wrong database.
> When I run the query "select yt1_name, yt1_descr, yt2_name, yt2_descr from
> yuva_test1 left outer join yuva_
On Tuesday 30 July 2002 11:50 pm, Bruce Momjian wrote:
> Here are the open items for 7.3. We have one more month to address them
> before beta.
> Source Code Changes
> ---
Bruce, is the config file location stuff not being addressed? I remember Mark
(mlw) had worked up the pat
On Tuesday 30 July 2002 11:51 pm, Tom Lane wrote:
> Lamar Owen <[EMAIL PROTECTED]> writes:
> >> CREATE DATABASE foo WITH LOCATION = 'BAR'
> > And requires you to be a database superuser anyway.
> CREATE DATABASE does not require superuser privs, only createdb
> which is not usually considered par
> Schema handling - ready? interfaces? client apps?
With schemas, how about settings for automatically creating a schema for a
user when you create the user, etc.
Chris
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://
Hi,
I see different results in Oracle and postgres for same outer join queries.
Here are the details.
I have the following tables in our pg db
table: yuva_test1
yt1_id yt1_nameyt1_descr
1 1-name1 1-desc1
2 1-name2 1-desc2
3 1-name3 1-de
Lamar Owen <[EMAIL PROTECTED]> writes:
>> Ah. See, we already have a failure in a security analysis here. This
>> command:
>> CREATE DATABASE foo WITH LOCATION = 'BAR'
>> uses a string that's in the environment.
> And requires you to be a database superuser anyway.
CREATE DATABASE does not requi
Here are the open items for 7.3. We have one more month to address them
before beta.
---
P O S T G R E S Q L
7 . 3 O P E NI T E M S
Current at ftp://candle.ph
Curt Sampson <[EMAIL PROTECTED]> writes:
> CREATE VIEW test AS ...
> CREATE RULE test_insert AS
> ON INSERT TO test
> DO ...
> INSERT INTO test VALUES (1, 'one', 'onemore');
> ERROR: Cannot insert into a view without an appropriate rule
> What am I doing wrong here? Is there a bug?
Mak
Tom Lane wrote:
> [EMAIL PROTECTED] (Neil Conway) writes:
> > On Tue, Jul 30, 2002 at 09:48:42PM -0400, Bruce Momjian wrote:
> >> Where does the mention belong in the docs? I have it in the monitoring
> >> section in the stats section right now.
>
> > I'd vote for User's Guide -> Functions & Oper
[EMAIL PROTECTED] (Neil Conway) writes:
> On Tue, Jul 30, 2002 at 09:48:42PM -0400, Bruce Momjian wrote:
>> Where does the mention belong in the docs? I have it in the monitoring
>> section in the stats section right now.
> I'd vote for User's Guide -> Functions & Operators -> Misc. Functions.
T
On Tuesday 30 July 2002 07:46 pm, Curt Sampson wrote:
> On Tue, 30 Jul 2002, Lamar Owen wrote:
> > I said it. In any case, using strings that are in the environment
> > requires an untrusted PL, or a C function.
> Ah. See, we already have a failure in a security analysis here. This
> command:
>
Curt Sampson wrote:
> On Tue, 30 Jul 2002, Bruce Momjian wrote:
>
> > You can add children without modifying your code. It is classic C++
> > inheritance; parent table accesses work with the new child tables
> > automatically.
>
> I don't see how my method doesn't do this as well. What code do
On Tue, 30 Jul 2002, Bruce Momjian wrote:
> You can add children without modifying your code. It is classic C++
> inheritance; parent table accesses work with the new child tables
> automatically.
I don't see how my method doesn't do this as well. What code do you have
to modify in the relatio
I have completed this TODO item:
* Remove LockMethodTable.prio field, not used (Bruce)
Applied.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Chri
Curt Sampson wrote:
> On Wed, 31 Jul 2002, Christopher Kings-Lynne wrote:
>
> > > I highly doubt that. Relating two tables to each other via a key, and
> > > joining them together, allows you to do everything that inheritance
> > > allows you to do, but also more. If you have difficulty with keys
On Wed, 31 Jul 2002, Christopher Kings-Lynne wrote:
> > I highly doubt that. Relating two tables to each other via a key, and
> > joining them together, allows you to do everything that inheritance
> > allows you to do, but also more. If you have difficulty with keys and
> > joins, well, you real
> On Mon, 2002-07-29 at 08:53, [EMAIL PROTECTED] wrote:
> > > Just a long standing curiosity?
> > e) Inertia. MySQL got more popular way back when; the reasons
> may no longer
>
> f) Win32 Support. I can download a setup.exe for mysql and have it up
> and running quickly on Windows. I think tha
> I highly doubt that. Relating two tables to each other via a key, and
> joining them together, allows you to do everything that inheritance
> allows you to do, but also more. If you have difficulty with keys and
> joins, well, you really probably want to stop and fix that problem
> before you do
Neil Conway wrote:
> On Tue, Jul 30, 2002 at 09:48:42PM -0400, Bruce Momjian wrote:
> > OK, renamed to backend_pid() to match the libpq name.
>
> Ok, thanks.
>
> > Where does the mention belong in the docs? I have it in the monitoring
> > section in the stats section right now.
>
> I'd vote for
uvscan doesn't extract out MIME attachments but amavis does. You have to
have a whole lot of un archivers on the system for that reason.
Dave
On Tue, 2002-07-30 at 22:13, Christopher Kings-Lynne wrote:
> Hmmm - I'm pretty sure that uvscan won't automatically extract out MIME
> attachements. You
I'm having a weird problem on my " PostgreSQL 7.2.1 on i386--netbsdelf,
compiled by GCC 2.95.3" system. Executing these commands:
CREATE TABLE test_one (id int PRIMARY KEY, value_one text);
CREATE TABLE test_two (id int PRIMARY KEY, value_two text);
CREATE VIEW test AS
SELECT test_one.id, va
> Or you might have made a number of changes to a database which has
> been running for a while, and want to see whether the changes have
> had the desired effect. (Say, whether some new index has helped
> things.)
Well out stats had gotten up in to the millions and hence were useless when
I mad
On Tue, 30 Jul 2002, Jeff Davis wrote:
> Can you point me (someone without a real understanding of relational theory)
> to some good resources that explain the concepts well?
C. J. Date's _An Introduction to Database Systems, Seventh Edition_ is
a fat tome that will give you an extremely good gr
I would also like to know this! They don't mention it anywhere on their
site!
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Marc G. Fournier
> Sent: Wednesday, 31 July 2002 2:20 AM
> To: Larry Rosenman
> Cc: Christopher Kings-Lynne; [EMAIL
Hmmm - I'm pretty sure that uvscan won't automatically extract out MIME
attachements. You need to scan normal files.
We use inflex on our mail servers to extract all our emails before
scanning...
Chris
> -Original Message-
> From: Marc G. Fournier [mailto:[EMAIL PROTECTED]]
> Sent: Tue
On Tue, Jul 30, 2002 at 09:48:42PM -0400, Bruce Momjian wrote:
> OK, renamed to backend_pid() to match the libpq name.
Ok, thanks.
> Where does the mention belong in the docs? I have it in the monitoring
> section in the stats section right now.
I'd vote for User's Guide -> Functions & Operator
OK, renamed to backend_pid() to match the libpq name. I was unsure
about merging it into the stats stuff myself.
setest=> select backend_pid();
backend_pid
-
12996
(1 row)
Where does the mention belong in the docs? I have it
On Tue, Jul 30, 2002 at 08:40:13PM -0400, Bruce Momjian wrote:
> I have implemented this TODO item:
>
> * Add getpid() function to backend
>
> There were a large number of pg_stat functions that access pids and
> backends slots so I added it there:
>
> test=> select pg_stat_ge
On Mon, 2002-07-29 at 08:53, [EMAIL PROTECTED] wrote:
> > Just a long standing curiosity?
> e) Inertia. MySQL got more popular way back when; the reasons may no longer
f) Win32 Support. I can download a setup.exe for mysql and have it up
and running quickly on Windows. I think that native Win
I have implemented this TODO item:
* Add getpid() function to backend
There were a large number of pg_stat functions that access pids and
backends slots so I added it there:
test=> select pg_stat_get_backend_mypid();
pg_stat_get_backend_mypid
--
On Tue, 30 Jul 2002, Thomas Lockhart wrote:
> But the zeroth-order issue is not security. It is storage management for
> large databases. Any scheme we have for accomplishing that must hold up
> to scrutiny, but we can not refuse to proceed just because there are
> "lions tigers and bears" out th
...
> I've been securing systems since I started an ISP in 1995, and so I've
> seen a lot of security vulnerabilities come and go, and I've got a bit
> of a feel for what kinds of things are typically exploited. And this one
> one just screams, "potential security vulnerability!" to me.
Sure, the
On Tue, 30 Jul 2002, Lamar Owen wrote:
> On Tuesday 30 July 2002 02:34 pm, Tom Lane wrote:
>
> > Who said anything about poisoning the environment? My point was that
> > there will be strings in the environment that were put there perfectly
> > legitimately, but could still serve as an attack ve
On 31 Jul 2002, Hannu Krosing wrote:
> I would not rush to drop advanced features, as they may be hard to put
> back later.
If they are hard to put back, it's generally because the other code
in the system that relates to it has changed, so you can't just bring
back what is in the old versions i
> > I have implemented the ROW keyword, but am not sure that I've gotten
> > what the spec intends to be the full scope of functionality. It may be
> > that I've missed the main point completely :)
...
> > afaict the spec is not at all verbose about this, and is very dense and
> > obtuse where it
On Tue, 30 Jul 2002, Lamar Owen wrote:
> Now, let me make the statement that the environment in this case is
> not likely to be a security issue any worse than having the stuff
> in postgresql.conf, as any attacker that can poison the postmaster
> environment can probably poison postgresql.conf.
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> 1. It cascade deletes objects, but it _always_ cascades, no matter what
> behaviour I specify. Also, it doesn't give me indications that it's cascade
> deleted an object.
Would you give a specific example?
> + drop table child;
> + ERROR:
...
> Thomas, are you going to extend this to locations for any table/index?
> Seems whatever we do for WAL should fix in that scheme.
Yes, the longer-term goal is enabling table/index-specific locations.
I'm not certain whether WAL can use *exactly* the same mechanism, since
1) the location for
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> I don't like SET for it --- SET is for setting state that will persist
> >> over some period of time, not for taking one-shot actions. We could
> >> perhaps use a function that checks that it's been called by the
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> I don't like SET for it --- SET is for setting state that will persist
>> over some period of time, not for taking one-shot actions. We could
>> perhaps use a function that checks that it's been called by the
>> superuser.
> Should w
Thomas Lockhart <[EMAIL PROTECTED]> writes:
>> If we add more environment-variable-dependent mechanisms to allow more
>> different things to be done, we increase substantially the odds of
>> creating an exploitable security hole.
> No. See above.
Your argument seems to reduce to "it's not insecu
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > A function seems like the wrong way to go on this. SET has super-user
> > protections we could use to control this but I am not sure what SET
> > syntax to use.
>
> I don't like SET for it --- SET is for setting state that will pers
On Tue, 2002-07-30 at 16:00, Curt Sampson wrote:
> On 30 Jul 2002, Hannu Krosing wrote:
>
> > On Tue, 2002-07-30 at 14:51, Adrian 'Dagurashibanipal' von Bidder wrote:
> >
> > > Bruce Momjian:
> > > > It causes too much complexity in other parts of the system.
> > >
> > > That's one reason.
> >
>
Bruce Momjian wrote:
Tom Lane wrote:
Peter Eisentraut <[EMAIL PROTECTED]> writes:
Tom Lane writes:
As an alternative syntax I can suggest
SET name TO value [ ON COMMIT RESET ];
Ugh. Why can't we stick with SET LOCAL?
> 2. I expect that even most PostgreSQL--or even database--experts don't
> have a real understanding of relational theory, anyway. That we still
> have table inheritance shows that. As far as I can tell, there is
> nothing whatsoever that table inheritance does that the relational model
> does not
Thomas Lockhart writes:
> 31) Specifications for Feature F511, "BIT data type":
> a) Subclause 5.3, "":
>i) Without Feature F511, "BIT data type", a
> shall not be a or a literal>.
>
> This seems to be a hard linkage of hex strings with the BIT type.
You'll also find in 5.3 Con
Neil Conway writes:
> However, it would be useful to be able to do something like this -- how
> about something like the following:
>
> - the auth system contains a list of 'auth domains' -- an identifier
> similar to a schema name
>
> - the combination of (domain, username) must be
Thomas Lockhart writes:
> I've developed patches to be able to specify the location of the WAL
> directory, with the default location being where it is now. The patches
> define a new environment variable PGXLOG (a la PGDATA) and postmaster,
> postgres, initdb and pg_ctl have been taught to recog
On Tue, Jul 30, 2002 at 04:21:24PM -0400, Tom Lane wrote:
> However, the real question is what is the use-case for this feature
> anyway. Why should people want to reset the stats while the system
> is running? If we had a clear example then it might be more apparent
> what restrictions to place
Bruce Momjian <[EMAIL PROTECTED]> writes:
> A function seems like the wrong way to go on this. SET has super-user
> protections we could use to control this but I am not sure what SET
> syntax to use.
I don't like SET for it --- SET is for setting state that will persist
over some period of time
Tom Lane wrote:
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > Having said all that, I still believe that this is something tailor-made for
> > postgresql.conf.
>
> Well, exactly. Regardless of how serious you may think the security
> argument is, it still remains that a config-file entry seems t
Lamar Owen <[EMAIL PROTECTED]> writes:
> Having said all that, I still believe that this is something tailor-made for
> postgresql.conf.
Well, exactly. Regardless of how serious you may think the security
argument is, it still remains that a config-file entry seems the ideal
way to do it. I ca
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> It all works now and I have just submitted it to -patches as a new contrib,
> >> but it probably should make its way into the backend one day.
>
> > OK, the big question is how do we want to make stats reset visible to
> > users? T
On Tuesday 30 July 2002 02:34 pm, Tom Lane wrote:
> Andrew Sullivan <[EMAIL PROTECTED]> writes:
> > On Tue, Jul 30, 2002 at 02:05:57PM -0400, Tom Lane wrote:
> >> If we add more environment-variable-dependent mechanisms to allow more
> >> different things to be done, we increase substantially the
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> It all works now and I have just submitted it to -patches as a new contrib,
>> but it probably should make its way into the backend one day.
> OK, the big question is how do we want to make stats reset visible to
> users? The current patch uses a func
Christopher Kings-Lynne wrote:
> > OK, now I run it and it does absolutely nothing to the pg_stat_all_tables
> > relation for instance. In fact, it seems to do nothing at all - does the
> > reset function even work?
>
> OK, I'm an idiot, I was calling the funciton like this: void blah(void)
> wh
> As for why PostgreSQL is less popular than MySQL, I think it is all
> momentum from 1996 when MySQL worked and we sometimes crashed. Looking
> forward, I don't know many people who choose MySQL _if_ they consider
> both PostgreSQL and MySQL, so the discussions people have over MySQL vs.
> Postg
Ah yes - that was me making an unfortunate exptrapolation without thinking
it through.
Of course, PHP implements persistent connections for you, etc., etc., not
the postgres client library.
Chris
> -Original Message-
> From: Neil Conway [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 30 Jul
Try here:
http://osdb.sourceforge.net/
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Ramsey
> Sent: Tuesday, 30 July 2002 4:36 AM
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] TPC-* Benchmarks
>
>
>
> Have any organizations run TPC
I'm now working on it.
Tom Lane wrote:
>>Oleg Bartunov wrote:
>>
>>>One known issue: It'll not works with 64-bit OS. We'll certainly fix this
>>>but will appreciate if somebody with access to 64-bit machine could help us.
>>
>
> Actually, it dumps core instantly on 32-bit machines too, if they a
> Oleg Bartunov wrote:
>> One known issue: It'll not works with 64-bit OS. We'll certainly fix this
>> but will appreciate if somebody with access to 64-bit machine could help us.
Actually, it dumps core instantly on 32-bit machines too, if they are
pickier about alignment than Intel hardware is.
1 - 100 of 156 matches
Mail list logo
