[GENERAL] Wanted: Trick for granting permissions to users with hyphens

s and best regards Herbie -- ~~~~~~~~ Herbert Liechti http://www.thinx.ch The content management company. Visit http://www.contentx.ch ---

Re: [GENERAL] Storing a chain

Am Mittwoch, 19. November 2003 16.08 schrieben Sie: > Hi, > I'm seeking some opinion on the following problem May be this article is interesting for you: http://www.dbmsmag.com/9603d06.html Best regards Herbie -- ~~~~~

Re: [GENERAL] Lock rekord

from the user program. If the timestamp has changed in the meantime the record was updated from someone else and the transaction will be rejected. Regards Herbie -- ~~~~~~~~~~~~ Herbert Liechti E-Mail: [EMAIL PROTECTED] Th

Re: [GENERAL] Lock rekord

e method I suggested is a way to keep the locking times as short as possible. > > > It's ok. I do the same. > 1. Update lock field for marked to transaction (everyone else need to know It > is locked) And what happens if a user is closing his browser i.e. in a web applicati

Re: [GENERAL] How to dump from Postgre

Thomas Lockhart wrote: > > Yeah, it just vanished. Not my fault. The bitbucket ate it. And what is a bitbucket? My dictioniary knows nothing about this word. Just for all the people who's mother tongue is not english. :-) - Herbie

Re: [GENERAL] Web front-end

mentation and sample database by mail. Greetings Herbie -- ~~~~~~~~ Herbert Liechti E-Mail: [EMAIL PROTECTED] ThinX networked business servicesStahlrain 10, CH-5200 Brugg

Re: [GENERAL] How I can undelete recodes?

:( see http://www.rocksoft.com/taobackup/ my heartfelt sympathy! -- ~~~~~~~~~~~~ Herbert Liechti E-Mail: [EMAIL PROTECTED] ThinX networked business servicesStahlrain 10, CH-5200 Brugg

Re: [GENERAL] postgres perl DBI

. Try the same with the postgres user. I usually do only the make install step as root. Regards Herbie -- Herbert Liechti E-Mail: [EMAIL PROTECTED] ThinX networked business servicesStahlrain 10, CH-5200 Brugg

Re: [GENERAL] prefer (+) oracle notation

Tom Lane wrote: > > "Edmar Wiggers" <[EMAIL PROTECTED]> writes: > > I'm not sure about the standard, but I really like Oracle's notation for > > foreign keys: > > > select a.item_number, b.group_code_description > > from items a, group_codes b > > where a.group_code = b.group_c

Re: [GENERAL] 6.4.2 and 6.5 date usertype difference

You will find in the section Date/Time Types an explanation how to use the variable or sql statement. Greetings Herbie -- ~~~~~~~~~~~ Herbert LiechtiE-Mail: [EMAIL PROTECTED] ThinX networked business services Stahlrain 10, CH-5200 Brugg ~~~

[GENERAL] urgent: problems with query_limit

s wrong here? Herbie -- ~~~~~~~~~~~ Herbert LiechtiE-Mail: [EMAIL PROTECTED] ThinX networked business services Stahlrain 10, CH-5200 Brugg ~~~

Re: [GENERAL] User not in pg_shadow

nnection to database 'templete1' failed > FATAL 1: SetUserId: user 'dckinder' is not in 'pg_shadow'. > > How do I get dckinder to be in 'pg_shadow'? Use the program createuser as user postgres. Type man createuser for explanation

[GENERAL] error while vacuuming

ROR: Index pg_temp.3920.1 is not a btree Any hints? Is it possible that the creation of temporary tables with indexes clashes vacuum? Thanks Herbie -- ~~~ Herbert LiechtiE-Mail: [EMAIL PROTECTED] Th

Re: [GENERAL] next steps

We are planning to license the framework under GPL. The framework should be available on our website in the end of november and hopefully in the CPAN archive. Greetings Herbie -- ~~~~~~~ Herbert LiechtiE

[GENERAL] sql question

the solution? Thanks -- ~~~~~~~ Herbert LiechtiE-Mail: [EMAIL PROTECTED] ThinX networked business services Stahlrain 10, CH-5200 Brugg ~~~

Re: [GENERAL] sql question

ly those adresses which belongs to adressgroup 6 and do not count to any other group. That's way I tried the statement with the Exists clause. Greetings Herbie -- ~~~ Herbert LiechtiE-Mail: [EMAIL PROTECTED] ThinX networked business services Stahlrain 10, CH-5200 Brugg ~~~

Re: [GENERAL] PostgreSQL 6.5.3 on SuSE 6.1

PGDATA Greetings Herbie -- ~~~~~~~~ Herbert Liechti E-Mail: [EMAIL PROTECTED] ThinX networked business servicesStahlrain 10, CH-5200 Brugg

Re: [GENERAL] null and =

You will get a desaster ;-) Herbie -- ~~~~~~~~~~~~ Herbert Liechti E-Mail: [EMAIL PROTECTED] ThinX networked business servicesStahlrain 10, CH-5200 Brugg

Re: [GENERAL] Empty String Field

; > Mit freundlichen Grüßen / Best regards Auch einen Gruss /Greetings Herbie -- ~~~~~~~~~~~~ Herbert Liechti E-Mail: [EMAIL PROTECTED] ThinX networked business servicesStahlrain 10, CH-5200 Brugg

Re: [GENERAL] Accelerating subqueries

e the EXISTS Clause instead. Regards Herbie -- ~~~~~~~~ Herbert Liechti E-Mail: [EMAIL PROTECTED] ThinX networked business servicesStahlrain 10, CH-5200 Brugg

Re: [GENERAL] postgresql and perl?

not doing it this way: my @fields = qw/name zip location/; push @fields, $sort_selection; $sqh = $dbh->prepare( "SELECT " . join(', ', @fields) . " FROM company ORDER BY $sort_selction; ); $sqh->execute(); Greetings Herbie -- ~~~~~~~~~~