SV: [GENERAL] Unanswered questions about Postgre

Hi, ... > > > That is what transactions are for. If any errors occur, then the > > > transacction is aborted. You are supposed to use transactions when you want > > > either everything to occur (the whole transaction), or nothing, if an > > > error occurs. And thats wrong! The caller should hav

SV: [GENERAL] Table whose name has Capital letters

Hi, ... > I have created a table with the name 'Nov2000' and now it is impossible to > access it, because psql is always searching for the table 'nov2000'. Put the table name inside quotes. ie: SELECT FROM "Nov2000" _not_ SELECT FROM Nov2000 ... > Have I done something wrong or is it a bug ? I

SV: [GENERAL] PG and login

Thanks, I had allready played around with those files with elog(DEBUG,...), but elog(...) did never do any output. But when you confirmed that those were the files, Ive used fprintf(stderr,...) instead and it worked. Why does not elog(DEBUG,...) work everywhere? Well who cares, _NOW_ when I kno

[GENERAL] default timestamp and default autoinc

Hi, Does pg have "default timestamp" and "default autoinc" as default values (used in CREATE TABLE). And where is the PostgreSQL reference guide. Or actually/maybe how do I make html files of the sgml files that are included with the CVS tree (what do I need, jade? and where do I get it?)? // J

[GENERAL] PG and login

Hi, Where does the backend do its user validation? If I login with "psql -u" how does the backend take care of the username and password? Ive tried to find where it happens without success (using a lot of elog(DEBUG,...)). (we are talking "password" identification, not "ident", kerberos or "cry

SV: [GENERAL] Postmaster startup problems

... > I'm having problems starting postgres.What happens is > that I start it but then it says it isn't running. ... > DEBUG:Data Base System is starting up at Sat Oct 7 13:13:29 2000 > DEBUG:Data Base System was shut down at Sat Oct 7 13:13:25 2000 > DEBUG:Data

[GENERAL] CREATE USER and ODBC

Hi, Sorry if this has allready been sent, but Ive not received it from the list. I seem not to able to create a user through ODBC (through MFC classes). What I use is "CDatabase::ExecuteSQL( "CREATE USER jarmo WITH PASSWORD 'myPass'" );" PostgreSQL complains that it can not create users inside

[GENERAL] Updating cursors

Hi, Ive a SELECT cursor which I want to update/delete but postgresql does not support these: UPDATE myTable SET myColumn = 'myValue' WHERE CURRENT OF myCursor DELETE myTable WHERE CURRENT OF myCursor Does there exist any workaround? Or is my syntax wrong? One workaround would be to get the row