Re: [GENERAL] Mammoth replicator

to replicate the whole DB). I'm I wrong on this? And finally a question related with the instalation: are there debian binaries to install replicator? TIA -- Andrei Kovalevski PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co

Re: [GENERAL] How to design a customer TABLE which hold credit card infos and other payments?

, and you definitely shouldn't keep in DB the whole data required to authorize transaction. Just take in mind how dangerous this info could be in case of security leak. -- Andrei Kovalevski PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated

Re: [GENERAL] [ODBC] Error in Adding All Table

kann`s mit allen: *http://www.produkte.web.de/messenger/?did=3123* -- Andrei Kovalevski PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

Re: [GENERAL] Connect to postgres from a dynamic IP

. Opening your access to everyone without crypto sounds like something you don't want to do. Specially if users can change their own passwords... Does anybody ever measured performance slowdown for SSL connections? -- Andrei Kovalevski PostgreSQL Replication, Consulting, Custom Development, 24x7

Re: [GENERAL] (un)grouping question

-- Andrei Kovalevski PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 1: if posting/reading through

Re: [GENERAL] (un)grouping question

in this column? ;) Regards, Jeff Davis ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- Andrei Kovalevski PostgreSQL Replication, Consulting, Custom Development, 24x7

Re: [GENERAL] Newbee to databases (ODBC)

to define the blob size, and no is not set yet. I could solve it by using 2 different select statemen (once for the size and one for the blob) but that seems to be a bad solution. Sorry again! /Paul -- Andrei Kovalevski PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Re: [GENERAL] postgresql 8.3rc1 on vista

suggestions? Thanks, Roger ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Andrei Kovalevski PostgreSQL

Re: [GENERAL] Windows x64 Port

Hello, Magnus Hagander wrote: Willem Buitendyk wrote: Is there any plan to port Postgresql to windows x64? I can currently run Postgresql as 32 bit inside Vista 64 - would I see better performance if Postgresql was running under 64 bit. My biggest concern is memory - at 32 bit is not

Re: [GENERAL] number errors

Hello, If you use ODBC - you should devide error from ODBC driver and errors from PostgreSQL, ODBC driver return it's own error codes, and composes error Description depending on Error Code and Text from PostgreSQL server. So you should have numbers: 1) ODBC error code - described in MSDN;

Re: [GENERAL] odbcng

Hello, This query works for me on Access 2003. Which versions of Access and ODBCng you have? We can communicate via [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]. I'll try to help you with any problems. Sam Mason wrote: On Tue, Nov 06, 2007 at 05:48:12PM -0300, Alvaro Herrera wrote: FYI

Re: [GENERAL] Npsql is much faster than ODBC ?

Rainer Bauer wrote: Alvaro Herrera wrote: Rainer Bauer wrote: Andrej Ricnik-Bay wrote: On Nov 7, 2007 2:40 PM, Rainer Bauer [EMAIL PROTECTED] wrote: That's nice to hear. But I respect licences as they are and the ODBCng driver is licenced under the GPL.

Re: [GENERAL] Windows vista

Hi! PostgreSQL win32 port works pretty well on Vista. You can find latest 8.2 binaries there: http://www.postgresql.org/ftp/binary/v8.2.5/win32/ Use installer from postgresql-8.2.5-1.zip

Re: [GENERAL] Installation problems

Hi! [EMAIL PROTECTED] wrote: Hi all. I post it again, not sure to have posted it correctly the last time. My problem is about installing PostgreSQL 8.2.3 on WIndows XP Mediacenter. At the end of the installation, I get the following error: unable to start the service. Administrator right

Re: [GENERAL] Fastest way to import only ONE column into a table? (COPY doesn't work)

Phoenix Kiula wrote: On 16/08/07, Richard Broersma Jr [EMAIL PROTECTED] wrote: --- Phoenix Kiula [EMAIL PROTECTED] wrote: On 16/08/07, Rodrigo De León [EMAIL PROTECTED] wrote: On Aug 15, 11:46 pm, [EMAIL PROTECTED] (Phoenix Kiula) wrote: Appreciate any tips, because

Re: [GENERAL] PG Admin

Bob Pawley wrote: Can anyone tell me why a table developed through the PG Admin interface isn't found by SQL when accessing it through the SQL interface?? Bob Pawley 1) Are you sure you are connecting to the same database? 2) What kind of SQL interface you are using? Andrei.

Re: [GENERAL] Error installing postgresql-8.2.4 on windows 2003 server

Hkrenske wrote: I have been successful in installing to Windows 2000 but when installing the binary installation “postgresql-8.2.msi” as a service, I receive the error The program postgres is needed by initdb but was not found in the same directory as C:/Program

[GENERAL] pgTray - win32 tray tool for monitoring PostgreSQL service

Hi all! Everyone who use PostgreSQL server on Windows knows - it would be nice to have some tray management and monitoring tool for PostgreSQL server which is running as NT Service (for example - MS SQL already have such tool). I have created a new project on pgfoundry -

Re: [GENERAL] pgTray - win32 tray tool for monitoring PostgreSQL service

Tony Caduto wrote: Andrei Kovalevski wrote: Hi all! Everyone who use PostgreSQL server on Windows knows - it would be nice to have some tray management and monitoring tool for PostgreSQL server which is running as NT Service (for example - MS SQL already have such tool). I have

Re: [GENERAL] odbc with encrypted ssl key?

Hi! You may try https://projects.commandprompt.com/public/odbcng/. This PostgreSQL ODBC driver's connection string can contain parameters you need: SSL_CERTIFICATE=[string] - path to SSL certificate file SSL_PRIVATE_KEY=[string] - your SSL private key

Re: [GENERAL] problems with SELECT query results

Joshua wrote: I checked the table and found that none of my fields in the SELECT statement contain NULLs. Any other suggestions? Why are you using such constructions in your query: ',' || ',' || ',' ? May be this set of commas makes you think that some of your fields are empty? Do you have

Re: [GENERAL] dns less connection

Hi! First of all, be sure you have PostgreSQL ODBC driver installed. To do this - follow: start -control panel - administrative tools - data sources (ODBC) - drivers If you see in a list PostgreSQL ANSI or PostgreSQL Unicode - this means driver is installed, otherwise - you should

Re: [GENERAL] C functions under windows

Islam Hegazy wrote: Hi all I have postgresql server installed on a windows machine and I want to retrieve data using C functions. I followed the steps in the documentation but it didn't work for windows. I created a .dll projects for my functions but postgres.h calls .h files that I can't

Re: [GENERAL] query from a list of ids

You can try this one. SELECT table2.* FROM (SELECT string_to_array(ids, ', ') FROM table1 WHERE name = 'Peter') AS a(a), (SELECT generate_series(1,array_upper(string_to_array(ids, ', '),1)+1,1)FROM table1 WHERE name = 'Peter') c(n),

Re: [GENERAL] SQLConnect failure

[EMAIL PROTECTED] wrote: Original Message Subject: Re: [GENERAL] SQLConnect failure From: Bill Moran [EMAIL PROTECTED] Date: Mon, April 02, 2007 2:54 pm To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org In response to [EMAIL PROTECTED]: We have code that has