Dave Page píše v po 19. 07. 2010 v 14:24 +0100:
> On Mon, Jul 19, 2010 at 1:56 PM, Zdenek Kotala wrote:
> > Dave Page píše v po 19. 07. 2010 v 13:32 +0100:
> >> I'm working on setting up a new buildfarm member as we don't seem to
> >> have any active Solaris
Dave Page píše v po 19. 07. 2010 v 13:32 +0100:
> I'm working on setting up a new buildfarm member as we don't seem to
> have any active Solaris ones :-(
Unfortunately, I had to stop them :(. Sorry.
I cannot remember this bug. However for Solaris 10 is better to use
SunStudio 11. I see lot of bug
IP píše v ne 14. 02. 2010 v 21:15 +0100:
> Hi,
>
> Thanks, great info. I will retest that, for sure. Nevertheless status of
> PostgreSQL packages for Sun Solaris is something really interesting ;-) Here
> http://www.postgresql.org/download/solaris we can read that the packages are
> produced by
We (means postgresql community -> Bjorn or me) will fix it in 8.4.3
packages. It will be confusing to rerelease already released 8.4.2
package.
Just for clarification, There is no Sun's Solaris 10 PostgreSQL 8.4
packages.
Zdenek
IP píše v ne 14. 02. 2010 v 20:39 +0100:
> What is the f
Tom Lane píše v so 06. 02. 2010 v 10:57 -0500:
> "IP" writes:
> > Issue: no value returned for 8.4.2 Solaris 10 x86 installation
>
> This isn't necessarily a bug. The source-function report depends
> on having used a C compiler that supports the __func__ or __FUNCTION__
> symbol, and not all do.
Alvaro Herrera napsal(a):
Zdenek Kotala wrote:
[EMAIL PROTECTED] napsal(a):
In file src/test/regress/pg_regress.c:1112
It seems to me that variables "s" and "tmp" leak memory here if last_dot is
false:
OK. It seems as a bug. tmp and s should be freed when strrchr fails
f(s, ssize, "%s_%d.%s", tmp, i, last_dot + 1);
free(tmp);
return s;
}
OK. It seems as a bug. tmp and s should be freed when strrchr fails. Also there
is not check when malloc fails.
Zdenek
--
Zdenek Kotala Sun Microsystems
Prague, Czec
view it is good to
release unused memory, because process can reuse it. But when you know what you
do then you can break a rule.
Zdenek
--
Zdenek Kotala Sun Microsystems
Prague, Czech Republic http://sun.com/postgresql
--
Sent via pgsql-bugs mailing list (
Harvey, Allan AC napsal(a):
Zdenek,
Hmm, It does not look good. Your OS does not return proper
information about
codeset. Following code is broken:
setlocale(LC_CTYPE, ctype);
sys = nl_langinfo(CODESET);
sys = strdup(sys);
See
http://www.opengroup.org/onlinepubs/0096
f there is a leak or document better where the memory
is released.
I think all information is collected and they are used for all pg_dump run. It
does not make sense to free them. See line 725.
Zdenek
--
Zdenek Kotala Sun Microsystems
Prague, Czech Republic http:
MATCH
cs_CZ.ISO8859-2 ...- NO MATCH
english_uk.ISO8859-15 ...- NO MATCH
english_uk.8859 ...- NO MATCH
--
Zdenek Kotala Sun Microsystems
Prague, Czech Republic http://sun.com/postgresql
--
Sent via pgsql-bugs mailing list (pgsql
Heikki Linnakangas napsal(a):
Zdenek Kotala wrote:
The following code is in btreefuncs.c function GetBTPageStatistics:
stat->max_avail = BLCKSZ - (BLCKSZ - phdr->pd_special +
SizeOfPageHeaderData);
I think it should be:
stat->max_avail = BLCKSZ - (phdr->pd_special + SizeOfPa
s contained in this email or any
attachments.
--
Zdenek Kotala Sun Microsystems
Prague, Czech Republic http://sun.com/postgresql
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
The following code is in btreefuncs.c function GetBTPageStatistics:
stat->max_avail = BLCKSZ - (BLCKSZ - phdr->pd_special + SizeOfPageHeaderData);
I think it should be:
stat->max_avail = BLCKSZ - (phdr->pd_special + SizeOfPageHeaderData);
Zdenek
--
Z
could not reattach to shared memory napsal(a):
The following bug has been logged online:
Bug reference: 4389
Logged by: could not reattach to shared memory
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3-1
Operating system: any 8.3.*
Description:FATAL: co
.
Zdenek
--
Zdenek Kotala Sun Microsystems
Prague, Czech Republic http://sun.com/postgresql
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
-collation
Zdenek
--
Zdenek Kotala Sun Microsystems
Prague, Czech Republic http://sun.com/postgresql
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Lampa napsal(a):
The following bug has been logged online:
Bug reference: 4292
Logged by: Lampa
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3, 8.1.8
Operating system: Debian x86_64, Debian i686
Description:directory pg_clog never cleaned
Details:
Dire
If I understand correctly, Is version 8.0.0-rc1 bundled with MoteView? If yes
then I highly recommended to install 8.3.1 version. Version 8.0 is unsupported
on Windows platform now.
Zdenek
Yu Qun napsal(a):
hey:
I am the new one to use PostgreSql, when I install the MoteView includin
Tom Lane wrote:
My suspicion though is that you'll find that a large portion of that
page is damaged; that's usually what we've seen in such cases in the
past.
I think, It can happen only if corruption is less then TOAST chunk size. In
other case, page header or tuple header+chunk id should be
Karsten Desler wrote:
I don't know much about the postgres architecture and I don't know if bounds
checking on-disk values on a read makes a lot of sense since usually one
should be able to assume that there are no randomly flipped bits; but it
would've been nice to have a sensible log entry as
The first record ctid=(0,1) is obsolete, you can delete it. It is probably race
condition in VACUUM and catalog modification. Did you added or modified any user
account (e.g. password change) in related time? Please, can you let us know
exact version of PostgreSQL?
Zdenek
Kho
Try to look into base/16403/ directory and check if file 469917 exists. And run
select relname from pg_class where relfilenode=469917
to determine which relation (table) is affected.
Zdenek
PS: 8.1 version of PostgreSQL is not supported on win. Use 8.3
Boldinov napsal(a):
Roman Kononov napsal(a):
The following bug has been logged online:
Bug reference: 4114
Logged by: Roman Kononov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: x86_64 GNU/Linux
Description:Inconsistent shift operator
Details:
The below
[EMAIL PROTECTED] napsal(a):
I ran today a legacy application with PG 8.3.1 on a test machine.
The DB is some ~30 MB. Default tables do have OIDs and BLCKSZ is set
system-wide to 16384 (because of another DB).
Can you tried your application with standard BLKSZ? Or Can you send testcase?
A
Premysl Paska napsal(a):
The following bug has been logged online:
Bug reference: 4084
Logged by: Premysl Paska
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.15
Operating system: Linux
Description:Some DST timezones switche to summer time (one week)
later
Ronald Kuczek napsal(a):
The following bug has been logged online:
Bug reference: 4068
Logged by: Ronald Kuczek
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: Open SuSE 10.3
Description:Failed to compile 8.3.1
Details:
Compilation fro
.html#DATATYPE-FLOAT
It describes your problem.
Zdenek
Mirosław Marek napsal(a):
wv and wb are defined as double precision
Mirek
Zdenek Kotala pisze:
mirek napsal(a):
The following bug has been logged online:
Bug reference: 3991
Logged by: mirek
Email ad
mirek napsal(a):
The following bug has been logged online:
Bug reference: 3991
Logged by: mirek
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Linux fedora(for work) and windows(for development)
Description:pgsql function sum()
Details:
Alexandra Nitzschke napsal(a):
We went on with analyzing:
- the table was created at 2008/01/03 17:56h
- the nightly dump started at 2008/01/03 22:00h
- it tried to copy the table 'adresse_080103' at 22:00:08
- the dump crashed at 22:32:10 ( because of the error we reported
2007/12/14; we re
t error in December, we have updated postgres with the
patch provided by Zdenek Kotala.
We have had a look at the log files if an error message was written by
the catch-blocks of this patch.
But we haven't found any.
My patch only add page header control before write. It cannot catch this
p
gnp yadav wrote:
The following bug has been logged online:
Bug reference: 3941
Logged by: gnp yadav
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Ubuntu Linux
Description:Insert Error
Details:
CREATE TABLE sentence
(
sentence_id seri
e
I'm the first person to use the short opt, but thought it best to report it!
Cheers,
David
On 30/01/2008, *Zdenek Kotala* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
David Dunwoody wrote:
> The following bug has been logged online:
>
David Dunwoody wrote:
The following bug has been logged online:
Bug reference: 3913
Logged by: David Dunwoody
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.6
Operating system: SuSE 8.2.6
Description:pg_dump -T option not recognised
Details:
When running
Gregory Stark wrote:
"Zdenek Kotala" <[EMAIL PROTECTED]> writes:
I got dump of affected two blocks from Alex and it seems that both blocks were
overwritten together with some 128bytes length structure (there some pattern)
and complete damaged size is 9728bytes (first bloc
Zdenek Kotala wrote:
Zdenek Kotala wrote:
I got dump of affected two blocks from Alex and it seems that both
blocks were overwritten together with some 128bytes length structure
(there some pattern) and complete damaged size is 9728bytes (first block
is overwritten completely and second one
Zdenek Kotala wrote:
alex wrote:
WARNING: relation "transaktion" TID 1240631/12: OID is invalid
ERROR: invalid page header in block 1240632 of relation "transaktion"
7. 2007/12/10 : We started the export of the data ( which runs every
morning ) for the last days agai
alex wrote:
WARNING: relation "transaktion" TID 1240631/12: OID is invalid
ERROR: invalid page header in block 1240632 of relation "transaktion"
7. 2007/12/10 : We started the export of the data ( which runs every
morning ) for the last days again. These exports use the same
SQL-Commands as
[EMAIL PROTECTED] wrote:
I cant get core file now.
Can you recompile it as Heikki suggested? It seems more like compiler
bug and without core file/stack trace we are not able say more.
Zdenek
---(end of broadcast)---
TIP 5:
[EMAIL PROTECTED] wrote:
Dnia Wt Listopada 20 2007, 14:20, Simon Riggs napisał(a):
On Tue, 2007-11-20 at 11:46 +, Heikki Linnakangas wrote:
In logs after this:
Nov 20 11:02:04 www postgres[32757]: [4-1] wolni>NOTICE: CREATE
TABLE /
PRIMARY KEY will create implicit index "phpbb_acl_roles_
Michael Charnoky wrote:
2007-11-15 15:38:03.880 PST: ERROR: could not find block containing chunk
0x902fb98
This message appears in AllocSetFree or AllocSetRealloc function in
aset.c source. In both function it means that defined context does not
contain memory block. By my opinion there
RaviKumar.kapa wrote:
The following bug has been logged online:
Bug reference: 3754
Logged by: RaviKumar.kapa
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.1
Operating system: Windows2000
Description:postgresql+hibernate
Details:
I have the dought.i.e
Do you have a core file? Can you provide stack trace output?
Thanks
Michael Charnoky wrote:
The following bug has been logged online:
Bug reference: 3752
Logged by: Michael Charnoky
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3beta2
Operating syst
Tom Lane napsal(a):
So somehow src/test/thread/thread_test.c is missing from your source
tree. The only reason I've seen for that happening is when people
thought that they could download just the "base" tarball and not the
whole source distribution.
I found this problem as well when I verif
heasley wrote:
Thu, Nov 08, 2007 at 11:04:01AM +0100, Zdenek Kotala:
heasley napsal(a):
The configure is via NetBSD's pkgsrc system.
./configure --sysconfdir=/usr/pkg/etc/postgresql --datadir=/usr/pkg/share/po
stgresql --with-docdir=/usr/pkg/share/doc/postgresql --with-template=solari
heasley napsal(a):
The following bug has been logged online:
Bug reference: 3728
Logged by: heasley
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.10
Operating system: sparc-sun-solaris2.9 gcc-4.1.1
Description:pthread autoconf hangs
Details:
If the auto
Tom Lane wrote:
"sapna kapoor" <[EMAIL PROTECTED]> writes:
some tables are giving error :
ERROR: invalid page header in block 32655 of relation "" while
accessing.
Some are giving
ERROR: could not access status of transaction 1778384896
DETAIL: could not open file "pg_clog/06A0": No s
It seems that TAS(mutex) is not supported. Try to compile with
--disable-spinlocks, but performance will not be good.
I'm not sure if this file is in 7.4 version, but see
pgsql/src/backend/port/hpux/tas.c.template
Zdenek
Rajaram J wrote:
Hi
I'm having trouble building 64-b
Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
It's presumed that the right to create tables within a database entails
the right to create them someplace; hence no permissions check is made
on the database's default tablespace. Without that, not
Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
It seems that we not able to revoke create privilege on default tablespace.
This is intentional.
I don't understand why.
It's presumed that the
Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
It seems that we not able to revoke create privilege on default tablespace.
This is intentional.
I don't understand why. I did not find any mention about this in the
documentation. Please, could you
I try to revoke create privileges (PG8.2.4) on the default tablespace and I
found following strange behavior:
As superuser:
revoke create on TABLESPACE pg_default from u_test1;
As u_test1:
ns_test=> create table test_06 (id int) tablespace pg_default;
ERROR: permission deni
Zdenek Kotala wrote:
I looked on it, but I think let parser to fill namespace information in
ctx->relation structure should be better then do it in this place. There
is also unfilled istemp flag.
Ignore this. It is good place.
However, I think add following function into namespace.c
sho
Heikki Linnakangas wrote:
Zdenek Kotala wrote:
Jasen Betts wrote:
template1=# create temp table foo ( x text);
CREATE TABLE
template1=# alter table foo add column y text ;
ALTER TABLE
template1=# alter table foo add column id serial;
NOTICE: ALTER TABLE will create implicit sequence
Jasen Betts wrote:
The following bug has been logged online:
Bug reference: 3403
Logged by: Jasen Betts
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.0
Operating system: window XP (vmware)
Description:ver 8.2 can't add serial column to temp table,but 8.1
c
Murali Doss napsal(a):
The following bug has been logged online:
Bug reference: 3397
Logged by: Murali Doss
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.8
Operating system: Linux
Description:change the pg_setting
Details:
Dear All,
How to change the p
Murali Doss wrote:
Hi Michael,
Same database dump is there Solaris, Windows and Linux and the partial
search query is displaying the expected results in Solaris and Windows
OS but the query returning 0 row in Linux OS.
SELECT * FROM tablename WHERE colname BETWEEN 'B' AND 'B~';
Any query to f
Murali Doss wrote:
The following bug has been logged online:
Bug reference: 3394
Logged by: Murali Doss
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Linux
Description:Partial search not working
Details:
Dear All,
Partial search que
Volodymyr Kostyrko wrote:
Zdenek Kotala wrote:
I tested on Solaris AMD64 and Sparc v240 (64bit) and it works for me.
Do you use 32bit or 64bit version of postgreSQL and what you have in
.pgpass?
I use sparc64 and my .pgpass file was like:
localhost:5432:*:pgsql:password
Actually i have
I tested on Solaris AMD64 and Sparc v240 (64bit) and it works for me. Do
you use 32bit or 64bit version of postgreSQL and what you have in .pgpass?
Zdenek
Volodymyr Kostyrko wrote:
It seems to me that auth on the local interface(?) is broken somehow on
sparc64.
[data/pg_hba.c
Todd Frankson wrote:
I have not Tried PSQL.
I use PG Admin.
Forgive me as i am not familiar with Postgres as much as other
databases.
I open the Query tool from PGAdmin
Type Select X from y
Where Z
I get back only a Portion of a field that is Defined as "text".
In the PGAdmin, the Max. Retur
Todd Frankson wrote:
When selecting From a Text field that has 4096 characters in it, the query
tool only returns a few hundred characters, and exports maybe a hundred more
characters than the result set.
What happen if you do that in psql? Do you receive all data? And what
tool do you use -
John R Pierce wrote:
I just built a version of postgres 8.2.4 on Solaris 10 x86 ... a few
things that could be mentioned in INSTALL, and or in the Solaris notes
Solaris.FAQ is best place for it.
http://www.postgresql.org/docs/faqs.FAQ_Solaris.html
Solaris has a `crle` command that perfo
Sridhar Sourirajan wrote:
Is PostgreSQL supported on these UNIX platforms. When I go to
www.postgresql.org, I only see binary downloads for Linux and Win32. How about
for these other flavors of Unix? Thank you!
PostgreSQL is bundled with Solaris 10 (update 2 and newer). There also
project o
Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
I found following expression in md.c:
seekpos = (long) (BLCKSZ * (blocknum % ((BlockNumber) RELSEG_SIZE)));
There's no percentage in touching that code unless you intend to enable
the non-segmented behavior; which will pr
I found following expression in md.c:
seekpos = (long) (BLCKSZ * (blocknum % ((BlockNumber) RELSEG_SIZE)));
all variables and constants are int (32-bit) and long (also very often
32-bit). In case when somebody want to change RELSEG_SIZE to value
related to 4GB and bigger chunk he can expect d
Peter Eisentraut wrote:
Zdenek Kotala wrote:
There is Solaris FAQ update. Please, look on it and let me know any
comments.
The actual answer to the question "Can I compile PostgreSQL with
Kerberos v5 support?" is "Yes, why not?". I don't think "Can I use
this
There is Solaris FAQ update. Please, look on it and let me know any
comments.
Thanks Zdenek
Rich Teer wrote:
The following bug has been logged online:
Bug reference: 2969
Logged by: Rich Teer
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.2
Operating s
I work on it. It will be ready until Friday.
Zdenek
Bruce Momjian wrote:
I have not seen an updated patch for FAQ_Solaris yet.
---
Zdenek Kotala wrote:
Rich Teer wrote:
The following bug has been logged
Rich Teer wrote:
The following bug has been logged online:
Bug reference: 2969
Logged by: Rich Teer
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.2
Operating system: Solaris 10
Description:Inaccuracies in Solaris FAQ
Details:
Hi there,
First, many than
SAKAI Kiyotaka wrote:
I compiled PostgreSQL-8.2.0 on Solaris 8, but I cannot execute
binaries because it cannot find linked shared libraries, like
libgcc_s.so.
% cd src/interfaces/libp
% rm libpq.so*
% make
gcc -shared -h libpq.so.5 fe-auth.o fe-connect.o fe-exec.o fe-misc.o
fe
Дейтер Александр Валериевич wrote:
Hi,
PostgreSQL 8.1.5 have a problem with division by zero on sparc.
Solaris 9 sparc, gcc 4.0.2, 4.1.1:
$ ./configure --enable-thread-safety --disable-nls --without-perl
--without-python --without-krb5 --without-openssl --without-readline
...
I found that y
Andreas Lange wrote:
Zdenek Kotala wrote:
Main problem is -fast switch. It modifies behavior of floating point
operation (it is reason why It is not good option for postgres) and
use another floating point libraries and some function are inlined. It
is reason why pow test passed with -fast
Tom Lane wrote:
Andreas Lange <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
I suppose there is something funny about pow() on your platform
causing that probe to fail. What does config.log have at the
"checking for library containing pow" step?
configure:5168: checking for library containing p
Remy Beaumont napsal(a):
The following bug has been logged online:
Bug reference: 2651
Logged by: Remy Beaumont
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2 - beta 1
Operating system: Solaris 10 on T2000
Description:8.2 - beta 1 does now compile with Sun
[EMAIL PROTECTED] napsal(a):
Compiling PostgreSQL 8.1.4 under Solaris 10, I ran into a problem documented
back on 2006-05-30. Apparently in order to compile successfully, one has to
remove an unreferenced function pqsignalinquire() in
src/interfaces/libpq/pqsignal.c.
Since I stepped into th
Tom Lane wrote:
"John Weekley" <[EMAIL PROTECTED]> writes:
Platform is 64 bit Solaris x86.
...
"../../../../src/include/storage/s_lock.h", line 814: #error: PostgreSQL
does not have native spinlock support on this platform. To continue the
compilation, rerun configure using --disable-spinlocks.
77 matches
Mail list logo
