Hello List, Does anyone knows what are the high and low error numbers in postgresql and where can I find more info related. Thanks in...

Josué Maldonado

04-07-2004 04:50 PM
Josué Maldonado

Hi there, Is there a way of specifying the precision of a timestamp *with timezone* field? It works fine for timestamps *without* timezones,...

mboes@tweag.net

04-07-2004 12:24 PM
Tom Lane

What do people think of adding some more aggregate functions. These are the ones that MySQL has and PG doesn't: - STD/STDDEV - VARIANCE - BIT_OR -...

David Garamond

04-07-2004 11:34 AM
Tom Lane

On Wed, 7 Apr 2004 mboes (AT) tweag (DOT) net wrote: I think you can with the timestamp(m) with time zone (note the space between time and...

Stephan Szabo

04-07-2004 10:37 AM
Stephan Szabo

I'd like to be able to have a PL/pgSQL function defined as SECURITY DEFINER, but still have access to the calling username within the function. Is...

Adam Witney

04-07-2004 08:56 AM
Bruno Wolff III

Hello, Is there a way to see the different functions I add to a database with create or replace function ? I browse the documentation but was not...

Cyrille Gautard

04-07-2004 03:58 AM
Richard Huxton

Hi: In postgres documentation its written that if we execute query as PERFORM query inside our stored procedure; then the special variable FOUND is...

Rajat Katyal

04-07-2004 03:28 AM
Richard Huxton

=?ISO-8859-1?Q?Pailloncy_Jean-G=E9rard?= <pailloncy (AT) ifrance (DOT) com> writes: If it's an index then you can just REINDEX. However, you would...

Tom Lane

04-07-2004 01:15 AM
Tom Lane

Trilobite Trilobite wrote: Perhaps I'm missing something obvious, but ... my understanding of the above is that you're saying that some accounts...

William White

04-06-2004 11:55 PM
David Garamond

Hi I am newbie so this problem may be too simple to be asked.please help me if any new thing to be added in following: I want to use user defined...

Vinay Jain

04-06-2004 11:19 PM
Vinay Jain

I'm getting a bunch of these in my log: 2003-11-22 21:00:00 ERROR: syntax error at or near "s" at character 87 I think there might be an unescaped...

CSN

04-06-2004 11:07 PM
Bruce Momjian

I dove into config guts and figured out the way to build via specifing the location of the config scripts for tcl and tk... pgtksh behaves badly,...

Jerry LeVan

04-06-2004 10:56 PM
Daniel A. Steffen

Hi, we have a table width about 60.000.000 entrys and about 4GB storage size. When creating an index on this table the whole linux box freezes and...

Bernhard Ankenbrand

04-06-2004 10:16 PM
wespvp@syntegra.com

At the time I built Postgresql 7.4.2 I did not have aqua Tcl/Tk installed. The Aqua Tcl/Tk version installs in a different location the the...

Jerry LeVan

04-06-2004 08:04 PM
Daniel A. Steffen

I am running postgresql 7.4.2 and having problems creating a trigger function properly. I keep getting the following error: ERROR: OLD used in query...

Peter Erickson

04-06-2004 05:51 PM
Jeff Eckermann

Aberdeen has a review of open source rdbms. The overall review was quite positive but mentioned a few things missing. Features desired according to...

Anthony_Barker

04-06-2004 03:26 PM
Frank Finner

Hi, I have a very odd postgresql problem. I have some subqueries contained within a function which are looking for unrefernced data and then delete...

Bob

04-06-2004 12:28 PM
Bob

Matthias Teege wrote: Maybe like this: create or replace function fconcat_name(varchar, varchar, varchar) returns varchar as ' select replace($1 ||...

Joe Conway

04-06-2004 12:16 PM
Ron St-Pierre

On Tuesday 30 March 2004 18:20, Indibil wrote: I'm not sure if you are still interested, but you probably need to subscribe to the address above...

Richard Huxton

04-06-2004 12:09 PM
Richard Huxton

On Mon, 05 Apr 2004 11:55:17 -0500, Wes Palmer <Wesley.R.Palmer (AT) syntegra (DOT) com> wrote: In many (if not most) cases yes; always no. Think...

wespvp@syntegra.com

04-06-2004 07:59 AM
Manfred Koizar

not sure what it's supposed to look like, but i'm reasonably sure 'show time zone' shouldn't produce this-- db=# set timezone = '-6'; SET db=# show...

Will Trillich

04-05-2004 11:50 PM
Tom Lane

---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy (AT) hub (DOT) org Yahoo!: yscrappy ...

Marc G. Fournier

04-05-2004 11:14 PM
Marc G. Fournier

Hi, Are there any plans on adding CLUSTER-related information to "\d tablename" ? -- Best regards, Igor Shevchenko ---------------------------(end...

Igor Shevchenko

04-05-2004 11:07 PM
Bruce Momjian

---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy (AT) hub (DOT) org Yahoo!: yscrappy ...

Marc G. Fournier

04-05-2004 10:00 PM
Marc G. Fournier

Just upgraded Majordomo2 and Perl on the server ... just testing to make sure that everything goes through fine ... ---- Marc G. Fournier ...

Marc G. Fournier

04-05-2004 09:23 PM
Marc G. Fournier

Hello list, Apologize me if this is so obvius. How can I know the difference in years/months/days between 2 dates, for instance: 04/05/2004 -...

Josué Maldonado

04-05-2004 06:12 PM
Devrim GUNDUZ

Tom Lane wrote: Every definition of an interval I've seen defines it in terms of a set. For example, the interval (a,b) in R is the set {x : x > a...

William White

04-05-2004 05:39 PM
Tom Lane

How can i get a list of domain names from template1? -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819)...

Alexander Cohen

04-05-2004 03:40 PM
Alexander Cohen

SRA America is sponsoring an evening event with me in NYC. If folks want to go, the details are on our web site under "Events". -- Bruce Momjian ...

Bruce Momjian

04-05-2004 02:22 PM
Matthew T. O'Connor

Hello, In the init-script contained in the RPMs downloadable from the PostgreSQL site (I checked the one for Fedora), an explicit locale is set...

Troels Arvin

04-05-2004 01:46 PM
Lamar Owen

Hi, I'm running PostgreSQL 7.4 on Cygwin(Win XP Pro). Everything works perfectly, but I have to replace the current version with a 7.3 version for...

Jakub

04-05-2004 08:54 AM
Jakub

Hello, I have one main table and 2 many-to-many relation tables and 2 one-to-many relation table. Main table has 150 000 rows and...

Michal Hlavac

04-05-2004 08:48 AM
Michal Hlavac

I have just upgraded froom Fedora test1 to test2 which has upgraded postgres version from 7.4.2 to 7.4.5 (frrom rpm -q) I have used pg_dumpall to...

mike

04-05-2004 06:20 AM
mike

Hi all, Version 1.0.0.4 of the Postgresql OLE DB provider for Windows was just released. Get it...

Shachar Shemesh

04-04-2004 06:10 PM
Shachar Shemesh

Hi, I have a machine that is currently a bit unstable. No I got a: sysad=# select * from attacks where start < '1.1.2000'; ERROR: Invalid page...

Konstantinos Agouros

04-04-2004 10:28 AM
Konstantinos Agouros

I have a table that will have a parent/child relationship (specifically a recursive collection of categories) and was wondering if I can reference a...

Joe Stump

04-03-2004 11:46 PM
Joe Stump

When I try to run thread_test.c from the CVS tip, it hangs in an infinite CPU loop on both linux (RedHat AS 3.0, gcc 3.2.3) and Mac OS X 10.3.3...

Wes Palmer

04-03-2004 04:32 PM
Wes Palmer

Hi: I prepare the statement for execution as follows: PREPARE query(text) as SELECT count(*) FROM transform_customer_billing where inv_no =...

Rajat Katyal

04-03-2004 01:41 PM
Tom Lane

While trying to install the roundup issue tracking system I discovered the following - faulty - behaviour: My fresh postgres 7.4.2 install on a...

Mathias Picker

04-03-2004 01:38 PM
Tom Lane

I hope this is the correct newsgroup for this query (if not please give me a pointer to where is best): I understand the theory of normalisation etc...

Louis Aslett

04-03-2004 08:27 AM
Louis Aslett

hi PGurus, i searched the archives and read the docs, because this problem shouldn't be new. But i really don't know what to search for. i am...

Janning Vygen

04-03-2004 07:59 AM
Janning Vygen

I came across an interesting feature regarding namespace name changes. To illustrate suppose you have two connections open whose commands occur...

Jeffrey R. Greco

04-03-2004 12:27 AM
Jeffrey R. Greco

I am trying to update rows in a new table and re-cast to boolean at the same time. I am absolutely certain that the integers are 0 or 1. Is there a...

Randall Skelton

04-02-2004 07:54 PM
Manfred Koizar

Hi, I would like to know for all the entries inside pg_class table (except for shared tables and views), does the relfilenode field always...

muteki

04-02-2004 06:19 PM
muteki

On Wed, Mar 31, 2004 at 12:30:58 -0500, John DeSoi <jd (AT) icx (DOT) net> wrote: You should be able to do this with a view. current_user will give...

Bruno Wolff III

04-02-2004 03:26 PM
Bruno Wolff III

What is the storage cost of a null entry in a column? i.e. does a null entry of type integer, float8 or text consume the same amount of storage as...

Randall Skelton

04-02-2004 02:47 PM
Randall Skelton

Is there a mechanism to execute a function after the user connects to the database? I would like to set the schema path based on the user's group...

John DeSoi

04-02-2004 02:26 PM
Bruno Wolff III

Using psql and running as the owner of the table "app" I try to access the columns of the table like so: SELECT * FROM app; which returns all the...

Iker Arizmendi

04-02-2004 02:17 PM
Joe Sunday

VIRUS ALERT Notre anti-virus a trouvé W32/Netsky-P virus dans un email vous etant adresse from: falken (AT) canalvisualbasic (DOT) net Le message...

virusalert@pyrenet.fr

04-02-2004 10:25 AM
virusalert@pyrenet.fr

Does the optimizer optimize away the foreign key checks on a primary key if its value doesn't change, even though it's had a value assigned to it? ...

Sean Chittenden

04-02-2004 10:22 AM
Tom Lane