thank you for answer and excuse me for later
this is query plan:
QUERY PLAN
---
Nested Loop (co
Since some days i've been working on a "blocking period" trigger.
Before customer's login data will be checked, the system should be
look, if there's set a timetook-FIELD(TIMESTAMP) in the future. Then,
login trial will be denied!
Besides, if login fails due to wrong login data, a
loginattempts-FIE
On Mon, 3 May 2004, H.J. Sanders wrote:
>
> Hello list.
>
>
> I have difficulties starting the postmaster automatically at boot time
> (everything I tried is done by 'root').
>
> Can someone give me an example for LINUX (SUSE 8).
Just FYI, this probably belongs on admin, but no biggie.
I sta
hello,
I am porting an Oracle stored procedure to plpgsql (pg 7.4.1) that has about
ten ref cursor OUT parameters, a varchar OUT parameter and returns an
integer. The varchar is an error/status message, the integer is a 1/0 for
success/failure.
What are your thoughts on the best way to appro
H.J. Sanders wrote:
> I have difficulties starting the postmaster automatically at boot
> time (everything I tried is done by 'root').
>
> Can someone give me an example for LINUX (SUSE 8).
Maybe you would rather want to download the binary packages, which take
care of that. RPMs for SuSE are av
Hello list.
I have difficulties starting the postmaster automatically at boot time
(everything I tried is done by 'root').
Can someone give me an example for LINUX (SUSE 8).
Many thanks.
Henk Sanders
---(end of broadcast)---
TIP 8: explain an
Peter Eisentraut wrote:
Pallav Kalva wrote:
I tried both database privileges and table privileges (all and
select) it still doesnt work. Not sure
what is wrong here, I tried logging in as both postgres and usps user
and both them doesnt work.
What about all those groups that have privile
Pallav Kalva wrote:
> I tried both database privileges and table privileges (all and
> select) it still doesnt work. Not sure
> what is wrong here, I tried logging in as both postgres and usps user
> and both them doesnt work.
What about all those groups that have privileges? Please post the
usps=# revoke all on database usps from public,test;
You seem to think that that translates to revoking all privileges to
objects within the database. It doesn't. It only revokes privileges
directly associated with the database object, which are the rights to
create new schemas and temp tab
Pallav Kalva <[EMAIL PROTECTED]> writes:
> I did the same, still doesnt work . Here is the sequence of what I did .
> usps=# revoke all on database usps from public,test;
You seem to think that that translates to revoking all privileges to
objects within the database. It doesn't. It only revoke
Autre variante
psql nom_base -c '\d nom_table' > nom_fichier
Arne
On Mon, 3 May 2004, Paul Thomas wrote:
>
> On 03/05/2004 12:49 Eric Anderson Vianet SAO wrote:
> > How could I record the ´ \d table ´ command to a file?
>
> \o file
>
---(end of broadcast)--
Peter Eisentraut wrote:
Pallav Kalva wrote:
Also here is the privileges information from information_schema
tables. Is there a way to REVOKE these
privileges ?
You need to log in as the user that has granted the privilege you want
to revoke. In this case, log in as postgres and do REVOKE
On 03/05/2004 12:49 Eric Anderson Vianet SAO wrote:
How could I record the ´ \d table ´ command to a file?
\o file
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
Business |
|
Eric Anderson Vianet SAO wrote:
How could I record the ´ \d table ´ command to a file?
echo '\d' | psql rnd > outputfile
--
Until later, Geoffrey Registered Linux User #108567
Building secure systems in spite of Microsoft
---(end of broadcast)
How could I record the ´ \d table ´ command to a file?
sds
Eric Anderson
CPD Via Net SAO
11-66432800
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
15 matches
Mail list logo
