[GENERAL] Getting user who fired a trigger

2004-07-07 Thread Anton Nikiforov
Dear All, I have made a trigger procedure that logs all table's changes to the log_table in XML format, but i do need to log a user who did that and not succsessful with this. The documentation (including "37.10. Trigger Procedures") give me nothing. Could somene supply me with a solution or docu

Re: [GENERAL] Grant Select privileges for all tables in schema

2004-07-07 Thread Bruno Wolff III
On Tue, Jul 06, 2004 at 15:44:01 -0700, [EMAIL PROTECTED] wrote: > Hi there, > > I am using Postgresql 7.3 and I want to grant select rights to a user on all tables > in a schema, including those that may be created in the future but whose names are > not yet known. I want to do something lik

Re: [GENERAL] Error in postgreSQL

2004-07-07 Thread Franco Bruno Borghesi
you should check the logs, when postmaster dies right after starting it always leaves a helpfull message there. On Wed, 2004-07-07 at 10:09, José Augusto Tovar wrote: Hi all, I´m using postgreSQL in WinME and i had a very strange problem. When i start the postgres the process postmaster sta

[GENERAL] Help with query: indexes on timestamps

2004-07-07 Thread Keith C. Perry
Ok, I've tried a number of things here and I know I'm missing something but at this point my head is spinning (i.e. lack of sleep, too much coffee, etc...) My environment is PG 7.4.3 on Linux with 512Mb of ram and swap. This was just upgraded from 7.4 (just to make sure I'm current). Some of my

Re: [GENERAL] Help with query: indexes on timestamps

2004-07-07 Thread Richard Huxton
Keith C. Perry wrote: I have a table with with 1 million records in it. Here is the definition CREATE TABLE report ( match int4, action varchar(16), stamp timestamptz, account varchar(32), ipaddress inet, profile varchar(16), rating text, url text ) WITHOUT OIDS; The is one index

[GENERAL] Why do subselects in target lists behave differently wrt implicit casts?

2004-07-07 Thread Mike Mascari
This is a really trivial question, but I'm curious. Why do subselects in target lists behave differently than simple queries? Ex: [lexus] create temporary table bar (key varchar(32) not null); CREATE TABLE [lexus] insert into bar select ''; INSERT 1319585 1 [lexus] insert into bar select (select

Re: [GENERAL] Getting user who fired a trigger

2004-07-07 Thread Richard Huxton
Anton Nikiforov wrote: Dear All, I have made a trigger procedure that logs all table's changes to the log_table in XML format, but i do need to log a user who did that and not succsessful with this. The documentation (including "37.10. Trigger Procedures") give me nothing. Could somene supply me

Re: [GENERAL] Getting user who fired a trigger

2004-07-07 Thread Anton Nikiforov
Thanks for the replay, Richard. Richard Huxton wrote: Anton Nikiforov wrote: Dear All, I have made a trigger procedure that logs all table's changes to the log_table in XML format, but i do need to log a user who did that and not succsessful with this. The documentation (including "37.10. Trigger

Re: [GENERAL] Help with query: indexes on timestamps

2004-07-07 Thread Keith C. Perry
Quoting Richard Huxton <[EMAIL PROTECTED]>: > Keith C. Perry wrote: > > > > I have a table with with 1 million records in it. Here is the definition > > > > CREATE TABLE report > > ( > > match int4, > > action varchar(16), > > stamp timestamptz, > > account varchar(32), > > ipaddress

[GENERAL] (no subject)

2004-07-07 Thread Doseok Kim
digest-status LISTNAME ---(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: [GENERAL] Getting user who fired a trigger

2004-07-07 Thread Richard Huxton
Anton Nikiforov wrote: Could somene supply me with a solution or documentation part that i should read? Can't remember which part it is, but you want one of: SELECT CURRENT_USER; SELECT SESSION_USER; test=# SELECT CURRENT_USER; current_user -- anton (1 row) test=# SELECT SESSION

[GENERAL] (no subject)

2004-07-07 Thread Doseok Kim
set pgsql-general digest ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] postgresql +AMD64 +big address spaces - does it work?

2004-07-07 Thread Andy B
Ok - just to end this thread, I think I understand what I was missing. I'll stop this thread, and just comment on my first thread. Thank you everyone who helped ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an inde

Re: [GENERAL] Enough RAM for entire Database.. cost aside, is this

2004-07-07 Thread Andy B
> There's a good bit of depth in the archives of this list. I would start > searching back for discussions of effective_cache_size, as that is involved > in *costing* the caching job that the OS is doing. Thanks - that's just what I need to sink my teeth into. I'll have a trawl and get back later

Re: [GENERAL] Enough RAM for entire Database.. cost aside, is this

2004-07-07 Thread Andy B
Hello Shridhar, Thanks for the reply. > There is no reason why you should not do it. How remains to be a point of > disagreement though. You don't allocate 16GB of shared buffers to postgresql. > That won't give you performance you need. I think in the other thread, Tom was alluding to this too.

Re: [GENERAL] postgresql +AMD64 +big address spaces - does it work?

2004-07-07 Thread Andy B
> I get the feeling that, that regardless 64bit support or not, that the > *concept* of a database which just happens to all easily fit within RAM > isn't one that gets the thumbs down... Oops, I meant to say '*is*' one that gets the thumbs down... ---(end of broadcast)-

Re: [GENERAL] Enough RAM for entire Database.. cost aside, is this

2004-07-07 Thread Andy B
Hello again Mike, Thanks for the replies! Here's my next salvo! > Perhaps I'm a bit naive about complex data structure caching strategies, but > it seems to me that the overhead of tracking tuples (which is what you > would want if you are going to manage your own cache, as opposed to simply > ca

Re: [GENERAL] Enough RAM for entire Database.. cost aside, is this

2004-07-07 Thread Andy B
>If all the data fits into memory, then this cache thrashing won't occur, yes? No - it *can* occur in a 2 tier cache strategy. The critical question here is: *If* the data postgresql needs is in the linux buffer cache, what (if anything) does the OS have to do to make it available to the postmas

Re: [GENERAL] Enough RAM for entire Database.. cost aside, is this

2004-07-07 Thread Andy B
> It's not that making the cache bigger is inefficient, it's that the cache is > not used the way you are thinking. Ok, I think I've got it now. The missing piece of the puzzle was the existence of the Linux buffer cache. So that's what the effective_buffer_cache value is for(!) I read Shridhar

Re: [GENERAL] postgresql +AMD64 +big address spaces - does it work?

2004-07-07 Thread Andy B
Hello again and thanks to everyone for the replies so far. Tom, and all, I hear what you are all saying, and furthermore, in cases where the amount of RAM is much smaller than the database size, I agree totally. However, I'm *only* talking about a particular scenario which, till now, has really on

[GENERAL] FATAL: the database system is in recovery mode

2004-07-07 Thread Ron St-Pierre
We're developing a java app and are using postgres as the database. On our dev server I started the app, closed it, but the java process was still open so I killed it, which caused the above error. I've had to do this in the past but have not had this happen before. I've searched the archives a

[GENERAL] Column name 'user' not allowed?

2004-07-07 Thread Thomas Mueller
Hi, I tried to install phpopenchat but I can't create this table: poc=> CREATE TABLE poc_user_account ( poc(> USER varchar(255) NOT NULL, poc(> PASSWORD varchar(255), poc(> CONFIRM_CODE char(32), poc(> DISABLED int NOT NULL DEFAULT '0', poc(> KICKED int NOT NULL DEFAULT '0', poc(> PAS