Hello!
I would like to get more flexible tool for database management that EMS of
pgadmin. So now I'm trying to use PD 15 with Postgres 8.4.1. It's very exciting
:)
So what can I say?
It seems to be there are no problems with tables, sequences, FK... But there
are some difficulties with:
1. St
Hello!
I need PG 8.4 built from source code for WinXP. So I got archive
postgresql-8.4.1.tar.gz, unpacked it and built postgres by MinGW, as usual:
configure --witout-zlib
make
make install
Everything seeds to be fine until we tried to test pg_dump. It failed (not
always but often).
Command:
p
> 2009/9/15 el dorado :
> > Hello!
> > I need PG 8.4 built from source code for WinXP. So I got archive
> > postgresql-8.4.1.tar.gz, unpacked it and built postgres by MinGW.
> > Everything seeds to be fine until we tried to test pg_dump. It failed (not
> &g
> Hello!
> Thank you very much for your answer. I try to use gdb now. But there is a
> little difficulty. I'm not quite sure it is connected with postgres build.
> Probably I do something wrong using gdb but maybe you could show me the
> direction for resolving the problem?
> I built PostgreSQL
Лучшие предложения интернет-магазинов на Това�...@mail.ru
http://r.mail.ru/cln4267/torg.mail.ru/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: el dorado
To: pgsql-general@postgresql.org
Date: Fri, 18 Sep 2009 15:24:24 +0400
Subject: [GENERAL] Build PG 8
Sorry, the previous letter was sent by mistake.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Hello!
I need to build PG 8.4 from sources for WinXP. There are two ways to do it: by
means of MinGW of by means of MSVC. Firstly I used MinGW (gcc), but
unfortunately I noticed some problems with result biniries (f.e.
http://archives.postgresql.org/pgsql-general/2009-09/msg00526.php).
What is r
> > What is recommended now for building PG 8.4 for WinXP? Is it better to use
> > MSVC compiler?>
> MingW is perfectly supported, and we know people use it.
> MSVC is the recommended one I'd say, mainly because that's how the
> official binaries are built, so the results are much more well-test
> > > What is recommended now for building PG 8.4 for WinXP? Is it better to
> > > use MSVC compiler?>
> Regards, Marina.
>
> > MingW is perfectly supported, and we know people use it.
> > MSVC is the recommended one I'd say, mainly because that's how the
> > official binaries are built, so the
Hello.
I had such an error but rather long ago. Unfortunately I don't remember all the
details but you could try to do the followig:
- check if the directory 'data' has read/write rights for your OS account
(account under which you try to start postgres).
- check if your OS account has the right
Hello!
I have user-defined procedure (C procedure) realised in dll
('c_some_text_dll'). It is called in the following way:
1. CREATE OR REPLACE FUNCTION "app_text" () RETURNS text AS
'$libdir/c_some_text_dll', 'getTextValueFromApplication'
LANGUAGE 'c' VOLATILE RETURNS NULL ON NULL INPUT SECURITY
Hello!
I use Postgres 8.4.1 as service, with Windows 7. It seems to me the same
situation will take place with Vista.
I've notice that in some special cases PG uses folder %APPDATA% for Windows
user 'postgres', instead of the PostgreSQL-specific application data folder
(f.e., C:\PostgreSQL\8.4\
> > I've notice that in some special cases PG uses folder
> > %APPDATA% for Windows user 'postgres', instead of the
> > PostgreSQL-specific application data folder (f.e.,
> > C:\PostgreSQL\8.4\data). It results in some unexpected bugs.
>
> Could you please be more specific in describing what
Thank you, Andrew, it's very interesting and cognitive article.
Though it couldn't resolve my problem now. It looks like recommendations -
where to put your application data. But I put my data in some definite location
and postgres looks for it in another one - that's the strangeness of situatio
Hello!
I'd like to write C-function returning text for using in PG 8.3.3. (WinXP SP2)
For compilation I use MinGW-5.1.4 (gcc 3.4.5),MSYS-1.0.10.
The code looks like this (in reduced variant):
#include "postgres.h"
#include "fmgr.h"
#include "executor/executor.h"
#include "utils/timestamp.h"
#incl
I download ready binaries from
http://www.postgresql.org/ftp/binary/v8.3.3/win32/
(postgresql-8.3.3-1-binaries-no-installer.zip)
So I didn't know exactly which compilier was used.
Are these binaries built by means of MSVC?
Regards, Marina.
> el dorado <[EMAIL PROTECTED]> writes:
&
Hello!
Is there any opportunity to find out what compilier is used to build standard
binaries from http://www.postgresql.org/ftp/binary/v8.3.3/win32/
(postgresql-8.3.3-1-binaries-no-installer.zip
MSVC or MinGW(gcc)?
I have some problems with C-procedures compilation (PG 8.3, WinXP). I've got
the
Hello.
I'm trying to create a C-procedure returning text variable - again :).
Postgres 8.3.3 (standard binaries - so built by means of MSVC), WinXP SP2.
I also use MSVC 2005 for compilation my library.
Configuration type - Dynamic Library (.dll)
Additional include directories -
D:\pgsql83\include;
Hello.
Thank you very much for your answer.
I found an option "Configuration Properties\C/C++/General/Detect 64-bit
Portability Issues". It was set to 'Yes'. I made it 'No'.
Now I don't get these warnings about 'type cast'.
The result:
1>Compiling...
1>getstring.c
1>d:\pgsql83\getstring\
ard binaries - so built by means of MSVC), WinXP SP2.
Error while using the function in PG - invalid memory alloc request size
4294967293
It seems to me I must change some other options in Configuration Properties -
but I can't guess what exactly...
Or maybe I should use Visual S
se the FULL version for
compilation at all - only express edition?
By the way - there is a directory 'D:\pgsql83\include\server\port\win32_msvc'.
But I can't use it instead of 'D:\pgsql83\include\server\port\win32' (should I
?) - there is an error due to lack of file 'n
21 matches
Mail list logo
