Hi,
I updated PostgreSQL from 8.4.4 to 9.0.0 from repo (PGDG) via yum and it
leaves some business unfinished IMHO.
I have a Fedora Core FC12 (Linux 2.6.32.21-168.fc12.x86_64) up-to-date.
So, after the upgrade, I found the following:
a) The postgresql service is not present anymore, so I must st
When I do this
CREATE TABLE "*T1*"
> (
> "T1_ID" bigint NOT NULL,
> CONSTRAINT "*T1*" PRIMARY KEY ("T1_ID" )
> );
I get the following message:
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "T1" for
> table "T1"
> ERROR: relation "T1" already exists
> ** Error *
Hi,
After upgrading pgadmin3 fro 1.14.1 to 1.14.2 via yum, the link in /usr/bin
went missing.
The link was originally installed by the previous pgadmin3 install from yum.
The restored link looks like this:
lrwxrwxrwx 1 root root 27 Feb 28 11:08 /usr/bin/pgadmin3_91 ->
/usr/pgsql-9.1/bin/pgad
Hi,
I'll first explain how it is now and then I'll explain how I think it
should behave :-)
I have Postgresql 9.1.4 64bit Linux
- The default tablespace at install is "pg_default" which is (here)
somewhere in /var/lib/...
- The parameter "default_tablespace" in *postgresql.conf* is commented out
The fuzzystrmatch module (
http://www.postgresql.org/docs/9.2/static/fuzzystrmatch.html) is currently,
as of 9.2.1, documented with the caution *"At present, the soundex,
metaphone, dmetaphone, and dmetaphone_alt functions do not work well with
multibyte encodings (such as UTF-8)"*.
While the vene
