Toast will be in 7.1, scheduled for August.
[ Charset ISO-8859-1 unsupported, converting... ]
> As part of the Fmaps project (Fmaps.sourceforge.net), Eric Miller is
> developing some new geographic types for Postgres. We have several questions
> relating to the implementation of new types, variab
John Daniels wrote:
>
> (After I have installed 7.0.2, I will send a diff and comments to the port
> maintainer to help him when he updates the port.)
John,
Since Andreas is busy for so long, I'd suggest you send-pr your
patches so people can upgrade postgres before he gets back and
commits th
mikeo <[EMAIL PROTECTED]> writes:
> we have a 34 million row table. after many inserts, updates, deletes
> the performance degraded so we vacuumed the table. the output indicated
> that the index was also vacuumed but the size didn't change. it was still
> 80m so we dropped and recreated it
#create group "users";
CREATE GROUP
#create user "user1" with password 'pass1' in group "users";
CREATE USER
#create user "user2" with password 'pass2' in group "users";
CREATE USER
#create user "user3" with password 'pass3' in group "users";
CREATE USER
.
#create user "user2012" with passwo
hi,
we have a 34 million row table. after many inserts, updates, deletes
the performance degraded so we vacuumed the table. the output indicated
that the index was also vacuumed but the size didn't change. it was still
80m so we dropped and recreated it reducing it to 20m. no big deal but
i
Is there a source distribution to install just psql? What I'm looking
for is a quick and easy way to install psql and DBD::Pg (which needs
libpq) on a bunch of different unix client machines.
I realize that all the source is there in the main postgresql
distribution but I can't make heads or tai
On Mon, 12 Jun 2000, I'm Your Handiman -Online- wrote:
# > test
#
# kewl i'm in..sorry all for the test...:(
# anywayjust installed postgresSQL 7.0 and everything took fine
It's OK to just post your question, the test is kinda redundant if
you're going to ask a question imme
I'm Your Handiman -Online- wrote:
> test
kewl i'm in..sorry all for the test...:(
anywayjust installed postgresSQL 7.0 and everything took fine
is this normal?
[postgres@localhost postgres]$ /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data
DEBUG: Data Base System is startin
test
John Cochran <[EMAIL PROTECTED]> writes:
>> John Cochran <[EMAIL PROTECTED]> writes:
Why isn't the upper() function working in the first query?
>>
>> Odd. You aren't by some chance working in a non-ASCII locale where
>> "upper('Boulevard')" yields something besides 'BOULEVARD', are you?
>
John Cochran <[EMAIL PROTECTED]> writes:
> Why isn't the upper() function working in the first query?
Odd. You aren't by some chance working in a non-ASCII locale where
"upper('Boulevard')" yields something besides 'BOULEVARD', are you?
regards, tom lane
Hi Travis,
I know this is not what you're asking for, and I
imagine you have already thought of this, but just
in case . . .
You could add an extra column to each of your
tables. These columns would be populated by a
procedure that runs through the existing recordset
and assigns sequential numb
Hello all,
I have quite strange problem.
I have one table for lots of dicts:
CREATE TABLE dicts (
id serial,
type int4,
name text
);
And dicts_type table with textual description of types. Don't blame me... I know that
this is not
fast. I just try to be as close as the
Greetings,
I'm having problems with what I believe to be a simple query and I assume
that either there is a bug in PostgreSQL in handling functions during a
select or I'm doing something very stupid.
I have a table of words and abbreviations where the word is being
used as a primary key. Everyth
Hi,
I have the following situation:
I AM USING THE C LANGUAGE INTERFACE (LIBPQ) but I
have also tried the situation described below from
within psql and got the same results.
I am using PostgreSQL version 6.4.
- I Have to keep a cursor for a select * from
open most of the time and somet
How do I prevent users from seeing the names of tables/structure of tables
on which they do not have permission to perform operations. I would like
to make the database appear, to clients, to only contain the view to which
they have permissions, and nothing else.
-
Let's say I have two tables with the follwing data:
Table_X
A | B
-
1 | Cat
2 | Dog
3 | Mouse
4 | Hat
Table_Y
C | D
-
2 | Eat
4 | Book
I would like a select statement that joins these two tables to produce the
following. It lines up the rows one by one against
> At 06:28 PM 07-06-2000 -0400, Bruce Momjian wrote:
> >I have been told by the publisher that most changes to the book must be
> >done by next week.
> >
> >The book is at:
> >
> > http://www.postgresql.org/docs/awbook.html
> >
> >Again, many thanks to those that have supplied suggestions for
At 06:28 PM 07-06-2000 -0400, Bruce Momjian wrote:
>I have been told by the publisher that most changes to the book must be
>done by next week.
>
>The book is at:
>
> http://www.postgresql.org/docs/awbook.html
>
>Again, many thanks to those that have supplied suggestions for the book.
More
19 matches
Mail list logo
