<>How about using phpPgAdmin? Or something like that?
Also, is there a SQL statement that will return all the possible
privileges? Use that in a subselect and then grant WHERE?
Chris Ochs <[EMAIL PROTECTED]> wrote:
Is there a shortcut to grant all privileges on a schema and it's objects to
a use
Ah, that's the information I needed. I already have a "split" version, I just
wanted to know if it was possible to it the other way. You've been very
helpful.
Thanks...
On Thursday 03 June 2004 09:50 am, Martijn van Oosterhout saith:
> On Thu, Jun 03, 2004 at 09:08:40AM -0400, Terry Lee Tucker
Jack Orenstein <[EMAIL PROTECTED]> writes:
> What would be really nice is something like "cluster recent". The idea is to
> cluster only rows added since the last cluster.
And you would put them where?
regards, tom lane
---(end of broadcast)---
On Thu, 3 Jun 2004 09:04:43 +0200, "Nagib Abi Fadel"
<[EMAIL PROTECTED]> wrote:
>Let's say for example the variable is called "X". The view is called
>"t_view" and the temporary table is called "t_temp".
>Each time a user connects to the web, the application will initialize the
>variable X and it w
On Thu, Jun 03, 2004 at 09:08:40AM -0400, Terry Lee Tucker wrote:
> Let me explain:
>
> I have written a "C" function which contains calls to other functions, all of
> which work with an API to a mileage database product called PCMiler. These
> functions make connections to the PCMiler databae,
On Monday 16 February 2004 19:15, Wei Wang wrote:
> I get compile error for this code:
>
>
> for i in 1..arg_count-1 LOOP
> RAISE NOTICE quote_literal(to_char(i, ''9''));
> END LOOP;
>
> where arg_count = 3.
>
> I tried RAISE NOTICE to_char(i, ''9''); as well.
> to_char returns text, right? Then w
Let me explain:
I have written a "C" function which contains calls to other functions, all of
which work with an API to a mileage database product called PCMiler. These
functions make connections to the PCMiler databae, do error checking on the
origin and destination, get directions, etc. There
Subtracting two dates/timestamps will return an interval. So
select now()::date - '2004-01-13'::date
returns 34.
Is this what you need?
On Feb 16, 2004, at 2:01 PM, MaRCeLO PeReiRA wrote:
Hi Guys,
I am in troubles with some dates.
"I need to know the difference, in days, between two
dates."
Well, i
Greg Stark wrote:
Can you recommend an application-level workaround that will access pages
in the right order?
Well you could try CLUSTER-ing your table on that index.
For my application, the problem with CLUSTER is that it reclusters the entire
table. So as the table grows, the cost of CLUSTER go
Jack Orenstein <[EMAIL PROTECTED]> writes:
> Alvaro Herrera wrote:
>
> > On Wed, Jun 02, 2004 at 08:38:58PM -0400, Jack Orenstein wrote:
> >
> > >What is the pattern of access to data pages? I can think of two likely
> > >answers:
> > >
> > >1) The index is scanned for ages 30 through 40. As each
Hi list,
I am working with 7.4.1 under Linux (SuSE 8.1) The server is a HP
ProLiant DL 380-G3, 2x Intel Pentium4-Xeon, 2.8 GHz, 4 GB memory and a
RAID 5 system with ca. 500 GB diskspace (xfs file system)
When doing big transactions or changes (UPDATE several million rows in
one step) on a datab
Hi Robert,
I changed the return type from OPAQUE to TRIGGER and the trigger function
reloaded without any complaint. I suppoe that when I loaded this new version
(with the output from pg_dumpall) that the return type was automatically set
to TRIGGER? I couldn't understand the fact that the code
12 matches
Mail list logo
