Hilary Forbes <[EMAIL PROTECTED]> writes:
> I have an existing table suppliers and I have created a new user
> 'hilary'
> REVOKE ALL on TABLE suppliers FROM hilary;
> now login as hilary
> SELECT * from suppliers;
> and I get all the records!!!
Most likely there's been a grant of (at least) select
> A|B|C
> 1|2|20
> 1|3|10
> 1|4|21
> 2|3|12
> 2|4|22
> 3|4|23
> 1|3|10
> 2|3|12
> 3|4|23
> -select all records where A=1,
> -find, into this selection, the record where there's the minimum value
> of the field C
> -print all the fields for this record.
maybe this will work;
select a,b,c
from ta
- Original Message From: "Kevin Nikiforuk"
xp512-0715-0716=# FOR LV in 1..10 LOOP
It appears that you are trying to use the For .. Loop structure from the
psql command line. This structure is not plain SQL - its meant to be used
within PL/pgSQL. Have you tried incorporating it int
REVOKE ALL on TABLE suppliers FROM hilary;
now login as hilary
SELECT * from suppliers;
and I get all the records!!!
If I create a **new** table though and then do the above, the permissionswork I
get a polite
message telling me "no go". Thissounds to me like a problem with earlier
compatibility
> Sorry if this is in the archives, but I've done a search and couldn't find
> anything relevant.
> I'm running HP's precompiled version of 8.1.3.1 as part of their Internet
> Express offering, and
> I can't seem to run a for loop. Here's what I'm seeing:
> xp512-0715-0716=# FOR LV in 1..10 LOOP
On Thu, 20 Jul 2006, Kevin Nikiforuk wrote:
> Sorry if this is in the archives, but I've done a search and couldn't
> find anything relevant. I'm running HP's precompiled version of 8.1.3.1
> as part of their Internet Express offering, and I can't seem to run a
> for loop. Here's what I'm seeing:
On Thu, 20 Jul 2006, Hilary Forbes wrote:
> Dear All
>
> We are running pg v 7.4.1 and importantly the database has been
> converted from earlier versions of pg (6.5 I seem to recall).
>
> I have an existing table suppliers and I have created a new user 'hilary'
>
> REVOKE ALL on TABLE suppliers F
Dear All
We are running pg v 7.4.1 and importantly the database has been converted
from earlier versions of pg (6.5 I seem to recall).
I have an existing table suppliers and I have created a new user
'hilary'
REVOKE ALL on TABLE suppliers FROM hilary;
now login as hilary
SELECT * from suppliers;
a
Dear users
It's a simple problem I think (and I hope :-)
I have a table like this:
A|B|C
1|2|20
1|3|10
1|4|21
2|3|12
2|4|22
3|4|23
where the first two column are a combination without repetition (with
k=2) of the numbers 1,2,3,4
for each pair I have a value in the column C.
I would want a s
Sorry if this is in the archives, but I've done a search and couldn't find
anything relevant. I'm running HP's precompiled version of 8.1.3.1 as part of
their Internet Express offering, and I can't seem to run a for loop. Here's
what I'm seeing:
xp512-0715-0716=# FOR LV in 1..10 LOOP
xp512-071
Hi Aaron,
I removed them because when I bring the data back into my GUI, the
returns are treated as a record break by the software and I cannot
decrypt them or display the rest of the record that is not encrypted.
Regards
John T
Aaron Bono wrote:
On 7/19/06, *John Tregea* <[EMAIL PROTECTED]
* Florian Weimer:
> In addition, it occurred to me that I get the INSERT failure only if
> there is a suitable PRIMARY KEY/UNIQUE constraint on the table. I
> haven't got that in all cases, so I need that advisory locking anyway,
It seems that LOCK TABLE ... IN EXCLUSIVE MODE does exactly what I
12 matches
Mail list logo
