I have been using strictly TRUST access through hba up to now because
all my SQL boxes have been inside of firewalled systems. However, now I
need to allow access to a postgreSQL box that is on the Internet. This
box needs to grant access to two Linux boxes and one Windows computer
that have dy
At 17:31 +0300 on 06/09/1999, Natalya S. Makushina wrote:
>
> I can put the part of query outside the parentheses.
...
> But if i increased number of "OR" in query, the server was down and
>worked very,very slowly. I can't see any rezult from optimizer.
> It's very strange thing!
The postgres o
Hi!
Thanks for help.
I can put the part of query outside the parentheses.
There two results from explain ( after vacuum).
Result from my query in original form:
NOTICE: QUERY PLAN
Unique (cost=129.36 size=0 width=0)
-> Sort (cost=129.36 size=0 width=0)
-> Nested Loop (cost=129
At 11:56 +0300 on 05/09/1999, Alois Maier wrote:
>I know that I can set the transaction level with the SET TRANSACTION
>LEVEL statement. How can I get the transaction level from SQL ?
Normally, the counterpart of SET is SHOW. Did you try SHOW TRANSACTION LEVEL?
Herouth
--
Herouth Maoz, Intern
At 11:45 +0300 on 02/09/1999, Natalya S. Makushina wrote:
> where CLIENTS.CLIENTID=SOTRUD.CLIENTID and
> ( CLIENTS.PRINADL=PRINADLEG.PRINADL and CLIENTS.FLG_MY and (NOT
>CLIENTS.ARH) and lower(SOTRUD.EMAIL) LIKE lower('[EMAIL PROTECTED]%')
> OR CLIENTS.PRINADL=PRINADLEG.PRINADL and CLIENTS.FLG
Is there a way to get the error number instead of error message in
lippq or libpq++ ??
is PQerrorMessage(conn) the only funtion to know wich type of error
appear ?
--
+--+
| Marzullo Laurent |
| Analyste-programmeur |
| SEMA-GROUP B
