> Hi,
>
> I just found a reference to descriptions to functions/tables/...etc.
> and am now wondering how to add them myself?
>
> Joost Roeleveld
not sure if there is a shortcut to this (it's short enough already):
INSERT INTO pg_description (objoid, description)
SELECT oid, 'your descripti
> select key from inv_word_i where word='whatever' order by count desc ;
>
> and this is fast, however, if I use:
>
> select key from inv_word_i where word~'^whatever.*' order by count desc ;
>
> it is very slow.
Did you try '^whatever' instead of '^whatever.*'? Based on common
sense, the form
> Whats BSD ?? Hows itcompare to linux ?
>
> Newbie you know
This conversation develops at a remarkable speed; it's just the
direction that apperas to be wrong. This site should be able to
absorb it:
http://www.unix-wizards.com/
Also, anyone having questions as to which of the systems is bett
> The other end of the spectrum is where you load the payware VMWare stuff.
> It allows you to emulate a complete new PC with it's own BIOS on Linux.
> Basically you run Linux, and then within Linux you can boot up one or even
> more virtual PCs which can run DOS, Windows, OS/2 Linux even and so o
> NOTICE: BufferAlloc: cannot write block 990 for joblist/central
Whenever I saw this error it was caused by the full filesystem in the
data/base/ directory.
--Gene
Frank Mandarino wrote:
> Thanks for your response.
>
> I knew from the programming documentation that the opclass was optional.
> I'm pretty sure, although I will check again tonight, that I tried
> creating the index without specifying the opclass, but I found that the
> index was still not use
> > When the postmaster dies, init will automatically
> > respawn it, much the same as getty, or xdm, etc.
> > Now, since init will be starting the postmaster,
> > the /etc/rc.d/init.d script should be removed and
> > the links to it in /etc/rc.d/rc[whatever].d should
> > also be removed (or yo
I am wondering whether it's normal to see dropping a btree improve the
query which could never complete enough that it completes in a blink?
I realize the data I have here represent the worst possible input to
btree, and I'm probably better off without any index at all, but I
guess it is somethin
> I was looking for a DBMS that supports multidimensional index structures
> like rectangles and points. During my search I found the link to the
> PostgreSQL system.
It does have the R-tree access method and a set of 2-D object types,
such as points, rectangles and polygons. It is also extensibl
> This seems like a simple SQL command, but I'm getting errors.
> Running 6.5.0 under RedHat 5.2:
>
> db=> select count(distinct customer_username) from customerdata;
> ERROR: parser: parse error at or near "distinct"
>
> How do you get a count of distinct data output via postgres?
SELECT cus
The posting I just ran into while reading my other list offers such
a clear insight into book printing that I couldn't stand the temptation
of forwarding it here. The book in question is rather controversial,
but no more so than your average book on software would be. Note point
3 -- it pretty muc
> I also think the ticks that Michael is talking about are required. You can
> usually find more information about the "copy" error in the server.log
> (don't know where this is located on your system).
The file name must be enclosed in single closing quotes ('\047'). And
by the way, psql (if b
> > Is it possible to manipulate the way an index is created by using
> > functions?
Yes, it is possible:
\h create index
Command: create index
Description: construct an index
Syntax:
CREATE [UNIQUE] INDEX indexname ON class_name [USING access_method]
( attr1 [type_class1], ...attrN | f
> I can't put the output of \df command to a file.
psql -d database -c "\df" > file
> Greetings.
>
> Using pg6.5.1 on Solaris 2.6, I'm trying to create a very simple function
> using plpgsql. Here's the code I've executed:
>
> /*
> CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
> '/opt/pgsql/lib/plpgsql.so' LANGUAGE 'C';
>
> CREATE TRUSTED PROCEDURAL LANGUAGE
> > unfortunately '^whatever.*' is what I'm trying to locate (ie: all words
> > starting with whatever, but with nay trailing text), the problem seems to be in
> > the termination of the index scan, not in the actual regex match (which actually
> > seems very good, speed wise..) otherwise I could
Charles Curley wrote:
>
> Ulf Mehlig wrote:
>
> > In my opinion, the regexps are much more powerfull compared to "like
> > '%anything'"-statements; but the regular expression syntax is a little
> > bit weird, and if you have a look in the docs of programs which
> > heavily depend on regexps (per
Hi,
I am joining two or more tables on the column that has quite a number
of nulls, assuming 'a.key = b.key' to be a valid expression even when
both operands are NULLs. The result set is way smaller that I
expect. Could that be because the two NULLs do not match?
I guess there are two possible
"Jackson, DeJuan" wrote:
> > I'm looking for a way that my Perl program can look up the names of
> > the
> > tables in a database. Is there a way to do this?
>
> I thought for sure this was on the FAQ...
Maybe it isn't yet, but it is in "Administrative Tasks" chapter of the users's manual
(alo
Because new keywords have been added since the original manuals were written, some of
the examples may not work any longer, such as this:
(in the files known to me as userguide.ps or admin.html)
> This query lists all binary operators.
>
> SELECT o.oprname AS binary_op,
>
Sorry I could not keep up with your progress -- I am grossly
overcommited :(
Konstantinos Vassiliadis wrote:
>
> Thanks in advance for your help.
> I had a look at your defined type. I have some questions:
> a) I don't really understand the syntax of the Makefile. I understand it
> is required t
Konstantinos Vassiliadis wrote:
>
> Hi
> I am new to Postgres. I am trying to load a C function in Postgres under
> Red Hat Linux.
> I compile using
> gcc -I$PGROOT -I$PGROOT/include -I$PGROOT/src/include -c phone.c
> to produce the object file 'phone.o'
> Then I link using
> ld -Bdynamic -o ph
22 matches
Mail list logo
