[SQL] How can I read display message from a C function

2006-05-04 Thread Fay Du
Hi All:     I would like to put some message in my C function ( myTestFunction). Currently, I want to see time for each function call inside myTestFunction. The output to the screen commands are in myTestFunction. myTestFunction is called from postgresql. How can I see the messages? Thanks

[SQL] Connecting to Postgres from other machines (outside localhost)

2006-05-04 Thread Catalin Pitis
Hello   I installed PostgreSQL 8.0 on Windows and I can connect from localhost only. How can I configure the server to allow connection from other machines?   Thank you Catalin

Re: [SQL] Connecting to Postgres from other machines (outside localhost)

2006-05-04 Thread Oisin Glynn
Catalin Pitis wrote: Hello I installed PostgreSQL 8.0 on Windows and I can connect from localhost only. How can I configure the server to allow connection from other machines? Thank you Catalin Under Start-> Programs->PostgreSQLXX->Configuration files postgresql.conf pg_hba.conf Are the

[SQL] audit table containing Select statements submitted

2006-05-04 Thread Hogan, James F. Jr.
No response from the pgsql-admin list so I though I would try cross posting here: pgsql-sql@postgresql.org pgsql-general@postgresql.org I just know I am not the first to try and do this Jim * Can anyone point me in a direction that may help me populate in real time a table

Re: [SQL] audit table containing Select statements submitted

2006-05-04 Thread Ben K.
Current_user Timestamp "The Select Statement Submitted by the User" http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html#PLPGSQL-TRIGGER-AUDIT-EXAMPLE might be close to what you want. Regards, Ben K. Developer http://benix.tamu.edu ---(end of broadcast)

[SQL] is an explicit lock necessary?

2006-05-04 Thread Ash Grove
Hi, Does beginning a transaction put locks on the tables queried within the transaction? In the example below, is #2 necessary? My thought was that I would need to use an explicit lock to make sure that the sequence value I'm selecting in #4 is the same one that is generated from #3. I'm worried

Re: [SQL] is an explicit lock necessary?

2006-05-04 Thread Andrew Sullivan
On Thu, May 04, 2006 at 11:10:56AM -0700, Ash Grove wrote: > Hi, > > Does beginning a transaction put locks on the tables > queried within the transaction? You mean like a table lock? No. A transaction does entail some locks: for instance, an access exclusive lock will block behind your share l

Re: [SQL] is an explicit lock necessary?

2006-05-04 Thread Stephan Szabo
On Thu, 4 May 2006, Ash Grove wrote: > Hi, > > Does beginning a transaction put locks on the tables > queried within the transaction? > > In the example below, is #2 necessary? My thought was > that I would need to use an explicit lock to make sure > that the sequence value I'm selecting in #4 is

Re: [SQL] is an explicit lock necessary?

2006-05-04 Thread Ragnar
On fim, 2006-05-04 at 11:10 -0700, Ash Grove wrote: > Hi, > > Does beginning a transaction put locks on the tables > queried within the transaction? > > In the example below, is #2 necessary? My thought was > that I would need to use an explicit lock to make sure > that the sequence value I'm sel

Re: [SQL] Connecting to Postgres from other machines (outside localhost)

2006-05-04 Thread Catalin Pitis
After I've changed the pg_hba.conf, I got the following error when connecting (from log file)   2006-05-04 21:57:26 LOG:  invalid entry in file "C:/Program Files/PostgreSQL/8.0/data/pg_hba.conf" at line 68, token "192.168.0.1/192"2006-05-04 21:57:26 FATAL:  missing or erroneous pg_hba.conf file 200

Re: [SQL] Connecting to Postgres from other machines (outside localhost)

2006-05-04 Thread Catalin Pitis
Ok, I found it, it was my mistake.   An IP entry should be have /32 or /128. I used different values. Now I got it (RTFM).   Regards, Catalin  On 5/4/06, Oisin Glynn <[EMAIL PROTECTED]> wrote: Catalin Pitis wrote:> I did all you said:>> I set pg_hba.conf:>> # IPv4 local connections: > hostall