Hello, If I do something like: SELECT * FROM sometable ORDER BY somerow DESC LIMIT 1 OFFSET 2; ... and there are multiple rows in sometable where...

Net Virtual Mailing Lists

10-25-2004 11:31 AM
Peter Eisentraut

Note : you may use illustrations and diagrams to enhance explanations. XYZ Company is a car Production Company. It has four factories and many...

rohit srivastava

10-25-2004 06:03 AM
rohit srivastava

Hi all, I have a text field which I'll be doing LIKE searches against so I wanted to set up an index on it. The data itself is too long to create a...

Chris

10-25-2004 12:05 AM
Chris

I have a table with about 1,400,000 rows in it. Each DELETE cascades to about 7 tables. When I do a 'DELETE FROM events' I get the...

10-24-2004 09:05 PM
Tom Lane

I am writing functions and I find it curious that CREATE FUNCTION does not do syntax checking. Example: test=# CREATE FUNCTION foo(INTEGER) RETURNS...

Karim Nassar

10-24-2004 08:56 PM
Tom Lane

In order to address a recent security report from iDefence, we have released 3 new "point" releases: 7.2.6, 7.3.8 and 7.4.6 Although rated only a...

Marc G. Fournier

10-24-2004 07:53 PM
Tom Lane

On Fri, Oct 22, 2004 at 09:36:10AM -0400, Jan Wieck wrote: Or someone around here will, anyway. I might get hit by a wayward streetcar, but...

Chris Browne

10-24-2004 06:55 PM
Andrew Sullivan

Getting recurring lines in log of ERROR: permission denied for relation logs Is there a way to tell from which DB this error is coming from? Or...

Francisco

10-24-2004 11:14 AM
Francisco

Hi all, I have upgraded my cygwin installation and it has replaced my old 7.3 postgresql. My questions are the following: How can I use the old...

Bilicki Vilmos

10-24-2004 11:13 AM
stig erikson

Hello, I would like to ask if my problem with sequence is a proper behavior or this is a bug (probably not)... I have a table: CREATE TABLE...

Marek Lewczuk

10-24-2004 06:40 AM
Sim Zacks

Hi, My boss wants to add some logging functionality to some of our tables on update/delete/insert. I need to log who, when, table_name, field...

Tim Vadnais

10-24-2004 02:53 AM
Pierre-Frédéric Caillaud

Hi, I want to make use of some contrib/dblink functions inside my user defined functions, e.g. I would like to be able to call dblink_record() from...

Katsaros Kwn/nos

10-24-2004 12:39 AM
Michael Fuhr

On Sat, 2004-10-23 at 22:22, Karim Nassar wrote: Assuming there's only one or two databases in the cluster, it would be pretty easy to just do...

Karim Nassar

10-23-2004 08:08 PM
Karim Nassar

Just a sanity check -- data fed into pg using the COPY tablename (col1, col2) FROM stdin; ... data \. Does not cause referential triggers to fire...

James Robinson

10-23-2004 07:55 PM
Tom Lane

I am trying to write a sigle command to update the max number from detail. Something like: update group set max_msgid=max(c.msgid) from group g,...

Vic Cekvenich

10-23-2004 07:16 PM
Bruno Wolff III

Not sure if this is a win installer issue or Microsoft MDAC issue... I've installed the win32 pg8.0 beta2 dev3 along with the accompanying ODBC that...

A. Mous

10-23-2004 02:00 PM
Gary Doades

Hello again, as I am new to PostgreSQL (great pice of softwork btw) this probably won't be the last question. I access PostgreSQL from Java via the...

Ruediger Herrmann

10-23-2004 12:05 PM
Bruno Wolff III

I have a PHP script that was having problems using the COPY command with files around 1500 lines in size. The script will build the copy data from...

Robert Fitzpatrick

10-23-2004 11:49 AM
Robert Fitzpatrick

Is there a schema repository somewhere? i am looking for a data warehouse clickstream schema to get some view on how others have made such a schema.

stig erikson

10-23-2004 05:42 AM
stig erikson

I have come up with a simple query that runs horribly depending on the number of columns selected. select order_lines.* from orders,...

Cott Lang

10-23-2004 05:19 AM
Gaetano Mendola

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Scott Marlowe wrote: That's true. This is the second time in these last days that I see someone...

Dan Pelleg

10-23-2004 05:04 AM
Gaetano Mendola

I've installed both 32-bit and 64-bit executables of 7.4.5 on ia64 running HP-UX B.11.23. The 32-bit version works fine and accepts both local...

Ed L.

10-22-2004 08:37 PM
Ed L.

The site seems to be down Tom. Tom Lane wrote: <snip> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you...

Dennis Gearon

10-22-2004 07:09 PM
Gaetano Mendola

what does this message mean? thanks, --h

Hicham G. Elmongui

10-22-2004 06:03 PM
Tom Lane

Guys, My boss has been keeping himself busy reading MySQL marketing pubs, and came at me with a few questions this morning regarding...

John Wells

10-22-2004 05:32 PM
Kevin Barnard

I need to select all tuples from a table, but need them to be fetched with a constant delay (say 1 sec) between every consecutive tuples. The first...

Hicham G. Elmongui

10-22-2004 04:21 PM
Hicham G. Elmongui

Hi, I have an installation of Postgres 7.4.2 on SuSE 9.1. This version of SuSE comes with a binary for plperl and several other postgres procedural...

Eric E

10-22-2004 03:18 PM
Eric E

Greetings: While working with plpgsql and triggers, I've been using TG_NAME to display the trigger name at various points where I need to raise an...

Terry Lee Tucker

10-22-2004 01:44 PM
Terry Lee Tucker

Hi all, has anyone implemented row versions/timestamps in PostgreSQL or any thoughts on this? Did I hit the right term? What I want to achieve is...

Ruediger Herrmann

10-22-2004 10:18 AM
Tom Lane

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dennis Gearon wrote: For partion in some way I don't mean only split it in more tables. You can use...

Dennis Gearon

10-22-2004 09:37 AM
Dennis Gearon

Guys, I have an opening currently for the following position. If interested, email me at john.wells__replace_this_with_at__timco.aero. Although...

John Wells

10-22-2004 08:52 AM
John Wells

Hello MySQL has information about several storage engines. MEMORY to handle temporary tables, InnoDB to handle transactions and which also can...

nd02tsk@student.hig.se

10-22-2004 05:54 AM
nd02tsk@student.hig.se

Hello all I've been approached by the development people about removing the 'public' schema. They complain about having to manually remove the...

Henry Combrinck

10-22-2004 04:31 AM
Henry Combrinck

Hi Folks, I'm looking for something that is completely independent of the MSVC++ Dev Studio environment, something that will compile and run...

Randy Yates

10-21-2004 11:16 PM
Randy Yates

Vic Cekvenich wrote: ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Vic Cekvenich

10-21-2004 08:33 PM
Vic Cekvenich

Hello, I appreciate very much the readline functionality on the psql client. However, I'd like to ask if it is possible for the...

Carlo Florendo

10-21-2004 08:31 PM
Carlo Florendo

I am trying to write a sigle command to update the max number from detail. ---------------------------(end of...

Vic Cekvenich

10-21-2004 07:52 PM
Vic Cekvenich

Don, If the data is can be mapped as 2D or 3D Cartesian coordinates, you could use spatial operators from PostGIS. Rick Don Isgitt

Richard_D_Levine@Raytheon.com

10-21-2004 03:40 PM
Richard_D_Levine@Raytheon.com

I have a project where it is necessary to determine Outliers of lab results and looking for some pointers on the best way to handle this type of...

Robert Fitzpatrick

10-21-2004 02:55 PM
Don Isgitt

On Thu, 2004-10-21 at 09:08 +0200, JiÅ™Ã* NÄ›mec wrote: http://techdocs.postgresql.org/guides/GUITools hth, Robby --...

Robby Russell

10-21-2004 11:19 AM
Bill Harris

I am trying to download postgresql from one of the mirror sites. I get prompted for a username and password. I try anonymous login and my password...

Joseph.Dunleavy@vertexinc.com

10-21-2004 11:06 AM
Joseph.Dunleavy@vertexinc.com

Hello ! I have two tables (which contains individual months' data). One of them contains 500 thousand records and the other one about 40k,...

Otto Blomqvist

10-21-2004 04:11 AM
Sim Zacks

On Wednesday October 20 2004 10:12, Ed L. wrote: That worked for 3 of 4 cases, but for a fourth, I see the message that it's zeroing the page, but...

Ed L.

10-21-2004 02:31 AM
Ed L.

My question is it possible to speed up a query doing preselects? What I'm working on could end up being a very large dataset. I hope to have 100-1000...

Dennis Gearon

10-20-2004 11:04 PM
Hicham G. Elmongui

Is the ON COMMIT syntax available to temporary tables created using the CREATE TABLE AS syntax? If not, is there a way to drop such a table at the...

Thomas F.O'Connell

10-20-2004 07:32 PM
Neil Conway

Hello, I have a problem using latin2 in postgresql 8 (beta2) with Delphi, with settings client_encoding = server_encoding = latin2 for...

PavelK

10-20-2004 07:05 PM
PavelK

I know this is kinda a debate, but how much ram do I give postgres? I've seen many places say around 10-15% or some say 25%....... If all this server...

Josh Close

10-20-2004 06:53 PM
Josh Close

Hi! I'm from Italy, and sorry about my english... I have a question that I know it is already said in the groups but I have however some doubts I...

Raffaele Spizzuoco

10-20-2004 04:59 PM
Kevin Barnard

Hi, I have a question about sequences. I need a field to have values with no holes in the sequence. However, the values do not need to be...

Eric E

10-20-2004 03:38 PM
Andrew Sullivan

Hi, I have a question about sequences. I need a field to have values with no holes in the sequence. However, the values do not need to be in...

Eric E

10-20-2004 03:37 PM
Eric E