Re: [GENERAL] Using database to find file doublettes in my computer

2008-11-19 Thread Lothar Behrens
On 18 Nov., 07:40, [EMAIL PROTECTED] (Craig Ringer) wrote: > -- Once paths is populated, extract duplicates: > > SELECT get_filename(path) AS fn, count(path) AS n > FROM paths HAVING count(path) > 1 > INTO TEMPORARY TABLE dup_files; > > -- Creates UNIQUE index on PATH as well > ALTER TABLE dup_fil

[GENERAL] Using database to find file doublettes in my computer

2008-11-17 Thread Lothar Behrens
Hi, I have a problem to find as fast as possible files that are double or in other words, identical. Also identifying those files that are not identical. My approach was to use dir /s and an awk script to convert it to a sql script to be imported into a table. That done, I could start issuing que

Re: [GENERAL] Am I overseen ?

2007-10-18 Thread Lothar Behrens
On 18 Okt., 19:33, [EMAIL PROTECTED] (brian) wrote: > Lothar Behrens wrote: > > On 18 Okt., 18:22, [EMAIL PROTECTED] ("Scott Marlowe") wrote: > > >>Normally when you get thundering silence, you've asked a question no > >>one feels real qualified

Re: Re : [GENERAL] Am I overseen ?

2007-10-18 Thread Lothar Behrens
want to do: compare databases schemas using XML files and synchronising the schemas. Interesting tool ! ! http://db.apache.org/ddlutils/   Have fun, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Scott Marlowe <[EMAIL PROTECTED]> À : Lothar Behrens <[EMAI

Re: [GENERAL] Am I overseen ?

2007-10-18 Thread Lothar Behrens
On 18 Okt., 18:22, [EMAIL PROTECTED] ("Scott Marlowe") wrote: > On 10/18/07, Lothar Behrens <[EMAIL PROTECTED]> wrote: > > > > > On 18 Okt., 17:17, [EMAIL PROTECTED] (brian) wrote: > > > Lothar Behrens wrote: > > > > Hi, > > > >

Re: [GENERAL] Am I overseen ?

2007-10-18 Thread Lothar Behrens
On 18 Okt., 17:17, [EMAIL PROTECTED] (brian) wrote: > Lothar Behrens wrote: > > Hi, > > > Several groups I post most of them does not answer. > > Did noone see my postings ? > > > Please at least give me one answer :-) > > > Thanks, Lothar > > ping

[GENERAL] Am I overseen ?

2007-10-18 Thread Lothar Behrens
Hi, Several groups I post most of them does not answer. Did noone see my postings ? Please at least give me one answer :-) Thanks, Lothar ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.or

[GENERAL] conditional alter table add ?

2007-10-17 Thread Lothar Behrens
Hi, I do convert an UML XMI model to a database script to create the database schema. To enable multiple iterations I need conditional alter table add column like syntax. Is there any way to do this ? Tanks, Lothar ---(end of broadcast)--- TIP 2:

[GENERAL] Problem with database

2004-12-21 Thread lothar . behrens
Hi, I had a crash with my hdd and now I have recovered the database with the directory found in lost and found. Now I get an error, if I try to open the database admin tool PGAdmin III: cannot open relation pg_amop What is missing ? Coul'd this corrected ? Thanks Lothar -

[GENERAL] foreign keys

1998-12-16 Thread Lothar Behrens
Hello, I tried to define foreign keys, but I get the answer that this is not implemented yet. Is this feature planned in next time? Thanks Lothar

[GENERAL] Problem with curses

1998-05-30 Thread Lothar Behrens
/usr/lib/libreadline.a(terminal.o): In function `_rl_enable_meta_key': terminal.o(.text+0x7ce): undefined reference to `tputs' /usr/lib/libreadline.a(terminal.o): In function `_rl_control_keypad': terminal.o(.text+0x7fb): undefined reference to `tputs' terminal.o(.text+0x822): un