Sponsored Links

comp.databases.postgresql.general comp.databases.postgresql.general

Page 21 of 96

« First

Last »

Threads in Forum : comp.databases.postgresql.general

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
beta2 not finding openssl Beta2 of 8.0.0 doesn't find openssl. 7.4.1 on the same system does. This is RH 9 (kernel 2.4.20-8) with openssl-0.9.7b installed from the source... Mike Nolan	09-01-2004 05:25 PM Tom Lane	1	69
materialized view PostgreSql support materialized views ??? if not, there is something similar?? Thanks Esteban kemp Esteban Kemp	09-01-2004 05:02 PM Alvaro Herrera	7	76
PostgreSQL and Fedora? Hi, I'm curious to know whether PostgreSQL works well with Fedora RedHat Linux? If there are any issues, I would like to know about them. Many... Daniel Secomb	09-01-2004 01:54 PM Glen Parker	4	81
insertiing an image file (blob) into postres... Dear my friends.... I created a column with datatype bytea. The name of the column is emoicon I did like this: kv=# insert into salesreport... Prabu Subroto	09-01-2004 12:59 PM Daniel Schuchardt	1	63
Re: PostgreSQL 8.0.0 Beta 2 Uploaded On Wed, Sep 01, 2004 at 01:18:59PM -0300, Marc G. Fournier wrote: Beta2 is also available via BitTorrent at <http://bt.postgresql.org/>. BTW, any... David Fetter	09-01-2004 12:50 PM Marc G. Fournier	1	79
possible memory leak in 8.0 beta 1 This is under Windows 2000 SP4 using the beta1 installer package. If I create the following table: CREATE TABLE test1 ( idnbr int4 NOT NULL, num1... Shelby Cain	09-01-2004 12:33 PM Tom Lane	2	61
Performance on 7.4 vs 7.2? Hi there Pg admins, I have 2 systems, one OLD, (linux 2.4 running postgresql-7.2.1-5 with a perl web db on Apache/1.3.23 mod_perl 1.26 and dbi 1.37... Pablo S	09-01-2004 11:23 AM jake johnson	2	78
<> syntax legal? Is it legal syntax to use <> instead of != in a Postgres query? I didn't see it listed... Greg Donald	09-01-2004 10:58 AM terry@ashtonwoodshomes.com	2	85
Suppress output from psql? Is there a way 'within' psql to suppress output? One of our cron scripts calls a sql file which contains various database commands (ALTER TABLEs,... Ron St-Pierre	09-01-2004 10:47 AM Ron St-Pierre	6	87
VISIO and System Tables Has anyone gotten VISIO setup to see the the pg system tables? I have Visio 2003 and i am not sure of the driver... UMPA Development	09-01-2004 09:56 AM UMPA Development	0	80
Types and SRF's Hi, I am trying to get my feet wet in SRF's I had to define a type in order to get my first attempt at a srf for an sql language function... Jerry LeVan	09-01-2004 07:24 AM Jerry LeVan	4	70
Importing data from MS Access Hi, I have a postgres instance up and running and I was using the EMS PostgresSQL datapump tool to import the data from MS Access but is there... Nick	09-01-2004 06:50 AM W. Scott Gibson	1	76
Rule/sequence weirdness I have some processes that create data. Other processes run by cron periodically take that data and insert it into appropriate tables in a 7.4.1... Steve Crawford	09-01-2004 03:30 AM Richard Huxton	1	66
Python Postgresql support? Is it possible to build the python postgresql support library on Mac OSX 10.3.5 with the default python install? Adding "--with-python" gets an... Jerry LeVan	09-01-2004 02:09 AM Pierre-Frédéric Caillaud	1	53
Overloading '<' operator Hi all, I was trying to overload '<' operator for (varchar,varchar). But in the function which handles the comparision I want to use the... Suresh Tri	09-01-2004 12:31 AM Suresh Tri	3	67
Error Message Importing Into PostgreSQL (Using phpPgAdmin) Hi, I'm using PostgreSQL 7.3.4 with phpPgAdmin 2.4.2 and the ".sql" file I'm trying to import came from a dump from a server running PostgreSQL... Daniel Secomb	09-01-2004 12:29 AM Russell Smith	1	53
Large Databases What is the linux and/or postgres limitation for very large databases, if any? We are looking at 6T-20T. My understanding is that if the hardware... elein	08-31-2004 10:41 PM Cott Lang	7	73
Representating a family tree Hi, Are there any built in or known structures I can use in Postgres to represent a family tree? The usual tree representations in SQL are for... Guy Naor	08-31-2004 09:04 PM Joel	1	59
Multicolumn Primary Key We've got a table that has a definition as follows: CREATE TABLE linking_table ( fk int8 REFERENCES source_table( pk1 ), value int8, PRIMARY KEY(... Thomas F.O'Connell	08-31-2004 06:44 PM Matthew T. O'Connor	5	66
expected both swapped tables to have TOAST tables I tried to truncate a table and received the following error: "expected both swapped tables to have TOAST tables". Googling provided no insight.... Steve Crawford	08-31-2004 06:36 PM Steve Crawford	2	54
[OT?] Problems with majordomo :-) * Alvaro Herrera <alvherre (AT) dcc (DOT) uchile.cl> : Ohhh! Thank you very much indeed, Alvaro. Your post, and Marc's answer, (although I don't... Ennio-Sr	08-31-2004 06:15 PM Ennio-Sr	4	71
cannot reach http:/archives.postgresql.org Is that site working for you? I'm unable to reach it since a couple of days, my messages are not getting through, pgsql-?????-owner (AT) postgresql... Ennio-Sr	08-31-2004 05:24 PM Marc G. Fournier	5	57
Re: Single Row Table? ( 1 2 ) On Fri, Aug 27, 2004 at 13:32:07 +0530, Yateen Joshi <yjoshi (AT) starentnetworks (DOT) com> wrote: A simple way to force this is to add a primary... Bruno Wolff III	08-31-2004 04:24 PM Mike Nolan	12	126
Substring result short by 1 Hi, I have a question about substring(), when I run the following query: prepaid=# select substring('15148300', 0,... David Filion	08-31-2004 03:49 PM Tom Lane	2	53
Change config of running PGSQL I have an existing installation of 7.3.4 that appears to have been made with "--without-readline and --without-zlib" parameters used at build time. ... McDougall, Marshall	08-31-2004 03:24 PM Doug McNaught	3	51
Microsoft Project and PostgreSQL? Does anyone have experiences using PostgreSQL for storing Microsoft Project data? MS Access, SQL Server and Oracle are supported according to the... Klaus Harbo	08-31-2004 03:17 PM Klaus Harbo	2	66
About "lock file postmaster.pid" Error , cannot setup postmaster Hello all, I met a problem about cannot start postmaster. The situation I met is that I was running postmaster, but because of the server closed... Ying Lu	08-31-2004 03:08 PM Ying Lu	2	53
Forcing a stored procedure recompile Hello everyone. Can anyone suggest if there's a way to force a plpgsql stored procedure to be recompiled every time that it's called, based on the... Mike McGavin	08-31-2004 01:53 PM Gaetano Mendola	1	54
Conditional foreign key? We have a list of customers, some of whom have purchased feature X and some of whom have not. If a customer has paid for featurex, they can use it,... Benjamin Smith	08-31-2004 12:10 PM Gaetano Mendola	1	65
DB failure? PostgreSQL: 7.4.1 Last week, I had a corrupt index on one table with 2 million rows. On a specific search, the database would SEGV. I dropped and... Wes Palmer	08-31-2004 10:27 AM Chester Kustarz	3	72
functions/stored procedures please CC me. Are the UDF/functions/procedures written by users available in all schemas in a DB? ---------------------------(end of... Dennis Gearon	08-31-2004 10:08 AM Dennis Gearon	0	60
pltcl.so problem.. I am trying to build pltcl.so and have a small problem. It builds fine butwhen I try to createlang, I get the dreaded "...server closed the... Ian Harding	08-31-2004 09:51 AM Ian Harding	0	63
Hebrew support -- please help ! Hi all, I develop an application (JAVA/JSP) on RedHat PostgreSQL 7.4.3 with PostgreSQL 7.4.2 JDBC3 with SSL (build 213). This application needs to... Elie Nacache	08-31-2004 06:58 AM Tatsuo Ishii	5	74
functionality like Oracle's "connect by" I know this question has been discussed, probably multiple times, but I can't seem to access archives.postgresql.org today.... I need to select all... David Parker	08-31-2004 05:44 AM Oleg Bartunov	2	65
Storing a query plan to disc... Hi! I'm new to PostgreSQL (and C) and what I'm trying to do is to store a query plan on disc (in a binary file). My approach is to use SPI functions... Katsaros Kwn/nos	08-31-2004 05:32 AM Katsaros Kwn/nos	0	58
Re: aggregates with complex type as state and init condition hi tom, thanks for your tipps. now it works for me. but i could not use a numeric array, because i found no way to assign the new calculated values... Thomas Chille	08-31-2004 05:23 AM Thomas Chille	0	54
Problems inserting data in Unicode format Hi. I have a PostgreSQL 7.4.3 DB in a debian box. I´ve created an Unicode DB in it. I connect to that linux from windows using PuTTY. My problem is... OKI	08-31-2004 03:25 AM OKI	0	54
Re: UTF-8 and LIKE vs = ( 1 2 3 4 ) On Aug 27, 2004, at 5:27 AM, Joel wrote: As far as I know, collation is essentially how an index is ordered, correct? So that when I so an "ORDER... Peter Eisentraut	08-31-2004 03:17 AM Joel	38	262
psqlodbc-07.03.0200 --with-iodbc won7t compile on Mac OS X Okay, not much traffic on the postgres.odbc group so I'll try here. I'm trying to get postgresql and excel x to talk over odbc and a cup of tea but... Tim Perkins	08-31-2004 12:43 AM Peter Eisentraut	1	74
update trigger performance Hello list, I'm having a performance issue with a trigger before update, a single row update take this explain analyze update detpp set... Josué Maldonado	08-30-2004 04:02 PM Josué Maldonado	0	57
moving an installation I need to be able to build postgres (7.4.3) with a given --prefix, but then pack up the installation directory and deploy it in another directory (as... David Parker	08-30-2004 03:54 PM Tom Lane	9	90
Copy Table from Text File; Start at Line Number X Rather than at Beginning of File Hi, I have a text file I need to import into Postgres, v. 7.2. The file has a header row. I want to begin the import at the line below the header... John Alexander	08-30-2004 01:21 PM John Alexander	0	52
Generic/Common trigger Hello list, Is there a way to write a common/generic trigger function for multiple tables to save in a column (stamp) the last time a row was... Josué Maldonado	08-30-2004 11:37 AM mallah@trade-india.com	1	76
Problem with select and null Hi all 'SELECT (null * null)' returns null 'SELECT (null - 0)' returns null 'SELECT ((null * null) - 0)' gives the following error - ERROR:... Frank Millman	08-30-2004 11:17 AM Tom Lane	2	59
Technical recommendations Hi all, I have received via the Advocacy questions about optimising a database server using PostgreSQL. The people asking the questions are... Francois Suter	08-30-2004 10:37 AM Scott Marlowe	3	64
Re: timestamp and date behaviour with '-infinity' On Mon, 30 Aug 2004, Russell Smith wrote: It looks to me that it turns into a NULL date. I'm not sure why it's doing that rather than an error,... Stephan Szabo	08-30-2004 10:33 AM Tom Lane	1	54
pg_autovacuum start-script I haven't had a chance to try it yet, but it looks like it will do what you want. Thomas F.O'Connell wrote: ---------------------------(end of... Thomas F.O'Connell	08-30-2004 09:10 AM Matthew T. O'Connor	7	60
Deadlocks caused by referential integrity checks On Aug 27, 2004, at 5:16 PM, Joshua D. Drake wrote: Thanks... On which transaction would I set that? The short one or the long one? Or both? And... Greg Stark	08-30-2004 08:58 AM Vivek Khera	6	50
is last modified timestamp for tables recorded in any system table(s)? is so,can someone direct me to the location? Tia ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading... email lists	08-30-2004 08:29 AM Michael Glaesemann	1	66
Process locked in INSERT: how to debug? Hello, What is the best method to debug a database that sometimes gets locked in the INSERT mode? ('ps -afx \| grep postgres' shows me a process... Philippe Lang	08-30-2004 07:47 AM Csaba Nagy	1	54

Page 21 of 96

« First

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off