Re: [GENERAL] phppgadmin and external access

2004-07-23 Thread mike g
Sounds like the pg_hba.conf file does not have that other computer listed in it. On Fri, 2004-07-23 at 08:37, eClaire wrote: > Hello, > > I'm new in this list. First, scuse me for my not very good english and > please speak me in simple words ;) > > I had install postgresql on my debian, no

Re: [GENERAL] ERROR: AllocSetFree: cannot find block containing c

2004-07-23 Thread Edwin New
Title: RE: [GENERAL] ERROR: AllocSetFree: cannot find block containing chunk 507928 Tom, Thanks for your response. Select * from pg_class; works fine.  Can you suggest anything else?  I don't really understand what the error message means. We are retiring this database over the next six

[GENERAL] pg storage system

2004-07-23 Thread Krzysztof Labiak
Where can I find some documents about PostgreSQL storage system ? I think that ERL-M87-06.pdf is quite old. I need some details. Perheps there is some comparison paper between postgres and postgresql strorage system. Thanks for any information. Kris ---(end of broadcast)

Re: [GENERAL] select, columns, and aliases

2004-07-23 Thread CSN
??? --- Michael Kleiser <[EMAIL PROTECTED]> wrote: > select a.*, b.* > from tablea AS a > inner tableb AS b > on a.id=b.aid; > > > CSN schrieb: > > Is it possible to automatically prefix a table > alias > > (or table name or something else even) to each > column > > in a select list? For

Re: [GENERAL] Postgres "invalid page header"

2004-07-23 Thread Tom Lane
=?ISO-8859-1?Q?Hubert_Fr=F6hlich?= <[EMAIL PROTECTED]> writes: > E.g. On a client (Athlon 1400+, 512 RAM, XFS, SuSE Linux 8.1 with 2.4.19 > kernel), I regularly crash when using > numberOfRows=30 and ndatabases=3 FWIW, I could not reproduce any such problem here. I ran three test cycles with

Re: [GENERAL] Connexion to Postgresql using TCP/IP

2004-07-23 Thread Tom Lane
=?iso-8859-1?Q?Secr=E9tariat?= <[EMAIL PROTECTED]> writes: > I edit /etc/rc.d/init.d/postgresql, > and I replace the values for PGDATA with the path to my database. > Now I can connect the PC when I use : > service postgresql start > It was due to an update from PG 7.3 to PG 7.4 who has modified t

Re: [GENERAL] select, columns, and aliases

2004-07-23 Thread Bruno Wolff III
On Fri, Jul 23, 2004 at 02:48:01 -0700, CSN <[EMAIL PROTECTED]> wrote: > Is it possible to automatically prefix a table alias > (or table name or something else even) to each column > in a select list? For example: > > select a.*, b.* > from tablea a > inner tableb b > on a.id=b.aid; > > result

Re: [GENERAL] Connexion to Postgresql using TCP/IP

2004-07-23 Thread Secrétariat
- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Secrétariat" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 23, 2004 4:33 PM Subject: Re: [GENERAL] Connexion to Postgresql using TCP/IP > =?iso-8859-1?Q?Secr=E9tariat?= <[EMAIL PROTECTED]> writes: > > I use a

Re: [GENERAL] Connexion to Postgresql using TCP/IP

2004-07-23 Thread Tom Lane
=?iso-8859-1?Q?Secr=E9tariat?= <[EMAIL PROTECTED]> writes: > I use a PostgreSQL server 7.4 on Linux Mandrake 10 with IP 192.168.0.15, > a database gestix is created. > An PostegreSQL user "postgres" id defined on this server, > I add in the .bash_profile of this user the line : > PGDATA=$HOME/data;