Hi Ng, probably simple question: what is the easiest way to get the id of an inserted row. I have the folliwing table: Create table...

Stefan Braumeister

07-11-2007 08:35 AM
Stefan Braumeister

Sascha Bohnenkamp wrote: Thanks but it's probably not what I am looking for: I would need to make materialized views by hand before or after A1......

dblearner

07-09-2007 08:41 AM
dblearner

Hi All, I am pretty new to SQL and having trouble trying to formulate a query from what I have been reading in a couple of books (and got...

Kurt

07-03-2007 06:37 AM
Kurt

Hi Group, i am new in the database topic and i look for an database that can work with compressed database files. i look mysql 6 has the falcon...

Thomas Fragstein

07-03-2007 01:34 AM
Andreas Kretschmer

Hallo, I would like to know how is the difference about the performance of PostgreSQL and Firebird. thx

xdb

07-02-2007 03:29 AM
Laurenz Albe

Howdy all, The PostgreSQL documentation says of the INTERVAL type: Internally interval values are stored as months, days,...

Ben Finney

06-29-2007 04:03 AM
Andreas Kretschmer

Hallo everybody, I just have a little question, but very important for my applications, I would want to know the exactly statement (or function) to...

davide

06-26-2007 11:59 AM
Laurenz Albe

Poochie© <poochie{digit:=2}@{googlemail}.com> wrote: You wield strange terms :^) What is a seamless operation? I think you are referring to the...

Andreas Kretschmer

06-25-2007 03:32 AM
Laurenz Albe

SQLeonardo a powerful and easy-to-use tool that lets you query databases. Download the latest release at http://sqleonardo.altervista.org

nickyb

06-08-2007 05:33 PM
nickyb

I'd like to set an empty string (not null) in a field bytea as default. I've tried this: "txt1" BYTEA DEFAULT ''::bytea but when i insert a new...

diego

06-08-2007 04:30 AM
Laurenz Albe

Thomas Guettler <guettli.usenet (AT) thomas-guettler (DOT) de> wrote: I'd recommend that you add a unique constraint rather than an unique...

Andreas Kretschmer

05-31-2007 10:33 AM
Robert Klemme

Hi group, I installed TSEARCH2 on Postgres8.1 (Debian). It runs all fine. I have 2 tables indexed, and created triggers to keep the vectorcolumns...

Erwin Moller

05-31-2007 05:33 AM
Laurenz Albe

I have got a query: explain analyze select tfield from tws order by tfield; Query Plan...

Artur

05-22-2007 09:48 AM
Artur

I'm trying to get some code to run with PostgreSQL after succesfully getting it to run with MySQL and Sqlite, and if I had known Postgres was going...

SM Ryan

05-20-2007 02:00 PM
Guido Neitzer

Hi I have a problem with Postgresql 8.2 for windows in my server with Windows 2003 standard R2 SP2(Core2Duo, 2GB, RAID5). On this server I have MS...

sg_pl

05-20-2007 11:13 AM
sg_pl

Hello all, i've add some column to an existing table and automatically are been placed in the bottom of the table. Is it possible to reorder the...

Dade

05-18-2007 04:00 AM
Laurenz Albe

Hello all, i would like to restore a backup make in plain text format but i'm not able to do it. when i give the command: pg_restore -i -h...

Dade

05-16-2007 09:41 AM
Dade

"Martin v. Löwis" <martin@v.loewis.de> wrote: It is indeed mysterious why your change should change anything... There is no read lock in...

Laurenz Albe

05-14-2007 04:40 AM
Laurenz Albe

Hello, I am using SSL connections with client certificates. Everything works fine. Now I am making up my mind if there is a way to have the pg...

Ch Lamprecht

05-07-2007 08:38 AM
Ch Lamprecht

I was wondering if there is a tool either as part of the Postgres or avaliable as a seperate utilitiy that would allow us to monitor how much of...

Fuzzydave

05-03-2007 06:02 AM
Fuzzydave

Is it possible to do something like this to encrypt using a gnupg public key insert into junk Values (1, 'fred smith', pgp_pub_encrypt ('A...

muHaarib

05-02-2007 01:39 PM
muHaarib

A Tomcat frontend is logging the following error. The backend is Postgres 8.1. < ERROR: character 0xc582 of encoding "UTF8" has no equivalent...

genkuro@gmail.com

05-02-2007 04:03 AM
Laurenz Albe

Hello NG, if I installed PostgreSQL 8.2.4-1 at a Windows Vista plattform with a NTFS filesystem at "C:\pqsql\82" and choosing an own user, which I...

Thomas Steinbach

04-27-2007 08:14 AM
Laurenz Albe

Configured a SqlDataSource using this example: http://www.123aspx.com/redir.aspx?res=35840 Running that "Generate INSERT, UPDATE dn DELETE...

Beemer Biker

04-26-2007 06:50 PM
Beemer Biker

I'm using Hylafax and sending the stats to a PostgreSQL table called faxreports. I'm needing to report on error types per hour and don't know how to...

Alfred

04-24-2007 03:56 AM
Robert Klemme

Hi All, I need to run several .sql files using psql. To do that I have prepared following batch file: psql -h 10.x.x.x -U postgres -f...

Krzysztof Adamski

04-22-2007 04:39 AM
Nanno

There is a transformational change going on in business intelligence. Users are becoming more and more demanding. They want access to their real-time...

Yellowfin Public Relations

04-16-2007 09:14 AM
Yellowfin Public Relations

is it possible to have the copy command truncate character data when the data is too long to fit in the field? For example field description1 is 19...

pauls@computer-systems.com

04-16-2007 02:37 AM
Andreas Kretschmer

I am looking to Dezign currently. A recent email from the author indicates an update forthcoming with additional support for Postgresql. On Mar 30,...

Richard

03-30-2007 10:05 PM
bsg75

Hi, I know the difference beetwen Proc and Func, the former shoud not return a value and the latter should. But it seems that within Postgres they...

Corrado Alesso

03-27-2007 04:53 PM
Corrado Alesso

Sascha Bohnenkamp ha scritto: Thank you all for these useful replies. Corrado

Corrado Alesso

03-27-2007 04:53 PM
Corrado Alesso

Rüdiger Sörensen <soerense (AT) mpch-mainz (DOT) mpg.de> wrote: Maybe PostGIS is what you want: http://www.postgis.org/ Yours, Laurenz Albe

Laurenz Albe

03-22-2007 05:36 AM
Laurenz Albe

Hi, Please before I start remember that I am not a DBA (much as I enjoyworking with PostgreSQL and learnign to admin it) I am a developer who has...

Fuzzydave

03-22-2007 05:33 AM
Laurenz Albe

Hi, I must find a value in all numeric fields in my postgres database. The database hasn't oids. How I can create this statement. Thx Phil

Philipp Kraus

03-19-2007 03:45 AM
Laurenz Albe

Hi, Hope this is the right group for this...please let me know if there is a better one. I have tried a whole bunch of things to get a windows...

Eric

03-19-2007 03:37 AM
Laurenz Albe

apologize for cross-posting Hey there, i am in trouble with postgres on a linux platform, because i am quite new with both. (i guess i cannot say,...

Henning Bredel

03-12-2007 04:36 AM
Laurenz Albe

Hi. I must migrate a database from a server with postgresql 7 to a server with postgresql 8. Do I need some conversion? Thanks.

Lucifer

03-11-2007 07:04 AM
HansH

Hi, I'm trying to connect postgresql 8.1 to domino server/lotus notes 6.01 (no results at the moment!) installed on a linux server. Do you know if is...

Gabriele

03-08-2007 04:39 AM
Laurenz Albe

I am *still* working with a legacy system written in Python and Postgres, the current feature I am working on is to automatically modify...

Fuzzydave

03-04-2007 12:41 AM
EMartinez

Sascha Bohnenkamp <bohnenkamp (AT) mevisbreastcare (DOT) de> wrote: Are you looking for something like this: SELECT t.relname AS table, conkey AS...

Laurenz Albe

03-01-2007 11:49 AM
Laurenz Albe

Hi Everybody! Right now I'am trying to find a replication solution for Postgres 8.x. I indeed did find some projects working on this, but most of...

Lars Both

03-01-2007 03:22 AM
Lars Both

Hi, I need to buid a SELECT statement for a software designed to make a simple request, like "SELECT value FROM table WHERE arg = 'argument'" My...

Eric Belhomme

02-22-2007 05:52 AM
Laurenz Albe

www.computerweekly.com/Articles/2007/02/13/221688/postgresql-opens-way-for-bespoke-database-function.htm Hot skills Open source approach encourages...

admin@neobasic.biz

02-21-2007 04:33 AM
admin@neobasic.biz

Hi all I have a problem trying to restore a backup of a database from postgres 7.4 to 8. When I execute the backup file with "\i FILE" i get a lot...

ismael

02-15-2007 03:10 AM
HansH

Hello, I'm a novice using postgresql and I've hit the ERROR: invalid multibyte character for locale error when using the lower function. I've...

Jano

02-14-2007 03:38 PM
Jano

Is there a way to retrieve data from database about specific table using some client interface in C or PHP? For example, if we have some table with...

karas

02-14-2007 06:32 AM
Laurenz Albe

Hi, we have several postgres sql 8.x machines here with about 4500 tables on each. Each table has about 150000 up to 5000000 rows. We saw, that a...

peter stimpel

02-14-2007 06:13 AM
Laurenz Albe

Hello ! I tried to install postgres on windows vista. Any attempt failed because of failures during the installation procedure. Has anyone installed...

M.A.Bednarz

02-01-2007 11:56 AM
M.A.Bednarz

I have a sql query that does not provide the correct counts. select location.name as "location Name", count ( case when incident.location_type = 138...

Bigjim

01-28-2007 10:15 PM
Bigjim

I have a need to enter values in to multiple tables in a database. These need to be related together by the ID of the last item inserted in to one of...

The Other Guy

01-27-2007 02:15 PM
The Other Guy