Hi friends!
I'm working in a trigger and I need to put the result
of a query into a variable.
That's very easy- apparently!
The query has a aggregate function like this:
select sum(field) into variable ...
and I'm sure that field and variable are int4 type.
So, when I run this trigger there
jreniz writes:
> ''there is no operator '=$' for types 'int4' and 'int4'
It seems you need to put a space into a construct of the sort 'x = $1'.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
---(end of broadcast)---
T
Peter Misovic <[EMAIL PROTECTED]> wrote:
> Hallo,
> I´m sorry for ma beginner guestion, but I want to know, where can I download
> a graphics GUI for managing my PostgreSQL ? A like to obtain a version for
> Win98.
> Thanks a lot a once again and I´m sorry for my question. I´m a new user
> Postgre
Hallo,
I´m sorry for ma beginner guestion, but I want to know, where can I download
a graphics GUI for managing my PostgreSQL ? A like to obtain a version for
Win98.
Thanks a lot a once again and I´m sorry for my question. I´m a new user
Postgre SQL, so therefore I´m asking that ...:-)))
Bye bye .
Hello, I have written a backup script that will vacuum, analyze and backup every
postgresql database.
(1) Modify logfile and backup_dir variables to suite your needs.
(2) I have a trust relationship so I am never prompted for a password on connection.
(3) Add an entry to crontab to perform the
I also asked a similar question earlier , and found zde, though I'm having
problems w/ my pg_hba.conf. it keeps telling me that there is no entry for
me though there is:
localall
trust
host all 209.91.163.194 255.255.255.0 trust mike
hostall 127.
I am trying to run postgres under 4.2-STABLE FreeBSD using a large amount
of shared memory, and am having problems finding the correct settings.
The box has 512MB or RAM, of which I would like for Postgres to use 400MB
for buffers and 32MB for sorting, which I determined would be:
-B 51200 (5120
Michael Fork <[EMAIL PROTECTED]> writes:
> The box has 512MB or RAM, of which I would like for Postgres to use 400MB
> for buffers and 32MB for sorting, which I determined would be:
This is a bad idea. For one thing, you have neglected to allow anything
for backend local data; you should probabl
