Hi,
I am new to Postgresql and to SQL as well and I have
the following situation, which has been performed so
far using Codebase Database Manager (xbase standard)
in
several application softwares, using C programming
language:
I have a table with 50.000 records;
I have to display a grid
Peter Mount wrote:
Lamar Owen Wrote:
NOTE: There are no Linux/alpha patches in these RPMs. Hopefully, that
situation will soon be rectified in a -2 RPMset. However, I _did_ get
the 7.0 JDBC jar's in
PM: Good job I got them done in time wasn't it ;-)
The interesting side of it was that
On Tue, 16 May 2000, siva wrote:
hello,
i'm a web server administrator of clickcricket.com, i was tried to get some
information on postgres database tools, when i clicked search postgres link; it was
given me a search.cgi not found error. pls. check this minor mistakes from the major
site
On Tue, May 16, 2000 at 01:41:48AM -0700, Dustin Sallings wrote:
On Mon, 15 May 2000, Charles Tassell wrote:
I ran into this exact problem, and it was *very* significant on a
15M row table I have. :) It didn't seem to want to use the index, even
freshly created, without a vacuum
Two questions:
1. Is there a way to make an "Array field," where you could refer to
something like afield[1], afield[2], . . . and have them each be an
integer or some other base data type?
2. If not, I think something equivalent could be accomplished using
composite data types written in
Marcos Barreto de Castro wrote:
My questions are: Is there a skip function in
Postgresql that I can use to browse through the
records in a table forwards and backwards (That table
has 50,000 records)? If not, how would I be able to
develop
such a mechanism as the one explained above? Are
I had the ODBC stuff set up for PostgreSQL 6.* and running it from
within StarOffice5.1 last week. This morning I successfully upgraded to
PostgreSQL 7.0 (goodie for me). Unfortunately I don't know how to
upgrade the ODBC drivers. I have them, I'm just not sure what to do
with them.
To get
Could anyone please tell me what I'm doing wrong? I'm sure I'm just
overlooking something, but what?
==
moran:/acct$ id
uid=1007(postgres) gid=1003(postgres) groups=1003(postgres)
moran:/acct$ export P=/acct/pindybook
moran:/acct$ initlocation P
The location will be
"Ross J. Reedstrom" [EMAIL PROTECTED] writes:
On Tue, May 16, 2000 at 01:41:48AM -0700, Dustin Sallings wrote:
I ran into this exact problem, and it was *very* significant on a
15M row table I have. :) It didn't seem to want to use the index, even
freshly created, without a vacuum analyze.
I think what you need to do is:
$ initlocation $P
^
$ createdb indybook -D $P
^
-Original Message-
From: Richard J Kuhns [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000 8:26 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Question about
Richard J Kuhns wrote:
Could anyone please tell me what I'm doing wrong? I'm sure I'm just
overlooking something, but what?
==
moran:/acct$ id
uid=1007(postgres) gid=1003(postgres) groups=1003(postgres)
moran:/acct$ export P=/acct/pindybook
first guess is this:
Here are more info. Sorry, I thought taht because this case is very simple,
it was not necesary, but
5 ROWS aprox
QUERY:
SELECT * FROM d_cue WHERE d_cue.clave = '$cue'
INDEX:
create index d_cue_clave on d_cue (clave);
EXPLAIN:
ra1999= explain select * from d_cue where
Marcos Barreto de Castro wrote:
My questions are: Is there a skip function in
Postgresql that I can use to browse through the
records in a table forwards and backwards (That table
has 50,000 records)? If not, how would I be able to
develop
such a mechanism as the one explained above?
After my posting last night, the web version of the book was again
unavailable this morning because of server changes.
It is working now:
http://www.postgresql.org/docs/awbook.html
--
Bruce Momjian| http://www.op.net/~candle
[EMAIL PROTECTED]
On Tue, 16 May 2000, siva wrote:
and i also wants to know how to find and delete duplicate values from postgres
database(primary key not defined). and i dont wants to go thru. any other books or
reference . give me the correct syntax :
The correct syntax for writing a sentence is to
Hello all:
Using 6.5.3, SuSE 6.4, logged in as 'billb'.
Here are 2 instances of the COPY command;
-
copy custprofile from '/home/billb/custpr.txt' using delimiters ';';
The result is:
ERROR: COPY command, running in
On Tue, May 16, 2000 at 01:57:19PM -0400, Bill Barnes wrote:
Hello all:
Using 6.5.3, SuSE 6.4, logged in as 'billb'.
Here are 2 instances of the COPY command;
-
copy custprofile from '/home/billb/custpr.txt'
17 matches
Mail list logo