[GENERAL] DROP TRIGGER permission

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

[GENERAL] radius authentication

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

Re: [GENERAL] DROP TRIGGER permission

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 user

[GENERAL] tg_relation doesn't seem to have the attribute names!

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 no

Re: [GENERAL] One Database per Data File?

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 questions are really

Re: [GENERAL] radius authentication

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 in

Re: [GENERAL] One Database per Data File?

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 -

Re: [GENERAL] Overloading || ( text,text ) operator

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

Re: [GENERAL] Confused with db client encoding

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 ran (in

Re: [GENERAL] tg_relation doesn't seem to have the attribute names!

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. This

Re: [GENERAL] RAD with postgreSQL

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

[GENERAL] Passing RECORD variable from func1() to func2()

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:

[GENERAL] PL-PGSQL language

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

Re: [GENERAL] RAD with postgreSQL

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 have a

Re: [GENERAL] Passing RECORD variable from func1() to func2()

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 should

Re: [GENERAL] PL-PGSQL language

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 install

Re: [GENERAL] RAD with postgreSQL

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 with

Re: [GENERAL] Indexing Order By columns

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

Re: [GENERAL] Passing RECORD variable from func1() to func2()

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

Re: [GENERAL] Passing RECORD variable from func1() to func2()

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 AS ...

Re: [GENERAL] Passing RECORD variable from func1() to func2()

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 the

Re: [GENERAL] Index on TEXT versus CHAR(32)... fast exact TEXT matching

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