openSUSE Programming July 2004

programming@lists.opensuse.org

22 participants
30 discussions

by Prabu Subroto

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

17 years, 11 months

RE: [suse-programming-e] selecting more that 2 tables based on 1 subquery find an error (revision)

by Wenzel, Scott

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

17 years, 11 months

selecting more that 2 tables based on 1 subquery find an error (revision)

by Prabu Subroto

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

17 years, 11 months

selecting more that 2 tables based on 1 subquery find an error

by Prabu Subroto

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

17 years, 11 months

selecting more that 2 tables based on 1 subquery find an error

by Prabu Subroto

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

17 years, 11 months

YaST modules and KDE control center

by Dominic Reynolds

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

17 years, 11 months

Problems with large executables under SuSE 8.2 ....

by William A. Mahaffey III

.... 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.

17 years, 11 months

Re: Qt-Designer by Trolltech

by Prabu Subroto

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

17 years, 11 months

RE: [suse-programming-e] populating (insert into...) a table with determined record from another table.

by Wenzel, Scott

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

17 years, 11 months

RE: [suse-programming-e] populating (insert into...) a table with determined record from another table.

by Wenzel, Scott

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

17 years, 11 months

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

openSUSE Programming July 2004