Help!! This is a post hard drive crash problem.. The bad drive was mounted on a fresh install and the databases were manually moved. I have a table...

Stephen G.

03-01-2004 04:00 PM
Stephen G.

Hi all, is there a backend command analog to Apache's httpd -V which will show me what was passed to the configure script at compile...

Andrew Kelly

03-01-2004 11:40 AM
Tom Lane

Sorry, I had meant to write: The command ALTER TABLE some_table ADD COLUMN some_column CHAR(6) UNIQUE; ^^^^^^^^^^ hangs indefinitely (hours!), even...

kynn@panix.com

02-29-2004 10:49 PM
kynn@panix.com

Hi, I have a big table (10 million records, each quite small - half a dozen text and numeric fields) which I need to (eek!) outer join with...

Cath Lawrence

02-29-2004 06:36 PM
Cath Lawrence

The command ALTER TABLE ADD COLUMN some_column CHAR(6) UNIQUE; hangs indefinitely (hours!), even though the table is relatively small (about 2500...

kynn@panix.com

02-29-2004 05:05 PM
kynn@panix.com

Hi Everyone, I have used pg_dumpall on a database that was created with LATIN1 encoding and has a whole bunch of messy latin1 data in it. I want to...

Joseph

02-29-2004 04:50 AM
Markus Bertheau

Hi, I think the better is to modify you file before. With sed it should be something like : sed "s/\(\tab*\).*\(\tab\)/\1\2/" file > newfile where...

Bruno LEVEQUE

02-28-2004 11:00 PM
Tom Lane

Hello Frds, I am getting following error while compiling Postgres7.4 or Postgres7.4.1 with option --enable-thread-safety Details /configure...

Rajan Bhide

02-28-2004 08:13 PM
Bruce Momjian

Hi, I am getting following error if I compile postgres7.4.1 source code using gmake and gcc. ld.so.1: /tmp/postgres/bin/psql: fatal: libgcc_s.so.1:...

Rajan Bhide

02-25-2004 03:13 AM
Rajan Bhide

hi, i tryed to install postgresql 7.4.1 on my redhat 8.0 OS. i got the following error message: # rpm -i postgresql-7.4.1-1PGDG.i386.rpm error:...

stm23

02-24-2004 10:09 AM
Tom Lane

When I place the HTML tags in the body of the email, I just get the tags showing as text. Is this what you meant? I currently use a function...

JWDougherty

02-22-2004 05:44 PM
Tom Lane

Hi all, as we all know one has to pg_dump a db before backuping it. But wouldn't it be possible to create a "named pipe" (mknod) that, on read...

Nabil Sayegh

02-22-2004 02:30 PM
Josh Berkus

PL> ------------------------------------------------------------ PL> -- QUERY PL> ------------------------------------------------------------ PL>...

daq

02-22-2004 01:54 PM
joseph speigle

Hi, I'm having some performance issues when querying a couple of tables containing a large amount of data. Here's the schema: CREATE TABLE...

Bob

02-21-2004 07:42 AM
daq

okay, its a novice list so I'll take a crack at this one. I couldn't find create rule as ... select .... in the documentation, only rules for...

Luc ROLLAND

02-21-2004 05:26 AM
joseph speigle

Hi, I have a table in postgreSQL, ver. 7.4.1, which serves up image data(JPEG) to users browsers. In various posts I have read there has been a...

beyaNet Consultancy

02-20-2004 10:22 AM
beyaNet Consultancy

hi, I was wondering again (I'd asked this a while back but can't find in archives) ..... how can I make an sql comment? For example this script...

joseph speigle

02-20-2004 10:00 AM
joseph speigle

DB> Folks, DB> Is there a catalog table or location where I can go to find data counts for DB> tables? DB> It would be nice if I could do a query...

daq

02-20-2004 02:44 AM
daq

I'm trying to drop an empty table (0 records) using: testdb=> drop table empty_table; but psql just hangs indefinitely after I hit return. No...

kynn@panix.com

02-19-2004 11:30 PM
Tom Lane

hi, How can I spool output comments? In oracle there is a command which allows "echo on" so that all output is tee'd to the window and spool, as...

joseph speigle

02-19-2004 08:17 PM
joseph speigle

Dear all , This is just a speculation Can I run PostgreSQL super user with a system account thats not allowed to login to the shell With shell I...

V i s h a l Kashyap @ [Sai Hertz And Control Systems]

02-19-2004 12:44 PM
V i s h a l Kashyap @ [Sai Hertz And Control Syste

Hi Tom, I was using 7.1.3 on linux(debian), and not 7.2.4, so sorry for that. Recently I migrated to 7.4.1 version of postgres, And I cud NOT see...

Rajan Bhide

02-18-2004 10:57 AM
Tom Lane

Hi Folks, I'm cutting my first app with ESQL (postgresql) within C and have a remedial question. When I pass a fixed length string to SQL to add to...

Andy Collins

02-18-2004 06:08 AM
Andy Collins

I have a problem: I cannot connect to my Postgresql database from PHP - but I can connect from PgAdmin. I get this error: Unable to connect to...

B. Nielsen

02-18-2004 04:21 AM
Crombleholme, Roy

Stupid question. Does it take longer to add records to a large database as oppose to a smaller one? Intuitively I would think so, but I just don't...

Sugrue, Sean

02-18-2004 02:55 AM
Wim

Hi Folks, Following is the Error string returned by Postgres Server for insert query of approx 32k in length. Postgres Version :...

Rajan Bhide

02-17-2004 10:19 AM
Tom Lane

Dear all, Have anyone tried start PostgreSQL xinit sessions. If yes kindly forward the procedures esle would be greatefull for any...

V i s h a l Kashyap @ [Sai Hertz And Control Systems]

02-17-2004 03:20 AM
Maximilian Tyrtania

Is there anyway I can change a field to allowing nulls without dumping the table, dropping it, recreating it as desired, and filling all the data...

Rob Mosher

02-16-2004 11:03 AM
Rob Mosher

I am trying to use PostgreSQL 7.2.1 on QNX 6.2.0. This version is available as a third party package from QNX. After installing the package, I am...

Stephen Rasku

02-16-2004 10:29 AM

Greetings, I am interested in writing a stored procedure (PL/Perl) in determining whether a particular row is currently locked (using SELECT ..FOR...

Dexter Tad-y

02-16-2004 08:39 AM
Dexter Tad-y

On Thu, 12 Feb 2004, Nick Tew wrote: You can do this either from a trigger (written in C or an untrusted pl language) or with a listening...

Stephan Szabo

02-15-2004 02:56 PM
Stephan Szabo

I copeid myself on this forward and never received it so I am sending it again.... It has been over a week and I have not seen this posted. I was...

Lynn.Tilby@asu.edu

02-15-2004 02:54 PM
Stephan Szabo

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 08:54 PM
Ivo Anon

I typed in "NULL value without indicator" into the postgresql.org site and received 5 responses, all having to do with error codes and structures. ...

Lynn.Tilby@asu.edu

02-12-2004 06:55 PM
Lynn.Tilby@asu.edu

How to perform COPY from memory instead of files? Any examples/pointers would be greatly appreciated. Thanks in advanced Rajan

Rajan Bhide

02-12-2004 06:12 AM
M. Bastin

Hi, does anybody know how I can have psql scroll wide tables instead of wrapping them? At the moment it uses the pager if there are too many rows....

Nabil Sayegh

02-11-2004 11:01 PM
Greg Sabino Mullane

Colleagues, How do I get the postgresql statistics? I would like to know queries per second etc. The stats_start_collector variable is on, and I...

Victor Sudakov

02-10-2004 11:55 PM
Victor Sudakov

I want to use postgreses user name and password capability to allow web-bases users to log in and be authenticated. I also want to go the user the...

chris@zenmgt.com

02-10-2004 12:50 PM
Francisco

I've just installed the beta version of PeerDirect's Postgres. According tothe instructions I am able to create a database with createdb comand,...

Arman Meltonyan

02-10-2004 11:48 AM

Michal, It's possible in 7.3 and 7.4 but not in earlier versions of PostgreSQL. ...

Josh Berkus

02-10-2004 08:52 AM
Nabil Sayegh

Latest release (v2.0.5.5) of FireStorm/DAO now provides full support for Postgres...

Andy Grove

02-09-2004 11:52 AM
Andy Grove

Hello! On Feb 9, 2003, at 9:03 PM, Iandé Coutinho wrote: Maybe someone else knows more about this, but PostgreSQL is (notoriously) case-insensitive...

Michael Glaesemann

02-09-2004 07:30 AM
Michael Glaesemann

Is there a way to initialize tables by reading the data from a regular text file? Thanks! kynn ---------------------------(end of...

kynn@panix.com

02-08-2004 01:00 PM
kynn@panix.com

G'day- I'm running Postgresql 7.4.1 and pgplsql as a procedural language. I want to call a java class from the command line inside a...

Doug Boyd

02-07-2004 03:51 PM
Tom Lane

Hi I have a scheme that I want to save ditribute to other people. How can Isave it in a .dat file? Thanks Janet

Bantamess

02-06-2004 01:13 PM
Josh Berkus

Hello, I was looking in postgres source code because I am in an operating systems class yaddd-yadda-yadda and wanted some code examples of working...

joseph speigle

02-05-2004 09:25 PM
Marc G. Fournier

I'm a rank beginner. (I took a mickeymouse DB course a few years ago; that's the extent of my DB background.) I want to become proficient with...

kynn@panix.com

02-05-2004 08:13 PM
brew@theMode.com

Thanks Guys! Let me be a little for specific. I am trying to make a php/pg/apache app that when run checks for its database and if not found creates...

Marcel Wolf

02-05-2004 07:30 PM
Josh Berkus

Guys I am trying to log on to the template0 to create a new database. The error I get is .. Warning: pg_connect(): Unable to connect to PostgreSQL...

Marcel Wolf

02-05-2004 05:42 PM
Josh Berkus

I am looking to automate and simplify the creation of new, empty tables from a template. I'm running PostgreSQL 7.3.4 under Fedora Core 1. My...

Matthew Syvinski

02-04-2004 10:53 PM
Josh Berkus