Is there any way to forcibly disconnect all users from a database, or else force the drop of the database even though others are still connected? I...

Lee Harr

01-24-2004 07:29 AM
Lee Harr

I must have a fundamental misunderstanding about using schema. Before using schema, I usually have a file that has my database definition, and I can...

Lee Harr

01-24-2004 06:27 AM
Nigel J. Andrews

On Thu, 2004-01-22 at 18:00, Phil Campaigne wrote: LD_LIBRARY_PATH is often not set except for users with specific needs. Having it set might lead...

Phil Campaigne

01-23-2004 12:48 PM
Reece Hart

Created a new 7.4 database. # create database foo with encoding = UNICODE; Then tried to restore my dump from pg 7.2 which was SQL-ASCII or...

Erwin Brandstetter

01-23-2004 12:06 PM
Erwin Brandstetter

Hi As far as I can tell, the pull_up_IN_clauses does not optimize recursively. Am I totally misguided here? Index:...

Dennis Haney

01-23-2004 11:52 AM
Tom Lane

A few question regarding PostgreSQL handling of queries: - Is each query submitted parsed and planned even if it is identical to a query submitted...

lnd@hnit.is

01-23-2004 03:45 AM
lnd@hnit.is

In the following query the field 'memid' is varchar(8). Is the error message below a bug? select substr(memid,1,1) as memtp, substr(memid,2,4) as...

Mike Nolan

01-22-2004 10:42 PM
Mike Nolan

For ease of configuration and other reasons, I would like for my single-user GUI app to be able to use postgresql in-process as a library accessing a...

Jeff Bowden

01-22-2004 09:51 PM
Tom Lane

Hi, I have a database of zipcodes,longitude and latitude. I want to calculate the nearby zipcodes from a specific zipcode. I have the function that...

tasmisr

01-22-2004 09:16 PM
tasmisr

This is certainly my feeling. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire...

Brian Maguire

01-22-2004 01:27 PM
Julian North

After copied pg database from one PC to another -I could not find plpgsql function(s) in the copied database. -had to instal plpgsql language...

lnd@hnit.is

01-22-2004 01:11 PM
Tom Lane

I am using 7.4.1 Basically I am trying to use a regex that will match: john smith john r smith john r. smith When I use:

Culley Harrelson

01-22-2004 12:10 PM
Culley Harrelson

Guys, Sent a message out last week asking for info, but wanted to send another more direct one. The company I work for has decided to cut ties with...

John Wells

01-22-2004 08:58 AM
John Wells

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

01-22-2004 06:21 AM
Axier

This was probably asked n-times but still: Is there any way to end (commit/rollback) a transaction inside a stored function? (The reason why it is...

lnd@hnit.is

01-22-2004 03:38 AM
Chris Travers

Hello, I am testing a web application (using the DBX PHP function to call a Postgresql backend). I have 375Mb RAM on my test home box. I ran ab...

Alex Madon

01-21-2004 07:54 PM
Richard Huxton

I'm trying to build a table that will store a history of records by enumerating the records. I want the newest record to always be number ZERO, so I...

D. Dante Lorenso

01-21-2004 07:40 PM
Richard Huxton

I'd like to be able to do queries like "select count(*), fromline from message where subject like 'Couldn%'" quickly. I see that, in...

Kragen Sitaker

01-21-2004 07:15 PM
Kragen Sitaker

Hello. I subscribed to pgsql-bugs and submitted a bug report about 10 hours ago, but have yet to see my post go through, so I thought I'd...

Mike Mascari

01-21-2004 05:51 PM
Tom Lane

Hi, I'm currently running 7.3.4 on Debian/testing, I've been trying to get pgxml_dom working but after doing some normal tests I find that...

Simen Brekken

01-21-2004 04:58 PM
John Gray

Hello, I do not find an ODBC related newsgroup using postgreSQL at the backend. Where can I find it ? My short questions are: If I use SQLSetPos...

Lothar Behrens

01-21-2004 03:40 PM
Lothar Behrens

hello, Iam trying to install postgres-7.4.1 on my tru64 (O.S version 5.1A) box without the shared library support. Here's my list of...

Sathiamoorthy Balasubramaniyan

01-21-2004 01:44 PM
Tom Lane

Jared Carr <jared (AT) 89glass (DOT) com> writes: What it looks like to me is that this shutdown never completed, probably because some client was...

Jared Carr

01-21-2004 12:38 PM
Tom Lane

I'd like to reference values returned by a subselect in the same SELECT query. Example: SELECT id, ( SELECT COUNT(*) FROM second ) AS...

Marco Lazzeri

01-21-2004 12:10 PM
Bruno Wolff III

Is it possible to check what query was last run by a connection? Every so often I am gettings all of my connections maxed and the whole database just...

Tedd Shasting

01-21-2004 11:49 AM
Tedd Shasting

Linux Magazine Feb 2004 published an article titled "Postgresql 7.4: The Database Administrator's Database". It is a 5 page article describing in...

Brian Maguire

01-21-2004 08:41 AM
Brian Maguire

Hello, After using Postgresql for a while, through ODBC / MS Access, I'm not able to connect to the server anymore. The server reports "Too...

Philippe Lang

01-21-2004 07:50 AM
Philippe Lang

Quoting "Joshua D. Drake" <jd (AT) commandprompt (DOT) com>: Agreed- I was hoping some else would say that. I mentioned that earlier in this...

Sai Hertz And Control Systems

01-21-2004 05:33 AM
Kris Jurka

Hi all, I am using postgresql7.4. How to handle arrays in plpgsql. How can I pass an array. Is it possible to retrieve values from an array...

K. Deepa

01-21-2004 03:04 AM
Rajesh Kumar Mallah

I'm start to try to developer a Data Warehouse over PostgreSQL, I want to know what tools exist to: Modeling (Diemsnional) ETL process (Extract...

Esteban Kemp

01-20-2004 03:43 PM
Alvaro Herrera

Hi. Could someone please tell me how to access the template0 tables through PgAdmin. I'm using PgAdmin 1.4.12 and Postgres 7 something. If I log...

Dylan Milks

01-20-2004 01:28 PM
Tom Lane

My company is developing a PostgreSQL 7.4 application. We don't want our customers to have to manage the database, so we're automating as much...

Jack Orenstein

01-20-2004 12:43 PM
Andrew Sullivan

Is it possible to find "system change ID" in SQL or stored procedures? By "system change ID" I understand an internal serialized number which...

lnd@hnit.is

01-20-2004 11:36 AM
Jan Wieck

Hi Guys, Do you know any companies in the San Diego Area(or nearby) who can give consulting expertise. This is for getting us up and running with...

Thapliyal, Deepak

01-20-2004 11:31 AM
Thapliyal, Deepak

On Fri, 2004-01-16 at 06:58, Harald Fuchs wrote: But it won't complain usefully. It will just abort the transaction. It's difficult to determine...

LitelWang

01-20-2004 05:34 AM
John Sidney-Woollett

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-20-2004 01:30 AM
thierry

I'm running Postgres 7.1.3, and just started having a problem where my dynamic site is going down (read-only DB, with no writes happening to the DB)...

Aurangzeb M. Agha

01-19-2004 10:48 PM
Aurangzeb M. Agha

The JDBC driver has been moved out of the main source tree to a gborg project. This change will only affect new major releases. The 7.4 series will...

Kris Jurka

01-19-2004 07:56 PM
Kris Jurka

Hello all, I'm running a debian server and recently updated my version of PostgreSQL to "unstable", that being v7.4.1. I had no trouble at...

Aienthiwan

01-19-2004 06:33 PM
Aienthiwan

I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE). Did nothing special, just make && make install and all was well. I now...

bill.postgresql-users@mcmilleon.com

01-19-2004 05:23 PM
Tom Lane

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

Hello all! I've upgraded postgresql from 7.2 to 7.4, and my data dir has changed a lot: S.ficheros Tamaño Usado Disp Uso% Montado...

Carlos Costa Portela

01-19-2004 04:45 PM
Carlos Costa Portela

What's the best way to ease development of plpgsql. My largest issues with plpgsql pertain to the quoting of course. Bill...

bill.postgresql-users@mcmilleon.com

01-19-2004 04:40 PM
Rich Hall

Hi, I've got a table: <code language="SQL"> CREATE TABLE "common"."dynamic_enum" ( "pk_id" integer ...

ezra epstein

01-19-2004 02:27 PM
Tom Lane

Does exist a syntax in PostgreSQL for integer (INT) number ranges? It could be useful for queries like "SELECT * FROM table WHERE id IN (range from...

Marco Lazzeri

01-19-2004 01:27 PM
Stephan Szabo

I'm using Postgres 7.4. I have a database called tracking and user called test5. From the Red Hat command line test5 can psql tracking and...

Chris Skaryd

01-19-2004 01:19 PM
Chris Skaryd

I have a 3 tier client/server application where the client connection to the server which then uses PostgreSQL. I'd like to extend the client to...

jbi130@yahoo.com

01-19-2004 12:50 PM
Keith C. Perry

"Julio Misael Gutierrez" <jmisaelg (AT) amnetsal (DOT) com> writes: Because there is a row type (composite type) associated with...

Tom Lane

01-19-2004 12:26 PM
scott.marlowe

Hi, we are currently using another database product but besides some licensing issues we are finding more and more problems with the database. We...

David Teran

01-19-2004 12:18 PM
scott.marlowe

Hello, perhaps you may have some advice. The postgresql documentation for COPY FROM INFILE suggests that high-ascii characters be encoded to a...

Mental

01-19-2004 11:57 AM
Tom Lane