July 2004 - openSUSE Programming - openSUSE Mailing Lists

altering a table to set serial function
by Prabu Subroto 27 Jul '04

27 Jul '04

Dear my friends... I am using postgres 7.4 and SuSE 9.1. I want to use auto_increment as on MySQL. I look up the documentation on www.postgres.com and I found "serial" . But I don't know how to create auto_increment. here is my try: " kv=# alter table sales alter column salesid int4 serial; ERROR: syntax error at or near "int4" at character 40 " Please tell me the correct command to that. Thank you very much in advance. __________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail

1 0

RE: [suse-programming-e] selecting more that 2 tables based on 1 subquery find an error (revision)
by Wenzel, Scott 26 Jul '04

26 Jul '04

You are actually talking about 3 tables. You must link the first 2 tables. I am assuming you have custid as a field on description table. If you have a large number of rows, make sure you properly tune your database. I am assuming this is a small number of rows for learning. I am reformatting your query. It should go something like this.... select c.custid, cd.description, c.company, c.title, c.salutation, c.firstname, c.lastname, c.address, c.postcode, c.city, c.areacode, c.phone, c.mobilephone, c.fax, c.email from customer as c, customerdescription as cd where c.custid = cd.cust_id and c.custid in (select custid from sven1); Hope this helps.. -Scott -----Original Message----- From: Prabu Subroto [mailto:prabu_subroto@yahoo.com] Sent: Monday, July 26, 2004 7:41 AM To: suse-programming-e(a)suse.com Subject: [suse-programming-e] selecting more that 2 tables based on 1 subquery find an error (revision) Dear my friends... I am using SuSE 9.1 and postgres. I want to "select" query 2 tables. one is "customer" and one is "customer.description" but the customer records that I want to "select" are only what in subquery result. Here what I've done: postgres@patrix:~> psql kv Welcome to psql 7.4.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit kv=# select c.custid, cd.description, c.company, c.title, c.salutation, c.firstname, c.lastname, c.address, c.postcode, c.city, c.areacode, c.phone, c.mobilephone, c.fax, c.email from customer as c, customerdescription as cd where c.custid in (select custid from sven1); Terminated postgres@patrix:~> Anybody could give me any solution? Thank you very much in advance. __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail -- To unsubscribe, email: suse-programming-e-unsubscribe(a)suse.com For additional commands, email: suse-programming-e-help(a)suse.com Archives can be found at: http://lists.suse.com/archive/suse-programming-e

3 2

selecting more that 2 tables based on 1 subquery find an error (revision)
by Prabu Subroto 26 Jul '04

26 Jul '04

Dear my friends... I am using SuSE 9.1 and postgres. I want to "select" query 2 tables. one is "customer" and one is "customer.description" but the customer records that I want to "select" are only what in subquery result. Here what I've done: postgres@patrix:~> psql kv Welcome to psql 7.4.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit kv=# select c.custid, cd.description, c.company, c.title, c.salutation, c.firstname, c.lastname, c.address, c.postcode, c.city, c.areacode, c.phone, c.mobilephone, c.fax, c.email from customer as c, customerdescription as cd where c.custid in (select custid from sven1); Terminated postgres@patrix:~> Anybody could give me any solution? Thank you very much in advance. __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail

1 0

selecting more that 2 tables based on 1 subquery find an error
by Prabu Subroto 26 Jul '04

26 Jul '04

Dear my friends... I am using SuSE 9.1 and postgres. I want to "select" query 2 tables. one is "customer" and one is "customer.description" but the customer records that I want to "select" are only what in subquery result. Here what I've done: postgres@patrix:~> psql kv Welcome to psql 7.4.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit kv=# select c.custid, cd.description, c.company, c.title, c.salutation, c.firstname, c.lastname, c.address, c.postcode, c.city, c.areacode, c.phone, c.mobilephone, c.fax, c.email from customer as c, customerdescription as cd where c.custid in (select custid from sven1); Terminated postgres@patrix:~> Anybody could give me any solution? Thank you very much in advance. __________________________________ Do you Yahoo!? Y! Messenger - Communicate in real time. Download now. http://messenger.yahoo.com

1 0

selecting more that 2 tables based on 1 subquery find an error
by Prabu Subroto 26 Jul '04

26 Jul '04

Dear my friends... I want to "select" query 2 tables. one is "customer" and one is "customer.description" but the customer records that I want to "select" are only what in subquery result. Here what I've done: " postgres@patrix:~> select c.custid, cd.description, c.company, c.title, c.salutation, c.firstname, c.lastname, c.address, c.postcode, c.city, c.areacode, c.phone, c.mobilephone, c.fax, c.email from customer as c, customerdescription as cd where c.custid in (select custid from sven1); bash: syntax error near unexpected token `cd.description,' postgres@patrix:~> " Anybody could give me any solution? Thank you very much in advance. __________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo

1 0

YaST modules and KDE control center
by Dominic Reynolds 23 Jul '04

23 Jul '04

I have created a YaST group for a series of icons that perform related tasks. I created a group file and in YaST the group displays properly and the icons are logically contained within the group. However running kcontrol allows access to "YaST2 Modules" which does not include the newly created group but does include the individual application icons (although displayed at the top level). Is there another configuration to define the YaST2 Module groups for KDE Control Center other than: "/usr/share/applications/YaST2/groups/" Thanks, Dominic

1 0

Problems with large executables under SuSE 8.2 ....
by William A. Mahaffey III 23 Jul '04

23 Jul '04

.... I have a large, FORTRAN 77 program which I maintain for use by government clients (NASA mostly). I just (today) updates the box it is on from RH7.2 to SuSE 8.2, kernel 2.4.20-4GB. When I compile up an executable that wants about 1.3 GB of RAM, it gets killed by the kernel as soon as it starts running (signal 11, segfault). I attach some relevant particulars. I compiled under the Intel FORTRAN compiler, version 8.0.46. I upgraded primarily to get > 1 GB address space, & I don't seem to be getting it. What am I doing wrong ? Thanks in advance.

1 0

Re: Qt-Designer by Trolltech
by Prabu Subroto 23 Jul '04

23 Jul '04

Du meinst vielleicht so: " qmake -project qmake make "? oder kannst du auch so machen: qmake -o <<myfile>> ./<<myfile.pro>> make --- Jan Hendrik Berlin <tux007(a)ita-hbu.de> wrote: > Hallo! > > Ich versuche gerade mit dem Qt-Designer > klarzukommen, der bei SuSE 9.1 dabei > ist! Also Version 3.3.1! > Also so einiges ist ja dem CBuilder von Borland sehr > �nlich! Aber, ich finde > das kn�fchen zum compilieren nicht! Wie bersetzte > ich denn nun mein Werk? > Der Rest erscheint mir eigentlich recht einfach! > > mfg > Jan > > -- > Um die Liste abzubestellen, schicken Sie eine Mail > an: > suse-programming-unsubscribe(a)suse.com > Um eine Liste aller verfgbaren Kommandos zu > bekommen, schicken > Sie eine Mail an: suse-programming-help(a)suse.com > > __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail

1 0

RE: [suse-programming-e] populating (insert into...) a table with determined record from another table.
by Wenzel, Scott 23 Jul '04

23 Jul '04

Sorry, Take out the word "values" -----Original Message----- From: Prabu Subroto [mailto:prabu_subroto@yahoo.com] Sent: Thursday, July 22, 2004 9:45 AM To: suse-programming-e(a)suse.com Subject: RE: [suse-programming-e] populating (insert into...) a table with determined record from another table. Dear my friend, Scott... No, it does not work. Here is my try: kv=# insert into sven1 (custid, noapp) values (select custid, noapp from appointment where done='N' and salesid='6'); ERROR: syntax error at or near "select" at character 43 kv=# Please keep telling. Thank you very much in advance. --- "Wenzel, Scott" <scott_wenzel(a)BUDCO.com> wrote: > insert into sven1 (custid,nnoapp) values > (select custid,noapp from appointment > where done = 'N' > and salesid = '6') > > This will work if there are no other constraints on > any of > the other remaining fields in sven1 > > -----Original Message----- > From: Prabu Subroto [mailto:prabu_subroto@yahoo.com] > Sent: Thursday, July 22, 2004 9:24 AM > To: suse-programming-e(a)suse.com > Subject: [suse-programming-e] populating (insert > into...) a table with > determined record from another table. > > > Dear my friends... > > I am using postgres and SuSE 9.1 . > > I created a table (named : sven1). I want to > populate > this table with the record from another table (named > : > appoinment). > but I don't know how to formulate the sql query. > > I tried this one: > insert into sven1 (custid, noapp) values ((select > custid from appointment where done='N' and > salesid='6'), (select noapp from appointment where > done='N' and salesid='6')); > > But I got this error in my psql console: > kv=# insert into sven1 (custid, noapp) values > ((select > custid from appointment where done='N' and > salesid='6'), (select noapp from appointment where > done='N' and salesid='6')); > ERROR: more than one row returned by a subquery > used > as an expression > kv=# > > Anybody would be so nice to help me solving this > problem? > > Thank you very much in advance. > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail Address AutoComplete - You start. We > finish. > http://promotions.yahoo.com/new_mail > > -- > To unsubscribe, email: > suse-programming-e-unsubscribe(a)suse.com > For additional commands, email: > suse-programming-e-help(a)suse.com > Archives can be found at: > http://lists.suse.com/archive/suse-programming-e > > -- > To unsubscribe, email: > suse-programming-e-unsubscribe(a)suse.com > For additional commands, email: > suse-programming-e-help(a)suse.com > Archives can be found at: > http://lists.suse.com/archive/suse-programming-e > > __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/ -- To unsubscribe, email: suse-programming-e-unsubscribe(a)suse.com For additional commands, email: suse-programming-e-help(a)suse.com Archives can be found at: http://lists.suse.com/archive/suse-programming-e

2 2

RE: [suse-programming-e] populating (insert into...) a table with determined record from another table.
by Wenzel, Scott 23 Jul '04

23 Jul '04

insert into sven1 (custid,nnoapp) values (select custid,noapp from appointment where done = 'N' and salesid = '6') This will work if there are no other constraints on any of the other remaining fields in sven1 -----Original Message----- From: Prabu Subroto [mailto:prabu_subroto@yahoo.com] Sent: Thursday, July 22, 2004 9:24 AM To: suse-programming-e(a)suse.com Subject: [suse-programming-e] populating (insert into...) a table with determined record from another table. Dear my friends... I am using postgres and SuSE 9.1 . I created a table (named : sven1). I want to populate this table with the record from another table (named : appoinment). but I don't know how to formulate the sql query. I tried this one: insert into sven1 (custid, noapp) values ((select custid from appointment where done='N' and salesid='6'), (select noapp from appointment where done='N' and salesid='6')); But I got this error in my psql console: kv=# insert into sven1 (custid, noapp) values ((select custid from appointment where done='N' and salesid='6'), (select noapp from appointment where done='N' and salesid='6')); ERROR: more than one row returned by a subquery used as an expression kv=# Anybody would be so nice to help me solving this problem? Thank you very much in advance. __________________________________ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- To unsubscribe, email: suse-programming-e-unsubscribe(a)suse.com For additional commands, email: suse-programming-e-help(a)suse.com Archives can be found at: http://lists.suse.com/archive/suse-programming-e

3 3