Hi, I have been trying to install Website Replicator 5.17 (WSR) on my server and am having a bit of trouble. Some tables that the script...

Sergio L. Garza M.

12-31-2003 04:59 PM
Sergio L. Garza M.

Hi, with PostgreSQL 7.3.4 the command 'vacuumdb --all --analyze' had the following output for my databases: Vacuuming addr VACUUM Vacuuming...

Olaf Ferger

12-29-2003 01:44 PM
Olaf Ferger

Hi!... Normally, there is only one attribute for the primary key but in my table, my primary key is composed of two attributes. How do I state this...

Peggy Go

12-29-2003 12:43 PM
Casey Allen Shobe

I'm using PostgreSQL 7.4, and I have two tables, which I created as follows: CREATE TABLE needlestyle ( needle_style_id ...

Lola Lee

12-27-2003 07:03 AM
Lola Lee

Hello, Could somebody tell me when and how to use pgsql system catalog tables (those start with pg_)? I read the chapter 43, and know they store...

LIANHE SHAO

12-26-2003 01:34 PM
LIANHE SHAO

Hi, I'm trying to create a time format string for strptime (GNU, FWIW) that will parse an unmodifed timestamptz string. No luck with Google yet. In...

Paul Makepeace

12-26-2003 11:18 AM
Tom Lane

Hi I have updated my RedHat Linux installation to v 9.0, and now run Postgres-7.0.3-8 and Perl-5.8.0-88. I am trying to install v 1.9.0...

Peter Grossi

12-26-2003 06:09 AM
Peter Grossi

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, for development of a installation script I want a PL/pgSQL script that cleans up a database...

Thiemo Kellner

12-25-2003 04:32 AM
Thiemo Kellner

Tom Much-delayed thanks for pointing me to directions on how to handle multiple installations. Tom Lane posted: I just got my new machine and...

Michael Glaesemann

12-24-2003 08:52 AM
Michael Glaesemann

Tom Much-delayed thanks for pointing me to directions on how to handle multiple installations. Tom Lane posted: I just got my new machine and...

Michael Glaesemann

12-24-2003 08:45 AM
Michael Glaesemann

Hello to the whole list, is possible to save a file (PDF) in the database as blob object? Which kind of field should I use to achieve...

Luca Ferrari

12-23-2003 01:52 PM
Marcin Gil

Same problem I reported earlier. I have a column declared as PK but PostgreSQL 7.4 allowed it to create entries with the same key.. Schemas,...

Marcin Gil

12-23-2003 11:29 AM
Marcin Gil

I know that PostGres can do about half of this, what I want to know is whether the other half is possible. We are setting up a postgres database on...

d.kelly@maxfordham.com

12-23-2003 09:20 AM
d.kelly@maxfordham.com

Hi There: I am brand new to PostgreSQL and currently living in India. I would like to download latest version of PostgreSQL. Could you please let me...

darbinj@npd.hcltech.com

12-23-2003 03:28 AM
Marek Lewczuk

"Matthew Rudolph" <mrudolph (AT) zetec (DOT) com> writes: You're more or less out of luck on this, because that is not the behavior that SQL...

Tom Lane

12-22-2003 05:27 PM
Tom Lane

Is there a table that contains info about the data/index files of a postgresql db, such as filename, bytesize, etc?? I'm looking for something...

Chris

12-22-2003 04:14 PM
Bruce Momjian

I was wondering if postgres generates any logs. If so where are they. Or does it have to be told to make them. If this is the case what do i have to...

Chris

12-22-2003 01:14 PM
Matt Lynch

Hi, Is their equivalent to SQL Servers xp_cmdshell that can be called in plpsql or plperl function? Michael Godshall GMAC Global Relocation ...

Godshall Michael

12-19-2003 11:09 PM
joseph speigle

Hi, I recently got a dedicated server at Rackspace.com that came with PostgreSQL server version 7.1.3 installed. I am installing a script that...

Sergio L. Garza M.

12-19-2003 10:26 AM
Tom Lane

Is there a way to issue select .. like to ignore letter case? Or do I have to use full text indexing? Regards, -- Marcin Gil marcin.gil @...

Marcin Gil

12-19-2003 04:59 AM
Marcin Gil

Hi all Running postgres under RedHat9, I moved the /tmp partition to / and copied the /usr into a much larger one in order to get more disk space...

Patrice Durosay

12-19-2003 04:23 AM
Patrice Durosay

novices! I have succeeded in making accessing my www passwords easy from the shell. I store the passwords in a postgresql table, and use the bash...

joseph speigle

12-18-2003 04:31 PM
joseph speigle

Hi! Im just new to pgsql. I'm trying to use pqxx since the program that I'll be doing is in C++. I'm using Redhat Linux 9.0 and using KDevelop for...

Peggy Go

12-18-2003 12:46 AM
joseph speigle

I am trying to convert a driver for dspam from mysql to postgres. In the files I have they are useing mysql.h. Is there a similar library for...

Chris

12-17-2003 04:32 PM
Michael Fuhr

Hi, could somebody tell me what I'm missing here? Postgres appears to not know where to look for the table I am using in my SELECT INTO clause...

joseph speigle

12-17-2003 12:54 PM
joseph speigle

I would like to be able to deny client applications access to tables, and insulate the database through an api of functions. Updater, inserter...

Gerard Mason

12-16-2003 08:30 PM
Gerard Mason

Hi, When I query the pg_stat_all_tables view all I get back is 0's. How can I tell if the statistics collector is running? I have the param's set...

Michael Guerin

12-16-2003 01:15 PM
Michael Guerin

I would like to be able to deny client applications access to tables, and insulate the database through an api of functions. Updater, inserter...

Gerard Mason

12-16-2003 09:28 AM
Tom Lane

Hi! Using PHP, Pear::DB i managed to put duplicate entries on a primary key column. My PostgreSQL version is 7.4 self compiled, running on Slackware...

Marcin Gil

12-16-2003 03:43 AM
Marcin Gil

Is there a way to set up a disk size (data size maybe) on postgresql databases (files)? How to recognize which directory is connected to a certain...

Marcin Gil

12-16-2003 03:17 AM
Marcin Gil

Friends In my machine none of the header files coming with postgresql are present. So if u have the header files libpgeasy.h and libpg-fe.h please...

Manu M P

12-16-2003 12:54 AM
Manu M P

Hi, In the past few days I've continued to examine some replication possibilities for PostgreSQL, in order to build a high-availability setup, but I...

Oliver Fromme

12-15-2003 04:04 PM
Oliver Fromme

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 duncan adams wrote: I haven't used it, it seems that it's the ODBC driver that it's using it... In my...

papapep

12-15-2003 01:18 PM
papapep

Dear all , This may be considered an information : If you have created your table as WITHOUT OIDS; Then your data would not be retrieved into 1. ...

Sai Hertz And Control Systems

12-15-2003 10:46 AM
Sai Hertz And Control Systems

Hi there- I'm new to pgsql, but would like to use if form my next project. Has anyone successfully install pgsql on a HP-UX machine? I have yet...

Ryan King

12-14-2003 06:49 PM
Tom Lane

I have postgresql 7.3 running on Linux (Red Hat 9). I installed all the rpms that were avaiable on the CDs, but I can't find source examples showing...

Marcelo Pinto

12-14-2003 05:43 PM
Marcelo Pinto

I am getting a field of date type from PostgreSQL and an integer that is a number of days (1 to 3). select date, num_days from table $date,...

hodges@xprt.net

12-14-2003 03:16 PM
greg@turnstep.com

Hi everybody, forgive me if this is covered in an FAQ or something, I just haven't been able to find it. This question might not even belong on this...

Andrew Kelly

12-14-2003 02:46 PM
greg@turnstep.com

Friends I created a superuser "user1" and given permissions to create users and data bases. I then tried to connect the user to the data base "test"...

Manu M P

12-13-2003 02:17 AM
Oliver Elphick

1. I have a domain which is hosted on a server running Red Hat, Apache php and PostgreSQL 2. I have a schema for a database which was not written by...

datadummy

12-12-2003 09:03 PM
datadummy

On 12 Dec 2003, Chris Travers wrote: I assume from the content of the above paragraph, that certification is regarded as applying to only...

Bret Busby

12-12-2003 11:38 AM
Bret Busby

I cant seem to find an answer to this in the archives... I'm hoping someone has come across this problem before. Beware this is a long email... Ive...

Cody Phanekham

12-11-2003 07:08 PM
Cody Phanekham

I am migrating an application over from mysql to postgresql and am a little confused on how to write the following query in PostgreSQL. The...

Alan T. Miller

12-11-2003 03:15 PM
Bruno Wolff III

Hello, everyone. I am VERY new, as in simply researching possibilities, to SQL Servers in any shape or form. However, I do have a question: on the...

Amy Young

12-11-2003 09:08 AM
Frank Way

Friends When i tried to execute the command "\c test testpos" i got the message "Previous connection kept" ( The user testpos has super user...

Manu M P

12-11-2003 07:08 AM
Manu M P

Friends Is there any way to list all the data bases available in a host? Also is there any way to list the users in the...

Manu M P

12-11-2003 06:58 AM
Aarni Ruuhimäki

hi to all does anybody know about uITRON.. What is uITRON core... any help appreciated thanks in...

Smitha V. Babu

12-11-2003 04:57 AM
Smitha V. Babu

Friends The man page of createuser shows that only superusers can create users with "createuser". How can i make an ordinary user a super...

Manu M P

12-11-2003 04:48 AM
Oliver Elphick

Friends The man page of createuser shows that only superusers can create users with "createuser". How can i make an ordinary user a super...

Manu M P

12-10-2003 10:31 PM
Manu M P

Friends The man page of createuser shows that only superusers can create users with "createuser". How can i make an ordinary user a super...

Manu M P

12-10-2003 10:31 PM
Manu M P