Re: [BUGS] Compiling problem on Solaris

2006-12-14 Thread Tom Lane
SAKAI Kiyotaka <[EMAIL PROTECTED]> writes: > I think the following patch is needed, so that LD_RUN_PATH is also > passed to -R option. Hmm ... this puts the build-time LD_RUN_PATH into the executables, which doesn't seem very appropriate --- rpathdir is the correct thing IMHO. Also, what happens i

Re: [BUGS] Compiling problem on Solaris

2006-12-14 Thread Zdenek Kotala
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

Re: [BUGS] execute incorect query and get data

2006-12-14 Thread Tom Lane
=?ISO-8859-2?Q?Marek_Wr=F3bel?= <[EMAIL PROTECTED]> writes: > create table a (a1 integer); > create table b (b1 integer); > insert into a (a1) values (1); > insert into a (a1) values (2); > select a1 from b; > ERROR: column "a1" does not exist at character 8 > but : > select a1 from a where a1 not

[BUGS] execute incorect query and get data

2006-12-14 Thread Marek Wróbel
PostgreSQL : 8.2 Operating system: fedora RC4 create table a (a1 integer); create table b (b1 integer); insert into a (a1) values (1); insert into a (a1) values (2); select a1 from b; ERROR: column "a1" does not exist at character 8 but : select a1 from a where a1 not in (select a1

[BUGS] BUG #2825: Installation doesnt let me create username

2006-12-14 Thread Josh
The following bug has been logged online: Bug reference: 2825 Logged by: Josh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows XP Description:Installation doesnt let me create username Details: When i try to install a postgres as a

Re: [BUGS] postgresql installation on centOS not working

2006-12-14 Thread Danish Siddiqui
Tom Lane wrote: Heikki Linnakangas <[EMAIL PROTECTED]> writes: Danish Siddiqui wrote: it configures and shows statements that its creating the make file and checking all the dependencies..but then when I do #make it again starts checking for all the dependencies and this keeps on repe

[BUGS] ERROR: could not access status transaction #####

2006-12-14 Thread Jorge . De-Pauw
Dear, I would like to call on your assistance with regards to the following error I'm receiving in a PostgreSQL database: When creating new objects in PostgreSQL, after queries or when a VACUUM is launched the following error appears: ERROR: could not access status transaction # DETAIL: coul

Re: [BUGS] BUG #2645: pg_restore crashes

2006-12-14 Thread Andrew MacLeod
I observed this symptom with a 4Mb .backup file (details of commands issued below). The restore always failed at the same rogue table. On going back to the source DB, I experienced trouble on that table: vacuum worked, but vacuum FREEZE hung after which SELECT count(*) hung! In my case, the "w

[BUGS] Compiling problem on Solaris

2006-12-14 Thread SAKAI Kiyotaka
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-print.o fe-lobj.o fe-pr

Re: [BUGS] the bug report form doesn't accepts the email address

2006-12-14 Thread Magnus Hagander
Gergely CZUCZY wrote: hello the bug reporting form on the website does not accept any valid email address i fill it with. http://wwwmaster.postgresql.org/system/handleform.php i had tried [EMAIL PROTECTED]'' and [EMAIL PROTECTED]''. both are valid, working email addresses. Bye, Gergely Czuczy