Oliver Jowett wrote:
template1=> prepare s1(int) as select $1;
PREPARE
template1=> execute s1('12');
?column?
--
12
(1 row)
(now replace "int" with "unknown"..)
Ok, bad example since the backend probably can't infer a type for the
PREPARE in this case. A better example:
template1=
Tom Lane wrote:
David Wheeler <[EMAIL PROTECTED]> writes:
To get initial PREPARE support, I don't think that the other DBD::Pg
developers mind sending strings to the PostgreSQL server in a SQL
PREPARE statement.
The question, in my mind, is it currently possible to do this without
specifying th
Tom Lane wrote:
> David Wheeler <[EMAIL PROTECTED]> writes:
> > if I understand a previous post from you, this functionality should be
> > added to libpq, but you haven't had time and aren't sure what the API
> > should look like, anyway, is that correct?
>
> Right. Proposals welcome.
>
> > Is
Jan Wieck <[EMAIL PROTECTED]> writes:
> The problem comes and goes. So either I can cause a coredump just on the
> snap by running a shellscript that does 100 psql -c "select version()"
> calls, or it is next to impossible to crash it at all.
Hmm, that's really bizarre. It seems like the only s
On 4/19/2004 1:18 PM, Jan Wieck wrote:
Tom Lane wrote:
Andrew Sullivan <[EMAIL PROTECTED]> writes:
On Thu, Apr 15, 2004 at 07:52:59PM -0400, Tom Lane wrote:
I can see from your trace that you are using the getaddrinfo code from
libc, but where is configure finding a header that declares struct
addr
David Fetter <[EMAIL PROTECTED]> writes:
> Is there some large impact of setting this to be on by default?
A UDP send() per command, plus the ensuing activity in the pgstats
processes (which are by default activated only by backend start/stop).
If you want it to be on by default, I think the onus
Andreas Pflug wrote:
Gaetano Mendola wrote:
I'd like to fix this by myself but for lack of time and lack of postgres
code knowledge I'm stuck.
What you want is
CREATE VIEW foo AS
SELECT p1, p2, bar('theValidParameter') as p3
FROM othertab;
GRANT ALL ON TABLE foo TO public;
and don't want to gr
I have installed the latest config.guess and config.sub, which was
supposed to be done at the start of beta. I have reviewed their
changelog; there should be no changes for existing systems, but there
are a year's worth of new systems and bug fixes.
--
Peter Eisentraut
http://developer.postgr
Gaetano Mendola wrote:
I'd like to fix this by myself but for lack of time and lack of postgres
code knowledge I'm stuck.
What you want is
CREATE VIEW foo AS
SELECT p1, p2, bar('theValidParameter') as p3
FROM othertab;
GRANT ALL ON TABLE foo TO public;
and don't want to grant execute on bar() t
Greg Stark <[EMAIL PROTECTED]> writes:
> I'm starting to get a better idea of what's going on here though. Is it the
> case that the operators in the operator class are only used when actually
> doing an index scan?
Not even that, really. The operator class is what the planner uses to
detect that
Tom Lane <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > I don't understand what overlap_{left,right} are supposed to mean.
>
> In this thread:
> http://archives.postgresql.org/pgsql-general/2004-03/msg01135.php
> we had decided that the rtree stuff is not only poorly do
"Michael Paesold" <[EMAIL PROTECTED]> writes:
> Is there currently debug output in the code that could tell me answers to
> those questions?
There is some debug output available from the ARC code,
but I dunno if its output is actually useful ;-). Try
http://developer.postgresql.org/docs/postgres
On Sep 17, 2004, at 2:21 PM, Tom Lane wrote:
Okay, here we have Bruce saying he'll add it to open items:
http://archives.postgresql.org/pgsql-hackers/2004-08/msg00147.php
so I guess it is the same thing. Good, that will give us some
political
cover for squeezing it into 8.0 ;-).
Ah, okay, so Jan
Tom Lane wrote:
> You can't turn off the bgwriter process entirely anymore, because we
> rely on it for checkpoints. However I suppose there's no solid reason
> not to allow bgwriter_delay to be set as high as checkpoint_timeout,
> which would accomplish your goal of not spinning up the laptop dis
David Wheeler <[EMAIL PROTECTED]> writes:
>>> Is this the task labeled "allow libpq to check parameterized data
>>> types" here?:
>>> http://candle.pha.pa.us/cgi-bin/pgopenitems
>>
>> I think that was something else, but memory is fuzzy.
> I'm less sure, since I was the one who asked Jan Wieck a
Kind people,
I'm writing up a pg_top. The first cut will be for 8.0, as it relies
on (I know, I know) set-returning functions in plperlu. To make it do
the right thing, stats_command_string needs to be on.
Is there some large impact of setting this to be on by default? If
not, could we set tha
On Sep 17, 2004, at 1:54 PM, Tom Lane wrote:
David Wheeler <[EMAIL PROTECTED]> writes:
if I understand a previous post from you, this functionality should be
added to libpq, but you haven't had time and aren't sure what the API
should look like, anyway, is that correct?
Right. Proposals welcome.
W
David Wheeler <[EMAIL PROTECTED]> writes:
> if I understand a previous post from you, this functionality should be
> added to libpq, but you haven't had time and aren't sure what the API
> should look like, anyway, is that correct?
Right. Proposals welcome.
> Is this the task labeled "llow lib
On Sep 17, 2004, at 1:32 PM, Tom Lane wrote:
Well, that's the problem: you can't. The SQL PREPARE command doesn't
have any provision for dealing with unspecified parameters. I think
this is reasonable since if it could, it would still have no way to
tell
you what it resolved the parameter types
David Wheeler <[EMAIL PROTECTED]> writes:
> To get initial PREPARE support, I don't think that the other DBD::Pg
> developers mind sending strings to the PostgreSQL server in a SQL
> PREPARE statement.
> The question, in my mind, is it currently possible to do this without
> specifying the type
"Michael Paesold" <[EMAIL PROTECTED]> writes:
> pgwriter is keeping my disks busy and disturbs me :-(. The more I like
> pgwriter for a production system, the less I like it on my desktop during
> developement.
> So I thought I would just be able to disable this, but that seems not the
> case.
You
On Wed, 15 Sep 2004 13:50:43 -0400, Tom Lane wrote:
> The describe statement part could be much trickier but DBD::Pg
doesn't really
> need that for basic functionality.
Doesn't it? I thought the problem was that they couldn't find out what
datatypes the parameters got resolved as. That may not
Marc Colosimo <[EMAIL PROTECTED]> writes:
> I'm using 7.4.5 on Mac OS X (G5) and was profiling it to see why it is
> SO SLOW at committing inserts and deletes into a large database. One
> of the many slowdowns was from MemSet. I found an old (2002) thread
> about this and retried the tests (se
Reposted, I did not see the mail come through...
(Lists working ok?)
Hi everybody,
I have started testing PostgreSQL on windows. Now that I have managed to
import a dump of one of our production databases to postgres on my notebook,
there is one issue that came up immediatly after running VACUUM
Tom Lane wrote:
Josh Berkus <[EMAIL PROTECTED]> writes:
As said, I discussed this with Gaetano on IRC, and am not sure why things are
set up the way they are.If a user has permission on a view, shouldn't
that include permission on any functions executed by the view?If not, why
not?
See pr
Greg Stark <[EMAIL PROTECTED]> writes:
> I don't understand what overlap_{left,right} are supposed to mean.
In this thread:
http://archives.postgresql.org/pgsql-general/2004-03/msg01135.php
we had decided that the rtree stuff is not only poorly documented
but actively broken. I had thought that B
See http://archives.postgresql.org/pgsql-announce/2004-09/msg4.php
Mikhail
---(end of broadcast)---
TIP 8: explain analyze is your friend
I don't understand what overlap_{left,right} are supposed to mean.
In general what seems to be missing from the documentation of operator
strategies and support functions is what invariants between them are required.
Can I just make up a meaning for overlap_{left,right}? That's what other
r-tree
"Dave Page" <[EMAIL PROTECTED]> writes:
>> From: Dave Cramer [mailto:[EMAIL PROTECTED]
>> I'd like to know more about the issues you are trying to
>> solve? Seems counter productive for all of us to attempt this
>> independently
> Mainly lack of time :-)
> SSL and v3+ protocol support are the
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Neil Conway wrote:
> >> On Thu, 2004-09-16 at 23:24, Bruce Momjian wrote:
> >>> It will be applied as soon as one of the PostgreSQL committers reviews
> >>> and approves it.
> >>
> >> does this reflect a change in the patch applicatio
> -Original Message-
> From: Dave Cramer [mailto:[EMAIL PROTECTED]
> Sent: 17 September 2004 14:52
> To: Dave Page
> Cc: Greg Stark; Oliver Jowett; Tom Lane; Merlin Moncure;
> [EMAIL PROTECTED]
> Subject: Re: [HACKERS] libpq and prepared statements progress for 8.0
>
> Interesting,
>
Interesting,
I'd like to know more about the issues you are trying to solve? Seems
counter productive for all of us to attempt this independently
What about the .net driver ? Yet another protocol implementation ?
Dave
On Fri, 2004-09-17 at 09:36, Dave Page wrote:
>
> > -Original Message---
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Cramer
> Sent: 17 September 2004 14:32
> To: Greg Stark
> Cc: Oliver Jowett; Tom Lane; Merlin Moncure;
> [EMAIL PROTECTED]
> Subject: Re: [HACKERS] libpq and prepared statements progress for 8.
The odbc driver must be doing the same thing, as well I suspect pgadmin
has a protocol stack built into it as well?
There is a jdbc driver for postgresql on sourceforge that does use
libpq. The fact that it is not widely used should be educational.
Dave
On Thu, 2004-09-16 at 01:11, Greg Stark wro
Gaetano Mendola wrote:
Hi all,
I'm having some problem with permissions on views, I spoke with Josh on IRC
about it and I'm reposting it:
I found a not simmetrical behavior about permission on views and functions.
Let me explain:
If I use the view/table T inside the view V, is enough give the sele
On Wed, 2004-09-15 at 19:51, Tom Lane wrote:
> "Katsaros Kwn/nos" <[EMAIL PROTECTED]> writes:
> > What I'm trying to do is to get the Query related to a select statement,
> > alter it and produce a new SPI_plan that will execute. To do so, I
> > retrieve the query from the _SPI_plan->qtlist, alter
36 matches
Mail list logo