i came across this patent in regard to main db usage, am i the only one
who think this patent is rediculous?
http://164.195.100.11/netacgi/nph-Parser?Sect1=PTO1&Sect2=HITOFF&d=PALL&p=1&u=/netahtml/srchnum.htm&r=1&f=G&l=50&s1='5,832,497'.WKU.&OS=PN/5,832,497&RS=PN/5,832,497
diff kind of DBs.
>
> Notice that the two select statements need to have the same number of columns,
> and the fields should be in the same order. Field names don't have to match as
> long as the datatypes are compatible.
>
>
>
>
> "Thomas T. Thai&qu
On Fri, 22 Jun 2001, Tom Lane wrote:
> "Thomas T. Thai" <[EMAIL PROTECTED]> writes:
> >> Use a union query:
> >>
> >> select rec_id, path, '' as link, name from cat_cat
> >> UNION
> >> select rec_id, path, link, name fro
On Fri, 22 Jun 2001, Alex Pilosov wrote:
> On Fri, 22 Jun 2001, Thomas T. Thai wrote:
>
> > > Huh? That *is* the generic, fully-SQL-standard way.
> >
> > the project i'm doing this for is opensource and i need it to work in both
> > postgresql and mysql
RE: http://www.postgresql.org/idocs/index.php?functions-string.html
In Table 4-6. SQL String Functions and Operators
FUNCTIONRETURN TYPE DESC
...
substring( text extract
string substri
i'm parsing DMOZ data files, and i need to store the path and later
reference it to get the associated CatID to store for the parent of the
child paths. however, some of the paths are larger than 500 chars. would a
WHERE clause like this:
... WHERE path='top/this/really/long/500/char/path'
w
On Fri, 7 Sep 2001, Roderick A. Anderson wrote:
> On Fri, 7 Sep 2001, Joe Conway wrote:
>
> > Well, there's already this:
> > http://techdocs.postgresql.org/jobs.php
try clicking on the login or register.. it doesn't work. maybe that's why?
>
> Duh!
>
> > But it currently has no listings :(
as a pgsql superuser, how can i list all the users and their rights? on
mysql i just do a select on the mysql table. i'm a newbie here. i read the
documents and didn't find the answer.
also, when i start 'psql' as system user joe, it says:
psql: FATAL 1: Database "joe" does not exist in the sys
PLEASE NOTE: I'm brand new to PostgreSQL as of today. I've just moved from
MySQL because it's not stable on NetBSD/Alpha. I don't know enough about
pgsql to see if these failed test would make it unstable for production.
i start the server like this:
$ postmaster -D /usr/pkg/pgsql/data > /var/pg
i just wanted to let you all know that i'm so very happy to have joined
the list. since my first day on here, support has been great. i happen to
use NetBSD/alpha and it's not the most advocated OS or platform but i like
it very much. i am still an mysql user. my impression of your support thus
fa
i'm starting to use mnogosearch 3.1.8 and pgsql-cvs on
NetBSD/Alpha.
i'm getting a tremendous amount of these errors in my log file when i'm
running indexer:
...
ERROR: Cannot insert a duplicate key into unique index url_url
ERROR: Cannot insert a duplicate key into unique index url_url
ERROR:
after i ran vacuum analyze, i see that all my database directories with
respect to their database names have changed to all numbers:
# ls -l /var/pgsql/data
total 17
-rw--- 1 pgsql wheel 4 Dec 30 15:45 PG_VERSION
drwx-- 6 pgsql wheel 512 Jan 8 05:28 base
drwx-- 2 pgsql wh
On Tue, 9 Jan 2001, Peter Eisentraut wrote:
> > after i ran vacuum analyze, i see that all my database directories with
> > respect to their database names have changed to all numbers:
>
> > is this normal?
>
> Yes, and it surely was like that before the vacuum analyze as well. This
> is new w
how does one change the time intervals between 'checkpoints'?
pgsql 7.1-current, mnogosearch-3.1.8, netbsd/alpha-1.5.1-current, dec
alpha 500, 1G ram, uw-scsi
i'm trying to find out why postgres is the bottle neck in my searches with
mnogosearch. i've tried both the search.c and php version of search and
they both took up to 50 seconds for a one word search
On Fri, 12 Jan 2001, Tom Lane wrote:
> "Thomas T. Thai" <[EMAIL PROTECTED]> writes:
> > 'select * from url' from psql monitor took 59 seconds.
>
> How big is the table? Your EXPLAIN mentions 99256 rows, but I can't
> tell if that stat is up-to-d
On Sun, 14 Jan 2001, Peter Eisentraut wrote:
> Thomas T. Thai writes:
>
> > what kind of performance hit would i endure if i compiled with
> > --enable-debug on -current
>
> The effect in terms of query execution speed is probably minimal. The
> problem is that t
On Sun, 14 Jan 2001, Peter Eisentraut wrote:
> Thomas T. Thai writes:
>
> > i've noticed that when using php scripts or the "c" cgi search.cgi from
> > mnogosearch, if i access either script from the web browser and stop it
> > with ESC in the middle o
i'm still porting my app from mysql to pgsql. i'm stuck on this one. in my
mysql app where i have a tree structure defined as:
01
0101
0102
...
ZZ01
ZZ02
ZZ0301
...etc
it's basically base 36
when i would move a node in the tree, i would do something like this in
mysql:
UPDATE tbl SET code =
C
sorry it was the very first thing in functions-sting.htm manual. i guess i
was looking for the actual function name CONCAT.
string || string
On Fri, 26 Jan 2001, Thomas T. Thai wrote:
> Date: Fri, 26 Jan 2001 11:57:55 -0600 (CST)
> From: Thomas T. Thai <[EMAIL PROTECTED]>
>
while doing a vacuum, i got a 'broken pipe' error. is this serious?
...
DEBUG: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 2: Vac 0,
Keep/VTL 0/0, Crash 0, UnUsed
2, MinLen 1206, MaxLen 1499; Re-using: Free/Avail. Space
5444/0; EndEmpty/Avail. Pages 0/0. CPU
0.00s/0.00u sec.
DEBUG: Index
how do i increase WAL_FILES and why is it telling me to do that?
DEBUG: Index url_url: Pages 30242; Tuples 457116: Deleted 0. CPU
3.98s/3.42u sec.
DEBUG: Index url_crc: Pages 7874; Tuples 457116: Deleted 0. CPU
1.08s/3.15u sec.
DEBUG: XLogWrite: new log file created - try to increase WAL_FILES
On Mon, 29 Jan 2001, Tom Lane wrote:
> Date: Mon, 29 Jan 2001 01:57:29 -0500
> From: Tom Lane <[EMAIL PROTECTED]>
> To: Thomas T. Thai <[EMAIL PROTECTED]>
> Cc: PostgreSQL General <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] while vacuum: pq_flush: send() fa
On Mon, 29 Jan 2001, Tom Lane wrote:
> Date: Mon, 29 Jan 2001 02:04:47 -0500
> From: Tom Lane <[EMAIL PROTECTED]>
> To: Thomas T. Thai <[EMAIL PROTECTED]>
> Cc: PostgreSQL General <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] increase WAL_FILES
>
> &quo
i've browsed the archive and see that there is a way in using triggers to
achieve automatic modification time stamp. i'm porting a mysql
application, and need that same functiona. pgsql's timestamp is for
date+time[+zone]. however, for mysql it's used to stamp the time when the
record was inserted
On 7 Feb 2001, Gunnar R|nning wrote:
> It is really not based on the FTI code in PostgreSQL, since with we started
> out with a Progress database last year before porting to PostgreSQL. The
> idea is the same though, a separate lookup table containing the words for
> exact matching. Last time I ha
still trying to port this app from mysql to pgsql, but getting this error:
Database error: Invalid SQL: select
t_stories.heading,t_stories.rid,count(*) as cmts from t_stories,t_comments
where t_comments.toprid = t_stories.rid and t_stories.verified = 'y' group
by t_comments.toprid order by t_stor
27 matches
Mail list logo
