OS: Redhat, kernel 2.4
PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by
GCC 2.96
I have a table that has two triggers functions
applied to it
1) CREATE TRIGGER trig_delete_user BEFORE DELETE ON
tbl_user FOR EACH ROW EXECUTE PROCEDURE delete_user();
2) CREATE TRIGGER trig_insert_sys_user
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> If I run SQL such as DELETE FROM tbl_user WHERE id > '20'; and there is mor=
> e than one record that meets the condition (id > '20') then I get the follo=
> wing problem. The BEFORE trigger function is only being called on the first=
> record that is
[EMAIL PROTECTED] writes:
> The bug is repeatable so if anyone wants more information please request.
Hmm. There's a known bug in plpy.execute concerning handling of NULLs,
but offhand this doesn't look like it ever passes NULLs to execute() ---
is that correct? Otherwise, we'll need a stack tra
Hi,
I noticed that Postgres issues a fatal error when given a quoted name of
table or column. This is a problem in secured cgi scripts, which quote
everything they get from the user, to avoid malicious users from trying to
execute SQL commands using some engineered input.
shared# select versio
I'm stuck here with a query that kills postgresql backend.
I've installed postgresql 7.3.1 on two machines..
one with gcc 3.2, glibc 2.3.1 source based (a)
and the other with gcc 2.95.3, glibc 2.2.3 slackware 8 (b)
both are PIII with kernel 2.4.20.
(a) has ext3 and (b) has xfs for the database st
unsubscribe
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hi,
When creating a temp table with a column which has a type of serial, the error below
appears in the postgres log file after disconnection.
This also then leaves the temp table, seq, idx and schema in the db.
It looks like postgres is trying to clean up the temp stuff and is trying to delete
On Thu, 6 Feb 2003, Yaniv Hamo wrote:
> I noticed that Postgres issues a fatal error when given a quoted name of
> table or column. This is a problem in secured cgi scripts, which quote
> everything they get from the user, to avoid malicious users from trying to
> execute SQL commands using some e
On Thu, 2003-02-06 at 22:26, Yaniv Hamo wrote:
> Hi,
> I noticed that Postgres issues a fatal error when given a quoted name of
> table or column. This is a problem in secured cgi scripts, which quote
> everything they get from the user, to avoid malicious users from trying to
> execute SQL comma
Yaniv Hamo <[EMAIL PROTECTED]> writes:
> shared# CREATE TABLE 'testtable' ('test' INT);
> ERROR: parser: parse error at or near "'testtable'" at character 14
This is not a bug. (Perhaps you were looking for double quotes "..."
not single quotes '...' ?)
regards, tom lane
On Wed, 5 Feb 2003, Ricardo Capurro wrote:
> I suppose it´s because the tableNamePattern is being converted toLowerCase()
> I suggest to eliminate this conversion and leave the user do the
> conversion if he desires.
If you upgrade to a newer version of the JDBC driver you will find your
sugges
Title: Message
Hi PostgreSQL developers,
I am
having trouble with PostgreSQL’s implementation of
DataBaseMetaData.getTables()
and looking at the code I found this comment and so I am writing to
you.
The
problem I am having is that If I create tables with
uppercase letters like this
Stefanos Harhalakis <[EMAIL PROTECTED]> writes:
> I'm stuck here with a query that kills postgresql backend.
Hoo, that was a fun one. Try this patch ...
regards, tom lane
*** src/backend/optimizer/plan/initsplan.c.orig Wed Sep 4 16:31:21 2002
--- src/backend/optimizer/p
"David Heggie" <[EMAIL PROTECTED]> writes:
> When creating a temp table with a column which has a type of serial, the error below
>appears in the postgres log file after disconnection.
Good catch. Here's the patch if you need it before 7.3.3 ...
regards, tom lane
*** s
- Original Message -
From: "Josh Berkus" <[EMAIL PROTECTED]>
To: "Insyde" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 02, 2003 6:28 PM
Subject: Re: [BUGS] Problem when adding an existing primary key
> Ricardo,
>
> > When I try to insert via application a registry that
15 matches
Mail list logo
