Paul <[EMAIL PROTECTED]> writes:
> create table xx (a int4);
> create rule xx_xx2 as on delete to xx where old.a=1 do notify xxx;
> something like "backend closed connection"
Okay, the problem here is that we don't support NOTIFY (or other utility
statements) in conditional rules. This isn't lik
I do not see this (using fairly random table
creations since you didn't provide the schema)
in 7.2devel. I get 7 and 7 at the end. Which
7.1 are you using? Have you tried upgrading
to 7.1.2?
In any case, a script to create the tables and
views and populate them with the appropriate data
wou
On Thu, 31 May 2001, Letitia Hickman wrote:
> Getting a "Warning: PostgreSQL query failed: ERROR: Cannot insert a
> duplicate key into unique index
> auditlog_pkey in /htdocs/ecorp-real-estate.com/intranet on line 167"
>
> Continue to get also
>
> :Warning: PostgreSQL query failed: ERROR: pars
shashi ahuja <[EMAIL PROTECTED]> writes:
>Now wht happen is in my final query of test1 and test2, "total_message" and
>"con_phone" both
> the columns output is changed by 5 times which is a random value.
Would you mind providing this example in the form of a psql script that
reproduces
On Mon, 4 Jun 2001, Manager, RIKOP I.S.P. wrote:
> Dear Sir or Madam.
> We'we noticed that command
> psql -U user database
> don't check password. However databese was created next commad
> createdb -U user -W databese
What does your pg_hba.conf say?
---(end o
On Sat, 2 Jun 2001, J. Michael Caine wrote:
> the following works:
>
> create table t1 (id serial primary key);
> create table t2 (id serial primary key);
> create table t12 (
> t1_id int references t1(id) on delete cascade,
> t2_id int references t2(id) on delete cascade
> );
>
> b
[EMAIL PROTECTED] writes:
> repeated syntax errors in plpython modules cause database to reset
Hm. Can you provide a debugger backtrace from the crash? Either look
for a core file in the database subdirectory, or attach gdb to the
running backend process before you induce the crash.
Paul <[EMAIL PROTECTED]> writes:
> create rule xx_xx2 as on delete to xx where old.a=1 do notify xxx;
I see it too. Will investigate.
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go
Bruce Momjian <[EMAIL PROTECTED]> writes:
> My question is whether you think "--" _inside_ quotes should be a
> comment. I don't think it should be.
It should be if plpgsql thinks it is. But that's not the problem here.
Doubling the quote marks would help...
regards, tom
Peter Eisentraut <[EMAIL PROTECTED]> writes:
>> I'm running PG 6.5.3 on RedHat 6.0 with a 2.2.17 kernel:
>> My /var/log/messages is filling up with the following.
>>
>> Jun 3 04:06:23 ozzzy PAM_pwdb[5766]: (su) session opened for user postgres by
>(uid=0)
>> Jun 3 04:06:23 ozzzy PAM_pwdb[5
Hello world,
I am using "PostgreSQL 7.1.2 on i386-unknown-freebsd4.2, compiled by GCC
2.95.2" (according to version()). I suspect that there is a parser bug in
the handling of '--' comments:
radius=# create function test() returns integer as '
radius'# begin
radius'# -- comment without quote
PostgreSQL version : PostgreSQL 7.2devel on i686-pc-linux-gnu, compiled by GCC
egcs-2.91.66
Server crashes with SEGV.
Thank you
create table D_Inv_Location_Types (
Inv_Loc_Type_ID integer not null,
Inv_Loc_Type_Name varchar not null,
Inv_Loc_Type_Description varchar not null,
On line 1707 there is a dereference of 'relKind' which may very likely
be set to null. This can cause a null pointer exception. I've include
dthe workaround I am using, though there is almost certainly somethig
better.
Bob Weiler
String relKind;
switch (r.getBytes(3)[0]) {
case 'r':
i have four same tables in postgres and oracle.I'm
using the postgres 7.1 version.
listed below
GROUPSMS=# select * from group_smu_trans ;
sub_id | con_phone |
message |
+--+---
Getting a "Warning: PostgreSQL query failed: ERROR: Cannot insert a
duplicate key into unique index
auditlog_pkey in /htdocs/ecorp-real-estate.com/intranet on line 167"
Continue to get also
:Warning: PostgreSQL query failed: ERROR: parser: parse error at or near
"," in /htdocs/ecorp-real-estate
Sequence:
-
listen xxx;
create table xx (a int4);
create rule xx_xx2 as on delete to xx where old.a=1 do notify xxx;
-
Output:
something like "backend closed connection"
Output
Dear Sir or Madam.
We'we noticed that command
psql -U user database
don't check password. However databese was created next
commad
createdb -U user -W
databese
Postgres v.7.1
Linux Debian v. 2.4.4
Best regards,
Klemeshova Nataly"Rikop"
ltdp/n (3832) 18-40-38e-mail: [EMAIL PROTE
the following works:
create table t1 (id serial primary key);
create table t2 (id serial primary key);
create table t12 (
t1_id int references t1(id) on delete cascade,
t2_id int references t2(id) on delete cascade
);
but the following does not:
create table t1d () inherits(t1);
Rick Saunders ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
System Logs filling up with gunk
Long Description
I'm running PG 6.5.3 on RedHat 6.0 with a 2.2.17 kernel:
My /var/log/messages is filling up with the following.
19 matches
Mail list logo
