[BUGS] Bug #875: init script problem with reload
philippe ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
init script problem with reload
Long Description
In the RPM from ftp, for postgresql 7.2.3 you have an error in the
/etc/rc.d/init.d/postgresql reload
The reload function is
reload(){
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl reload -D $PGDATA -s" > /dev/null
2>&1
}
but here $PGDATA is no initialised.
Maybee you can add the same test as in stop()
if [ -f /var/lib/pgsql/PG_VERSION ] && [ -d /var/lib/pgsql/base/template1 ]
then
export PGDATA=/var/lib/pgsql
else
export PGDATA=/var/lib/pgsql/data
fi
Sample Code
No file was uploaded with this report
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
[BUGS] Bug #876: Bugs Inserts Arrays
Walter ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Bugs Inserts Arrays
Long Description
Hi, Im Walter, from Brazil, and I use PG 7.2.
(excuse my english!)
The error: the last entrance (last array
dimension) determine the dimension of all arrays,
losting data information.
see the example:
all of array has 2 elements. The error: the last entrance (last array
dimension) determine the dimension of all arrays,
losting data information (the information "002" of first array is lost).
If I make a mistake, forgot it, but if not, please, report me something !
Thanks a Lot
Walter
Sample Code
create table teste(serie integer,aula text[][]);
//it´s ok when insert this
insert into teste values (1,'{{"004","009"},{"009"},{""},
{"001","002"}}');
//But when I insert this..
insert into teste values
(1,'{{"004","009","002"},{"009","001"},{""},{"001","002"}}');
^^ -> lost information ^^ -> array dimension last
entrance.
No file was uploaded with this report
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Re: [BUGS] Bug #876: Bugs Inserts Arrays
[EMAIL PROTECTED] writes:
> Sample Code
> create table teste(serie integer,aula text[][]);
> //it´s ok when insert this
> insert into teste values (1,'{{"004","009"},{"009"},{""},
> {"001","002"}}');
> //But when I insert this..
> insert into teste values
> (1,'{{"004","009","002"},{"009","001"},{""},{"001","002"}}');
> ^^ -> lost information ^^ -> array dimension last
>entrance.
Yeah, this seems to be a long-standing misbehavior. I get the same
results as far back as PG 7.0 (the oldest version I have running):
play=> select * from teste;
serie |aula
---+-
1 | {{"004","009"},{"009",""},{"",""},{"001","002"}}
1 | {{"004","009"},{"009","001"},{"",""},{"001","002"}}
(2 rows)
On the other hand, the last time I fixed what seemed an obvious bug in
the array-value parser, I got flak for it. Anyone want to defend the
present behavior?
regards, tom lane
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
