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
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
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
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
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)
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
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
=?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
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
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
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
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
---(end
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 to work in
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)
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
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
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
17 matches
Mail list logo