On Tuesday 31 December 2002 22:41, Tony Ziolkowski wrote:
> SO what's the solution? I have an unworking postgresql.
You can try to downgrade to the previous version using 'rpm -U --oldpackage'
The Red Hat 8 release notes very explicitly caution against blind upgrades of
PostgreSQL. A dump shoul
Problems :
1. When I click public from pgAdmin I got this error
message :
An error has occured in pgadminII:frmMain.tvNamespace:
Number: -2147467259
Description: cache lookup for proc 3013562 failed
2. When I click certain tables from pgAdmin I got this
error message :
An error has occured in
On Monday 30 December 2002 09:41, Tony Ziolkowski wrote:
> To facilitate upgrading, the postgresql-dump utility has been provided.
Red Hat shipped their packages for RH 8.0 without postgresql-dump. They
didn't update their documentation.
The postgresql-dump program is no longer included at all,
On Tue, 31 Dec 2002, Rob Abernethy IV wrote:
> Is there any problem with this line from my pg_hba.conf file:
> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
> local all all 0.0.0.0 0.0.0.0 md5
A type of "local" doesn't take IP-ADDRES or IP-MASK. It's a UNIX-domain
socket,
Try leaving the IP fields blank, local uses a unix domain socket.
Rob Abernethy IV wrote:
Is there any problem with this line from my pg_hba.conf file:
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all 0.0.0.0 0.0.0.0 md5
I get this error when I try to connect:
Is there any problem with this line from my pg_hba.conf file:
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all 0.0.0.0 0.0.0.0 md5
I get this error when I try to connect:
LOG: parse_hba: invalid syntax in pg_hba.conf file at line 90, token "0.0.0.0"
FATAL: Mis
read
docs 19.11. porting from oracle pl/sql coming with tarball
or
http://www.postgresql.org/idocs/index.php?plpgsql-porting.html
it's
section 23.11.
Jie
Liang
-Original Message-From: Senthil
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 30,
2002 9:11 PMTo: [EMA
use
command ps to find out who is still connect db, terminate those sessions
then try again.
Jie
Liang
-Original Message-From: Mona Gamboa
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 25, 2002 12:13
AMTo: [EMAIL PROTECTED]Subject: [ADMIN]
postmaster failing to
try
latest version 1.4.12,
if
your pg is pre 7.3 then schema public is dummy one.
click
public schma, you should see tables.
good
luck.
Jie
Liang
-Original Message-From: Chris White
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 30, 2002 4:24
PMTo: [EMAIL PROTECTE
For the browser issue, you can switch between charsets with the META tag in the
"" section.
Exemple :
"Jean-Christophe ARNU (JX)" wrote:
> Le Tue, 31 Dec 2002 14:47:42 +0530
> "Somasekhar Bangalore" <[EMAIL PROTECTED]> me disait que :
>
> > Hi,
> >
> > I have a postgres database running linux pl
I think the question was how to find out which columns were affected by the
update statement. TG_OP will only tell you whether an update fired the
trigger.
Klaus
On Thursday 26 December 2002 03:29, CoL wrote:
> http://www.postgresql.org/idocs/index.php?trigger-manager.html
> http://www.postgres
"Mona Gamboa" <[EMAIL PROTECTED]> writes:
;; Hi,
;; I'm new to PostgreSQL--have been using it for 3-4 months now.
;; I've been porting our Oracle DB and applications to PostgreSQL
;; and I am using the latest release 7.3.
;;
;; Anyway, when I do try to shutdown the postmaster with th
you mean: pg_dump ?
C.
Tony Ziolkowski wrote, On 12/29/2002 9:06 PM:
I just upgraded my redhat linux from 7.2 to 8.0. During that process
postgresql 7.2.2 was installed on the system. According to the
documentation i should run postgresql-dump. However, I can't find that
program anywhere. Asid
No I meant what i wrote. The section from README.rpm-dist is:
To facilitate upgrading, the postgresql-dump utility has been provided.
Look
at the man page for postgresql-dump to see its usage. All executables to
restore the immediately prior version of the PostgreSQL database are
placed in
the
Hello,
We’re trying to access a database using pgAdmin II. The
database is installed on a Linux server (Red Hat 7.3 PostgreSQL). PgAdmin II is
installed on Windows 2000 Professional.
PgAdmin II shows the database along with
Languages and Schemas. None of the
other database features
I just upgraded my redhat linux from 7.2 to 8.0. During that process
postgresql 7.2.2 was installed on the system. According to the
documentation i should run postgresql-dump. However, I can't find that
program anywhere. Aside from the obvious of uninstalling 7.2, what can I do?
Thanks
--
http://www.postgresql.org/idocs/index.php?trigger-manager.html
http://www.postgresql.org/idocs/index.php?plpgsql-trigger.html
TG_OP ?
C.
shreedhar wrote, On 12/26/2002 12:57 PM:
Is there any eqvivalent or alternative to the following IF UPDATE(column) or
IF(COLUMNS_UPDATED()) of SQLServer2000.
Hi,
I'm new to PostgreSQL--have been using it for 3-4
months now.
I've been porting our Oracle DB and applications to
PostgreSQL and I am using the latest release 7.3.
Anyway, when I do try to shutdown the postmaster
with the following command:
pg_ctl -D /home/postgres/pgsql/DATA stop -m
Le Tue, 31 Dec 2002 14:47:42 +0530
"Somasekhar Bangalore" <[EMAIL PROTECTED]> me disait que :
> Hi,
>
> I have a postgres database running linux platform.The database has been
> enabled for multibyte support -works fine for Japanese,Spanish,German. But
> when it comes to French..i am able to inse
Hi,
I have a postgres database running linux platform.The database has been enabled for
multibyte support -works fine for Japanese,Spanish,German. But when it comes to
French..i am able to insert French data The Problem is when i want display the data
on the browser, some funny '?' comes alo
20 matches
Mail list logo