[DOCS] PostgreSQL 7.4 and 8.0 - psql reference
In Part II - PostgreSQL Client Applications, psql -- PostgreSQL interactive terminal (psql-ref.sgml - http://www.postgresql.org/docs/8.0/interactive/app-psql.html) is written: For example, FOO"BAR"BAZ is interpreted as fooBARbaz, and "A weird"" name" becomes A weird" name. So using psql I tried: CREATE TABLE FOO"BAR"BAZ (foo text); and got: ERROR: syntax error at or near ""BAR"" at character 17 AND > CREATE TABLE "A weird"" name" (foo text); CREATE TABLE > \dt ... -+---++-- public | A weird" name | table | postgres So what is happening with FOO"BAR"BAZ? What is really written in the documentation? Thanks, Halley Yahoo! Mail, cada vez melhor: agora com 1GB de espaço grátis! http://mail.yahoo.com.br ---(end of broadcast)--- TIP 8: explain analyze is your friend
[DOCS] Chapter 44. Native Language Support
In Chapter 44. Native Language Support, 44.1.2. Concepts (http://www.postgresql.org/docs/8.0/interactive/nls.html) is written: The extension of the message catalog file is to no surprise either .po or .mo. The base name is either the name of the program it accompanies, or the language the file is for, depending on the situation. This is a bit confusing. Examples are psql.po (PO file for psql) or fr.mo (MO file in French). But when I execute in Fedora Core 3: $ locate psql.po I get no files, and when I execute: $ locate psql.mo I get several files /usr/share/locale/cs/LC_MESSAGES/psql.mo /usr/share/locale/de/LC_MESSAGES/psql.mo /usr/share/locale/es/LC_MESSAGES/psql.mo /usr/share/locale/fr/LC_MESSAGES/psql.mo /usr/share/locale/hu/LC_MESSAGES/psql.mo /usr/share/locale/it/LC_MESSAGES/psql.mo /usr/share/locale/pt_BR/LC_MESSAGES/psql.mo /usr/share/locale/sv/LC_MESSAGES/psql.mo /usr/share/locale/tr/LC_MESSAGES/psql.mo /usr/share/locale/zh_CN/LC_MESSAGES/psql.mo /usr/share/locale/zh_TW/LC_MESSAGES/psql.mo /usr/share/locale/ru/LC_MESSAGES/psql.mo /usr/share/locale/sl/LC_MESSAGES/psql.mo /usr/share/locale/nb/LC_MESSAGES/psql.mo And in psql po directory there is no psql.po $ pwd /tmp/postgresql-8.0.1/src/bin/psql/po $ ls cs.po es.po fr.po it.po nb.popt_BR.po ru.po sl.po tr.po zh_TW.po de.po fa.po hu.po ko.po psql.mo ro.po sk.po sv.po zh_CN.po So this is really a bit confusing, and I think it should be: Examples are psql.mo (MO file for psql) or fr.po (PO file in French). Regards, Halley Yahoo! Mail, cada vez melhor: agora com 1GB de espaço grátis! http://mail.yahoo.com.br ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [DOCS] PostgreSQL 7.4 and 8.0 - psql reference
Halley Pacheco de Oliveira <[EMAIL PROTECTED]> writes: > In Part II - PostgreSQL Client Applications, psql -- PostgreSQL interactive > terminal > (psql-ref.sgml - > http://www.postgresql.org/docs/8.0/interactive/app-psql.html) is written: > For example, FOO"BAR"BAZ is interpreted as fooBARbaz, and "A weird"" name" > becomes A weird" name. Please observe the context in which that statement appears: it is talking about backslash commands only. For the syntax of SQL commands see http://www.postgresql.org/docs/8.0/static/sql-syntax.html regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [DOCS] PostgreSQL 7.4 and 8.0 - psql reference
Ok, now I understand >CREATE TABLE "fooBARbaz" (foo TEXT); CREATE TABLE > \dt ... -+---++-- public | A weird" name | tabela | postgres public | fooBARbaz | tabela | postgres ... > \dt fooBARbaz No relation found > \dt foo"BAR"baz ... -+---++-- public | fooBARbaz | table | postgres (1 row) Thanks, Halley --- Tom Lane <[EMAIL PROTECTED]> escreveu: > Halley Pacheco de Oliveira <[EMAIL PROTECTED]> writes: > > In Part II - PostgreSQL Client Applications, psql -- PostgreSQL > > interactive terminal > > (psql-ref.sgml - > > http://www.postgresql.org/docs/8.0/interactive/app-psql.html) is written: > > > For example, FOO"BAR"BAZ is interpreted as fooBARbaz, and "A weird"" name" > > becomes A weird" > name. > > Please observe the context in which that statement appears: it is > talking about backslash commands only. > > For the syntax of SQL commands see > http://www.postgresql.org/docs/8.0/static/sql-syntax.html > > regards, tom lane > __ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[DOCS] the PDF documentation on postgresql.org
Hello, Can anyone guide me through the exact process of creating PDF documentation used by www.postgresql.org. As some of you might remember I am having problems creating PDF's out of my SGML documentation. I was hoping that the methodology being used by postgresql.org might be a help. Thank you Saquib __ Discover Yahoo! Get on-the-go sports scores, stock quotes, news and more. Check it out! http://discover.yahoo.com/mobile.html ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [DOCS] the PDF documentation on postgresql.org
On Sun, 12 Jun 2005, Saquib Farooq Malik wrote: > Can anyone guide me through the exact process of > creating PDF documentation used by www.postgresql.org. > I built the 7.4 and 8.0 pdfs on postgresql.org. I was able to do so by using the sgml tools available in the old debian stable (Woody). You must use plain jade instead of openjade (which crashes). Trying this on debian unstable took about ten days on an Athlon ~1500, but it did complete. I suspect the problem is related to different stylesheet versions, but I have not actually confirmed this. Kris Jurka ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
