Re: [GENERAL] Mammoth replicator

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 Hosti

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

toring any card and card holder info, 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 suppo

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

h&oum l;rt? Der 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

specially to authenticate the connection. 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 Replicat

Re: [GENERAL] Newbee to databases (ODBC)

ill not work since I'm using "no" in the second statement 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 Kovalevsk

Re: [GENERAL] (un)grouping question

e other unique values 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, Consul

Re: [GENERAL] (un)grouping question

M mytable; ...if you don't need uid in the result set. Regards, Jeff Davis -- 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] 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 Postg

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 Postg

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] odbcng

Hello, This query works for me on Access 2003. Which versions of Access and ODBCng you have? We can communicate via [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] 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; 2

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 req

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, b

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] 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

[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 - http://pgfound

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 Files/PostgreSQL/8.2/bin/

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 SSL_PASSPHRASE=[str

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 e

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 s

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 f

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 be