PostgreSQL Database Forum

I want to use PostgreSQL on a project that will have to run on both Linux and Windows. But using cygwin is not a viable option. Does the dbExpert version of PostgreSQL run natively under Windows? Thanks in advance! John

Yow, there's got to be an easier way to do this ... I'm trying to create a script file that will process a table whose name is constructed from an integer argument passed into the script file. E.g., $ psql -f my_script.sql -v id=24 .... DELETE FROM table_00024 WHERE ... Here's what I came up with so far:

Hi Wondering are there internal API layers within the Postgres server ? Looking for some way to directly cursor through indexes. Chad

I have a database that should be quite simple to do. I have a base object that is easily defined as create table myObject ( a integer, b integer, len integer, data bytea

Hi, I could only find support for defining functions in pl/pgsql. With a function I can have only one return value. What if I need to have multiple OUT parameters (i.e multiple return values) ? Is there any support for something that is similar to an Oracle stored procedure ? I understand that I can return a REFCURSOR from a postgres...

All the time, timestamp and datetime fields are producing some unexpected results. When I insert a row, assigning NOW() to a field of those types, it's showing up in the PST timezone. My ISP is in the EST timezone and when I look at the timezone of the server where mySQL is installed is showing up in UTC. When I query this table, is...

Anyone have any experience or suggestions where to look for tools, libraries etc that can take an XML template (xslt or xsdl) and create a table structure from the XML template definition? I have seen tools to do this in the microsnot world. I am runn PostgreSQL 7.x on linux. I have been doing db admin using PgAdminIII on Win 2k... ...

I cannot get the server to start on Mandrake 9.2. I've looked through the logs but cannot find anything to give a hint as to what the problem might be. If anyone has information of any kind I would like to hear from them. Thanks.

My BIOLOGICAL ALARM CLOCK just went off ... It has noiseless DOZE FUNCTION and full kitchen!!

..com Solutions Inc. has released FmPro Migrator 1.97 Enterprise Edition with a new FileMaker to PostgreSQL migration feature. Images within FileMaker container fields are automatically migrated to PostgreSQL 'lo' (large object type) columns. Improvements have also been made to the existing FileMaker 7 table consolidation feature. The latest...

Yow! We're going to a new disco!

Everywhere I look I see NEGATIVITY and ASPHALT ...

Hello ! I have complex system, which use PostgreSQL as a storage. Web-interface use Apache+mod_perl, Pg.pm for connection. I also have kernel of the system written in C++, which works as a UNIX daemon and process request from frontend mod_perl scripts. In some cases it needs to share transaction along the forntend script and kernel...

I have multiple workstations which I need to Add Local Printers too. PRINTER 1 = LPT1 PRINTER 2 = LPT2 PRINTER 3 = LPT3 All the LPT ports are redirected to print from the server. As of right now, I am manually adding each printer to each machine. I am looking for a sample script that will add the printers for me. All my machines are Windows...

Hi all, I have pg-server 7.4 running on mdk linux. Clients are using a php-gtk based application to communicate with db. I have noticed a very strange behaviour of the postgres server. Sometimes it "hangs" during the query (the query itself is quite simple and does not manipulate a lot of data). The client "freezes" waiting for the server...

Hello, I would like an advise on the following problem : I have a table of patients. Each patient can make different biological assessments. Each assessment is always decomposed into different laboratory tests. A laboratory test is made of a test number and two values coming from analysers.

Hello All, When trying to install postgresql 7.4.2 from source on mac os x 10.3, while running the configure command: /configure --with-includes=/sw/include/ --with-libraries=/sw/lib i got the following error message: checking for C compiler default output... configure: error: C compiler

Hello I've been installed Postgres 7.4.2 on FreeBSD system and when load average grow up i've error in postgres like this: ERROR: permission denied for function varchar ERROR: permission denied for function varchar and then postgres crashes. LOG: server process (PID 9787) was terminated by signal 11

I am running Suse 9.0 and have been working with postgresql 7.3.3 When I run psql as psql -v or psql -V and even psql --help I get a relocation error psql: relocation error: /usr/lib/libreadline.so.4: undefined symbol: BC Is there anyway to fix this with out reinstalling postgresql. Thanks,

does any body use it? I'd like to use it, but the crypt in database is different with crypt used in pam_pgsql.... -- T.

I was looking for a way to cast hex numbers (stored in a varchar column) to int. I found many people asking the same thing, but no answers. It seems that this is supported by the following syntax select x'1f'::int; Since this doesn't work with variable values, I wrote this following function. Perhaps it will help anyone wanting to do...

Hi, I don't have a problem but need to know exactly what is going on: I am able to ssh into the server running Postgresql then set display:0.0 to my machine in order to run and view the pgaccess X app on my desktop. Does this mean that the pgaccess connection is ssh-protected (encrypted)?

at first - can´t change the server version, so i have to live with the limitations of the version. since there is no ability to create queries between different databases in this version - how can i cover my problem described below? i guess, one part of the solution is to use pgdump, but how to continue?

Can anyone explain why this happens? (under 7.4.1) select '2004-05-27 09:00:00.500001-04' :: timestamp(0) ; timestamp --------------------- 2004-05-27 09:00:01 select '2004-05-27 09:00:00.500000-04' :: timestamp(0) ;

Hello dear newsgroup participants, I have some old proprietary database with following format for its entries: Instance of entry (some service information like table number and position) ^M (newline) 1 Parameter: Value ^M (newline) 2 Parameter: Value ^M (newline) 3 Parameter: Value ^M (newline)