Re: [GENERAL] SELECT statement with sub-queries

ECT * FROM products > WHERE category IN > (SELECT categories.cat FROM categories); This give an error See previously mail for what I want to archive -- Michelle KonzackMiila ITSystems @ TDnet GNU/Linux Developer 00372-54541400 signature.asc Description: Digital signature

Re: [GENERAL] SELECT statement with sub-queries

On 2017-05-28 11:23:47 Adrian Klaver hacked into the keyboard: > On 05/28/2017 10:53 AM, Michelle Konzack wrote: > >> > >>SELECT * FROM products WHERE category IN > >> (SELECT categories.cat FROM categories WHERE > >> categories.serial = products.

Re: [GENERAL] SELECT statement with sub-queries

varchar(100), p_desc varchar(1), ); 8<-- This is WHY I am puzzeling arround with the "integer" error. -- Michelle KonzackMiila ITSystems @ TDnet GNU/Linux Developer 00372-54541

[GENERAL] SELECT statement with sub-queries

teger==integer LINE1: ...gories.cat FROM categories WHERE categories.serial==products.category); ^ Hmm, "serial" is an "integer" and the "category" and "manufacturer" too. So whats wrong with it? -

[GENERAL] PHP-Shop with PostgreSQL

-- Michelle KonzackITSystems GNU/Linux Developer 0033-6-61925193 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID

. In clear this: CustID Count 1 1 1 2 1 3 2 1 2 2 3 1 3 2 3 3 ... How to do this? Thanks in avance -- Michelle Konzack

[GENERAL] HA for PostgreSQL (Auth-Server)

e Intranet Database itself is only arround 13 GByte Thanks, Greetings and nice Day/Evening Michelle Konzack -- # Debian GNU/Linux Consultant ## Development of Intranet and Embedded Systems with Debian GNU/Linux itsyst...@tdnet France EURL itsyst..

Re: [GENERAL] 10 TB database

with > 250GB/day unless you write a custom data loader that keeps multiple cores AFAIK he was talking about 250 GByte/month which are around 8 GByte a day or 300 MByte per hour Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator Tamay Dogan Network

Re: [GENERAL] 10 TB database

Note: On Friday I have a meeting with a Sun Partner in Germany because a bigger project... where I have to increase the performance of my database servers. I have to calculate with 150.000 customers. Thanks, Greetings and nice Day/Evening Michelle Konzack Syste

Re: [GENERAL] pgsql announce now on twitter

Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant ###

Re: [GENERAL] pgsql announce now on twitter

I was forced to block Twitter entirely on my Mailserver since they have even spamed my postmaster and abuse address. > (PS - I'm not on these lists. CC me if you want me to see your response) Done Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V

Re: [GENERAL] Database access over the Internet...

signature.pgp Description: Digital signature

Re: [GENERAL] Database access over the Internet...

ss then 3% from it... So, peoples now sending me PMs does not help, since it DoS my system and make it harder for me to work since I have to walk through this messages I do not need because I have it already seen. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator

Re: [GENERAL] Database access over the Internet...

read my WORK E-Mails with my GSM and haf to walk trough 100 of CCs which are definitively not important. And of course, each CC cost me money... 0.009 Euro/kByte. Getting per day 1 MByte of CC is annoying. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator

Re: [GENERAL] Database access over the Internet...

dd the banner to let peoples know I DO NOT WANT CCS. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.

Re: [GENERAL] How to design a "customer" TABLE which hold credit card infos and other payments?

at the German telecom there have peoples stolen 12 million records... OK, not Credit Card infos, but personal customer data. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant

Re: [GENERAL] How to design a "customer" TABLE which hold credit card infos and other payments?

Am 2008-11-07 07:48:25, schrieb Scott Marlowe: > On Thu, Nov 6, 2008 at 2:43 PM, Michelle Konzack > <[EMAIL PROTECTED]> wrote: > > > > * Do not Cc: me, because I READ THIS LIST, if I write here

Re: [GENERAL] How to design a "customer" TABLE which hold credit card infos and other payments?

Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack

Re: [GENERAL] Database access over the Internet...

Am 2008-11-07 07:51:37, schrieb Scott Marlowe: > On Thu, Nov 6, 2008 at 2:27 PM, Michelle Konzack > <[EMAIL PROTECTED]> wrote: > > > > * Do not Cc: me, because I READ THIS LIST, if I write here

Re: [GENERAL] Equivalent for AUTOINCREMENT?

Hi again, Am 2008-11-05 20:13:40, schrieb Craig Ringer: > Michelle Konzack wrote: > >OK, you hit me, I am trying to convert a mysql scheme to postgresql... OK, in the same time I am trying to make programs like os-commerce PostgreSQL usable > >Realy, I hate programs whi

[GENERAL] Database access over the Internet...

or 2 years. Note 2: I am working 95% mobil, which is WHY I use GSM/UMTS/HSDPA. (cost only 25 Euro/month with unlimited traffic at "O2" in Germany) Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network

Re: [GENERAL] Semi-customized queries? Subset of SQL? Accessing the parser? Injection?

7;t do that. (Or I wouldn't have asked the question.) Need a WWW > interface, period. And where is the problem? Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linu

[GENERAL] How to design a "customer" TABLE which hold credit card infos and other payments?

with it 1) how I should store it 2) how the TABLE fields should look like And yes, I would use a reference to external tables instead of puting those data in the main "customer" TABLE... Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrat

Re: [GENERAL] Redefining an existing Table Schema for Foreign Key Constraint - Question

ould be a problem for the above table... > 2. Are there credit cards owned by more than one customer? CreditCards are personaly and sometimes (in France) I need an ID card to prove, that I am the holder... So how can one credit card can have more then one owner? Thanks, Greetings and ni

Re: [GENERAL] Equivalent for AUTOINCREMENT?

counter SET last_used = last_used + 1; > -- > INSERT INTO sometable ( id, blah ) VALUES ( (SELECT last_used FROM > id_counter), 'blah'); Thank you for the example.... I will try it out now. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 2

Re: [GENERAL] Equivalent for AUTOINCREMENT?

x(serno) and add +1 the get the next value for "serno". Is there a solution for it? Since I can use a transaction block if required, there should be no problem with concurence access. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Ele

Re: [GENERAL] Equivalent for AUTOINCREMENT?

course I try avoid database specific functions... MySQL has hit me more then once. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with

Re: [GENERAL] Equivalent for AUTOINCREMENT?

ffernt tables? Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux

[GENERAL] Equivalent for AUTOINCREMENT?

anymore... Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant

Re: [GENERAL] Annoying Reply-To

Am 2008-10-23 15:52:30, schrieb ries van Twisk: > anyways.. I don't care anymore... I will do a reply all. I do normaly: killall ;-) Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian G

Re: [GENERAL] Annoying Reply-To

x27;t know about other MUAs. N.C. ;-) Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ #

Re: [GENERAL] Drupal and PostgreSQL - performance issues?

vening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Ap

Re: [GENERAL] Annoying Reply-To

To:" Header... So, I prefer, HOW this list is. Of course, I reply with or . Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Lin

Re: [GENERAL] Annoying Reply-To

Micr0$of SQL Server... LOL ;-) Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debi

Re: [GENERAL] Drupal and PostgreSQL - performance issues?

If you have problems with Reply-To: get a REAL MUA, which support Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter

Re: [GENERAL] how to use pam-pgsql

tation? The SQL SCHEME is included in the tarball so create a database like "system" and load the *.sql file into it. Now you can add normal unix users to it. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Do

Re: [GENERAL] Largest PostgreSQL 8.x DB someone is running?

three dinosaur from Sun Microsystems with each more then 500 SCSI drives of 300 GByte. So it is arround 21-25 TByte but do not ask me about the Electricity bill:-) Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network

Re: [GENERAL] PDF Documentation for 8.3?

(Bouygues Telecom) to the Internet and if I klick the PDF links, the conection timed out. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linu

[GENERAL] PDF Documentation for 8.3?

rching the site but there are no PDF's for 8.3 in format A4 or do I missing something? Note: The american "Letter" format sucks, because I am printing two A4 pages on ONE A4 side and with the "Letter" format I get very huge borders... Thanks, Greetings a

Re: [GENERAL] Oracle and Postgresql

Am 2008-09-15 10:12:08, schrieb Joshua Drake: > Are we going to start a VI vs Emacs argument too? They are out of concurence since I am using mc (Midnight Commander). :-P Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Ta

Re: [GENERAL] offtopic, about subject prefix

ssages without this prefix likely to be ignored by automatic filters > or something like that? Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Lin

[GENERAL] [OT] CSS Mailinglist?

disallow it. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux

Re: [GENERAL] psql scripting tutorials

Am 2008-09-11 10:03:03, schrieb Roderick A. Anderson: > Whatever happened to pgbash? I see the last update was Feb 2003 but > that was for Pg v7.3. I have tried it soe times ago with 7.4 but goten to many errors... ...and gaved up. Thanks, Greetings and nice Day/Evening Michelle K

FW by [EMAIL PROTECTED] : [GENERAL] [pgsql-general] Daily digest v1.8030 (22 messages)

Hi all, Since 2008-03-27 I get in paralel to the list messages this useless Daily diggest. Can anyone tell me who has activated this? Is this an accident by the list owner? Thanks, Greetings and nice Day Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan

[GENERAL] /var/lib/postgres on Hitachi E5K160 60 GByte (Raid-1 + Hotfix)

f them into a Raid-1 + Hotfix. The server is already running but /var/lib/postgres is currently on three Western Digital Raptor WD740 which consuming over 45 Watt andare laud liek an Combat-Aircraft... Three E5K160 would only consume arround 18 Watt. Any Experiences? Thanks, Greetings and nice Day

Re: [GENERAL] PostgreSQL on a CompactFlash

8 GByte Cards (Raid-5 + Hotfix) for the Data (the Postgresql.tar.gz and static data) The TAR Archive is around 5 GByte (PostgreSQL has already compressed the Stuff) and I was forced to install 12 GByte of Memory. Thanks, Greetings and nice Day Michelle Konzack Systemadministrator T

[GENERAL] Clustering/Partitioning tables from existing tables?

the "master" table now? Q 2: Can anyone provide me a script whic do that. (I am NOT THE GENIE) Note: The tables have only names like "data_N" where N is a number from 0 (yes, with leading zeros) to 9. Thanks, Greetings and nice Day

Re: [GENERAL] [OT] RAID controllers blocking one another?

o performant. Thanks, Greetings and nice Day Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant ##### Michel

Re: [GENERAL] Restoring 8.0 db to 8.1

ot; to fight the enormeous size which is growing every day by arround 350 MB. ...and since I am not God or the absolute PostgreSQL guru (which should redesign my Database-Structure) I have a bunch of "Large Objects" in this pig which should be normaly on a fileserver

Re: [GENERAL] 1 cluster on several servers

Am 2007-11-29 12:50:58, schrieb Willy-Bas Loos: > Hi, > > Is it possible to run one PostgreSQL cluster on more than one (hardware) > server? Yes of course... I run at a customer "Monster" with 42 PostgreSQL servers of each 1,8 TByte. Thanks, Greetings and nice Da

Re: [GENERAL] Temporary, In-memory Postgres DB?

.. Thanks, Greetings and nice Day Michelle Konzack Tamay Dogan Network Open Hardware Developer Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant ##### Mi

Re: [GENERAL] SELECT question

Am 2007-08-17 12:53:41, schrieb Michael Glaesemann: > > On Aug 17, 2007, at 7:27 , Michelle Konzack wrote: > > >* > >* Do not Cc: me, because I am on THIS list, if I write here.* > > You migh

[GENERAL] SELECT question

that LAST version of the elements... Greetings Michelle Konzack -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886 50, rue

Re: [GENERAL] How to move tables in another physial place

rives. But since the database IS on ONE PYSIACAL partiton I do not know, HOW TO MOVE some of the smaller tables (without stoping the PostgreSQL from operating since it is needed 24/7) Thanks, Greetings and nice Day Michelle Konzack Systemadministrator Tamay Dogan Network Debian GN

[GENERAL] How to move tables in another physial place

to another partition. How can I do this? (best and fastest way) Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant

Re: [GENERAL] Tsearch2 crashes my backend, ouch !

ge too. Where can I get the "tsearch_core patch" patch? Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/

Re: [GENERAL] Anyone know where I can get an 8.2.3 binary for ubuntu?

sql-8.2-8.2.3 cd postgresql-8.2 > edit debian/control and put the dapper's version for debhelper and > cdbs > dpkg-buildpackage -us -nc dpkg-buildpackage -us -nc -rfakeroot Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux

Re: [GENERAL] Any Plans for cross database queries on the same server?

door. I guess I'm a typical dumb American, traveling all the way to > Paris to eat at McDonald's. :-) Do you know "Döner Kebab"? Realy good beek or chicken with fresh salad! Not this "american" fast-feed. :-) And its cheaper! Greetings Michelle Kon

Re: [GENERAL] PG Email Client

able become two references for the TWO folders. Note: Currently I have 7.41 million messages in my table for testing plus the originals on Courier-Imap. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138

Re: [GENERAL] PG Email Client

ace), Courier-Imap, PostgreSQL and Sieve. The thing is currently in PreAlpha state (it works for me) with realy limited functions,since I have excluded most thinks to reduce errors while coding my stuff. It is only a private Research Project but maybe some times... Greetings

[GENERAL] Quering 4 or more physicale different PostgreSQL server at once

with most requested data on the first Server which will have arround 180 GByte and then the rest of "THE" table on the other servers. Note: "THE" table is a historical timeline... and the datasets are not ordered in the table. Greetings Michelle Konzack Systemadminis

Re: [GENERAL] Storing images in PostgreSQL databases (again)

ngish key, but workable I suspect (untested, we used an > artificial key, a serial). Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ #

Re: [GENERAL] pg web hosting with tsearch2?

Am 2006-09-29 13:45:34, schrieb Rick Schumeyer: > 3)All the web hosts I am aware of are still offering only pg 7.4. > Does anybody offer pg 8.x ? I am thinking about a root-Server for 39 Euro/Month on which I can install what I want Greetings Michelle Konzack Systemadminis

Re: [GENERAL] vista

ed with. But who sponsor a Vista machine? (Dualboot is no solution) Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ ##### Debian GNU/Linux Consultant ##

Re: [GENERAL] plz xxxxxxxxxxx me

er... My strings hit nearly ALL *subscribe mails. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux C

Re: [GENERAL] PostgreSQL installed in non-standard Directory

all the normal system libs and standard install packages... I will try it. But sometimes I have gotten strange results using chroots on foreign systems (specialy if I must install 100 or more packages) Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/L

[GENERAL] PostgreSQL installed in non-standard Directory

Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886

Re: [GENERAL] OK, this is a

uncated subject). :-) This is, why I was wondering about it. I use mutt since 1999/03 and never seen a truncated Subject: header. Greetings and nice Weekend Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User

Re: [GENERAL] plz unsubscribe me

h still doesn't cover "RE" translated in most of the world's > languages, which I'm sure occasionally pop up from people who use > localized mail clients. * ! ^Subject:.*(Re|AW|Antwort|Reply|Reponse|Sv): Better? Greetings Michelle Konzack Systemadminis

Re: [GENERAL] OK, this is a Test für

, whats going on here?] And even with mixed encoding type (base64 and quoted-printable) it is correct. Greetings Michelle Am 2006-09-13 15:09:17, schrieb Michelle Konzack: > Hi Alvaro, > > This is a second test with some non US-ACII characters... > > Since I am in France, I

Re: [GENERAL] Majordomo drops multi-line Subject:

ordomo2 support a nomail option as well ... I know, since some Mailinglist I am on are migrated to Majordomo2. Afaik does Mailman not support the "nomail" Option. Same for ezmlm, sympha, and smartlist. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network

[GENERAL] OK, this is a Test für a Subject containing one non ASCII character ans some more like éáóèàòôç [WAS: Re: [GENERAL] This is a Reply to the message "Re: Majordomo drops multi-line Subject

Hi Alvaro, This is a second test with some non US-ACII characters... Since I am in France, I have never seen broken Subject lines. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant Am 2006-09-09 12:30:25, schrieb Alvaro Herrera

Re: [GENERAL] plz unsubscribe me

l... it's not that hard to have any specific string > by mistake on your subject line... You can eliminate such things by checking the Subject line for Re: AW: SV: and such. :0 * ! ^Subject:.*Re: * ^Subject:.*(subscribe|subscribel|suscribe) /dev/null Greetings Michelle Konzack S

Re: [GENERAL] Majordomo drops multi-line Subject:

ot;nomail" if someone is subscribe (I am subscribed with two E-Mails an get ALL messages twice) but I need it to write from different locations or preventing to get messages bounced, because a worm hit my linux4michelle Mailbox (currently I get over 14.000 Spams and Viruses per day) which has only

[GENERAL] This is a Reply to the message "Re: Majordomo drops multi-line Subject:" and I produce a Subject lomger then 80 characters and since the OP is using mutt like me, whats going on here?

Hello, the OP is using mutt like me and I have never seen mutt, breaking the Subject in multiple lines. If I send mails, with such subjects, the are always bandworms... Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux

Re: [GENERAL] Tsearch2 & Hebrew

to search my whole Database... but for tsearch2 I think, I am looking for a PHP5/PGSQL coder on since I am not the master of PHP5 and PGSQL. (I am more Sysadmin and soldier then programmer even if I can code stuff) Greetings Michelle Konzack Systemadministrator Tamay Dogan Network

Re: [GENERAL] Tsearch2 & Hebrew

per day) in over 60 languages and can not search in arabic, farsi and hebrew. It seems, that there is NO solution for those three languages Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Co

Re: [GENERAL] User can not more login

Am 2006-08-14 16:32:08, schrieb Chris: > --password asks for YOUR password not the new one. SCHEISE!!! :-/ Thanks Michelle Konzack -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant ##### Miche

[GENERAL] User can not more login

The used database is psql (PostgreSQL) 7.4.7 contains support for command-line editing Greetings Michelle Konzack -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle

Re: [GENERAL] Long term database archival

f the database size, I have split them up into 10 years... which can easyly backuped as text/plain dump. But now I have problems doing searches with "tsearch2" in over 1000 tables. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Con

[GENERAL] tablespace and backup

3 x 4U for the Binaries (1,8 TB of original documents of any kind). Those three servers plus a very big Sun machine are connected of a CISCO to a SONET Dual STM-4 (since end march). Maybe it is relevant. Thanks Michelle Konzack -- Linux-User #280138 with the Linux Counter, http://counter.li.or

Re: [GENERAL] Urgent !!! Please Help Me

ch). You should install at least to Sarge 3.1 and PostgreSQL 7.4.7-6sarge1. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux C

Re: [GENERAL] Debian Packages For PostgreSQL

lent > spam honeypot. ;-) SPAM? I get no SPAM from this list... :-P IF YOU GET, you use the false OS. > - Tyler Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Coun

Re: [GENERAL] Alternative to knoda, kexi and rekall?

Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #

Re: [GENERAL] Alternative to knoda, kexi and rekall?

Am 2006-01-30 20:04:43, schrieb Peter Eisentraut: > Michelle Konzack wrote: > > Design a Database with OO2? code Functions? > > I'm not sure about what kind of function coding support you have in > mind, but certainly you can design a database with it. Is this lik

Re: [GENERAL] Alternative to knoda, kexi and rekall?

It would be time fo a Debian-Package... I will check it out, and if there is realy no one who has packed it for Debian, I will do it. Oh yes, - I am currently Co-Maintainer for some Packages in Debian. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian

Re: [GENERAL] Alternative to knoda, kexi and rekall?

ase note, that I am System- and Network-Administrator and not Database Designer. But since I have lost my two Employees I must do it myself. Any suggestions for commercial products? (need minimal a tryout version for testing) Greetings Michelle Konzack Systemadministrator Tamay Dog

Re: [GENERAL] Alternative to knoda, kexi and rekall?

Am 2006-01-25 17:01:39, schrieb Martijn van Oosterhout: > On Wed, Jan 25, 2006 at 04:43:18PM +0100, Michelle Konzack wrote: > > Hello, > > > > I am using PostgreSQL since more then 6 years now and for 1 1/2 years > > "rekall". Now there is a problem with th

Re: [GENERAL] Alternative to knoda, kexi and rekall?

Am 2006-01-25 16:56:04, schrieb Peter Eisentraut: > Michelle Konzack wrote: > > Does anyone know a Frontend for PostgreSQL which I can use to design > > and admin a very huge Database > > OpenOffice 2? Design a Database with OO2? code Functions? Greetings

[GENERAL] Alternative to knoda, kexi and rekall?

h GUI's exist under Linux! Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant #######

[GENERAL] tsearch2 and "how to use"

st column is in "timeline" and hold around 130 GByte of text/plain data. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ #

[GENERAL] tablespace and pg_dump

each $HOME is a ~/pgsql/ where the tablespace for this $USER is. Now my question: :-) What happen with the tablespace if I make a "pg_dumpall" and restore it on another machine where I have for example only ONE diskspace? Greetings Michelle Konzack Systemadministrator T

Re: [GENERAL] Data loading from a flat file...

Am 2006-01-05 23:04:16, schrieb Angshu Kar: > Also, my data file is showing some ^M chars like > > B1^M C1^M E1 > B2^M C2^M E2 If those ^M are coming from your data file, then you should use dos2unix and the problem is gone Greetings Mich

Re: [GENERAL] "REFERENCES" and UNIQUE

Am 2006-01-04 12:08:30, schrieb Stephan Szabo: > > On Wed, 4 Jan 2006, Michelle Konzack wrote: > > | CREATE TABLE countries ( > > | serno int NOT NULL UNIQUE, > > | isocode varchar(2) NOT NULL UNIQUE, > > | EN text

[GENERAL] "REFERENCES" and UNIQUE

Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian

[GENERAL] create summaries and update a second table?

update in the Main- Table. I am puzzeling arround, how can this be done. Any help welcome Thanks Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917

Re: [GENERAL] Toolkit for creating editable grid

Access 2.0 Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant ##### Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 003

Re: [GENERAL] Toolkit for creating editable grid

138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant ##### Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/F

Re: [GENERAL] 7.4.5 vs 8.0 on Debian/sparc

Hi Tom, Am 2005-12-15 11:29:12, schrieb Tom Lane: > Michelle Konzack <[EMAIL PROTECTED]> writes: > > Now if I chante my php5 scripts on my Webserver to point to the 8.0 > > PostgreSQL I get only connect errors. > > What errors exactly? Without details it's impos

Re: [GENERAL] [EMAIL PROTECTED],65$($k!"NY$N1|MMEp;#Ej9F$N?$BJT

Hello Tom, Am 2005-12-15 11:19:03, schrieb Tom Lane: > Michelle Konzack <[EMAIL PROTECTED]> writes: > > Since some days we become SPAMed. > > > How can this happen, if the list is subscriber only? > > Marc accidentally turned off the subscribers-only filter for a

  1   2   >