On Thursday 24 May 2007 13:02, John D. Burger wrote:
>
> We also have a hodge-podge of other sources, but those are the main
> ones. (By the way, we have found USGS to very amenable to dumping
> their data in arbitrary ways. Those state files essentially try to
> fit everything into a single CSV
On May 26, 5:58 pm, "Andrus" <[EMAIL PROTECTED]> wrote:
> Thank you.
> This doc says that dropping trigger drops depending objects also.
Only if you use CASCADE (default is RESTRICT).
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
See the SECURITY DEFINER option for CREATE FUNCTION. This way you
don't have to give them create table privileges, but they can still
create a table through your function. You'll need to use EXECUTE to
create a table in pl/pgsql.
On May 27, 2007, at 4:50 PM, CAJ CAJ wrote:
Had a questio
I set the ulimit for data to 4194304k:
core file size (blocks, -c) 0
data seg size (kbytes, -d) 4194304
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimite
Tom Lane <[EMAIL PROTECTED]> írta:
> Daniel Denes <[EMAIL PROTECTED]> writes:
> > But even then, it won't realize that the result are in correct order,
> > and does a sort! Why?
>
> In general the output of a nestloop doesn't derive any ordering
> properties from the inner scan. It might happen
On Sunday 27 May 2007 2:25 pm, ABHANG RANE wrote:
> Hi,
> Can you please let me know if anyone has used cube.c file in
> postgresql. I have installed the contrib modules required, but I just
> need to know how to implement cube operator on a table.
>
> Thanks
> Abhang
>
>
>
Hi,
Can you please let me know if anyone has used cube.c file in
postgresql. I have installed the contrib modules required, but I just
need to know how to implement cube operator on a table.
Thanks
Abhang
---(end of broadcast)---
TIP 9: In vers
Had a question on best approach with some security issues around on the fly
table creation by a user.
I want to users to create dynamic tables from the application. This means
that the user logged in should have create table privileges at the database
level. Assuming this is a security risk for a
I am using createdb to automatically create a database from a .sql file, but
in Vista it seems to prompt me for the postgres password.
How can I stop this from happening? I'm not using the -W or -password option
so why does it ask me for a password?
Here is my command...
createdb.exe -U po
=?ISO-8859-2?Q?D=E1niel_D=E9nes?= <[EMAIL PROTECTED]> writes:
> But even then, it won't realize that the result are in correct order, and
> does a sort! Why?
In general the output of a nestloop doesn't derive any ordering
properties from the inner scan. It might happen to work in your
particular
On May 27, 2007, at 12:23 , ABHANG RANE wrote:
I need to use the cube operator in postgresql 8.2. Whats the syntax
for the cube or a link to the documentation which clearly explains
how to use cube operator syntactically.
PostgreSQL does not have a native CUBE operator. There may be an
e
Hi,
I need to use the cube operator in postgresql 8.2. Whats the syntax for
the cube or a link to the documentation which clearly explains how to
use cube operator syntactically.
Thanks
Abhang
---(end of broadcast)---
TIP 6: explain analyze is
Hi,
I have three tables involved in my problem:
forums_grps [means: Forum-Groups]
- id (PRIMARY KEY)
- title
forums [means: Forums]
- id (PRIMARY KEY)
- forum_group_id (NOT NULL, FOREIGN KEY)
- order (defines listing order of forums in the same forum_group)
INDEX: (forum_group_id, order)
sit_sh
Conor,
You're covering a few different areas here. Rather than go into depth
on each one, I'll just point out a few things that came to mind while
reading your post.
On May 20, 2007, at 23:17 , Conor McTernan wrote:
I'm using Postgres for my web app, I users that interface with the
datab
On Sun, May 27, 2007 at 12:02:35PM +0200, Rafael Martinez wrote:
> Until postgresql 8.1.4, this has been working without problems.
> Yesterday I upgraded this database to 8.1.9 and select queries using the
> IF function fail with this error message:
>
> ERROR: cannot display a value of type anye
Hello
I am using an application that has this function defined in the database:
Schema | Name | Result data type | Argument data types |
Owner| Language | Source code | Description
+--+--+-++--+
At 03:25 AM 5/25/2007, A.M. wrote:
Indeed. Wouldn't it be a cool feature to persists transaction states
across connections so that a new connection could get access to a
sub- transaction state? That way, you could make your schema changes and
test them with any number of test clients (which de
17 matches
Mail list logo
