Sponsored Links

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

Page 51 of 96

« First

Last »

Threads in Forum : comp.databases.postgresql.general

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Enable/Disable triggers Hello list, Is there a way to disable temporary all the triggers of a table or database and then enable them back? Thanks in advance -- Josué... Josué Maldonado	03-04-2004 11:33 AM Bruce Momjian	1	126
Tips for public hosting ? Hi, Do you know if there is a guide and/or a description of procedures to make a public hosting site with PostgreSQL. Sorry for my english ... so I... Hervé Piedvache	03-04-2004 10:53 AM Hervé Piedvache	0	123
VIRUS (W32/Bagle-Zip) DANS UN MAIL VOUS ETANT ADRESSE (from<pgsql-general-owner+M58202@postgresql.org>) VIRUS ALERT Notre anti-virus a trouvé W32/Bagle-Zip virus dans un email vous etant adresse from: pgsql-general-owner+M58202 (AT) postgresql (DOT)... virusalert@pyrenet.fr	03-04-2004 10:41 AM virusalert@pyrenet.fr	0	128
META: Filtering viruses/worms -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Since "amavisd" does not appear to be catching the latest worm, how about filtering on size?... Greg Sabino Mullane	03-04-2004 10:09 AM Marc G. Fournier	3	131
Information about a column Dear All, I have column that contains couple of million rows of information and I was wondering what is the standard way of keeping 'summary... C G	03-04-2004 09:46 AM C G	0	126
libpq API for PQcmdTuples() -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi I was working recently on a mid-layer in my current projects for abstraction of SQL backends... Mihai RUSU	03-04-2004 08:05 AM Mihai RUSU	2	143
using Postgres to store many small files I am currently working on a Java web application in which we are making use of the JDBC driver for Postgres 7.4.1. Part of our application allows... Matthew Hixson	03-04-2004 07:12 AM Bas Scheffers	2	174
Réf. : Re: SPI memory managment issue after investigation, I have to reformulate : The actual memory is freed after each call of spi_finish, which is cool. However the global amount of... bsimon@loxane.com	03-04-2004 06:16 AM bsimon@loxane.com	0	125
need advice. I have a database that should be quite simple to do. I have a base object that is easily defined as create table myObject ( a integer, b... JustSomeGuy	03-03-2004 09:18 PM JustSomeGuy	0	123
Setting up Postgresql in Linux Phil Campaigne wrote: According to the docs you need it if you are going to create your own functions, however the documentation is a bit vague.... phil campaigne	03-03-2004 07:17 PM phil campaigne	0	95
Mistake in my query or Index Scan on subquery failure? (7.4) Hello, I have a problem with this simple query : explain select * from ref_artikel a where a.artnr in ( 351275 , 351346 , 293082 ) LIMIT 20 OFFSET... Gellert, Andre	03-03-2004 06:21 PM Tom Lane	2	96
Simple, but VERYuseful enhancement for psql command - or am I missing something? I'm designing a fairly involved database system. As part fo the process, I use the \i command a great deal. I set up fairly involved... Ben	03-03-2004 05:15 PM Ben	5	96
Slony-I makes progress After some substantial progress on the Slony-I engine development, I'd like to give a little status report and invite everyone who wants... Jan Wieck	03-03-2004 04:57 PM Jan Wieck	0	125
How index are running and how to optimise ? Hi, I have may be a stupid question, but I'm a little surprised with some explains I have, using date fields ... I would like to understand exactly... Hervé Piedvache	03-03-2004 01:52 PM scott.marlowe	2	100
Re: [ANNOUNCE] PostgreSQL 7.3.6 Now Available ... Hi, Just realized that man pages are not installed. Reason is that doc/man.tar.gz does not exists, but Makefile expects it. instead, there is a... Palle Girgensohn	03-03-2004 11:28 AM Palle Girgensohn	8	100
Error message Hello. After I have performed several queries by an external program on the database, an error message appeared: "hard limit on result handles... Eric	03-03-2004 10:57 AM Eric	0	131
Re: docs on tsearch2 See http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ George Essig ---------------------------(end of... George Essig	03-03-2004 10:56 AM George Essig	0	82
Setting up Postgresql on Linux On Mon, 1 Mar 2004, phil campaigne wrote: Phil, backtrack a bit...you can't edit postgres.conf until you've done an initdb because initdb... phil campaigne	03-03-2004 10:55 AM Ron St-Pierre	2	101
autocommit to off? Hi all, I've scoured the net for a simple way to set AUTOCOMMIT off in psql, for the duration of a session (not simply a transaction). The only... Bricklen	03-03-2004 10:51 AM Bricklen	0	135
making a copy of a table within the same database I wanted to dump the contents of one table to another (with a different name) within the same database. I am looking at pg_restore and it... Sally Sally	03-03-2004 10:37 AM Oliver Elphick	6	89
SPI memory managment issue I've read in the doc that every memory allocation done in a spi memory context was freed at the end of the context (after spi_finish) What happens if... bsimon@loxane.com	03-03-2004 10:08 AM Tom Lane	1	91
Selecting reals into doubles I have attached some SQL which produces what to me, at least, is rather unexpected results. Selecting real columns into double precision columns... Will Newton	03-03-2004 10:04 AM Tom Lane	2	97
compartmentalizing users Is there a way to segregate users by database or schema so that in a hosting situation you could keep different customers apart? Otherwise,... jwsacksteder@ramprecision.com	03-03-2004 09:16 AM Bruce Momjian	3	103
Large Object Hello: I am storing wave file in my postgresql database table as OID type. And I can use lo_export / lo_import to insert / select the corresponding... Mimi Siu	03-03-2004 09:14 AM Mimi Siu	0	134
PostgreSQL insert speed tests ( 1 2 ) Hello I need high throughput while inserting into PostgreSQL. Because of that I did some PostgreSQL insert performance... Sezai YILMAZ	03-03-2004 09:13 AM Bruce Momjian	11	165
Trigger using 'if NEW = OLD' I've got a trigger function that gets executed after an insert or an update. It basically just creates a copy of the row in a history... Colin Fox	03-03-2004 07:39 AM Colin Fox	0	120
plpgsql trigger function with arguments I'm sure I saw something like this on the postgresql web site but the the search function is down in the documentation area. I'm unable to pass a... Karl O. Pinc	03-03-2004 07:22 AM Colin Fox	2	111
constraints How can i get a list of constraints on a table? -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443 Alexander Cohen	03-02-2004 10:38 PM Karl O. Pinc	1	101
Max/min of 2 values function, plpgsql efficency? I'd like to write: SELECT larger(colA, colB) FROM foo and am wondering the best way to go about it. (Really, I'd like the larger() function to... Karl O. Pinc	03-02-2004 10:16 PM Joe Conway	3	117
Before ship 7.4.2 Is someone taking care about the fact that the pgdb.py shipped with 7.4.1 is the wrong version? What bail me out is the fact that the version pgdb.py... Gaetano Mendola	03-02-2004 08:10 PM Lamar Owen	4	127
Setting up Postgresql on Linux Thanks for the great response. I will try all of your ideas and get back with the results in a couple of days. thanks,... Phil Campaigne	03-02-2004 04:14 PM Phil Campaigne	0	99
using the "copy from" command Hi, I'm a first-time user of the "Copy ... From..." command, and I'm trying to load a table from a text flat... Knepper, Michelle	03-02-2004 03:53 PM Knepper, Michelle	4	135
Moving from MySQL to PGSQL....some questions ( 1 2 ) One easy way is to use the psql command line program and the \d command. It lists all your tables, lists all the columns in a table, etc. Karl <kop... Karam Chand	03-02-2004 01:57 PM Bruce Momjian	14	146
max table size Hi all, I'm running a data warehouse in Postgres and I was wondering what the max table size is column-wise and row-wise. I tried to search the... Alan Carbutt	03-02-2004 12:38 PM Bruno Wolff III	1	131
How to Cancel a query ? Hi, I issued a query from ASP using ADO. The web page after some time showed something similar to a 404 NOT found page. Postgres is still executing... Kuldeep Tanna	03-02-2004 11:48 AM Andrew Sullivan	1	103
Setting up Postgresql on Linux Hello, I originally installed postgresql as root user and now I am setting up a development environment with cvs and a java ide and tomcat. I... Phil Campaigne	03-02-2004 11:08 AM Ron St-Pierre	4	104
How to drop sequence? Hi, I have table: # \d category; category_id \| integer \| not null... Igor Kryltsov	03-02-2004 10:45 AM scott.marlowe	4	126
Data in table changed? Hi all, I have a large number of clients synchronizing with a central database. The clients update their local data by polling the database for... Thomas Holmgren	03-02-2004 10:23 AM Tom Lane	4	150
Installing Postgresql in Irix Hello friends, I am in trouble again...not exactly... my dependence on postgresql is increasing day by day !!! Now I am planning to install... Nilabhra Banerjee	03-02-2004 10:10 AM Tom Lane	1	96
More info on table fields Im looking to get a bit of info from a tables column. Im looking for if the column is a primary key, im also looking for the columns constraints and... Alexander Cohen	03-02-2004 08:18 AM Alexander Cohen	0	110
how to detect last change Hi, is some 'technical' way to detect where the last change (i.e. insert or update or delete) was performed on specified table ? I know I can write... Jan Poslusny	03-02-2004 05:28 AM Jan Poslusny	1	109
Setting up Postgresql on Linux On Mon, 1 Mar 2004, Phil Campaigne wrote: I'm a little confused as to what you are trying to accomplish. Can't you just start postgresql and... phil campaigne	03-01-2004 09:40 PM phil campaigne	0	111
can you run a psql command line query? After reading the manual, it looks like you can run a query on a single command line. But I cant get it to work... Does this look right to... tj	03-01-2004 09:15 PM tj	0	110
Why does app fail? ( 1 2 ) Hi, Like many here, I am fairly new to PostgreSQL having been forced to cut my teeth on Microsoft SQLServer. My apologies if this is the wrong... Paul Simpson	03-01-2004 08:32 PM Scott Ribe	11	211
sql query to get field types What sql query can i use to get all relative data to the types of fields that a table contains? -- Alexander... Alexander Cohen	03-01-2004 05:57 PM scott.marlowe	1	108
Linux Labs Heya, Does anyone have any experience of Linux Labs "Clusgres" (A Linux cluster hosting a PostgreSQL database server)? It seems to be a... Nick Barr	03-01-2004 05:48 PM Nick Barr	0	134
Re: SERIAL type - auto-increment grouped by other field You just need to define 'plpgsql' as a language in your database. At the shell, to define the language use: createlang 'plpgsql' <dbname>; After... Shachar Shemesh	03-01-2004 04:00 PM elein	2	76
using the "copy from" command to load tables from a txt flat file Hi out there, I'm a first-time user of the "Copy ... From..." command, and I'm trying to load a table from a text flat... Knepper, Michelle	03-01-2004 03:59 PM Bill Moran	1	96
Searches on www.postgresql.org failing "Can not connect to search daemon" -- greg ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your... Greg Stark	03-01-2004 03:38 PM Robert Treat	1	102
referring to computed values from the select list in the where andorder clauses I've got a moderately complex function defined which i then want to be able to test the value of, as well as select the value: select id,... Stephen Howard	03-01-2004 03:25 PM Stephen Howard	3	78

Page 51 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