Re: [GENERAL]

2011-10-30 Thread Craig Ringer
On 10/31/2011 09:45 AM, daflmx wrote: Hi,friends. How can I use the postgreSQL database after I have installed the postgresql-8.4_8.4.8-0squeeze2_i386.deb?I don't konw which directory it has been released to. It should be on your PATH. Use the "psql" command to interact with it, and start/stop

Re: [GENERAL]

2011-10-30 Thread Craig Ringer
On 10/31/2011 11:52 AM, daflmx wrote: Hi,friends. How can I remove the postgresql-9.1.1 from my system.I have installed it by source code. Thanks. If you installed it into a --prefix with nothing else in it, just delete that folder. If you used a --prefix that has other stuff in it, eg "--p

Re: [GENERAL]

2011-10-30 Thread John R Pierce
On 10/30/11 8:52 PM, daflmx wrote: Hi,friends. How can I remove the postgresql-9.1.1 from my system.I have installed it by source code. Thanks. fei rm -rf /path/to/postgres

[GENERAL]

2011-10-30 Thread daflmx
Hi,friends. How can I remove the postgresql-9.1.1 from my system.I have installed it by source code. Thanks. fei

Re: [GENERAL]

2011-10-30 Thread Scott Marlowe
On Sun, Oct 30, 2011 at 7:45 PM, daflmx wrote: > Hi,friends. > How can I use the postgreSQL database after I have installed the > postgresql-8.4_8.4.8-0squeeze2_i386.deb?I don't konw which directory it has > been released to. Make sure you've got a postgresql-8.4-client or something like that. su

[GENERAL]

2011-10-30 Thread daflmx
Hi,friends. How can I use the postgreSQL database after I have installed the postgresql-8.4_8.4.8-0squeeze2_i386.deb?I don't konw which directory it has been released to. Thanks. fei

Re: [GENERAL] Why is there no 8.3.16 rpm with _id ?

2011-10-30 Thread Devrim GÜNDÜZ
[Moving to pgsql-general] On Sun, 2011-10-30 at 07:24 +0100, hubert depesz lubaczewski wrote: > we'd like to upgrade to newest 8.3, and we're on 8.3.11 _id, but it > looks like 8.3.11 is the newest version of 8.3 built with integer > datetimes: > http://yum.postgresql.org/8.3/redhat/rhel-5-x86_64

Re: [GENERAL] From select to delete

2011-10-30 Thread Alexander Farber
I've got another great advice to use DELETE ... USING instead of DELETE ... (SUB-SELECT), so my procedure looks now like this (for archive): create or replace function pref_delete_user(_id varchar, _reason varchar) returns void as $BODY$ begin c

Re: [GENERAL] PostgreSQL Naming Rules - another question

2011-10-30 Thread Sim Zacks
On 10/29/2011 12:53 PM, Szymon Guz wrote: Hi, according to this part of documentation: http://www.postgresql.org/docs/9.1/interactive/sql-syntax-lexical.html#SQL- SYNTAX-IDENTIFIERS if I select some names from database and so