Hello list, I have a tcl trigger function called audit_log(varchar, bpchar), if I write a trigger in a table CREATE TRIGGER tg_test AFTER INSERT OR...

Josué Maldonado

09-04-2003 02:32 PM
Jan Wieck

Hi list, That's the question, anyone knows a way to do that? Thanks in advance, Josue Maldonado.

Josué Maldonado

09-04-2003 02:24 PM
Jan Wieck

On Thu, Sep 04, 2003 at 08:56:31AM -0700, Jenny - wrote: I think the locks would actually by represented by PROCLOCK structures. The LOCK structures...

Alvaro Herrera Munoz

09-04-2003 02:11 PM
Alvaro Herrera Munoz

Adam Kavan wrote: And you restarted the postmaster since activating these non-standard config options? Are you sure that *this* postgresql.conf...

Adam Kavan

09-04-2003 01:25 PM
Jan Wieck

Hi to all ... I'm looking to a way to auto update some fields of a row when other fileds are updated. the table structure are simple, CREATE TABLE...

Alessandro GARDICH

09-04-2003 01:21 PM
Richard Huxton

Hi, I am having problem using the crosstab function ( which is under the contrib/tablefunc directory). I have installed the tablefunc module and also...

Kuldeep Tanna

09-04-2003 01:18 PM
Richard Huxton

-----BEGIN PGP SIGNED MESSAGE----- Could anyone explain about the max_connections in postgres? We ran into the connection limit on one of our...

Andy Harrison

09-04-2003 12:59 PM
Andy Harrison

This email is semi-off topic; but documents a problem and the server-side solution when using MS Access as a client to many (all?) database servers. ...

Andrew L. Gould

09-04-2003 11:15 AM
Andrew L. Gould

Hi! We have an application running on Linux (SuSE 7.2, kernel 2.4.16) that opens lots of connections to a Postgres database and occasionaly...

Andreas Muck

09-04-2003 11:03 AM
Andreas Muck

Hello Now perhaps this is a bit dumb, but... I just populated a new table via \copy. After that, I realize that perhaps is a good thing to have a...

Claudio Lapidus

09-04-2003 10:05 AM
scott.marlowe

Hi !@! There is a something way to know which are the IP from conexcion to Postgres since plPgsql something like...

Edwin Quijada

09-04-2003 09:38 AM
Edwin Quijada

Hello everyone, I'm working on a tiny trigger function that needs to ensure that all values entered in a field are lowercase'd. I can't use pl/pgsql...

Jules Alberts

09-04-2003 08:33 AM
Jan Wieck

On 03/09/2003 22:56 Bjørn T Johansen wrote: I think sensible values are going to be very dependent on the number of requests. One way to find out...

Paul Thomas

09-04-2003 05:30 AM
Bjorn T Johansen

Hi again, as I said I am using Access as a front-end for postgresql via ODBC. There seams to be a problem with the boolean field. I am not able to...

E. Zorn

09-04-2003 04:12 AM
E. Zorn

hi, I am using Access as a front-end for postgresql via ODBC. The postgresql-server is hosted on a separate linux-computer. I like to change the...

E. Zorn

09-04-2003 04:12 AM
E. Zorn

I am trying to check performance in out database but I seem to be missing something. I try to run : select relname, idx_tup_fetch + seq_tup_read as...

Bjorn T Johansen

09-04-2003 03:54 AM
Bjorn T Johansen

Hi! We have an application running on Linux (SuSE 7.2, kernel 2.4.16) that opens lots of connections to a Postgres database and occasionaly...

Andreas Muck

09-04-2003 02:52 AM
Andreas Muck

Hi, I am a Postgres newbie who worked until now with Oracle. Now I want to know if it is possible (when yes the how?) in Postgresql To set...

Amin Schoeib

09-04-2003 02:32 AM
Karel Zak

Instead of SELECT currval( last_sequence() ), what about implementing oracl type...

Shridhar Daithankar

09-04-2003 01:16 AM
rolf.ostvik@axxessit.no

i've run into the situation where i need to set the last_value of a sequence. can someone tell me how this is done? --...

John Harrold

09-04-2003 12:46 AM
btober@seaworthysys.com

I'm trying to create a PLPGSQL function wich executes every statement inside it no matter if any one fails to execute. Any advice???

Dagoberto

09-03-2003 11:55 PM
Dagoberto

My date setting is ISO with US conventions, and output from a select is in the form yyyy-mm-dd (2002-01-18, for example. When I do a select such...

John Velman

09-03-2003 11:11 PM
Tom Lane

"Claudio Lapidus" <clapidus (AT) hotmail (DOT) com> writes: Given that we have a unary-minus operator for intervals, I see no conceptual objection...

Claudio Lapidus

09-03-2003 10:03 PM
Tom Lane

Hello, I have to migrate a MySQL database to a PostgreSQL database without procedures. The problem is that this MySQL database uses ENUM, do you...

Bruno BAGUETTE

09-03-2003 09:24 PM
Joseph Hepburne Healy

UPDATE BALANCE set TOTAL = TOTAL + ? WHERE ID = ? The "TOTAL = TOTAL + ?" fails with an error, but didn't fail using 7.2 (Peer Direct Windows...

Relaxin

09-03-2003 07:06 PM
Relaxin

Hi, I would like to know if there is a Function in Postgres Like the LAST_DAY Function in Oracle?? In Oracle you can use the function the get the...

Amin Schoeib

09-03-2003 06:04 PM
elein

Hi, I have a situation where I could impose a constraint by a rather complicatet CHECK table constraint, or I could define an ON INSERT OR UPDATE...

Andreas Fromm

09-03-2003 05:20 PM
Andreas Fromm

Hi, I'm trying to understand why a perfect match index is not being used, and a sequence scan is done in place: PostgreSQL 7.3.4 on i686-pc-cygwin,...

Carlos G Mendioroz

09-03-2003 05:04 PM
Carlos G Mendioroz

Hi, I'm looking for a database that will support Mac 8.6 onwards. Do you have any suggestions. Your input/advice on this will be appreciated, ...

Satish Kumar

09-03-2003 04:55 PM
Ron Johnson

Hi, After a very recent postgresql update, the postmaster failed to start because of this: Now I know nl_NL (AT) euro (DOT) UTF-8 is an incorrect...

Sander Smeenk

09-03-2003 03:59 PM
Sander Smeenk

I am installing erserver 1.2 right now, and am having a problem with the ers_addslave program. It uses the eRServer.pm perl module, which perl is...

Bill Montgomery

09-03-2003 03:59 PM
Marc G. Fournier

Hi. Sorry about my English. I´m finishing my studies in the University and my final project is about PostgreSQL. I want to know if is it possible to...

Donald Formiga Leite Junior

09-03-2003 03:43 PM
Josué Maldonado

Peter Eisentraut wrote: inserted instead? Or will the transaction fail because of a wrong number of columns? ---------------------------(end of...

Andreas Fromm

09-03-2003 03:37 PM
Andreas Fromm

Hello, How many memory does take numeric(3,0) ? Is it smaller than INT2 that takes 2 octets ? Thanks in advance...

Bruno BAGUETTE

09-03-2003 03:13 PM
Peter Eisentraut

the offnum of LOCKTAG I gather indicates which row (tuple) is being locked in a row level locking. But when I lock 2 diffrent rows of a table,...

Jenny -

09-03-2003 01:36 PM
Jenny -

Hi, I had dumped data using the command: pg_dump -U dbowner dbname -a -t table -f table-data.sql two tables (e.g. table1, table2). In the first...

Joshua L. San Juan

09-03-2003 11:05 AM
Tom Lane

"Aurangzeb M. Agha" <ama-list (AT) mltp (DOT) com> writes: You have several choices as I see it: 1) Have Postgres run as 'admin' (not ideal, but...

Doug McNaught

09-03-2003 10:05 AM
Adrian Phillips

Hi, Like I see there is no equivalent to the Oracle decode Function In Postgres.Is there maybe somebody who wrote decode as...

Amin Schoeib

09-03-2003 09:41 AM
Jeff Eckermann

On Sat, 30 Aug 2003 16:18:14 +0200 (CEST), peter_e (AT) gmx (DOT) net (Peter Eisentraut) wrote: Why is that?

Bo Lorentsen

09-03-2003 09:37 AM
Vivek Khera

Hello All, I wanted to know whether recursive selects are supported in the latest version of postgres. I checked out the unimplemented sql constructs...

Varun Kacholia

09-03-2003 09:28 AM
Tom Lane

If they happen to be stored in the same block, they'd have the same blkno .... then how would we recognize each individual row...

Jenny -

09-03-2003 09:24 AM
Jenny -

If they happen to be stored in the same block, they'd have the same blkno .... then how would we recognize each individual row...

Jenny -

09-03-2003 09:23 AM
Jenny -

Hi list, Is there a way to access an especific element of the array NEW in an TCL trigger, I have a loop that goes for each field (thanks Ian &...

Josué Maldonado

09-03-2003 05:36 AM
Ian Harding

Hi, When I Try to write Functions I always become the error That the language plpgsql doesn't exist. I tried it this way: createlang plpgsql...

Amin Schoeib

09-03-2003 04:59 AM
Shridhar Daithankar

Hi, Does anyone have any packages for 7.3.4 for debian woody? Thanks in advance, -- Martijn van Oosterhout <kleptog (AT) svana (DOT) org> ...

Martijn van Oosterhout

09-03-2003 02:31 AM
Martijn van Oosterhout

then what field can be used to recognize each individual row locked? thanks _________________________________________________________________ Help...

Jenny -

09-02-2003 08:57 PM
Jenny -

HI, how much storage space etc. Thanks Aaron On Wed, 2003-09-03 at 02:44, Richard Welty wrote: ---------------------------(end of...

Aaron

09-02-2003 05:20 PM
Marc G. Fournier

Hi All, I've noticed that in the pg_type system table, there is a data type called "name", would that represent the definition of the table...

Chris Bowlby

09-02-2003 03:57 PM
Ron Johnson

I'm having a problem with the backend occasionally crashing. I have interfaces with the database in two different applications -- a web viewer using...

Jeffrey Melloy

09-02-2003 01:08 PM
Jeffrey Melloy

I understand that ObjID of LOCKtag recognizes each individual row locked by a row level lock. BUt i have noticed that if i lock 2 different rows of...

Jenny -

09-02-2003 12:59 PM
Jenny -