Hi
>
> Hmm. The system's knowledge of selectivities for R-tree indexes is
> essentially nil; perhaps someone will be motivated to improve that
> someday. In the meantime, the entirely bogus numbers returned by
> src/backend/utils/adt/geo_selfuncs.c are supposed to be small enough
> to ensure th
* Frank Miles in "[GENERAL] newbie debugging pl/pgsql : better way?"
* dated 2000/10/24 11:56 wrote:
> I have a simple function that isn't working. I've enabled debugging,
> but the error message is still mystifying. My function is as
> follows:
>
>
> CREATE FUNCTION proj_name
Hi:
I'm just getting into pgsql, but have lots of sql experience.
I've read what I can find (Momjian and docs/faqs at .org)
Consider this perl regular expression in which $1 records the part of the
text that matches my regexp:
# print first word of string when first word starts with r and ends w
Hi,
What is the latest version of PostgreSQL?
Is there something like 7.1?
Pawel
Hi:
Now I have the NT binaries, I've installed them, also have running the
ipc-daemon but now when I try to start postgres this happens:
joe666@THOR /etc
$ /pgsql/bin/postgres.exe -D /pgsql/data/
DEBUG: Data Base System is starting up at Tue Oct 24 19:26:29 2000
DEBUG: Data Base System was in
"Vilson farias" <[EMAIL PROTECTED]> writes:
> I'm writing a script to erase non-droped temp tables.
Er, why don't you just disconnect?
> **But when I execute a delete, nothing happens:
> relatorio=# DELETE FROM pg_tables WHERE tablename like 'pg_temp.%';
> DELETE 0
Fortunately for you, pg_table
The answer is easy, but not welcome. The PHP you are using was compiled without
PostgreSQL support. It must be recompiled to include it.
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at
http://www.eudoramail.com
what was the third thing? *raised eyebrow*
On Tue, 24 Oct 2000, Vince Vielhaber wrote:
> On Tue, 24 Oct 2000, Robert Kernell wrote:
>
> > Hi.
> >
> > 1.) Can someone point me to the Postgres User's Manual online (not Bruce M.'s
> > book)?
>
> http://www.postgresql.org/users-lounge
>
> >
Sue <[EMAIL PROTECTED]> writes:
> This is the error message I receive when I try select version();
> WARN: parser error at or near "version"
If it says "WARN" rather than "ERROR" it must be *really* ancient ---
predates 6.3 for sure, hard to tell how much further back than that.
Do yourself a fa
The answer is easy, but not welcome. The PHP you are using was compiled without
PostgreSQL support. It must be recompiled to include it.
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at
http://www.eudoramail.com
Peter Keller <[EMAIL PROTECTED]> writes:
> I generated a table with a column type 'box', inserted some values and
> created an index (ops_box) on that column, run a vacuum and looked with
> the command EXPLAIN if the select will use the index.
> And the result was very astonishing:
> if I had inse
Broke my build on UnixWare 7.1.1... May be perl version confusion...
See my post to -hackers.
Larry
* Tom Lane <[EMAIL PROTECTED]> [001024 18:38]:
> Gilles DAROLD <[EMAIL PROTECTED]> writes:
> > The confusing POLLUTE option is no more used to see these parts compiled.
> > I thinks it's now full
please get me off this list
-Original Message-
From: Sue [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 11:34 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] How do I find out the version number
Hi Brett,
This is the error message I receive when I try
On Tue, 24 Oct 2000, Robert Kernell wrote:
> Hi.
>
> 1.) Can someone point me to the Postgres User's Manual online (not Bruce M.'s
> book)?
http://www.postgresql.org/users-lounge
>
> 2.) Can someone point me to the Postgres FAQ?
http://www.postgresql.org/users-lounge
Vince.
--
===
Marcin Mazurek <[EMAIL PROTECTED]> writes:
> is it possible to CREATE USER in a RILE or TRIGGER?
Not with a rule, and not with a plpgsql trigger either (although I think
the latter restriction is fixed in current sources). You could make it
work with a pltcl trigger, I believe.
> I am looking for a way that I can archieve a lot e-mail messages to a
> data
> base. I'm thinking of using pgsql.
Been there, done that. Works OK for me. Desreves a major rewrite, because
storing message bodies as BLOBs is useless and dangerous. If only there
were 25 hours in the day
Did you have those two dependency packages installed? I know, silly
question, but...
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Darrin Ladd" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 24, 2000 1:14 AM
Subject: [GENERAL
Hi,
I have done a little work concerning the famous PL/Perl compilation Error and
also into Interfaces/Perl5.
The confusing POLLUTE option is no more used to see these parts compiled.
I thinks it's now fully compatible with all Perl versions, yes Tom I use PPPort :-)
The way to put it into the
I have a simple function that isn't working. I've enabled debugging,
but the error message is still mystifying. My function is as follows:
CREATE FUNCTION proj_name(int) RETURNS char(7) AS '
DECLARE
prn ALIAS FOR $1;
precrec
Hi people!
I'm writing a script to erase non-droped temp tables. When I tried to delete
from pg_tables, the following problem raises:
**check out, there are data:
relatorio=# SELECT COUNT(*) FROM pg_tables WHERE tablename like 'pg_temp.%';
count
---
101
(1 row)
**There are data, reall
Hi.
1.) Can someone point me to the Postgres User's Manual online (not Bruce M.'s
book)?
2.) Can someone point me to the Postgres FAQ?
3.) What is OID?
Thanx a bunch!
Bob Kernell
Research Scientist
Surface Validation Group
AS&M, Inc.
email: [EMAIL PROTECTED]
tel: 757-827-4631
Douglas wrote:
>
> Since I'am new to linux and pgsql, and I really want to know about
> what was going on in the pocess, I didn't use rpm. and my linux
> kernel is 2.2.17. I only use enable-locale and enable_multbyte=EUC_TW
> as the configuration parameters.
Ok. To pass regression, you need t
Jeff Eckermann schrieb:
>
> Tom,
> Thanks very much for your full and clear answer.
> It's hard to imagine a general use for this facility, anyway.
> For me this is a one-off exercise, albeit a big one.
> Regards
>
There're commercial OO persistance frameworks out there, which create
there o
Hi all,
I generated a table with a column type 'box', inserted some values and
created an index (ops_box) on that column, run a vacuum and looked with
the command EXPLAIN if the select will use the index.
And the result was very astonishing:
if I had inserted 12 elements postgres will _NOT_ us
24 matches
Mail list logo
