Here's the link for rules.
http://www.postgresql.org/docs/7.3/static/rules-insert.html
Richard Huxton wrote:
On Wednesday 11 February 2004 15:56, C G wrote:
Dear All,
Could anyone explain why this function does will not work? The error
message is
DETAIL: exceptions.RuntimeError: maximum recursi
You could write a rule to trigger a record into a table as well.
Richard Huxton wrote:
On Wednesday 11 February 2004 15:56, C G wrote:
Dear All,
Could anyone explain why this function does will not work? The error
message is
DETAIL: exceptions.RuntimeError: maximum recursion depth exceeded.
CREA
arttime) VALUES (now());
SELECT * FROM foo;
On Monday February 9 2004 9:24, Barbara Lindsey wrote:
I have a case where I am collecting a "Start Date" and an "End Date".
I would like to default the "End Date" to the "Start Date" value if only
the "Start Date&
What permission does a user need to have to query the pg_ tables
(pg_attribute, pg_class, etc) ? Do they require special permissions?
arbara Lindsey wrote:
What kind of grant do you need to give a user so that they can have
permission to do a "SELECT nextval(ID)" on a sequence?
I granted the us
Yay! It works.
Thank you.
Bruno Wolff III wrote:
On Thu, Jan 29, 2004 at 09:52:56 -0500,
Barbara Lindsey <[EMAIL PROTECTED]> wrote:
What kind of grant do you need to give a user so that they can have
permission to do a "SELECT nextval(ID)" on a sequence?
I granted the user SELE
What kind of grant do you need to give a user so that they can have
permission to do a "SELECT nextval(ID)" on a sequence?
I granted the user SELECT,UPDATE,INSERT,DELETE on all the tables,
including the one that has the sequence, but the sequence query is
failing on permissions.
--
Barbara E. L
Files=25, Tests=268, 34 wallclock secs (10.72 cusr + 0.99 csys = 11.71 CPU)
:)
> On Mon, 1 Dec 2003, Barbara Lindsey wrote:
>
>> However, when I searched for DBD Pg on Google, it led me to a
>> DBD-Pg-1.22
>
> Try
>
> http://search.cpan.org/~rudy/DBD-Pg-1.31/Pg.pm
Satrapa wrote:
Barbara Lindsey wrote:
I have re-built Perl 5.8.2, I have installed PostgreSQL v7.4 and
DBI-1.38.
Then I tried installing pgsql_perl5-1.9.0 and it just wont work. Have I
picked up the wrong module? Are there some specific configs required for
any of these to support the Pg DBD
How does the performance compare using models mimicked from Oracle? Is
there any information anywhere on that?
Marek Lewczuk wrote:
Użytkownik Robert Treat napisał:
On Tue, 2003-11-25 at 08:07, Marek Lewczuk wrote:
Yes. I think the gist of your post was "out of the box postgresql
performed like
I am a postgres newbie.
I am trying to create a trigger that will put a copy of a record into a
backup table before update or delete. As I understand it, in order to do
this I must have a function created to do this task.
The function I am trying to create is as follows:
CREATE FUNCTION custome
10 matches
Mail list logo
