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
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'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
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.
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
--
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
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
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
"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
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
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
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
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
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
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
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:
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,
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,
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 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
20 matches
Mail list logo
