Bill Shui wrote:
>Hi there,
>
> I remember that in earlier versions of Postgres.
> You have to do something (which I cannnot remember) to enable
> a user to create plpgsql functions.
>
> which versions of postgres were they?
>
>thanks in advance.
>
>Bill
>
CR
Try this:
test=# create table test (a int4);
CREATE
test=# grant select, update on te
Stop there and press 'TAB' to complete the word 'test'.
Your command line then gets rewritten to :
grant select, update on SET
It seems that it occurs when you have commas in there...
Chris
--
Hi there,
I remember that in earlier versions of Postgres.
You have to do something (which I cannnot remember) to enable
a user to create plpgsql functions.
which versions of postgres were they?
thanks in advance.
Bill
--
The mark of a good part
"Henshall, Stuart - WCP" wrote:
>
> Would it be possible to offer an option for the OID column to get its value
> from an int4 primary key (settable on a per table basis maybe)?
> - Stuart
>
Sorry I don't understand well what you mean.
What kind of advantages are there if we let OIDs be optional
> > I'm trying create a unique index using more than one field and
> > applying a function in one field to achieve case insensitive
> > uniqueness but postgresql doesn't accept.
> >
> > create table a(
> > id int primary key,
> > id2 int not null,
> > name varchar(50),
> > unique(id2, low
I'd like to have statistics on when my database was last backed up or
vacuumed. Currently, I'm implementing this by using simple shell
scripts that write a date stamp to ascii files. I was wondering
whether this is or could be a feature added to Postgres?
For example, could one of the pg_* tables
> Tom Lane wrote:
> > "Steve Howe" <[EMAIL PROTECTED]> writes:
> > > ..\..\backend\lib\dllist.c(20) : fatal error C1083: Cannot open
include
> > > file: 'sysexits.h': No such file or directory
> >
> > Jan added that recently. I was wondering if it was portable or not ...
> > looks like now we kno
From: "Jan Wieck" <[EMAIL PROTECTED]>
> Tom Lane wrote:
> > and then the code takes care of swallowing expressions until ';',
> > similarly to the way SQL commands are handled. (plpgsql's parsing
> > methodology is sinfully ugly, isn't it? But I don't suppose you
> > want to try to replace it..
Tom Lane wrote:
> and then the code takes care of swallowing expressions until ';',
> similarly to the way SQL commands are handled. (plpgsql's parsing
> methodology is sinfully ugly, isn't it? But I don't suppose you
> want to try to replace it...)
It is, indeed, and I'm sorry for that.
We are evaluating PostgreSQL for a possible port to our
proprietary hardware platform. The hardware is a very
high end (processing power, I/O throughput, storage capacity)
storage system, attached to a host machine running Windows2K.
The question is what's the right way to do it. The following
i
Tom,
What you are describing is a pseudo circular log. Other database
systems (such as DB2) support the concept of both circular and
recoverable logs. Recoverable is named this way because
recoverable logs can be used in point-in-time recovery. Both
methods support crash recovery.
In genera
- Original Message -
From: eCommerce Software
Solutions Inc.
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, July 21, 2001 9:15 PM
Subject: Leaking Handles in Postgres 7.1.2 on Cygwin dll 1.3.2 on
Win 2000
The situation is this:I have cygwin
with ( dll 1.3.2 ) and
Tom Lane wrote:
>
> Patrick Macdonald <[EMAIL PROTECTED]> writes:
> > I understand your solution is for the existing architecture which does
> > not support point-in-time recovery. If this item is picked up, your
> > solution will become a stumbling block due the above mentioned log
> > extent d
On Sun, Jul 22, 2001 at 08:10:32PM +0900, Tatsuo Ishii wrote:
> Hum. Why don't you enable --enable-multibyte and
> --enable-unicode-conversion and set client_encoding to UNICODE? That
> would do a conversion from/to UTF-8 for Tcl 8.x (x > 9) clients?
You're right. Probably, this way correct enoug
I'm trying create a unique index using more than one field and
applying a function in one field to achieve case insensitive
uniqueness but postgresql doesn't accept.
create table a(
id int primary key,
id2 int not null,
name varchar(50),
unique(id2, lower(name))
);
Anyone have an
[EMAIL PROTECTED] (Lamar Owen) wrote in message
news:<[EMAIL PROTECTED]>...
> [trimmed cc:list]
> On Wednesday 18 July 2001 17:09, Bruce Momjian wrote:
> > OK, we need to vote on whether Oid's are optional, and whether we can
> > have them not created by default.
>
> [All the below IMHO]
Sean Chittenden wrote:
> Has anyone here thought about using the spread libraries for WAL
> replication amongst mutliple hosts? With this library I think it'd be
> possible to have a multi-master replication system..
Yes, there is some work being done to use Spread as the group
communi
Tom Lane wrote:
> "Steve Howe" <[EMAIL PROTECTED]> writes:
> > ..\..\backend\lib\dllist.c(20) : fatal error C1083: Cannot open include
> > file: 'sysexits.h': No such file or directory
>
> Jan added that recently. I was wondering if it was portable or not ...
> looks like now we know :-(.
Gr
Would it be possible to offer an option for the OID column to get its value
from an int4 primary key (settable on a per table basis maybe)?
- Stuart
> -Original Message-
> From: Hiroshi Inoue [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, July 21, 2001 7:31 AM
> To: Zeugswetter Andreas SB
>
August Zajonc wrote:
> Perhaps Postgresql folks could start thinking of peace talk sites as well? I
> recommand the tropics. Then all that's left is to find something to fight
> about to justify a flight down to paradise.
You are all welcome here in Cyprus. Monty too, he will find a lot of
Swedi
Domingo Alvarez Duarte wrote:
> I'm trying create a unique index using more than one field and
> applying a function in one field to achieve case insensitive
> uniqueness but postgresql doesn't accept.
>
> create table a(
> id int primary key,
> id2 int not null,
> name varchar(50),
> un
> What I mean is, do host lookups first in the text file, then if a
> pg_hostaccess table (example) exists, check it for host entries. This
> alleviates HUP or restart etc. to reload a config file.
Can't do that. Postmaster has no database access. Must be fast.
--
Bruce Momjian
22 matches
Mail list logo
