Re: [ADMIN] out of memory error

I had a similar problem after upgrade to 7.4.2, Try: SET enable_hashagg = false; Before you execute that SELECT stmt If you don't want disable it in postgresql.conf Jie Liang -Original Message- From: Adi Alurkar [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 5:01 PM To: [EMAIL

[ADMIN] rules

-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 5:19 PM To: Nico De Ranter Cc: postgres-list Subject: Re: [ADMIN] IDENT authentication failed but I'm not using ident Nico De Ranter [EMAIL PROTECTED] writes: \connect: FATAL: IDENT

[ADMIN] rules

According to the document of rule: CREATE RULE rulename AS ON delete TO mytablename DO ( delete from aaa where id=OLD.id; Delete from bbb where id=OLD.id; Delete from ccc where id=OLD.id ); Should work, but it doesn't, what wrong with it? Even I use { } Jie Liang

Re: [ADMIN] rules

Sorry, wrong question. -Original Message- From: Jie Liang Sent: Wednesday, May 19, 2004 10:20 AM To: Tom Lane Cc: postgres-list; [EMAIL PROTECTED] Subject: [ADMIN] rules According to the document of rule: CREATE RULE rulename AS ON delete TO mytablename DO ( delete from aaa where id

[ADMIN] Log msg

), but not how execute (process) . Jie Liang ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] Log msg

(process) . Jie Liang ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] [SQL] \set

Thank you, Tom. Jie -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 4:06 PM To: Jie Liang Cc: Christian Kratzer; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [ADMIN] [SQL] \set Jie Liang [EMAIL PROTECTED] writes: You will see AAA

[ADMIN] \set

! Thanks. Jie Liang ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] 7.4.2 out of memory

. Thanks. Jie Liang ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] string function -- replace needs a clear doc

('whatever%20sitis','si','SI'); replace --- whateverSItis (1 row) 1. No doc said % should escape by %%, and select replace('whatever%20sites','%20','%%20') won't work also. 2. v7.3.2 haven't resolved this problem yet, I am not sure the later version. Jie Liang

Re: [ADMIN] pgAdmin cannot view tables

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 PROTECTED

Re: [ADMIN] postmaster failing to shut down

use command ps to find out whois 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

Re: [ADMIN] md5 file

Thanks, I figure out: on freebsd it's command md5 Jie Liang -Original Message- From: Dan Langille [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 1:17 PM To: Jie Liang Cc: 'Bruce Momjian'; [EMAIL PROTECTED] Subject: Re: [ADMIN] md5 file On Mon, 23 Dec 2002, Jie Liang wrote

[ADMIN] libpg.so.2 is missing in 7.3.1

-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 11:32 AM To: [EMAIL PROTECTED] Cc: Simone Tellini; [EMAIL PROTECTED] Subject: Re: [ADMIN] locking a table Andreas Schmitz [EMAIL PROTECTED] writes: Maybe I have a different idea of exclusive.

[ADMIN] libpg.so.2 is missing in 7.3.1

libpq.so.2 not found at /usr/libdata/perl/5.00503/DynaLoader.pm line 169. I copy libpq.so.2 from 7.3.0 in /usr/local/pgsql/lib of 7.3.1 then all my scripts run OK. But I think that is very urly way to fix it. Is there other way or I missed something. Jie Liang ---(end

[ADMIN] list schema

Bruce, I wonder which command can show all schemas in 7.3? I mean: \dt -- show all tables \l -- show all databases ?? -- show all schemas Thanks. Jie Liang Software Engineer St. Bernard Software 16882 W. Bernardo Dr. San Diego, CA 92127 Tel: 858-524-2134 Fax:858-676-2228 [EMAIL

Re: [ADMIN] list schema

I believe \dn is better. Jie Liang Software Engineer St. Bernard Software 16882 W. Bernardo Dr. San Diego, CA 92127 Tel: 858-524-2134 Fax:858-676-2228 [EMAIL PROTECTED] -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:36 PM

[ADMIN] why schema name is same as username behaves different then others

then it will shadow the objects in the public schema that have same name. I haven't documentation address this yet. Jie Liang Software Engineer St. Bernard Software 16882 W. Bernardo Dr. San Diego, CA 92127 Tel: 858-524-2134 Fax:858-676-2228 [EMAIL PROTECTED] ---(end

Re: [ADMIN] why schema name is same as username behaves different then ot

Got it. Thank you. Jie -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:58 PM To: Jie Liang Cc: 'Bruce Momjian'; [EMAIL PROTECTED] Subject: Re: why schema name is same as username behaves different then others Jie Liang [EMAIL PROTECTED

Re: [ADMIN] why schema name is same as username behaves different then ot

But why shadow happens only schema name is SAME as username?? Jie -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:58 PM To: Jie Liang Cc: 'Bruce Momjian'; [EMAIL PROTECTED] Subject: Re: why schema name is same as username behaves different

[ADMIN] 3 million record updates

: shared_buffers=6 wal_buffers=8 sort_mem=512 vacuum_mem=8192 OS conf: shmmax=535404544 shmmin=1 shmmni=192 shmseg=256 shmall=130714 shm_use_phys=1 OS: FreeBSD-4.6.2 DB: Postgresql-7.2.1 Thanks. Jie Liang ---(end of broadcast)--- TIP 3: if posting/reading

Re: [ADMIN] problem in module Pg with Apache, Perl and SSL

module/category current distrbution file Pg pgsql_perl5-1.9.0tar.gz -Original Message- From: Morten Sickel [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 5:50 AM To: 'Nigel J. Andrews'; Pgsql-Admin (E-post) Cc: 'BELLIARD Francois -

[ADMIN] pg_dump bug

upgrading my DB from Pg7.1.3 to Pg7.2. This is one of problems I got. I don't know does this bug has been fixed in Pg7.2?? Jie LIANG Software Engineer St. Bernard Software 16882 W. Bernardo Dr. San Diego, CA 92127 Office:(858)524-2134 [EMAIL PROTECTED] ---(end

[ADMIN] Syslog

In postgresql.conf: # Syslog # requires ENABLE_SYSLOG How to do it? My OS is FreeBSD4.5 I installed Postgres-7.2 Urgent! Thanks! Jie Liang ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [ADMIN] Syslog

I did, it didn't work. Jie Liang -Original Message- From: Joe Conway [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:49 AM To: Jie Liang Cc: '[EMAIL PROTECTED]'; pgsql-sql Subject: Re: [ADMIN] Syslog Jie Liang wrote: In postgresql.conf: # Syslog # requires

Re: [ADMIN] Syslog

I did everything as you did, however, when start the postmaster, I got following: FATAL 1:'syslog' is not a valid option name. Jie -Original Message- From: Joe Conway [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 11:27 AM To: Jie Liang Cc: '[EMAIL PROTECTED]'; pgsql

[ADMIN] installation of 7.1.2 with tcl/tk

gmake[1]: Leaving directory `/usr/local/postgresql-7.1.2/src' gmake: *** [all] Error 2 *** Error code 2 Jie LIANG St. Bernard Software 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.stbernard.com www.ipinc.com

Re: [ADMIN] installation of 7.1.2 with tcl/tk

yes, I solved it. thanks anyway. Jie LIANG St. Bernard Software 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.stbernard.com www.ipinc.com On Mon, 4 Jun 2001, Tom Lane wrote: Jie Liang [EMAIL PROTECTED] writes: ./configure --with-perl

Re: [ADMIN] random rows

thanks. Jie LIANG St. Bernard Software 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.stbernard.com www.ipinc.com On Thu, 26 Apr 2001, Ing. Roberto Andrade Fonseca wrote: On Thu, 26 Apr 2001, Jie Liang wrote: How I can return

Re: [ADMIN] Connecting via perl gives root does not exist

For other users, you have to provide username and password which should existed in your db. Jie LIANG St. Bernard Software 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.stbernard.com www.ipinc.com On Sun, 22 Apr 2001, Randall Perry wrote

Re: [ADMIN] Re: [SQL] I cannot vacuum

- PostgreSQL 7.0.0 on i386-unknown-freebsdelf3.4, compiled by gcc 2.7.2.3 Dose later version such as 7.0.3 resolved this problem?? if so, which version I should install? Jie LIANG St. Bernard Software 10350 Science Center Drive Suite

[ADMIN] I cannot vacuum

unexpectedly. This probably means the backend terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Succeeded. any suggestion?? Jie LIANG St. Bernard Software 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office

Re: [ADMIN] There is error at the examples in PL/pgSQL

what's version psql you working on?? I pasted your example, it works fine. you might miss something... Jie LIANG St. Bernard Software 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.stbernard.com www.ipinc.com On Mon, 5 Mar 2001, Lu

Re: [ADMIN] can't run pg_dump in sh script using crontab

ot; [EMAIL PROTECTED] then you can figure out what's wrong. Jie LIANG St. Bernard Software Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.stbernard.com www.ipinc.com On Sat, 10 Feb 2001, Kogotkov, Vyacheslav wrote:

Re: [ADMIN] is a user in a group?

for. There should be something more elegant than this!!! There should be a system table which I can use to find the relation between user and groups. I would be very grateful to anyone who can help me:-). Bye, Jacopo -- Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100