Обсуждение: "select * from groupes" didn't display any data
I executed the script inst/creer-base, the script run, because when I did : $ psql auth auth=# \dt List of relations Schema | name | Type | Owner ------------------------------------------------- public | config | table | postgres public | groupes | table | postgres public | membres | table | postgres public | utilisateurs | table | postgres auth=# \q But, when I executed the script inst/init-base, that script didn't run, as you can see : $ psql auth auth=# \encoding latin9 auth=# select * from groupes auth=# "select * from groupes" didn't display any data. Can you help me. I work under Mandrake Thanks -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm
"lise chhay" <lise.chhay@mail.com> writes: > $ psql auth > auth=# \encoding latin9 > auth=# select * from groupes > auth=# > "select * from groupes" didn't display any data. I think you forgot to type a semicolon? regards, tom lane
I need an informed opinion: The performance boost from clustering is wonderful. But, some tables would have to clustered several times a day, since there is usually some type of "status" column that is updated pretty regularly. Clustering is an expensive operation. If I pulled out that column into another "child" table and linked the tables by a foreign key to the "parent" I could update the "child" table and it wouldn't foul up the master table's ordering at all. Create a view on the two tables, and I'd have a relatively-stable setup as far as ordering goes, yes? Is this adviseable? In the long-run, will it yield the results that I expect? Did I miss any details? Should I be looking for any pitfalls? CG __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/
lise chhay wrote: >I executed the script inst/creer-base, the script run, because when I did : >$ psql auth >auth=# \dt >List of relations >Schema | name | Type | Owner >------------------------------------------------- >public | config | table | postgres >public | groupes | table | postgres >public | membres | table | postgres >public | utilisateurs | table | postgres > >auth=# \q > >But, when I executed the script inst/init-base, that script didn't run, as you can see : >$ psql auth >auth=# \encoding latin9 >auth=# select * from groupes >auth=# > >"select * from groupes" didn't display any data. Can you help me. I work under Mandrake > >Thanks > > I think you forgot the closing semicolon. Try: Select * from groupes; It didn't know you were done typing. -- ------------------------------------------------------------------------- Naomi Walker Chief Information Officer Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100 ------------------------------------------------------------------------- Thought is the blossom; language the bud; action the fruit behind it. - Ralph Waldo Emerson ------------------------------------------------------------------------- -- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain informationthat is privileged, confidential and exempt from disclosure under applicable law. If you are not the intendedaddressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy,disclose or distribute to anyone the message or any information contained in the message. If you have received thismessage in error, please immediately advise the sender by reply email, and delete the message. Thank you.