Hello,
I'm writing a trigger in pl/pgSQL and I'd like to pass one column name as
argument to the trigger function.
Provided my table has only one column named 'id', I can do easilly
CREATE FUNCTION ft() RETURNS trigger AS $$
BEGIN
RAISE NOTICE 'It works:%', OLD.id;
END
$$ LANGUAGE plpgsql;
On Sat, Apr 5, 2008 at 4:05 PM, Pavel Stehule <[EMAIL PROTECTED]> wrote:
> Hello
>
>
>
>
> On 05/04/2008, Guillaume Bog <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I'm writing a trigger in pl/pgSQL and I'd like to pass one column name as
On Mon, Apr 7, 2008 at 1:56 AM, Craig Ringer
<[EMAIL PROTECTED]> wrote:
> Guillaume Bog wrote:
>
> > I want a table to be "read-only", so I raise exceptions with a before
> > trigger on update, insert and delete. It works well.
> >
> > This read
Hi!
We have been using postgresql since a while without problems. But now I find
we experience some slowness and the weird thing is that it seems to happen
because of a very short table (less than 200 lines), called "lockers" (see
below it's structure).
This table is accessed very often by a lot
On Wed, Jul 23, 2008 at 4:50 PM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Guillaume Bog wrote:
>
>> It seems I'm a bit stuck here. I'd appreciate some help. My main general
>> question is "how to handle very small but hot status table that has to be
>&
M, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Guillaume Bog wrote:
>
>> On Wed, Jul 23, 2008 at 11:17 PM, Richard Huxton <[EMAIL PROTECTED]>
>> wrote:
>>
>> I tried a vacuum full and had to stop it as it was blocking the server for
>> too long.
Hi dear Postgres users.
I have performance issues if I do the following pseudo-query:
SELECT a, b, (SELECT count(*) FROM t2 WHERE something) AS c
FROM t1 ORDER BY a LIMIT 10;
After some tests, it seems to me that the subquery on t2 is computed for all
rows of t1. As I don't "ORDER BY c", there i
On Tue, Nov 25, 2008 at 15:56, A. Kretschmer <
[EMAIL PROTECTED]> wrote:
> am Tue, dem 25.11.2008, um 15:34:57 +0800 mailte Guillaume Bog folgendes:
> > Hi dear Postgres users.
> >
> > I have performance issues if I do the following pseudo-query:
> >
> >
Hi everyone,
I'm now used to using psql to manage my databases into a terminal, and
I found the very convenient "\g |" command that pipes query result in
any shell tool I want. But I still have hard time finding some columns
in some tables (that may have 300+ cols). I would like to pipe the
resul
On 13/03/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:
On 3/12/07, Guillaume Bog <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I'm now used to using psql to manage my databases into a terminal, and
> I found the very convenient "\g |" command that pipes
Hi PostgreSQL afficionados,
I have a little question that I know is not fully on topic, but
because I'm lurking this list I know many highly skilled and
experienced people are there. So I try it:
I have to store a big html form in my database. It has around 100
fields of differents kinds (varcha
11 matches
Mail list logo
