Re: [GENERAL] Linking against static libpq using Visual C++

2011-03-31 Thread Julia Jacobson
Hi, Although I finally managed to build libpq using Visual C++, I'm continuously experiencing problems with this IDE. Therefore I switched to MinGW and it was indeed easy to compile libpq with it from the first time on. However, I'm experiencing the same problem as discussed on http://archives

Re: [GENERAL] Linking against static libpq using Visual C++

2011-02-27 Thread Julia Jacobson
Okay, I could fix it by myself now: One has to tell Visual C++ to ignore msvcrt.lib. A warning message during the compilation of my code already lamented a conflict between msvcrt and the included libraries. I should have taken it for serious instead of just ignoring it. So now everything works

Re: [GENERAL] Linking against static libpq using Visual C++

2011-02-27 Thread Julia Jacobson
My application looks like this: #include #include "libpq-fe.h" using namespace std; int main(void) { PGconn *conn; const char *info = "hostaddr = 'postgres.server.com' \ port = '5432' \ dbname = 'mydb' \ user = 'us

Re: [GENERAL] Linking against static libpq using Visual C++

2011-02-27 Thread Julia Jacobson
Thanks again for your answer. For all those experiencing similar problems, the missing libraries were: 1) ws2_32.lib 2) secur32.lib (for the SSPI functions) My code is compiled now without errors, but it seems to contain a buffer overflow. So there's still some work left for me ... On Sun, Feb

Re: [GENERAL] Linking against static libpq using Visual C++

2011-02-27 Thread Magnus Hagander
On Sun, Feb 27, 2011 at 18:01, Julia Jacobson wrote: > Thanks for your answer. I was indeed using the static libpq version from the > installer. > I tried to compile my own one with Visual Studio 2010, but this caused a lot > of problems due to the fact that Visual Studio 2010 has changed the mani

Re: [GENERAL] Linking against static libpq using Visual C++

2011-02-27 Thread Julia Jacobson
Thanks for your answer. I was indeed using the static libpq version from the installer. I tried to compile my own one with Visual Studio 2010, but this caused a lot of problems due to the fact that Visual Studio 2010 has changed the manifest tool. So I built a static version using Visual C++ 200

Re: [GENERAL] Linking against static libpq using Visual C++

2011-02-27 Thread Magnus Hagander
On Sun, Feb 27, 2011 at 15:40, Julia Jacobson wrote: > Dear PostgreSQL community, > > When trying to compile c++ code including libpq against the static version > libpq.lib, Visual Studio 2010 gives me the following errors: > I've built my libpq.lib with Visual Studio and added the include dire

[GENERAL] Linking against static libpq using Visual C++

2011-02-27 Thread Julia Jacobson
Dear PostgreSQL community, When trying to compile c++ code including libpq against the static version libpq.lib, Visual Studio 2010 gives me the following errors: 1>main.obj : error LNK2019: Unresolved external reference "__imp__exit" in Funktion "_main". 1>libpq.lib(fe-connect.obj) : error L

Re: [GENERAL] Linking pg_config (postgres 8.4 in SCO 5.0.7)

2009-12-08 Thread Tom Lane
erobles writes: > Hi i have been compiling the Postgres 8.4 on SCO OpenServer 5.0.7 but > when the pg_config is linking i got the next error: > Undefined > symbol > get_html_path Seems like you are somehow linking against a pre-8.4 version of src/port/path.c. How you managed to do that,

[GENERAL] Linking pg_config (postgres 8.4 in SCO 5.0.7)

2009-12-08 Thread erobles
Hi i have been compiling the Postgres 8.4 on SCO OpenServer 5.0.7 but when the pg_config is linking i got the next error: Undefined symbol get_html_path first referenced in file pg_config.o where can i find this function to make a success compiling of postgres??? by the way i search

Re: [GENERAL] Linking a Postgres table on Linux to Ms Access

2007-01-25 Thread Joshua D. Drake
codeWarrior wrote: > go in the other direction... Convert your table in MS Access to use a > pass-through query to the postgreSQL table. Connect yoour MS Access pass > through table to postgreSQL using OBBC. > > Even better: Drop MS Access completely and just use postgreSQL. Access is a > total

Re: [GENERAL] Linking a Postgres table on Linux to Ms Access

2007-01-25 Thread codeWarrior
go in the other direction... Convert your table in MS Access to use a pass-through query to the postgreSQL table. Connect yoour MS Access pass through table to postgreSQL using OBBC. Even better: Drop MS Access completely and just use postgreSQL. Access is a totally inferior technology. ""car

[GENERAL] Linking a Postgres table on Linux to Ms Access

2007-01-25 Thread carter ck
Hi all, Is there any way that I can synchronize a table in Postgres on Linux with another table in Ms Access? The requirement of the assignment is as following: In postgres, there is a table called message_received. Whenever we insert, update or edit this table, the table in Ms Access should

Re: [GENERAL] Linking tables and indexes

2007-01-15 Thread Jorge Godoy
Alvaro Herrera <[EMAIL PROTECTED]> writes: > If you're in 8.1 or better, I'd suggest defining only two indexes, one I'm on 8.1. Waiting for SuSE to update to 8.2... ;-) > on (ci_id) and other on (document_client_id), and let the system deal > with mixing them using the bitmap scan technique w

Re: [GENERAL] Linking tables and indexes

2007-01-15 Thread Alvaro Herrera
Jorge Godoy wrote: > Thinking about how PostgreSQL is able to use composed indices should I create > the reverse index ("CREATE INDEX something ON ged.documents_clients_cis > (document_client_id, ci_id)") or I'd only be wasting disk and processing? > > The query can be done from either side (i.e.

[GENERAL] Linking tables and indexes

2007-01-15 Thread Jorge Godoy
Hi! I'm not sure about the English terminology for that so I'm sorry if I made a mistake on the subject and on this message. I hope de code explains it better if I missed it :-) I have some tables that will have N:M relationships between themselves and for that I created some linking tables su

Re: [GENERAL] Linking Tables from 2 databases

2006-07-19 Thread Merlin Moncure
On 7/19/06, Pratik Shukla <[EMAIL PROTECTED]> wrote: I have created a DB1 with several tables. Now i need to create another DB2 with a linked table from DB1. So if there is a table_X in DB1, is there a way to import that table_X into DB2 so that any changes made to table_X in DB1 will also apply

Re: [GENERAL] Linking Tables from 2 databases

2006-07-19 Thread Richard Broersma Jr
I have created a DB1 with several tables. Now i need to create another DB2 with a linked table from DB1. So if there is a table_X in DB1, is there a way to import that table_X into DB2 so that any changes made to table_X in DB1 will also apply to DB2? table_X has references to other tables in D

[GENERAL] Linking Tables from 2 databases

2006-07-19 Thread Pratik Shukla
Hello,   I have created a DB1 with several tables. Now i need to create another DB2 with a linked table from DB1. So if there is a table_X in DB1, is there a way to import that table_X into DB2 so that any changes made to table_X in DB1 will also apply to DB2?   table_X has references to other tabl

Re: [GENERAL] linking temporary tables from MS Access?

2006-01-17 Thread Tony Caduto
Zlatko Matić wrote: Is it possible to use temporary tables from MS Access, as linked tables? I was not able to link, but maybe someone succeeded? It should work if you can do it all in the context of a single connection, but if it does not, just roll your own temp table, create one on the fly

[GENERAL] linking temporary tables from MS Access?

2006-01-17 Thread Zlatko Matić
Is it possible to use temporary tables from MS Access, as linked tables? I was not able to link, but maybe someone succeeded?

[GENERAL] Linking

2005-11-02 Thread Bob Pawley
I very much wish to thank Oliver and Michael for their help in getting started. I was scratching around the edges of trigger functions without being able to put everything in its proper place.   I now have a way of moving forward with some glimmer of eventually knowing what I am doing.   Than

Re: [GENERAL] Linking

2005-11-01 Thread Michael Fuhr
On Tue, Nov 01, 2005 at 02:22:07PM -0800, Bob Pawley wrote: > On data entry I want the serial number generated in process.fluid_id > to be transferred to column specification.fluid_id. This sounds like the same thing you asked last week. Was the example in the following message not helpful? Did

Re: [GENERAL] Linking

2005-11-01 Thread Oliver Elphick
On Tue, 2005-11-01 at 14:22 -0800, Bob Pawley wrote: > I have created the following tables. > CREATE TABLE process > ( > process_name varchar(60) NOT NULL, > fluid_id serial NOT NULL, > fluid varchar(30) NOT NULL, > ip_op_reactor varchar(3), > source varchar(30), > destination varchar(

[GENERAL] Linking

2005-11-01 Thread Bob Pawley
I have created the following tables.   First Table -   CREATE TABLE process (   process_name varchar(60) NOT NULL,   fluid_id serial NOT NULL,   fluid varchar(30) NOT NULL,   ip_op_reactor varchar(3),   source varchar(30),   destination varchar(30),   CONSTRAINT process_pk PRIMARY KEY (flu

[GENERAL] linking problems with Kerberos (heimdal) on FreeBSD

2005-10-15 Thread Palle Girgensohn
Hi! I'm having some difficulties using postgresql version 8.0.x with heimdal installed from /usr/src (i.e. the base system). This is on FreeBSD-5.x. When using the port of heimdal, from /usr/ports/security/heimdal, it works. The port install into /usr/local, whereas the base system is in /usr

Re: [GENERAL] linking access using ODBC driver with geometric data

2005-08-07 Thread Jeff Eckermann
"Jeff D. Hamann" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Sorry for the seemingly novice posting, but I could find a solution for > this on the web so far... > > I've been developing a database using postgresql (and loving it) and have > started running into problems with attem

Re: [GENERAL] Linking question

2004-10-23 Thread Michael Fuhr
On Thu, Oct 21, 2004 at 09:26:30AM +0300, Katsaros Kwn/nos wrote: > > I want to make use of some contrib/dblink functions inside my user > defined functions, e.g. I would like to be able to call dblink_record() > from my user defined code in this way: > > dblink_record("param1","param2"); > > I

[GENERAL] Linking question

2004-10-20 Thread Katsaros Kwn/nos
Hi, I want to make use of some contrib/dblink functions inside my user defined functions, e.g. I would like to be able to call dblink_record() from my user defined code in this way: dblink_record("param1","param2"); Is this possible? I would like to avoid: 1) inserting all the dblink code in

Re: [GENERAL] linking postgre to AD

2003-11-21 Thread Mike Mascari
Jason Tesser wrote: > I saw that there is a PAM module for Postgre. Just out of curiosity, where did you get the notion that the shorthand for PostgreSQL is "Postgre" and not "Postgres" ? Marc, would it be possible to have a TIP that reads: "Postgres + SQL = PostgreSQL" In fact, could you use

Re: [GENERAL] linking postgre to AD

2003-11-21 Thread Bruno Wolff III
On Fri, Nov 21, 2003 at 07:13:46 -0600, Jason Tesser <[EMAIL PROTECTED]> wrote: > > If I did that could I use a table in Postgre as a groups table so I can control > who can go where or who can see what in a web app? I was wondering if Postgre > had some built in functions that could help me

Re: [GENERAL] linking postgre to AD

2003-11-21 Thread Jason Tesser
Hi, On Fri, Nov 21, 2003 at 06:27:01AM -0600, Jason Tesser wrote: > I am looking into using PostgreSQL on the backend here. I work for a Bible College. > We are putting together a > new software package. The database would be on a LInux box but our domain is M$ so > we use active > directo

Re: [GENERAL] linking postgre to AD

2003-11-21 Thread Alex Page
On Fri, Nov 21, 2003 at 06:27:01AM -0600, Jason Tesser wrote: > I am looking into using PostgreSQL on the backend here. I work for a Bible College. > We are putting together a > new software package. The database would be on a LInux box but our domain is M$ so > we use active > directory. I

[GENERAL] linking postgre to AD

2003-11-21 Thread Jason Tesser
I am looking into using PostgreSQL on the backend here. I work for a Bible College. We are putting together a new software package. The database would be on a LInux box but our domain is M$ so we use active directory. I saw that there is a PAM module for Postgre. My question is with applic

Re: [GENERAL] Linking Postgresql OBDC via C

2000-09-15 Thread Jan Wieck
Jim Jennis wrote: > Hi Postgres colleagues, > > Sorry if this is a re-post, but it did not show up on the list (at least in > my mailbox) so I am posting it again. > > I am running a 3rd party development tool on Linux (Verastream from WRQ) > that has an open C API for multi-database connectiv

[GENERAL] Linking Postgresql OBDC via C

2000-09-15 Thread Jim Jennis
Hi Postgres colleagues, Sorry if this is a re-post, but it did not show up on the list (at least in my mailbox) so I am posting it again. I am running a 3rd party development tool on Linux (Verastream from WRQ) that has an open C API for multi-database connectivity. It transparently supports

Re: [GENERAL] Linking legacy PHP stuff

2000-08-19 Thread Simon Brooke
Tom Lane wrote: > > Simon Brooke <[EMAIL PROTECTED]> writes: > > curr_conn = result->conn; > > if ((curr_conn == NULL) && (pgTypeRes==0)) { > > Get rid of curr_conn and the ensuing test on same, is my advice. > This code should never have been reaching inside PGresult to begin >

Re: [GENERAL] Linking legacy PHP stuff

2000-08-18 Thread Tom Lane
Simon Brooke <[EMAIL PROTECTED]> writes: > curr_conn = result->conn; > if ((curr_conn == NULL) && (pgTypeRes==0)) { Get rid of curr_conn and the ensuing test on same, is my advice. This code should never have been reaching inside PGresult to begin with...

Re: [GENERAL] Linking legacy PHP stuff

2000-08-18 Thread Tom Lane
Lamar Owen <[EMAIL PROTECTED]> writes: > At 6.4, there was a protocol change that renders clients for libpq > version 1 incapable of connecting or using servers using protocol > version 2. Thus, unless you want to do surgery on PHP/FI 2, you will > have to stick with PostgreSQL 6.3.2 or earlier.

[GENERAL] Linking databases

1999-03-20 Thread Robert McArthur
Hello All, Is there any way to access tables in one database from another database on the Postgresql server? Thanks, Rob McArthur