cc me please: ---------------- I can't find in the HTML documentation the max length of a bit string. Anyone know where it...

Dennis Gearon

10-20-2004 02:34 PM
Dennis Gearon

is there a way to create a table with a certain type? CREATE TYPE typename AS (id integer, name varchar); and something like CREATE TABLE names OF...

Hicham G. Elmongui

10-20-2004 01:43 PM
Hicham G. Elmongui

I got a table with oid 25459. The file is 1073741824 bytes big. I did some more inserts, and now I have this two new files: size/name: 1073741824...

Leonardo Francalanci

10-20-2004 01:20 PM
Chris Browne

I was attempting to set up my psql client on the Win32 version of postgres 8.0 beta 2 to be able to use an external editor. I set the environment...

John Browne

10-20-2004 12:25 PM
John Browne

On Wed, 2004-10-13 at 06:31, Ed Stoner wrote: A username is an identifier; per the docs, "SQL identifiers and key words must begin with a letter...

Neil Conway

10-20-2004 12:21 PM
Lincoln Yeoh

IM trying to build the ppostgres ODBC driver for MacOSX. I thought id try and build it as a bundle from XCode. All compiles no problem but then at...

Alexander Cohen

10-20-2004 12:10 PM
Alexander Cohen

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 11:16 AM
David Ecker

Hello, We have been working on migrating oracle database to postgres for one of our client. We have a stored procedure in oracle which uses varray...

arvind

10-20-2004 10:46 AM
arvind

Some time ago (May 2004), we were making changes to a Postgresql server to allow a host to connect (pg_hba.conf). When we restarted the server, and...

Roberts, Adam

10-20-2004 10:15 AM
Tom Lane

It is very weird, I just tried both a group by and distinct and both of them still return the duplicates. I also tried a very simple union which...

Sim Zacks

10-20-2004 08:52 AM
Alvaro Herrera Munoz

Hello! Could you please run this with debugging enabled? You do this by passing "-d" to initdb. The interesting output is the stuff that comes...

Magnus Hagander

10-20-2004 04:51 AM
Magnus Hagander

On Wed, 2004-10-20 at 01:03, Kathiravan Velusamy wrote: It looks like the table is being defined with the column quoted, like this: create table...

Scott Marlowe

10-20-2004 03:49 AM
Scott Marlowe

Hello Searched around, but could not find this mentioned. I've noticed the following behaviour in 7.4.5: select * from foo where col1 = 1 or col1...

Henry Combrinck

10-20-2004 03:16 AM
Henry Combrinck

Thanks for the link. I had already looked at that page, and it gives basically no help at all. I think the problem is how Pgadmin handles new lines...

Sim Zacks

10-20-2004 01:40 AM
Stuart Bishop

Hi, while upgrade to 8.0 (beta3) we got some problem: we have a database which encoding is UNICODE, when we do queries like: select upper('ÖÐÎÄ');...

Weiping

10-19-2004 11:37 PM
Weiping

Hello, Is there a way to recover from the following error? I have (had) an existing database and wish not to lose the data tables. Thanks for any...

peter Willis

10-19-2004 09:52 PM
pw

Hello, Is there any way to reuse a column label in a select list like this: SELECT 1 + 1 AS a, a + 1 AS b; I vaguely remember being able to do...

ryan

10-19-2004 06:18 PM
Steven Klassen

Have you looked at the 7.3 configuration file vs. the 8.0. It's possible that the 7.3 file is tweakled better then the 8.0. Have you anaylzed the...

Kevin Barnard

10-19-2004 06:09 PM
Kevin Barnard

Ack! I sent this msg on October 14. Since then, I've gotten the primary key stuff working. Please disregard this msg. Thanks Scott

Scott Frankel

10-19-2004 05:40 PM
Scott Frankel

Is there a way to remove idle connections? My postgres server is getting serveral hundred idle connections. It's due to a postgres .NET provider not...

Josh Close

10-19-2004 03:27 PM
Gaetano Mendola

I'm trying to add some functionality to an already existing application...this applications works fine, and uses the PHP function pg_pconnect to make...

Jonathan Villa

10-19-2004 03:27 PM
Jonathan Villa

Hallo! I have a big problem, I am under time pressure to finish my project. can anybody please help me? I am developing a DB System associated with...

Tham Paudel

10-19-2004 02:25 PM
Tham Paudel

Is there a way to vacuum all tables in a schema? Or will I need to write a script to do it? -Josh ---------------------------(end of...

Josh Close

10-19-2004 02:21 PM
Thomas F.O'Connell

I'm not sure where to find it exactly, but does anyone know how much data a column of type "text" in a postgres DB can hold? Thanks

John Ossmann

10-19-2004 02:15 PM
John DeSoi

---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Froggy / Froggy Corp.

10-19-2004 01:33 PM
Froggy / Froggy Corp.

Hello ppl, Imagine some online system, based on PgSql. There are 'many' parts which depends on each other. I will give small example, but instead of...

Lada 'Ray' Lostak

10-19-2004 11:33 AM
Andrew Sullivan

Hi I tried creating the function (from sec 19.3.1). But it gives me the following error: "ERROR: type tablename does not exist". Any ideas of what i...

Hicham G. Elmongui

10-19-2004 11:32 AM
Tom Lane

Google "slony" Regards, aaron.glenn On Thu, 14 Oct 2004 10:29:11 +0530, Nageshwar Rao <nageshwarr (AT) planetasia (DOT) com>...

Aaron Glenn

10-19-2004 10:43 AM
Andrew Sullivan

Experimenting with Beta 8 on Windows; we got this message while running PC-SAS queries against a table with over 7 million rows. Which...

Taber, Mark

10-19-2004 10:29 AM
Taber, Mark

It is possible to mainteners of this list to keep this list from "/$?%/$?/? windows problems? I don't care about windows. The worst thing never...

Eric

10-19-2004 09:20 AM
Jan Wieck

Hello there, I am thinking how to solve another typical problem of online systems with combination of thin client... Imagine simple case, 2 users...

Lada 'Ray' Lostak

10-19-2004 07:50 AM
Lada 'Ray' Lostak

I'm a first-time user with PostgreSQL so please forgive my ignorance. I've purchased (and read) Practical PostgreSQL (O'Reilly) and...

Don Kelloway

10-19-2004 04:46 AM
Richard Huxton

Do you by any chance have more than one libpq.dll on your system? That these users might pick up in a different order because of different PATHs or...

Magnus Hagander

10-19-2004 04:16 AM
Magnus Hagander

hi,Gaetano Mendola: you wrote: em ,because i make a stupid mistake in programming!! :(( I made use of transactions to ensure database...

Ann

10-18-2004 11:58 PM
Ann

I *think* I'm seeing "vacuum analyze" queries launched automatically on an 8.0.0beta3 (unless I have a rogue autovac running that I haven't...

Ed L.

10-18-2004 06:30 PM
Ed L.

Mark Gibson <gibsonm (AT) cromwell (DOT) co.uk> writes: There's something awfully flaky going on here. The system should never have let you get...

Mark Gibson

10-18-2004 03:41 PM
Jan Wieck

BiggerSQL is an advanced Cocoa based Postgresql Browser/Editor for Mac OSX users. BiggerSQL lives at http://homepage.mac.com/levanj/Cocoa BiggerSQL...

Jerry LeVan

10-18-2004 01:19 PM
Jerry LeVan

in spite of the efforts of the french mailing list, an paper with some "grossieres" erreurs...I...

Masse Jacques

10-18-2004 01:14 PM
Hervé Piedvache

Hello Does PostgreSQL provide anything comparable with the functionality of MySQL Cluster? I appreciate all information. Thank you. Tim

nd02tsk@student.hig.se

10-18-2004 01:08 PM
Andrew Sullivan

Hello. I have a query like: SELECT big_table.* FROM little_table, big_table WHERE little_table.x = 10 AND little_table.y IN (big_table.y1,...

Mike Mascari

10-18-2004 10:19 AM
Bruno Wolff III

Hallo! I have a big problem, could you please help me? I am developing a DB System accociated with a File server. The DB Server schould manage...

Tham Paudel

10-18-2004 07:25 AM
Tham Paudel

I need to increase the number of connections to PostgreSQL 7.2.1. I have tried changing the value of max_connections in Postgresql.conf. It was...

Edwin New

10-17-2004 11:17 PM
Edwin New

I'm having a problem with a value coming out of a loop. CREATE OR REPLACE FUNCTION funmessagespermintotal() RETURNS int8 AS ' DECLARE this_rServer...

Josh Close

10-17-2004 03:37 PM
Josh Close

When a timestamp string input contains a timezone abbreviation (CDT, PST, etc), which timezone offset is used? The input date's or today date's? The...

David Garamond

10-17-2004 01:45 PM
Tom Lane

Hi, The operating system I run (Linux) comes with many, many timezone files for many different places in the world. For example: $...

Martijn van Oosterhout

10-17-2004 11:28 AM
Martijn van Oosterhout

I'm a C/Objective C programmer and am having a bit of difficulty figuring out how to define SQL table approximations to things that are very easy to...

Ken Tozier

10-17-2004 09:30 AM
Ken Tozier

Hello, Thank you to Oleg for your help with this earlier! It resolved it very nicely! I still have one remaining issue which I can't figure out,...

Net Virtual Mailing Lists

10-17-2004 01:55 AM
Oleg Bartunov

Hi, can pgsql acceppt invalid date values? Sometimes it would be nice to convert 2003-02-29 to 2003-03-01 or to 2003-02-28 automatically instead of...

Mage

10-17-2004 12:05 AM
Scott Marlowe

Hello, I've got a C++ library I need to use, and I want to use it from a pgsql function. Would anyone happen to have any examples of how to...

Eric Parusel

10-16-2004 11:56 PM
Tom Lane

Is it down ? regards ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose...

snpe

10-16-2004 10:46 PM
Alvaro Herrera