Pedro Alves ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
CHECK evaluation error when using more than one table
Long Description
Creating a table with the code shown, everytime I try to insert values I get the same
"ERROR: E
[EMAIL PROTECTED] writes:
> CREATE TABLE ninhada (
> c_id_mae int,
> n_id int,
> c_id_pai int,
> n_dta_nasc date,
> PRIMARY KEY (n_id, c_id_mae),
> FOREIGN KEY (c_id_mae) REFERENCES caes (c_id)
>ON DELETE CASCADE,
> FOREIGN KEY (c_id_pai) REFERENCES caes (c_id)
Roland Szabo ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Fails to add function from file with \i in psql
Long Description
For maintainance reasons, sql statements for our databases are saved in files, and
upon installation
Roland Szabo ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Special character pervents psql from parsing?
Long Description
Consider the two expressions in the example code. They are almost the same, the only
difference is, th
[EMAIL PROTECTED] writes:
> psql:triggertest.sql:4: NOTICE: plpgsql: ERROR during compile of c_fnc
> near line 1
> "sql:triggertest.sql:4: ERROR: parse error at or near "
Sounds like you saved your file with DOS-style newlines (\r\n). The
plpgsql parser doesn't think \r is whitespace. That'
Hi!
I'm found that call function has bug:
some function have more than one arguments and
if one argument is NULL, then all other arguments
is NULL too! But function calling only with one
NULL arguments. Why?!
My system Linux Slackware 7.0, Postgres 7.0.2.
kernel 2.2.16
log file attached.
Dmit
select 'hello ' || coalesce('there','there');
ERROR: Function 'text(unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
It seems clear that the coalesce construction must return a string - so why
do
I just find a workaround, which also may shed light on the bug itself:
select 'hello ' || coalesce('there','there',0::text);
?column?
-
hello there
(1 row)
And this is very strange indeed:
select 'hello ' || coalesce('there','there',0);
?column?
-
hello 13635
