Hi guys, I am in troubles with a SERIAL field. I have five tables. A parent table and four child tables. When I do the INSERT in the parent table,...

MaRCeLO PeReiRA

11-16-2004 10:53 AM
Tom Lane

Hi, i am testing a few queries in my postgresql DB. The first query after reboot is always slower because of an empty OS page/file cache. I want to...

Janning Vygen

11-16-2004 10:50 AM
Christopher Browne

Hi, We are pleased to announce the awaited DBManager Professional 3.0. This version is a new GUI with lots of new features. DBManager is a...

COS

11-16-2004 10:40 AM
gunmuse@gunmuse.com

Hi, I know that the disk space of the database server should never run out.... but it can happen. Which is the worst case? May the database be...

Mage

11-16-2004 10:14 AM
Mage

Hi, I'm sure this has been asked before, but my searches haven't come up with an example. I'm writing a generic trigger function called from...

Matt

11-16-2004 09:07 AM
Matt

Anatoly Okishev wrote: You probably need to be calling "SELECT get_national_code(...)" to access it via a standard query. -- Richard...

Richard Huxton

11-16-2004 06:28 AM
Mike Rylander

Hi all I have to develop an embedded database using memory FLASH and memory RAM Some tables must be saved in RAM and some tables in FLASH ( RAM and...

stefari@tiscali.it

11-16-2004 05:40 AM
Peter Eisentraut

Bjørn T Johansen wrote: They are just a logical hierarchy that allows you to organize your databases in more or less manageable ways. There is no...

Peter Eisentraut

11-16-2004 02:20 AM
Peter Eisentraut

I have a postgresql backend with an access front end and I am trying to redefine the recordset of the form to use an ADO recordset. The problem...

Sim Zacks

11-16-2004 01:48 AM
Sim Zacks

Give the IP Address of your connecting client in the pg_hda.conf file and restart postgres. Thanks ! - goutam Confidentiality Notice The...

Goutam Paruchuri

11-15-2004 10:03 PM
Jan Wieck

I run these commands automatically every night: vacuumdb -a -z -U postgres reindexdb -a -U postgres Is there a way to temporarily disable all...

CSN

11-15-2004 06:34 PM
CSN

On Sat, 13 Nov 2004, Gary L. Burnore wrote: A problem that you perceive, yet nobody else seems to ... very isolated problem ... of coufse, you...

Mike Cox

11-15-2004 05:16 PM
Brian {Hamilton Kelly}

Hi, Environment: SunOS 5.7 Generic_106541-29 sun4u sparc SUNW,UltraSPARC-IIi-Engine Postgresql-7.4.6 Build config: --with-java...

Jim Seymour

11-15-2004 05:07 PM
Jim Seymour

Hi, In 7.3 I was able to do: ALTER DATABASE babase SET "TimeZone" TO 'Nairobi'; a nice Posix TZ value (FYI UTC+3 w. no daylight savings time). In...

Karl O. Pinc

11-15-2004 12:03 PM
Karl O. Pinc

A cathartic time, to be sure. However, could we at least limit the scatology to the *body* of the messages? It's very difficult explaining to one's...

Taber, Mark

11-15-2004 11:19 AM
Richard_D_Levine@raytheon.com

Hi! Is there any Way or have somebody a Function to do something like this copy skurs from...

chris

11-15-2004 08:58 AM
Sim Zacks

Hi all, I'm using postgresql 7.4.2 and could not create relationships between subclases. I hava a EER model where the superclass Person has...

Dino Vliet

11-15-2004 08:10 AM
Dino Vliet

Hi, Can anyone suggest any websites that might help with connecting visual studio dot net (I would like to see it running using server explorer if...

Daron

11-15-2004 06:57 AM
Daron

On Mon, 15 Nov 2004 11:38:29 +0100, Stefano Bonnin <stefano.bonnin (AT) comai (DOT) to> wrote: You increase it a bit. Anyway its not worth the...

Stefano Bonnin

11-15-2004 05:53 AM
Dawid Kuroczko

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there, I haven't found a way to set the client encoding of a psql connection other then...

Holger Klawitter

11-15-2004 04:37 AM
Richard Huxton

suon wrote: There is no 7.5 - version 8.0 is in beta-testing though. There are links for jdbc/odbc on the homepage of...

Richard Huxton

11-15-2004 04:29 AM
Richard Huxton

Hi Since sometime yesterday, my postgresql (7.4.5) reports "ERROR: cannot compare arrays of different element types", when I analyze a specific...

Florian G. Pflug

11-14-2004 07:11 PM
Florian G. Pflug

hello all, i've got a database that takes up 4G of space. when i run a script that deletes all rows and then vacuum, the data directory gets down...

Bopolissimus Platypus Jr

11-14-2004 01:39 PM
Tom Lane

Hello all, I have accidently :-) found 'initlocation' and now I like to know, how many secondary database i can create. I like to do that, because...

Michelle Konzack

11-14-2004 01:26 PM
Michelle Konzack

Richard Huxton wrote No, not really. It raises the profile of the project a bit, makes access to PostGreSQL a little easier for people who find...

Mike Cox

11-14-2004 01:00 PM
Michelle Konzack

Obviously, there cannot be 21 postgresql groups in the comp.* hierarchy. Many of the 21 are not used that often, and would not be of much...

Mike Cox

11-14-2004 10:14 AM
Sim Zacks

stanley@a.shell.peak.org (John Stanley) wrote in news:cmra1r$ujk$1@a.shell.peak.org: Who would that be? -- Bill

Joseph Daniel Zukiger

11-14-2004 08:08 AM
Sim Zacks

barbara (AT) bookpro (DOT) com wrote in news:10outlgpkitaq20 (AT) corp (DOT) supernews.com: 21, at...

Woodchuck Bill

11-14-2004 06:39 AM
BARD ROCK

On Wed, Nov 10, 2004 at 02:34:22PM -0500, Ernest Kim wrote: Use currval(): http://www.postgresql.org/docs/7.4/static/functions-sequence.html Race...

Michael Fuhr

11-14-2004 12:29 AM
Michael Fuhr

I would like to ask the more experienced users on Postgres database a couple of questions I have on a db I manage with a lot of data. A lot of data...

Alexander Antonakakis

11-14-2004 12:01 AM
Michael Fuhr

Instead of putting the same 12 columns on every table (these 12 columns contain info about who created the record and when, for example)... It may be...

TJ Talluto

11-13-2004 08:57 PM
Mike Rylander

Dear peoples, We had an oddness today with one of of postgres servers (Dell 2 CPU box running linux) and postgres 7.4. The server was under heavy...

Gregory S. Williamson

11-13-2004 06:40 PM
Gregory S. Williamson

At 11:48 AM 11/8/2004, you wrote: It's not the same. Your list may not see the post for days. USENet is faster than that. It receives those...

Andy

11-13-2004 06:34 PM
Martijn van Oosterhout

On Tue, Nov 09, 2004 at 11:00:57PM -0000, John White wrote: This is hard to do with plpgsql, I don't understand why people keeps trying. It's much...

Alvaro Herrera

11-13-2004 04:55 PM
Alvaro Herrera

On Thu, Nov 11, 2004 at 11:55:33AM +0100, Bjørn T Johansen wrote: The documentation deprecates to_char(interval, text) and the Release Notes for 8.0...

Michael Fuhr

11-13-2004 12:11 AM
Michael Fuhr

On Sun, 7 Nov 2004, Russ Allbery wrote: Note that I'm not against making them moderated ... it changes nothing as far as how things are handled on...

Mike Cox

11-12-2004 09:36 PM
Marc G. Fournier

Hi. Is it possible to dump a database on a 7.4.6 server and then restore it on a 7.4.1 server? should i use the 7.4.1 pg_dump or the 7.4.6...

stig erikson

11-12-2004 05:50 PM
Tom Lane

This morning I got bitten by the "SELECT INTO" / "CREATE TABLE AS" from tables without OIDs bug in 7.4.1. Postmaster killed all the backends and...

Steve Crawford

11-12-2004 01:58 PM
Steve Crawford

How does one embed a sub-query lookup to one table in order to replace a foreign key id number with it's name in a SELECT on a second table? i.e.: ...

Scott Frankel

11-12-2004 01:52 PM
Scott Frankel

The my2pg.pl script creates custom functions that help with the MySQL "set" column type. I can't figure out how to use the functions once I have the...

Scott Chapman

11-12-2004 12:07 PM
Scott Chapman

Still too new to SQL to have run across this yet ... How does one return the latest row from a table, given multiple entries of varying data? i.e.: ...

Scott Frankel

11-12-2004 12:04 PM
Scott Frankel

Hello, I think I have found a query problem when the query has an alias for a table and use alias item and table name. I ilustrate the problem with...

Rodríguez Rodríguez, Pere

11-12-2004 06:22 AM
Matteo Beccati

Hello everyone; My systems admin says that he needs to have use of the Postgres user without a password. His Debian package manager requires...

Bob Powell

11-12-2004 03:52 AM
Oliver Elphick

Do I get more oids on a 64 bit machine? That is, is it also an unsigned four-byte integer on a 64 bit machine? -- Until later,...

Geoffrey

11-11-2004 08:19 PM
Neil Conway

I have a project "wyatterp.com" that was built to be an ERP development library using postgresql as a backend. We use it internally to run a 120...

Kyle

11-11-2004 07:53 PM
Kyle

Thomas Hallgren <thhal (AT) mailblocks (DOT) com> writes: The anon-CVS repository syncs to the master once an hour, last I heard. regards, tom...

Tom Lane

11-11-2004 07:11 PM
Tom Lane

I know I've seen this message before but I'm not quite sure what it means. I think it's because I have two vacuums running over each other. Does...

Kevin Barnard

11-11-2004 06:25 PM
Kevin Barnard

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday 11 November 2004 07:04 am, Terry Lee Tucker wrote: OID's are unique per database as long...

Uwe C. Schroeder

11-11-2004 06:24 PM
Terry Lee Tucker

On Thu, Nov 11, 2004 at 03:34:14PM -0500, Geoffrey wrote: Nope, it means that OIDs are not inherintly unique and you need to make an index to force...

Martijn van Oosterhout

11-11-2004 05:00 PM
Frank Bax

kmorgan (AT) spamcop (DOT) net (Kathy Morgan) wrote in news:1gn31ro.1o5r8tu1fi95j6N%kmorgan (AT) spamcop (DOT) net: Kathy and Rebecca are right. I...

Woodchuck Bill

11-11-2004 04:37 PM
Woodchuck Bill