Re: [GENERAL] unattened dump

2006-04-13 Thread Paolo Sala
Martijn van Oosterhout scrisse in data 04/13/06 10:47: On Thu, Apr 13, 2006 at 10:35:55AM +0200, Paolo Sala wrote: Hi all I am a newbe in postgres and I'm trying to obtain an unattended dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I havn't found

[GENERAL] unattened dump

2006-04-13 Thread Paolo Sala
Hi all I am a newbe in postgres and I'm trying to obtain an unattended dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I havn't found a way to pass a password in a unattended way. So I have to guess the only solution is to configure pg_hba.conf to use ident as authenticat

Re: [GENERAL] help

2006-04-05 Thread Paolo Sala
karthick muthu scrisse in data 04/06/06 07:54: hello hai, I am new to linux,now i have a job to maintain database using postgre in debian,so i want to know the completebasic details about how to use this. thanking you There are very useful manual online: http://www.postgresql.org/docs/ Hav

Re: [GENERAL] Inheritance

2006-03-28 Thread Paolo Sala
Richard Broersma Jr scrisse in data 03/28/06 15:18: No it isn't. But I remember reading on one of the lists that it was on the to-do list for 8.2. However, I do not know how high it is on the list of things to do. So I imagine that there is the potential that it might not be added. I'll wai

Re: [GENERAL] Inheritance

2006-03-27 Thread Paolo Sala
Jebus scrisse in data 03/27/06 19:03: I could be wrong but primary keys and other constraints are not inherited. Thank you very much Jebus; in effect I've found in the mailing list archives a 2003 thread "INHERITS and Foreign keys" that claim the same problem. Someone (Stephan Szabo) answer

[GENERAL] Inheritance

2006-03-27 Thread Paolo Sala
Hi, I'm new on postgres and I've just installed postgres 7.4.7 on a debian sarge. I'm interested on using inheritance. I've tried a simple code: CREATE TABLE t_main ( id serial primary key ); CREATE TABLE t_derived1 ( field1 varchar(128)default NULL ) IN