Is it possible to check if an update statement did anything in a transaction? ie begin; update table set intfield = intfield+1 where intfield >=...

Klint Gore

11-02-2003 08:05 PM
Klint Gore

Sorry, I mistyped the update command in my previous letter - of course, the update statement is the following: update ugyfelek set...

MaFa

11-01-2003 10:13 AM
MaFa

On Sunday, Jun 15, 2003, at 23:03 Asia/Tokyo, brew (AT) theMode (DOT) com wrote: Likewise catching up and cleaning out the mailboxes. I've...

Michael Glaesemann

11-01-2003 01:28 AM
Michael Glaesemann

* Oleg Bartunov <oleg (AT) sai (DOT) msu.su> : Many thanks to you, Oleg, and Tom Lane for anwering my post. May I ask how could one know if and when...

Ennio-Sr

11-01-2003 12:16 AM
Marc G. Fournier

Byron Amerson wrote: directory (I might've used /usr/local/pgsql/) and if you have a UID/GID of less than 500, they don't show up in the login...

Jeffrey Melloy

10-31-2003 04:38 PM
Jeffrey Melloy

Hey I'm new to unix and trying to get postrgresql installed. after running configure, while trying to run make, i get this in the terminal: sh-2.05b#...

Michael Kennett

10-31-2003 03:30 PM
Tom Lane

And why name a table with an accent egyy, anyway ? Sorry my french. Keep on keepin' on ! BR, Aarni Ruuhimaeki

Aarni Ruuhimäki

10-31-2003 03:26 PM
Aarni Ruuhimäki

Dear List, How can y wath the memory usage of postgres? Il be happy with a simple answer, but if there are ways to see soemthing like this: cache:...

Tomka Gergely

10-31-2003 03:19 PM
Tomka Gergely

I have a crazy problem here. Nobody seems to known why. I am not a database expert nor do known much about Postgres. I am just a system administrator...

Pedro Miguel Guedes

10-31-2003 03:02 PM
Bruno LEVEQUE

Can anyone explain to me how I can successfully fetch a date column defined in a 7.3 table into a c variable and have it store the date just as it is...

creid

10-31-2003 09:51 AM
Stephan Szabo

Hi@all, I have a small database with 10 tables. Now I'm looking for a tool to create (enduser) forms to fill them with data. I don't want to do them...

Kurt Derichs

10-30-2003 05:58 PM
Kurt Derichs

Hallo. i just coded a new datatype named "cistring", that can be used in every function that accepts text or varchar, and has the great ability to...

Daniel Migowski

10-30-2003 02:43 AM
Daniel Migowski

PostgreSQL: 7.3.4 Platform: SunOS 5.9 Generic_112233-07 sun4u sparc SUNW,Ultra-250 We plan to run vacuumdb nightly on our PostgreSQL cluster (which...

David Rickard

10-29-2003 04:35 PM
Tom Lane

I'd like to thank folks who helped me with the authentication problem I had earlier. I may have been asking the wrong question about, as they say,...

Eric S. Johansson

10-29-2003 03:53 PM
Oliver Elphick

I have a conversion process, written in foxpro, that creates php code to create tables, indexes, sequences, and that exports the tables' data that...

Jim Beckstrom

10-29-2003 11:26 AM
Josh Berkus

I need some help. I have ftp'd the Postgres Source and used Microsoft Visual C++ 6.0 to compile by grabbing the win32.mak file and creating a...

Paul R. Sand

10-29-2003 10:54 AM
Paul R. Sand

Hello all, First, let me explain hat I'm an absolute database novice. The reason I've made so much progress sofar with postgresql is that it is...

moonman

10-29-2003 09:03 AM
Emmon Simbo

How do I find out in Embedded SQL that a transaction has been aborted due to a deadlock? The closes error message in sqlca seems to be: -401...

Moshe Vardi

10-29-2003 08:33 AM
Tom Lane

Has anyone out there worked with Crystal Reports and PostgreSQL? We have an intranet site, currently in Oracle with many Crystal Reports...

David Rickard

10-28-2003 10:29 PM
Godshall Michael

Hello, When doing a description of a table I get the following line: Check constraints: "check_auth_method" (((((method =...

Williams, Quinton L

10-28-2003 03:29 PM
Williams, Quinton L

I hope this is ok on this list. I am currently using postgres 7.2 on my host machine for some internal information. I recently created a jail for...

Paul Bauer

10-28-2003 08:08 AM
Marc G. Fournier

Hi! Has anyone tried exporting a database in foxpro to PostgreSql ver7.1 ? If yes, did you encounter any problems ? I need to get this info so I...

Gerard M. Operana

10-27-2003 11:25 PM
Ron Johnson

In this moment I can make a selection of the first (or last) 10 records from a table. select * from table_name limit 10; I want to make a selection...

cristi

10-27-2003 11:06 AM
Anis W. Nugroho

Hi all, At home I have a Windows 1.6 GHz Pentium box which I use for accessing the internet &c. I have two old machines doing nothing at the moment...

Paul Ganainm

10-27-2003 10:19 AM
Peter Childs

Partha, Luc, Paul, and Michael, Thanks for the excellent pointers, and especially Partha for the wonderfully detailed example. I have Linux,...

Ed Fair

10-26-2003 08:20 AM
Ed Fair

Does the Windows DLL libpq.dll have support for the 'requiressl=1' optionin PQconnectdb? I'm able to use libpq.dll from my Windows XP programs...

Tony and Bryn Reina

10-25-2003 04:55 PM
Tony and Bryn Reina

Hello, I have 2 tables with identical schemas. What I have to do is insert in the 1st table all the rows from the 2nd table that don't exist in the...

Andrei Ivanov

10-25-2003 03:31 PM
Paul Ganainm

Yo, I have run into this problem in the past as well.. Even though there is probably a more elegant solutions, I found that creating a...

Jordan S. Jones

10-24-2003 07:33 PM
Jordan S. Jones

Hi all, I'm fairly new to Linux and totally new to PostgreSQL, so bear with me please. I do have lots of experience with Interbase, Firebird, MS...

Paul Linehan

10-24-2003 01:25 PM
Eric S. Johansson

Hi! I found, that in my web-application if some error occurs, the connection will not be closed. After a period I have uncountable open...

MaFa

10-23-2003 11:41 AM
MaFa

Hi! Question as above.. If I create large object and hold them in database, will they retain after dropping it? -- Marcin Gil marcin.gil @...

Marcin Gil

10-23-2003 08:36 AM
Tom Lane

Hello all! I've been working with PostgreSQL now for about a year and have really enjoyed it. And I've been able to impress the boss with very...

Michael Glaesmann

10-22-2003 09:53 PM
Tom Lane

Hi Could anyone let me know if I have done something wrong with the rule? As when trying to update via ODBC the update fails. Postgresql 7.3.2 1...

w fm3

10-22-2003 04:55 PM
w fm3

Hello, I'm running PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96 and I have a table like this: CREATE TABLE types ( id ...

Andrei Ivanov

10-22-2003 02:24 PM
Tom Lane

Hi All, I'm new with PostgreSql, so sorry, if this question is too simple.. :-) So, I realized, that PostgreSql doesn't truncates the xlog...

big_mafa

10-22-2003 11:56 AM
Tom Lane

Hi again, Is there an FAQ or something I can read about optimising speed of insertions and queries? I am doing some simple-minded stuff at...

Cath Lawrence

10-22-2003 09:35 AM
Tom Lane

I've been working on increasing the performance of a large query by writing a function that returns a table summary. The original table is orders...

Michael Glaesmann

10-21-2003 12:10 PM
Tom Lane

Hi, I'm looking for the correct syntax of getting a cross-classified table from my SELECT statement. Let's pretend I have this table: origin ...

Alexander Pucher

10-21-2003 06:41 AM
Muhyiddin A.M Hayat

I created a database with a table and I am interested to learn how to access it from a web page. Since I am a novice I would like to see an example...

Evan Panagiotopoulos

10-20-2003 07:11 AM
Bruno LEVEQUE

I just want to confirm that this is the correct behavior for the return value when combining text fields together. If one of the fields is NULL,...

Doug Silver

10-18-2003 08:27 AM
Nabil Sayegh

not even sure what is the correct database term to describe this problem. while maintaining the unique id of a case record , i have some tuples...

dev o'null

10-17-2003 09:55 PM
Josh Berkus

I'm trying to implement a simple Y/N type survey on our website using Postgresql and pHp. I am having difficulty, though, getting the database...

Dave

10-17-2003 08:53 AM
Dave

We have a intranet site we're converting to PostgreSQL; there are numerous pages where users have to enter dates (for search ranges, hire dates...

David Rickard

10-16-2003 12:45 PM
Bruno Wolff III

Is there any shorthand for granting access privileges (select etc) to all of the tables/views in a database or schema en masse? I have...

David Rickard

10-16-2003 12:40 PM
Bruno Wolff III

hi there i've got a problem with a field set up as type date. now we discovered that we have to allow not only full dates (2003-10-16) but also...

christoph.dellavalle@goetheanum.ch

10-16-2003 12:11 PM
Bruno Wolff III

Hi to all... I am facing a small problem.. I created a database in MSAccess with 5 tables,1 form,1 query and report . I want my client to view the...

Smitha V. Babu

10-16-2003 09:24 AM
Jeff Eckermann

Hello. I'm need know if postgress have some way to do something like Hot Stand-by . In another way is two database with the same data at the...

Mariano M. Gonzalez

10-16-2003 09:04 AM
Mariano M. Gonzalez

Hi, I'm trying to install phppgadmin on a FreeBSD (4.5-RELEASE) system, from the ports collection. 'make build' runs OK, but when I try 'make...

Desmond Coughlan

10-16-2003 07:51 AM
Robert Treat

Hello I have RH9 installed and want to run Postgresql. When I enter rpm -qa | grep postgreql I...

Bantamess

10-15-2003 04:19 PM
Aarni Ruuhimäki

Hi all. Another question -- I'm using plperl, and I was wondering what the best way to do a SELECT in it is. Am I best off using DBI and having the...

Systems Administrator

10-15-2003 02:59 PM
Sebastian Riedel