Hello,
Dropping a trigger is permitted if the user is the owner of the table
for which the trigger is defined.
In a plpgsql function, used by different users, I need to disable some
triggers for a short period of time. With the pgsql user login, I can
succesfully drop and create the trigger again
Has anyone ever taken a look at adding radius authentication to
Postgresql? I know it's not terribly secure in itself, but some 2
factor authentication schemes like Cryptocard use it for verifying one
time passwords, and at least in our case having 2 factor
authentication for remote access would b
On Mon, 2004-09-06 at 09:23, Philippe Lang wrote:
> Hello,
>
> Dropping a trigger is permitted if the user is the owner of the table
> for which the trigger is defined.
>
> In a plpgsql function, used by different users, I need to disable some
> triggers for a short period of time. With the pgsql
Hiya,
I am using the following line to retrieve the attribute name of the 1st
column for a table on which a trigger has been fired.
idfield=SPI_fname(trigdata->tg_relation->rd_att,0);
The trigger that calls this function runs after for insert, update and
delete.
Insert works fine with n
After takin a swig o' Arrakan spice grog, Randy Yates <[EMAIL PROTECTED]> belched out:
> Christopher Browne <[EMAIL PROTECTED]> writes:
>
>> Oops! Randy Yates <[EMAIL PROTECTED]> was seen spray-painting on a wall:
>>> I'm a complete newbie to postgres so please look the other way if
>>> these quest
On Mon, Sep 06, 2004 at 01:28:38AM -0700, Chris Ochs wrote:
> Has anyone ever taken a look at adding radius authentication to
> Postgresql? I know it's not terribly secure in itself, but some 2
> factor authentication schemes like Cryptocard use it for verifying one
> time passwords, and at least
Christopher Browne wrote:
That does not seem to be the case. I have three subdirectories in
my base/ directory, but according to PGADMIN III, only one database.
Look more closely; there _are_ three databases there. If PGAdmin III
is saying otherwise, it's hiding something.
Check out Display -> "
Suresh Tri wrote:
But when I try to drop the existing || operator, I get the following
error
ERROR: cannot drop operator ||(text,text) because it is required by
the database system
Also I cannot modify the application which runs over the database.
Hence I cannot overload || (varchar,varchar) and u
On Mon, 06 Sep 2004 00:02:24 +0100, Carlos Correia <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Here is the output a psql session. Please notice that the identation
> inconsistences in the records containg non ASCII chars is as outputed by
> psql.
>
> The db was created with LANIN9 and the console was ra
Graeme Hinchliffe <[EMAIL PROTECTED]> writes:
> I am using the following line to retrieve the attribute name of the 1st
> column for a table on which a trigger has been fired.
> idfield=SPI_fname(trigdata->tg_relation->rd_att,0);
SPI_fname thinks that column numbers start with 1, not 0.
>
I would prefer open-source solution if possible. I also would like to
developp on my linux box but the result will be used on a windows 2000
and XP machine. But If I have no choice, I will developp on winXP.
Any suggestion?
Python with WxWindows or Borland with Delphi/Kylix
P.S.: I never deve
Hello
Hopefully someone can shed some light on the following issue. After
chatting at irc.freenode.net/#postgresql, without success, this is my last
effort before giving up and using a temp table.
Essentially, I would like to pass a RECORD variable from one function to
another using plpgsql:
fu
Hello !
I use PostgreSQL 7.4.5-1mdk on an Mandrake Linux
10.0 server.
I've installed libpq3, postgresql,
postgresql-server and postgresql-docs for that version.
I've restarted my server.
My database works correctly, but I can't install
the PL-PGSQL.I can't find the librairy plpgsql.so on my
>I would prefer open-source solution if possible. I also would like to
>developp on my linux box but the result will be used on a windows 2000
>and XP machine. But If I have no choice, I will developp on winXP.
>
>Any suggestion?
>
>
It has nothing to do with open-source, but I suggest you h
"Henry Combrinck" <[EMAIL PROTECTED]> writes:
> Essentially, I would like to pass a RECORD variable from one function to
> another using plpgsql:
> func2(record)
You can't declare a plpgsql function that accepts RECORD; this is simply
not supportable. (For one thing, which actual record types sh
On Mon, Sep 06, 2004 at 08:09:39PM +0200, Secrétariat wrote:
> I use PostgreSQL 7.4.5-1mdk on an Mandrake Linux 10.0 server.
> I've installed libpq3, postgresql, postgresql-server and postgresql-docs for that
> version.
> I've restarted my server.
> My database works correctly, but I can't instal
You have also RealBasic, with cross-platform to Windows, Mac and linux...
Luc
- Original Message -
From: "Eric" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 05, 2004 8:48 PM
Subject: [GENERAL] RAD with postgreSQL
> Hi,
>
> Any suggestion to Rapid Application Dev w
On Sun, 2004-09-05 at 16:30, Hadley Willan wrote:
> Hi all,
> Can it speed things up to index the order by columns?
Yes, note that you need to index on what function you might be sorting
by as well:
create index test_dx on test (lower(name));
will allow indexes to be used on an order by lowe
> "Henry Combrinck" <[EMAIL PROTECTED]> writes:
>> Essentially, I would like to pass a RECORD variable from one function to
>> another using plpgsql:
>
>> func2(record)
>
> You can't declare a plpgsql function that accepts RECORD; this is simply
> not supportable. (For one thing, which actual reco
"Henry Combrinck" <[EMAIL PROTECTED]> writes:
> Can you give an example of what a "named rowtype" is?
The result of CREATE TYPE AS, or the row type implicitly created for a
table. For instance
CREATE TYPE complex AS (r float, i float);
CREATE FUNCTION abs(complex) RETURNS float
On Mon, Sep 06, 2004 at 10:39:54PM +0200, Henry Combrinck wrote:
> Can you give an example of what a "named rowtype" is? Are you refering to
> creating some kind of custom TYPE, and then passing that to
> func2(custom_type_row)?
You can use a table's rowtype, that is, a type that has the name of
what about to use a CRC32 checksum of the text, computed by client
application an then make index of crc32 data ?
ie
add column crc int4,
add column md5 varchar(255 )
create index blabla on mytable (crc)
or even create index blabla2 on mytable (crc,md5)
and query like . where crc='crc
22 matches
Mail list logo
