Hello all,
I have two questions about PostgreSQL 6.5:
1. CLUSTER does not work on indexes with more than one field. Is this
correct?
2. In the distribution tarball, the top-level directory is
"postgresl-6.5". Isn't there a 'q' missing?
--
Christian Ullrich
Does anyone know a product called DBMaker from a company called
CASEMaker and would like to tell me about its good and bad points?
I have filled and sent bug report about SELECT with LIKE in 6.5
which don't use realy index scaning, but don't see any reaction,
even if somebody get my report. Can anybody explain me how can I get
information about my bug report?
Thanks.
Alexander N Shulyak
Hi everybody,
I have just installed PostgreSQL 6.5 and encountered problems with
PL/pgsql: On an insert into a table which has a before-insert trigger
I get the following error message:
ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed:
/usr/local/pgsql/lib/plpgsql.so:
un
psql database
drop index table_pkey;
create unique index table_pkey on table (field1, fiel2);
\q
Tim Perdue wrote:
>
> How in the world do you rebuild the primary key table in Postgres?
>
> I've sent a few messages to hackers and don't get much response, but in a
> nutshell, there is a pro
I want to configure my new laptop to have the same versions of software as
my ISP has, which would mean PostgreSQL 6.3.2
Alas, my attempts to locate a PostgreSQL 6.3.2 gz have been futile.
I found a PostgreSQL 6.3.2 diff file, but not knowing what it diffs
against, much less actually having the
How in the world do you rebuild the primary key table in Postgres?
I've sent a few messages to hackers and don't get much response, but in a
nutshell, there is a problem with pgsql in that sometimes you can get
duplication in the primary key.
I eliminated the duplicates from the table today, but
On Thu, 17 Jun 1999, Robert Chalmers wrote:
> Thats what I thought but when I tried to run the backend to test it with
> postmaster -i
> It complained that the database 'postgres' didnt exist... I know., use
> postmaster -i template1 I suppose?
actually, start postmaster as usual.
by default, i
Thats what I thought but when I tried to run the backend to test it with
postmaster -i
It complained that the database 'postgres' didnt exist... I know., use
postmaster -i template1 I suppose?
thanks
Bob
- Original Message -
From: John M. Flinchbaugh <[EMAIL PROTECTED]>
To: <[EMAIL PROTE
Hi there,
I'd like to thank everyone who made the new release happen for the
beautiful new features, and above all, for delivering those without
stomping on my cherished extended types ;)
I'm back in business after a very short downtime. The tables loaded
almost twice as fast as they did with 6
On Wed, 16 Jun 1999, John M. Flinchbaugh wrote:
> On Wed, 16 Jun 1999, Robert Chalmers wrote:
> > Just installed 6.5, all seems well, but it wont start - claims initdb didn't
> > creat the database 'postgres' ...
> > whats happening here ?
>
> initdb only creates `template1'. you have to `creat
On Wed, 16 Jun 1999, Robert Chalmers wrote:
> Just installed 6.5, all seems well, but it wont start - claims initdb didn't
> creat the database 'postgres' ...
> whats happening here ?
initdb only creates `template1'. you have to `createdb postgres' for
yourself if you even want the postgres user
Bob Kruger wrote:
>
> A quick question -
>
> Last week I compiled and ran ver 6.5 beta2. I noticed that the "up arrow"
> key would allow me to easily edit my previous command. In working out a
> quick query, I always thought this was a nice feature that MySQL had and
> Postgres did not.
>
> I
>
> A quick question -
>
> Last week I compiled and ran ver 6.5 beta2. I noticed that the "up arrow"
> key would allow me to easily edit my previous command. In working out a
> quick query, I always thought this was a nice feature that MySQL had and
> Postgres did not.
>
> I have since downlo
Hi,
here is a new version of the bitmask type. It supports hash-indices as
well now, and fixes a bug in the definition of the <> operator.
I would appreciate it if somebody more knowledgable than myself would
look over the index definitions. They seem to work and are used by
postgres, so
A quick question -
Last week I compiled and ran ver 6.5 beta2. I noticed that the "up arrow"
key would allow me to easily edit my previous command. In working out a
quick query, I always thought this was a nice feature that MySQL had and
Postgres did not.
I have since downloaded and compiled
joel reed wrote:
> try configure --host=i686-pc-linux-gnu
>
> change i686 as needed
OK, cool, that worked ... but ... here's what happened next.
$ ./configure --host=i586-pc-linux
creating cache ./config.cache
checking host system type... i586-pc-linux-gnu
checking echo setting...
checking sett
Hi!
On Wed, 16 Jun 1999, Ming-Hung Eng wrote:
> I have a problem to copy datas from unix file, I get the following message
> when I try to import
> a file with more 20 lines :
>
> pgReadData() -- backend closed the channel unexpectedly
> This probably means the backend terminated abnorma
Hi
I have a problem to copy datas from unix file, I get the following message
when I try to import
a file with more 20 lines :
pgReadData() -- backend closed the channel unexpectedly
This probably means the backend terminated abnormally before or while
processing the request.
We have los
> Dear SGI friends,
> Please try NOT to compile PostgreSQL (any version) with gcc on Irix.
>
> Due to a problem in the generation of the code of semaphors and other
> structs, any PgSQL binary produced with gcc will be buggy.
> More information on this subject at
> http://reality.sgi.com/
Dear SGI friends,
Please try NOT to compile PostgreSQL (any version) with gcc on Irix.
Due to a problem in the generation of the code of semaphors and other
structs, any PgSQL binary produced with gcc will be buggy.
More information on this subject at
http://reality.sgi.com/ariel/freeware
At 01:32 +0300 on 16/06/1999, Dan Wilson wrote:
> I even tried to specify the template with --with-template=linux_i386, but I
> get the same exact error message:
> ./configure --with-template=linux_i386
> loading cache ./config.cache
> checking host system type... configure: error: can not gues
Hi,
I need the row oid of an insert in an PL/pgSQL function.
For explanation: After an insert I call a PL/pgSQL function (by a
trigger) and I like to insert into an other table the row oid of the
first insert. But I don't know how to get the oid.
Thank you for helping,
Peter
--
CREATE FUNCTION fu
23 matches
Mail list logo
