Heikki Linnakangas wrote:
On Thu, 7 Oct 2004, Oliver Jowett wrote:
Probably the next question is, do we want a database-side timeout on
how long prepared txns can stay alive before being summarily rolled back?
That sounds very dangerous to me. You could end up breaking global
atomicity if some o
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> Good point. Should we obscure pg_tablespace similarly to what we do for
>> pg_shadow?
> Well, if we feel file locations are better left only visible to
> super-users, we should. However, when managing disk space, aren't
> normal users also often inter
On Fri, 8 Oct 2004, Tom Lane wrote:
> Josh Berkus <[EMAIL PROTECTED]> writes:
> > I'll give you an example why not:
>
> > CALL some_sp ( user IS 19, session IS NULL );
>
> > However, Tom, couldn't AS confuse the parser when used to call a named
> > function in a SELECT clause?
>
> I don't think so
[ further response ... ]
Josh Berkus <[EMAIL PROTECTED]> writes:
> Example:
> SELECT user, session,
> crypt_function ( seed AS 345, content AS pwd_col ) AS munged_pwd
> FROM users;
I failed to look closely at your example before. Apparently you are
thinking of the syntax as being AS .
I
Josh Berkus <[EMAIL PROTECTED]> writes:
> I'll give you an example why not:
> CALL some_sp ( user IS 19, session IS NULL );
> However, Tom, couldn't AS confuse the parser when used to call a named
> function in a SELECT clause?
I don't think so. We are talking about
SELECT f(42 AS a,
Gavin,
> I agree that => restricts people in a way we are not at the moment. AS
> is a better idea but I also like IS, which makes more sense to me. IS is
> currently on the func_name_keyword list -- I *think* we could use it.
> What do you think?
I'll give you an example why not:
CALL some_sp (
On Fri, 8 Oct 2004, Gavin Sherry wrote:
> I agree that => restricts people in a way we are not at the moment. AS
> is a better idea but I also like IS, which makes more sense to me. IS is
> currently on the func_name_keyword list -- I *think* we could use it.
> What do you think?
Josh kindly poin
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > If they are using tablespaces is it OK that anyone can see their
> > location?
>
> Good point. Should we obscure pg_tablespace similarly to what we do for
> pg_shadow?
Well, if we feel file locations are better left only visible to
Bruce Momjian <[EMAIL PROTECTED]> writes:
> If they are using tablespaces is it OK that anyone can see their
> location?
Good point. Should we obscure pg_tablespace similarly to what we do for
pg_shadow?
regards, tom lane
---(end of broadcast)
Shinji Teragaito <[EMAIL PROTECTED]> writes:
152c152
< SHLIB_LINK+= `$(CC) -print-libgcc-file-name`
---
> SHLIB_LINK+= `$(CC) $(LDFLAGS) -print-libgcc-file-name`
Okay. I'm slightly worried about odd LDFLAGS values confusing this, but
we can deal with that w
Andrew Dunstan wrote:
>
>
> Tom Lane wrote:
>
> >
> >I am sort of on the fence about this. I am thinking that it would be
> >good to expose this information, but *only* to superusers. It would not
> >take much code to add a GUC variable flag bit that prevents
> >non-superusers from examining t
>> On Thu, 07 Oct 2004 15:32:16 -0400, Tom Lane <[EMAIL PROTECTED]> said:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
>> Has this been resolved?
> AFAIK everything is fixed. I put in Shinji's changes and some more of
> my own. I did port testing on HP 11.11 and 11.23 a month or so ago and
> fou
Bruce Momjian schrieb:
Reini Urban wrote:
Bruce Momjian schrieb:
I have applied all parts of your patch now.
Thanks. Core builds and works fine now. (plperl IPC problems aside)
But there's are still some more minor SHLIB glitches,
which only affects contrib, because -lpgport is missing for various
Tom Lane wrote:
I am sort of on the fence about this. I am thinking that it would be
good to expose this information, but *only* to superusers. It would not
take much code to add a GUC variable flag bit that prevents
non-superusers from examining the value of the GUC variable, and only a
little
In prior versions of Postgres, it has never been possible to remotely
find out the data directory location being used by the postmaster
(at least not without hacking some C code, which only superusers may
do).
You can make about equally good arguments that this is a bug or that
it's a feature:
BU
On Thu, 7 Oct 2004, David Fetter wrote:
> On Thu, Oct 07, 2004 at 11:47:55AM +0700, David Garamond wrote:
> > Joshua D. Drake wrote:
> > >>This brings up an interesting idea. What if it were possible to set
> > >>some kind of rules on DDL at database creation time? For example, I'd
> > >>like to
Reini Urban wrote:
> Bruce Momjian schrieb:
> > I have applied all parts of your patch now.
>
> Thanks. Core builds and works fine now. (plperl IPC problems aside)
>
> But there's are still some more minor SHLIB glitches,
> which only affects contrib, because -lpgport is missing for various dll's
I just made some major Win32 modifications in the past few days. Would
you try Cygwin compile and see if the following warnings are removed and
the rest of the system builds OK?
---
Reini Urban wrote:
> [BTW: there's no nee
Added to TODO:
* Consider parallel processing a single query
This would involve using multiple threads or processes to do optimization,
sorting, or execution of single query. The major advantage of such a
feature would be to allow multiple CPUs to work together to process a
single query
On Thu, 7 Oct 2004, Tom Lane wrote:
> Gavin Sherry <[EMAIL PROTECTED]> writes:
> > We cannot use named parameter notation with functions due to overloading.
> > Disregarding the idea of default values, consider:
>
> > create function foo(i int, j int) ...
> > create function foo(j int, i int) ...
On Thu, 7 Oct 2004, Peter Eisentraut wrote:
> Gavin Sherry wrote:
> > We cannot use named parameter notation with functions due to
> > overloading. Disregarding the idea of default values, consider:
> >
> > create function foo(i int, j int) ...
> > create function foo(j int, i int) ...
>
> That ju
On Fri, 8 Oct 2004, Gaetano Mendola wrote:
> Gavin Sherry wrote:
> > On Wed, 6 Oct 2004, Josh Berkus wrote:
> >
> > [snip]
> >
> >
> >>Of course, this is as true of functions as it will be of procedures. So half
> >>the functionality that I'm angling for to support with calling named param
Tom Lane wrote:
The main thing that I'm not happy about is the syntax. I'm going to
resist commandeering => for this purpose, and I don't see any way to use
that symbol for this without forbidding it as a user-defined operator.
I previously suggested using AS, which is already a fully reserved wor
Gavin Sherry wrote:
> On Wed, 6 Oct 2004, Josh Berkus wrote:
>
> [snip]
>
>
>>Of course, this is as true of functions as it will be of procedures. So half
>>the functionality that I'm angling for to support with calling named params
>>could be accomplished within the context of overloading just by
Yann Michel wrote:
> Hi,
>
> I'd like to know if there are any plans on introducing bitmap indexes
> into postgresql. I think this could mean a big performance improvement
> especially for datawarehousing applications. I know that there is an
> index type hash but I don't know how both types are c
I agree with Tom on both points, userspace quote and TODO list items.
---
Tom Lane wrote:
> Josh Berkus <[EMAIL PROTECTED]> writes:
> > What about the User Space quota patch?
>
> What about it? We never actually got one, a
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]
> Sent: 06 October 2004 17:35
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Pl/perl broken on Windows
>
>
> OK, I have adjusted the code to use #define for the plperl compile.
> This should preven
Josh Berkus <[EMAIL PROTECTED]> writes:
> What about the User Space quota patch?
What about it? We never actually got one, according to my mailbox.
I was a tad concerned about the speed penalty associated with possibly
checking during every commit, but in the absence of seeing a patch it's
impos
David Fetter <[EMAIL PROTECTED]> writes:
> Is there some way to mark this kind of stuff on the TODO
> list? Right now things are marked, essentially, "might get done
> eventually," and "handled in the coming release." Maybe some marker
> like "slated for version m.n" would be good. :)
If we actu
David Fetter <[EMAIL PROTECTED]> writes:
> How big a project would it be to have generalized DDL triggers? Apart
> from resource allocation, what are some downsides of providing such a
> facility?
BEFORE triggers on the system catalogs are Right Out. In principle we
could support AFTER triggers,
Yann Michel schrieb:
I'd like to know if there are any plans on introducing bitmap indexes
into postgresql. I think this could mean a big performance improvement
especially for datawarehousing applications. I know that there is an
index type hash but I don't know how both types are comparable due t
Bruce,
> No, not really. The only things I think we know we want for 8.1 is
> better integrated auto-vacuum and 2-phase commit.
What about the User Space quota patch? I though that one was pending review
as well.
And the completion of exception-handling for functions based on savepoints.
--
Hi,
I'd like to know if there are any plans on introducing bitmap indexes
into postgresql. I think this could mean a big performance improvement
especially for datawarehousing applications. I know that there is an
index type hash but I don't know how both types are comparable due to
they are both
On Thu, Oct 07, 2004 at 03:29:59PM -0400, Bruce Momjian wrote:
> David Fetter wrote:
> > On Thu, Oct 07, 2004 at 02:28:37PM -0400, Bruce Momjian wrote:
> > > Mark Wong wrote:
> > > > I'd like to set up a BOF with any of the developers who are
> > > > interested in Boston at the Linux World Expo com
On Thu, Oct 07, 2004 at 11:47:55AM +0700, David Garamond wrote:
> Joshua D. Drake wrote:
> >>This brings up an interesting idea. What if it were possible to set
> >>some kind of rules on DDL at database creation time? For example, I'd
> >>like to be able to throw an error if somebody tries to nam
Added to open items list:
* remove non-portable TABLESPACE clause from CREATE TABLE using
a SET or ALTER command
---
Philip Warner wrote:
> At 06:31 PM 1/09/2004, Fabien COELHO wrote:
> >I've notic
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Has this been resolved?
AFAIK everything is fixed. I put in Shinji's changes and some more of
my own. I did port testing on HP 11.11 and 11.23 a month or so ago and
found that we could build and pass regression on both gcc and vendor
cc on both platfor
David Fetter wrote:
> On Thu, Oct 07, 2004 at 02:28:37PM -0400, Bruce Momjian wrote:
> > Mark Wong wrote:
> > > I'd like to set up a BOF with any of the developers who are interested
> > > in Boston at the Linux World Expo coming up at the end of February. I
> > > don't have anything specific in m
On Thu, Oct 07, 2004 at 02:28:37PM -0400, Bruce Momjian wrote:
> Mark Wong wrote:
> > I'd like to set up a BOF with any of the developers who are interested
> > in Boston at the Linux World Expo coming up at the end of February. I
> > don't have anything specific in mind and would like to get some
Has this been resolved?
---
Shinji Teragaito wrote:
> >> On Tue, 24 Aug 2004 00:39:55 -0400, Tom Lane <[EMAIL PROTECTED]> said:
>
> > Shinji Teragaito <[EMAIL PROTECTED]> writes:
> >> I made a patch to let PostgreSQL work i
Mark Wong wrote:
> I'd like to set up a BOF with any of the developers who are interested
> in Boston at the Linux World Expo coming up at the end of February. I
> don't have anything specific in mind and would like to get something
> going. Any takers?
>
> Some of the things I'm currently worki
I'd like to set up a BOF with any of the developers who are interested
in Boston at the Linux World Expo coming up at the end of February. I
don't have anything specific in mind and would like to get something
going. Any takers?
Some of the things I'm currently working on are OLTP and DSS perfor
Tom, Gavin, Peter, Andrew,
> [ thinks some more... ] Actually I guess the problem comes with
>
> create function foo(i float, j int) ...
> create function foo(j int, i float) ...
>
> which is a legal pair of functions from a positional viewpoint, but
> would look identical when matching by names.
This seems to have shown two problems. First is using the constant
username 'postgres' for postgres login salt, but if we use something
variable we would have to pass that constant on the wire so everyone
will see it. We can't encrypt the random salt with the password because
the server doesn't
On Sat, Sep 18, 2004 at 06:06:05AM -0400, Jan Wieck wrote:
> On 9/17/2004 7:32 PM, Tom Lane wrote:
> >over time. I'm wondering about DNS lookup results in particular.
>
> Except for one "localhost", one "/tmp/.s.PGSQL..." and the "543x" lookup
> during the postmaster start, all lookups are IP ad
Peter Eisentraut wrote:
Gavin Sherry wrote:
We cannot use named parameter notation with functions due to
overloading. Disregarding the idea of default values, consider:
create function foo(i int, j int) ...
create function foo(j int, i int) ...
That just means we cannot use the parameter n
Gavin Sherry <[EMAIL PROTECTED]> writes:
> We cannot use named parameter notation with functions due to overloading.
> Disregarding the idea of default values, consider:
> create function foo(i int, j int) ...
> create function foo(j int, i int) ...
> If we did:
> SELECT foo(j => 1, i => 2)
> w
On Thu, 7 Oct 2004, Eyinagho Newton wrote:
> Can anyone explain how postgreSQL reads from a text
> file into tables already created in PostgreSQL?
Check out COPY command.
http://www.postgresql.org/docs/7.4/interactive/sql-copy.html
The file has to be in a certain format as explained in the
docum
On Wed, Oct 06, 2004 at 01:27:26PM -0400, Alvaro Herrera wrote:
> On Wed, Oct 06, 2004 at 10:01:42AM -0700, Mark Wong wrote:
> > On Mon, Oct 04, 2004 at 02:42:43PM -0400, Greg Stark wrote:
> > > Mark Wong <[EMAIL PROTECTED]> writes:
> > >
> > > > Links to results are here:
> > > > 7.5devel - http:
Gavin Sherry wrote:
> We cannot use named parameter notation with functions due to
> overloading. Disregarding the idea of default values, consider:
>
> create function foo(i int, j int) ...
> create function foo(j int, i int) ...
That just means we cannot use the parameter name as a distinguishin
Eyinagho Newton wrote:
> Can anyone explain how postgreSQL reads from a text
> file into tables already created in PostgreSQL?
Please direct general usage questions to <[EMAIL PROTECTED]>.
> I am also checking the thread in the Forum just to see
> if someone has written about it in the past.
Ple
Hiya Everyone,
Can anyone explain how postgreSQL reads from a text
file into tables already created in PostgreSQL?
I am also checking the thread in the Forum just to see
if someone has written about it in the past.
Thanks.
Newton
___
Do you Yahoo
Fabien COELHO <[EMAIL PROTECTED]> writes:
> Sorry for this stupid general comment, but why couldn't the gid be stored
> in some shared system table that would rely on pg infrastructure for
> caching, sharing, locking and so on?
That would have a number of pitfalls of its own:
* No outside-a-tra
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> If it were "the else's indent plus one more tab" it would be reasonably
> >> sane; it'd match the indentation of what comes next.
>
> > OK, I can do that but consider:
> > [ other case ]
>
> Just out of curiosity
On Wed, 6 Oct 2004, Josh Berkus wrote:
[snip]
> Of course, this is as true of functions as it will be of procedures. So half
> the functionality that I'm angling for to support with calling named params
> could be accomplished within the context of overloading just by extending the
> named param
Reini Urban schrieb:
Tom Lane schrieb:
Bruce Momjian <[EMAIL PROTECTED]> writes:
I am confused. CVS has in port.h:
so you should already be calling the junction code on Cygwin.
true. didn't thought of that. very strange.
Yeah, I'm sure he is, but it looks from the regression results like it
doesn'
On Thu, 7 Oct 2004, Euler Taveira de Oliveira wrote:
> Hi Gavin,
>
> > >
> > > I saw a initdb crashes when it is creating the template1 database.
> > I
> > > couldn't figure out what is wrong. I attached the backtrace and
> > some
> > > architecture/compiler info.
> > > If someone needs more info,
Hi Gavin,
> >
> > I saw a initdb crashes when it is creating the template1 database.
> I
> > couldn't figure out what is wrong. I attached the backtrace and
> some
> > architecture/compiler info.
> > If someone needs more info, drop me a line.
>
> Can you run initdb with the -d flag?
>
The log i
> Well, the question is how long must the individual databases retain
> state with which to answer "recover" requests. I don't like "forever",
> so I'm proposing that there should be an explicit command to say "you
> can forget about this gid".
I think it would be ok to forget the gid after:
>Tom Lane [mailto:[EMAIL PROTECTED]
> <[EMAIL PROTECTED]> writes:
> >> [EMAIL PROTECTED] wrote:
> >>> ... you end up with a core dump (signal 6) and an error
> saying that you
> >>> can't stop before end of backup.
> >>
> >> Was this corrected? I don't see any followups to it in the archives.
>
Implementation-wise, I really dislike storing the info in a shared hash
table, because I don't see any reasonable bound on the size of the hash
table (your existing code uses 100 which is about as arbitrary as it
gets). [...]
The idea that occurs to me instead is to not use WAL or shared memory at
Abhijit Menon-Sen <[EMAIL PROTECTED]> writes:
> --- fe-protocol3.c.1~ 2004-10-05 18:59:55.293092244 +0530
> +++ fe-protocol3.c2004-10-05 19:17:48.154807848 +0530
> @@ -220,6 +220,11 @@ pqParseInput3(PGconn *conn)
> conn->asyncStatus = PGASYNC_READY;
>
62 matches
Mail list logo
