Does anyone have any instructions on how to compile any relatively recent verson of Postgres on OpenVMS 7.2?

Shield123321

06-03-2004 07:24 AM
Shield123321

How can I find out with a SQL query whether a column in a view is indexed? That is whether a column in a view is just a 'copy' of a column in a...

Martin Schäfer

06-02-2004 07:52 AM
Martin Schäfer

Hi, we're converting from mysql to postgres... Today I syncronize many databases using a "where" clause to get complete inserts to insert to other...

bobb

06-01-2004 07:09 AM
bobb

Hello dear newsgroup participants, I have some old proprietary database with following format for its entries: Instance of entry (some service...

Ariel.Burbaickij@web.de

05-30-2004 09:20 AM
Ariel.Burbaickij@web.de

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

Jeff Boes

05-27-2004 09:03 AM
Jeff Boes

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

Peter Paskoff

05-27-2004 03:19 AM
Peter Paskoff

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

Jared Evans

05-26-2004 12:30 PM
Jared Evans

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

Richard van den Berg

05-26-2004 08:53 AM
Richard van den Berg

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.

Tomasz Brzezina

05-25-2004 08:48 AM
Tomasz Brzezina

**** Post for FREE via your newsreader at post.usenet.com **** I am a newbie try to port my applications to Postgres. I have an application that is...

Tim Nelson

05-20-2004 09:42 AM
Christopher Browne

I am trying to use PostgreSQL 7.1 which came with the SuSe 7.3 distribution that I have. I am using documentation postgre.org. postmaster -D...

CARL BAINES

05-20-2004 09:22 AM
Tim Ashman

I vaguely remember seeing that PostgresSQL optimized selects on certain UNION ALL statements, so that given: CREATE VIEW orders AS SELECT '2003-01'...

Stacy White

05-19-2004 10:13 PM
Stacy White

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

w00t

05-19-2004 01:51 AM
w00t

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

Adam Kempa

05-18-2004 08:53 AM
Adam Kempa

Hello All, When trying to install postgresql 7.4.2 from source on mac os x 10.3, while running the configure command: /configure...

dennis

05-17-2004 04:12 AM
dennis

Hello, I would like an advise on the following problem : I have a table of patients. Each patient can make different biological assessments. Each...

Alain Reymond

05-04-2004 10:06 AM
Alain Reymond

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

Michal Kuna

04-29-2004 02:31 AM
Michal Kuna

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

Swish

04-27-2004 10:07 PM
Swish

I have a question that is pretty annoying..I am trying to connect over a network. I keep on getting 'missing or erroneous pg_hba.conf file' I can...

mfour

04-27-2004 09:27 AM
Jeff Boes

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

Ruslan A Dautkhanov

04-27-2004 04:46 AM
Ruslan A Dautkhanov

Everywhere I look I see NEGATIVITY and ASPHALT ...

outadirt@neomeo.com

04-25-2004 11:41 AM
outadirt@neomeo.com

Yow! We're going to a new disco!

blanktracks@neomeo.com

04-25-2004 12:51 AM
blanktracks@neomeo.com

..com Solutions Inc. has released FmPro Migrator 1.97 Enterprise Edition with a new FileMaker to PostgreSQL migration feature. Images within...

David Simpson

04-23-2004 09:08 PM
David Simpson

Can anyone help with why our pages are slow to load during peak-use hours? We run a database site getting 4 million hits a month which becomes...

John H

04-23-2004 06:50 PM
Christopher Browne

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

ptexql@neomeo.com

04-23-2004 04:19 PM
ptexql@neomeo.com

I am having a semaphore issue when running initdb. The FAQ and PAG didn't help. System data: AMD64 1G RAM 80G HD VIA Chipset Linux 2.6.1-gentoo...

Noah Roberts

04-23-2004 04:23 AM
ArtB

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

d2e2

04-06-2004 04:11 PM
d2e2

You might want to check the PgAdmin site ( http://www.pgadmin.org ) they have full source available. that would include some usable libraries. I...

GARY CARTAGENA

04-03-2004 05:26 PM
Adrian Parker

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

GARY CARTAGENA

04-03-2004 01:11 PM
GARY CARTAGENA

On 4 Mar 2004 15:57:31 -0800, Ayokunle Giwa <agiwa (AT) cox (DOT) net> wrote: See the subtle difference? apppointment/appointment -JFL

Jan Fredrik Leversund

04-03-2004 07:43 AM
Jan Fredrik Leversund

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

Tony Rice

03-07-2004 09:31 AM
Tony Rice

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

Gunjeet

03-04-2004 06:59 PM
Gunjeet

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

JustSomeGuy

03-03-2004 08:17 PM
JustSomeGuy

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

Chad

03-02-2004 04:22 AM
Chad

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

Jeff Boes

02-24-2004 02:50 PM
Jeff Boes

I am getting this error when I try to run a program in my cgi-bin directory (don't know what I'm still missing to make it work): *** Authentication...

Mike S. Nowostawsky

02-20-2004 04:24 PM
Mike S. Nowostawsky

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

John Small

02-14-2004 01:11 PM
John Small

Bonjour, Is there an embedded sql precompiler for MF Cobol for Postgres or such a project ? Regards. Alain

Alain Reymond

02-14-2004 09:35 AM
Alain Reymond

I'm new to postgresql and I'm having problems with the 'nextval' function (or whatever it is called in postgresql). I created a table (called...

Ivo Anon

02-12-2004 07:54 PM
Ivo Anon

I'm a PostgreSQL newbie and I had a quick question concerning a setup that I have. I current have three tables, a, b, and c. On my create...

Joe

02-09-2004 07:29 PM
Joe

Hi I'd like to ask you when (if ever) you predict to release native support for Windows. And what PostgreSQL version will be the first...

johnny1024

02-09-2004 04:54 AM
Tony Reina

Hi group - I'm using php to extract data from postgres and print to browser. I have data that was input through checkboxes on a form - each checkbox...

Hunter

02-08-2004 09:56 AM
mali_djuro

Is there a method to encrypt data on postgresql similar to SafeJDBC?

NagitaK

02-07-2004 10:42 AM
NagitaK

Hi, I wonder how this can happen. A "not null" field is set to "" even if a sequence should set this to next sequence number. Ok, I know it is not...

Axier

02-04-2004 02:39 AM
Unregistered

Ah obviously you need to check that execute priveliges are set .. root $ chmod +x...

Remi

02-04-2004 02:22 AM
Unregistered

My company is researching the idea of moving from a very large, old and complex UniData DB to something else that is newer and quicker. I was...

Ralph

01-24-2004 11:02 AM
Christopher Browne

Hello, I can set user varibales in postgresql (ALTER USER user SET search-path=$owner,public,other;) and I can reset. (ALTER USER user RESET...

Joan

01-23-2004 05:23 AM
Joan

I'm having trouble restoring databases that have to lo type installed in /contrib/lo. The dump seems to work just fine, I get no errors when I...

Sam

01-22-2004 10:18 AM
boyd

hi, i make programms with c# and i would like to know if there is an alternative to odbc(wich is not really fast) to dialog with...

thierry

01-21-2004 09:52 PM
Nunya

Hi, I'm a novice to postgress and need to constract a simple tree. In my table I have: regionID int parentID int name char I need to do two...

Liza

01-19-2004 04:45 PM
boyd