Re: [GENERAL] Divert triggers on materialized views

the "current" partition, so the overhead of a single large index & table is no longer an issue. Cheers Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529 Brent Wood Principal Technician - GIS and Spatial Data Management Programme Leader - Enviro

Re: [GENERAL] $foo $bar is BAD

asm, acronyms, etc... If we refused to use any words which had a historical connotation than might offend someone, we might as well forget about documentation altogether. Brent Wood Brent Wood Principal Technician - GIS and Spatial Data Management Programme Leader - Environmental Information

Re: [GENERAL] About COPY command (and probably file fdw too)

... Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529 Brent Wood Principal Technician - GIS and Spatial Data Management Programme Leader - Environmental Information Delivery +64-4-386-0529 | 301 Evans Bay Parade, Greta Point, Wellington

Re: [GENERAL] Why is there no object create date is the catalogs?

written on a piece of paper), inserts, updates/edits, etc... but doing this in a standard way to meet all users needs is a long standing, unsolved probably unsolvable issue. Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529 Brent Wood Principal

Re: [GENERAL] Partioning with overlapping and non overlapping constraints

which migrates such records from a live to fixed partition would perhaps be appropriate. Organising your data by UTC timestamp may be the simplest approach for you. Cheers Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529

[GENERAL] Postgres char type inconsistency

|1 3 |1 So, in summary, varchar stores whatever feed to it and keeps trailing spaces to max length, char type will trim off trailing spaces, and stor a string shorter than the specified length.. Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4

Re: [GENERAL] synchronize DTAP

tools like rsynch - which offers intriguing backup replication possibilities. http://vimeo.com/105493143 the demo of the FUSE functionality starts at 39 minutes into the presentation. Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529 Brent Wood

Re: [GENERAL] advice sought - general approaches to optimizing queries around event streams

help your performance, in terms of underlying db efficiency performance, rather than tweaking your actual queries. Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529 Brent Wood Principal Technician - GIS and Spatial Data Management Programme Leader

Re: [GENERAL] Linux vs FreeBSD

://uptime.netcraft.com/perf/reports/performance/Hosters?orderby=epercent Cheers, Brent Wood Brent Wood Principal Technician - GIS and Spatial Data Management Programme Leader - Environmental Information Delivery +64-4-386-0529 | 301 Evans Bay Parade, Greta Point, Wellington | www.niwa.co.nzhttp

Re: [GENERAL] SSD Drives

Hi David, Does the RAID 1 array give any performance benefits over a single drive? I'd guess that writes may be slower, reads may be faster (if balanced) but data security is improved. Brent Wood Brent Wood Principal Technician - GIS and Spatial Data Management Programme Leader

Re: [GENERAL] SSD Drives

have you seen this? http://it-blog.5amsolutions.com/2010/08/performance-of-postgresql-ssd-vs.html Brent Wood Brent Wood Principal Technician - GIS and Spatial Data Management Programme Leader - Environmental Information Delivery +64-4-386-0529 | 301 Evans Bay Parade, Greta Point, Wellington

Re: [GENERAL] Mysterious DB reset

records though. Cheers Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529 From: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org] on behalf of Thom Brown [t...@linux.com] Sent: Thursday, March 06

Re: [GENERAL] Multiple Schema in One DB

,maps psql fish In your case this could perhaps be used by each application to customise the run time environment, so each has it's own PGOPTIONS string, and thus, when Postgres is run, it's own search path. Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4

Re: [GENERAL] union of types in a different category

' UNION SELECT 1; ?column? -- 1 (1 row) I didn't think UNION did an explicit distinct - if that is what is happening? Brent Wood Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529 From: pgsql-general

Re: [GENERAL] bulk loading table via join of 2 large staging tables

at better than 1 sec precision (ie - more than one value per second) you might join with the avg() value and group by to bring the output into 1 sec values. Cheers Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529

Re: [GENERAL] earthdistance

: http://trac.osgeo.org/postgis/wiki/UsersWikiInstall Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529 From: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org] on behalf of Olivier Chaussavoine

Re: [GENERAL] earthdistance

You might install Postgis to implement very powerful spatial functionality that can easily do what you are asking (plus a whole lot more). http://www.postgis.org Now that v2 installs as a Postgres extension, it is more closely coupled with the underlying database. Brent Wood Programme leader

Re: [GENERAL] partial time stamp query

reading record, the automatic aggregation of daily points into daily track lines, so the track for any selected set of dates can easily be displayed on a map (the platforms are mobile vessels - not fixed sites) You might adapt some of these ideas for your use case? Cheers Brent Wood Programme

Re: [GENERAL] COPY column order

+--+--- 1 | one |10 (1 row) HTH Brent Wood GIS/DBA consultant NIWA +64 (4) 4 386-0300 From: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org] on behalf of MD33 [mdubosfo...@yahoo.com] Sent: Tuesday, May 08, 2012 12:33 AM

Re: [GENERAL] CPU Load 100% when pg_dump start in Postgresql 8.4

Can you not nice the dump process to free up resources during the dump? Of course this will not free up any locks, and will make them hang around longer as the dump is slowed down. Brent Wood GIS/DBA consultant NIWA +64 (4) 4 386-0300 From: pgsql

Re: [GENERAL] huge price database question..

Also look at a clustered index on timestamp Brent Wood GIS/DBA consultant NIWA +64 (4) 4 386-0300 From: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org] on behalf of Jim Green [student.northwest...@gmail.com] Sent: Wednesday

Re: [GENERAL] what Linux to run

:-) Brent Wood GIS/DBA consultant NIWA +64 (4) 4 386-0300 From: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org] on behalf of David Boreham [david_l...@boreham.org] Sent: Sunday, March 04, 2012 3:23 PM To: pgsql-general@postgresql.org

Re: [GENERAL] running multiple versions

Run them in different locations with different addresses (5432 5433 for example) see this thread:http://archives.postgresql.org/pgsql-admin/2008-02/msg00084.php Brent Wood GIS/DBA consultant NIWA +64 (4) 4 386-0300 From: pgsql-general-ow

[GENERAL] Factors Influencing Participant Satisfaction with Free/Libre and Open Source Software Projects

Apologies for the cross posting, but this thesis may be of interest to a wide array of FOSS related lists. It just went public: Title:     Factors Influencing Participant Satisfaction with Free/Libre and Open Source Software Projects Author:     Chawner, Brenda Abstract:     The purpose of

Re: [GENERAL] Error Importing CSV File

, Brent Wood #! /bin/bash DB=test psql -d $DB -c drop table geo_data; # latitude has only one 't' psql -d $DB -c create table geo_data ( zip_code text, latitude float8, longitude float8, city text, state

Re: [GENERAL] Read MS-SQL data into Postgres via ODBC link?

example: psql -d $DB1 -F '|' -Atc select * from table; | psql -d $DB2 -c copy table from STDIN with delimiter '|' with null ''; A MySQL example would be similar, the second part pretty much identical. HTH, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Jonathan

Re: [GENERAL] Miidpoint between two long/lat points? (earthdistance?)

Why not install PostGIS with full ellipsoidal projection support use the azimuth distance functions available in SQL? Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Carlo Stonebanks 05/27/11 8:20 AM Nicely done, Merlin! Hope others with the same problem can find

Re: [GENERAL] concatenating with NULLs

'b' isnull then '_' else 'b' end) || (case when NULL is null then '_' end); ?column? -- ab_ (1 row) test=# HTH, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Seb 04

Re: [GENERAL] Postgres 9.1 - Release Theme

I haven't checked to follow this up, but it seems like the sort of announcement one might expect on 1 April. Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Darren Duncan 04/02/11 3:01 PM I was under the impression that QUEL was actually a good language in some ways

Re: [GENERAL] Web Hosting

companies, they allow you to install run Postgres, but do not provide support for it. Although given the technical competencies of their support staff, you may find one of them will be able to help anyway. HTH, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Uwe

Re: [GENERAL] Simple, free PG GUI/query tool wanted

Hi, pgadmin is still an admin tool, NOT a simple user query tool. I'd suggest PG Access as worth a look, but unfortunately it is no longer supported, and I have never tried it with a recent version of Postgres. Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Elford

Re: [GENERAL] COPY FROM and INSERT INTO rules

From the 8.3 docs... Be aware that COPY ignores rules. ... COPY does fire triggers, so you can use it normally if you use the trigger approach. HTH, Brent Wood All, I have a rule written on a temp table which will copy the valuesinserted into it to another table applying

Re: [GENERAL] Dumping a table from one database and adding it to another

Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand James B. Byrne 12/03/10 12:56 PM I have read the documentation respecting backups but I cannot seem to find any mention of the specific case that I wish performed. Hi James, pg_dump can take arguments to dump a specified table

Re: [GENERAL] techniques for bulk load of spatial data

data into PostGIS, depending on how big a bulk you are talking about. If your spatial data is available in Postgis WKB format, you could generate a file to use with Postgres copy command? Regards, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Please consider

Re: [GENERAL] median for postgresql 8.3

://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01 HTH, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand maarten 11/17/10 9:15 AM Hello everyone, I was doing some analysis of data to find average delays between some timestamp values etc... When

Re: [GENERAL] Database INNOVATION

perspective to support biological taxonomic trees/heirarchies, which do not easily fit the SQL model, although a number of kludges to traverse such structures are around. (I need to look at the Postgres recursive capability for this sometime) Cheers, Brent Brent Wood DBA/GIS consultant NIWA

Re: [GENERAL] Database INNOVATION

Have a look at PL/R. You can embed a command to generate a graphic using R via a user defined SQL function, This example from http://www.varlena.com/GeneralBits/Tidbits/bernier/art_66/graphingWithR.html HTH Brent Wood

Re: [GENERAL] Selecting top N percent of records.

Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Tim Uckun 10/18/10 3:40 PM Is there a way to select the top 10% of the values from a column? For example the top 10% best selling items where number of sales is a column. Thanks. -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] How to force select to return exactly one row

it for the output value without a second query. All depends on how much overhead there is in teh query. HTH, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Andrus 06/22/10 10:12 AM Autogenerated select statement contains 0 .. n left joins: SELECT somecolumns FROM ko

Re: [GENERAL] Best way to handle multi-billion row read-only table?

If you will be selecting sets of data within a time range, it should also improve performance if you can build a clustered index on the sample_time. It may also be worth looking at whether partitioning by timestamp channel offers any advantages. Brent Wood Brent Wood DBA/GIS consultant NIWA

Re: [GENERAL] db not dumping properly, or at least not restoring

an empty target db with PostGIS installed first, then let the constraints on PostGIS objects prevent the old PostGIS being installed in the new db. Or you can copy over the old PostGIS use the PostGIS upgrade SQL. Cheers, Brent Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Kirk

Re: [GENERAL] How to get variable out to shell script

to the variable called COUNT. The -Atc tells psql to return only the unaligned value, no formatting or column names, etc. If you store your SQL command outside the script, then you could use: COUNT=`psql -d database -Atf SQL_file` HTH, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New

Re: [GENERAL] haversine formula with postgreSQL

Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Scott Marlowe scott.marl...@gmail.com 09/18/09 11:35 AM On Thu, Sep 17, 2009 at 1:16 PM, Jonathan jharah...@gmail.com wrote: Hi! I am looking at the PHP/MySQL Google Maps API store locator example here: http

[GENERAL] psql crashing - don't know why

not in a position to upgrade at this point. Thanks, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand NIWA is the trading name of the National Institute of Water Atmospheric Research Ltd. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] commercial adaptation of postgres

Also try Netezza, one data warehouse appliance originally based on Postgres. Although this is not the only such Postgres derivative. Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Greg Smith gsm...@gregsmith.com 07/24/09 9:10 AM On Mon, 20 Jul 2009

Re: [GENERAL] indexes on float8 vs integer

in the front end. Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Scott Marlowe scott.marl...@gmail.com 07/12/09 10:31 PM On Sat, Jul 11, 2009 at 10:15 PM, Dennis Gearongear...@sbcglobal.net wrote: Anyone got any insight or experience in the speed and size

Re: [GENERAL] 10 TB database

as well, so it is a mix of hardware/OS/filesystem db setup to optimise for such a situation. For data retrieval, clustered indexes may help, but as this requires a physical reordering of the data on disk, it may be impractical. Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA

Re: [GENERAL] Change view definition - do not have to drop it

HTH, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Emi Lu em...@encs.concordia.ca 06/03/09 10:45 AM Now I need update view1 definition to create or replace view view1 as select col1, col2 from new_table; However, col1 in new_table is not bpchar. This gives me

Re: [GENERAL] Online Backups PostGre (rsync for Windows)

Hi There are a few rsync on Windows options, just google rsync windows One we've found works well is DeltaCopy, which may meet your requirements. Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Adam Ruth adamr...@mac.com 05/02/09 1:01 PM Cygwin comes

Re: [GENERAL] Proper entry of polygon type data

Hi Peter, If you want to use Postgres to store/manage/query spatial data, I strongly recommend you look at PostGIS, not the native Postgres geometry types. Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Peter Willis pet...@borstad.com 03/24/09 10:35 AM Hello, I

Re: [GENERAL] SRID conflict, PostgreSQL 8.3

, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand csmith csm...@insequenceinc.com 03/21/09 8:57 AM Hello, I serve a Geospatial IS project that for some years has used PostgreSQL and PostGIS. A strategy/scheme that has worked for all previous versions has failed

Re: [GENERAL] Uploading data to postgresql database

not have PostGIS drivers compiled in, if it doesn't you can compile it yourself against Postgres/PostGIS to enable this on your platform. Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Subha Ramakrishnan su...@gslab.com 03/18/09 7:04 PM Hi, Thanks for the reply. I

Re: [GENERAL] surprising results with random()

the original intent is to NOT generate an equal distribution, but I'm not sure what distribution is required. Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand ries van Twisk p...@rvt.dds.nl 02/24/09 12:13 PM Jessi, should the function not look like

Re: [GENERAL] Appending \o output instead of overwriting the output file

Thanks Tom, That will do trick. Perhaps \o+ as a future fix for this? Brent Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Tom Lane t...@sss.pgh.pa.us 02/18/09 7:46 PM Brent Wood b.w...@niwa.co.nz writes: Using \o to redirect output to a file from the psql command line

Re: [GENERAL] Appending \o output instead of overwriting the output file

away ... Thanks, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Tom Lane t...@sss.pgh.pa.us 02/19/09 10:19 AM John R Pierce pie...@hogranch.com writes: Tom Lane wrote: Brent Wood b.w...@niwa.co.nz writes: Perhaps \o+ as a future fix for this? I'd prefer \o file

[GENERAL] Appending \o output instead of overwriting the output file

Hi, Using \o to redirect output to a file from the psql command line, is there any way to have the output appended to the output file, rather than overwriting it? Thanks, Brent Woood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand NIWA is the trading name of the National

Re: [GENERAL] Update table with random values from another table

, lastname, username, email, random() as rand from testnames order by rand) WHERE t_firstname x.firstname; Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Rory Campbell-Lange r...@campbell-lange.net 02/17/09 4:33 PM I have

[GENERAL] how to implement a foreign key type constraint against a not unique column

values with a unique index on it as the foreign key, then a view which uses case or coalesce to present the nulls as -1, but this seems a cumbersome workaround. Thanks, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand NIWA is the trading name of the National Institute

Re: [GENERAL] Relational database design book

It might be useful to look at the capabilities of the Informix Timeseries Datablade (http://www-01.ibm.com/software/data/informix/blades/) if you want to look at ways of enhancing the temporal data capabilities of Postgres. Cheers, Brent Brent Wood DBA/GIS consultant NIWA, Wellington

Re: [GENERAL] how to group several records with same timestamp into one line?

if other channels had data, because the query uses an inner join. If this is a problem then you'll need to reword the query as an outer join. HTH, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand zxo102 ouyang [EMAIL PROTECTED] 11/13/08 3:15 AM Hi everyone, My

Re: [GENERAL] how to best resync serial columns

in this situation. Thanks for the reply, I'll note it for future reference. Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Erik Jones [EMAIL PROTECTED] 11/11/08 8:03 PM On Nov 10, 2008, at 6:48 PM, Brent Wood wrote: Hi, I have a number of tables

Re: [GENERAL] ordered pg_dump

installed). None of which is ideal or robust, having pg_dump able to generate ordered dumps natively would be useful. Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Josh Williams [EMAIL PROTECTED] 11/11/08 8:04 PM On Mon, 2008-11-10 at 17:05 -0800, Jeff

[GENERAL] how to best resync serial columns

(id) from the relevant table. Thanks, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand NIWA is the trading name of the National Institute of Water Atmospheric Research Ltd. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] Defining string to represent null values in select

the columns in the query, but is there a simpler way, like setting a system variable to specify this? Thanks, Brent Wood -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Specifying text to substitute for NULLs in selects

automatically.. Thanks, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Said Ramirez [EMAIL PROTECTED] 11/08/08 12:34 PM I think you are more after something like SELECT CASE WHEN foo IS NULL THEN 'NA' END FROM bar. -Said Ivan Sergio Borgonovo wrote: On Thu, 6 Nov

Re: [GENERAL] Specifying text to substitute for NULLs in selects

Thanks Adrian, That's perfect!! Cheers, Brent Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Adrian Klaver [EMAIL PROTECTED] 11/08/08 1:49 PM On Friday 07 November 2008 4:05:08 pm Brent Wood wrote: Thanks guys, I'm aware of those options, what I was wondering

Re: [GENERAL] postgres/postgis

/Application:/Geo/ HTH, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Eduardo Arévalo [EMAIL PROTECTED] 10/07/08 6:34 AM hello is campatible install postgresql-8.3.4-1-linux-x64 with postgis-1.3.3. postgis there for 64-bit architecture?? There are the libraries

Re: [GENERAL] foreign key problem

Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Jorge Godoy [EMAIL PROTECTED] 09/17/08 1:36 AM Em Monday 15 September 2008 19:05:25 [EMAIL PROTECTED] escreveu: Hi, I need a foreign key (or equivalent) where the referenced table cannot have a unique constraint. For fisheries

Re: [GENERAL] PostgreSQL TPC-H test result?

anything else, so perhaps config files for typical 1Gb, 4Gb 8Gb systems could be provided out of the box to make initial installs simpler? Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand Andrew Sullivan [EMAIL PROTECTED] 09/10/08 3:47 AM On Tue, Sep 09, 2008 at 07

Re: [GENERAL] Oracle and Postgresql

making a living with contracts for Postgres support. Cheers, Brent Wood Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand David Fetter [EMAIL PROTECTED] 09/01/08 6:09 PM On Sun, Aug 31, 2008 at 10:44:38PM -0400, Guy Rouillier wrote: M2Y wrote: Why most enterprises prefer

Re: [GENERAL] What's size of your PostgreSQL Database?

, this is copied over the LAN to another server which is backed up to tape every day. It works for us :-) Cheers, Brent Wood Ow Mun Heng [EMAIL PROTECTED] 08/19/08 4:00 PM On Mon, 2008-08-18 at 11:01 -0400, justin wrote: Ow Mun Heng wrote: -Original Message- From: Scott Marlowe [EMAIL

Re: [GENERAL] Query help

If I read this correctly, you want the output sorted by config_id,start_day(day),start_time, thus: select config_id, start_day as day, start_time, end_time from config order by config_id, start_day, start_time; Cheers, Brent Wood novice [EMAIL PROTECTED] 08/15/08 3:55 PM Hi, I have

Re: [GENERAL] storing latitude and longitude

Hi Mark, Look at Postgis, to do this properly. It adds full OGC spec support for managing spatial/querying spatial data within a Postgres database. It is an option included with the Windows Postgres installer, but is generally extra packages under Linux. Cheers, Brent Wood mark [EMAIL

Re: [GENERAL] To store and retrive image data in postgresql

in the database, but the images they are derived from is still stored outside the database as a file, with the path/name stored as database fields as a pointer to the image. HTH, Brent Wood -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Temporary Tables and Web Application

, it is never actually written to disk, but just generally sits in the cache. Cheers, Brent Wood Bill Moran [EMAIL PROTECTED] 06/06/08 8:01 AM In response to Tim Tassonis [EMAIL PROTECTED]: Bill Moran wrote: In response to Tim Tassonis [EMAIL PROTECTED]: Now, with apache/php

[GENERAL] PG 8.3 review in Linux Mag

You can't read the online article without an account, but the headlines might still be of interest (or you can buy the magazine :-) http://www.linux-mag.com/id/5679 Cheers, Brent Wood -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] pg_dump and schemas

use of sed, but it can pretty well always be made to do this sort of operation. Cheers, Brent Wood Rusty Conover [EMAIL PROTECTED] 05/04/08 8:42 AM Hi All, Is there a way to pass a parameter to pg_dump that would make the produced dump be loaded into a different schema rather

Re: [GENERAL] pg_dump and schemas

, Brent Wood Hi Brent, It's not he best solution, because we could have fields containing public in their names and sed would happily change those to test1 as well. I'm looking for a safer solution, thats why it should be a part of pg_dump. Rusty On Apr 5, 2008, at 12:41 AM, Brent Wood

Re: [GENERAL] (FAQ?) JOIN condition - 'WHERE NULL = NULL'

. see: http://www.postgresql.org/docs/8.2/static/functions-conditional.html (Incidentally, if you are storing bathymetry or CTD data, I'd be interested in seeing your db structures, as I may be doing some work in that area soon :-) HTH, Brent Wood -- Sent via pgsql-general mailing list

Re: [GENERAL] Using tables in other PostGreSQL database

integrity rules to be applied to any database any user creates. Agreed, not a common requirement, but one where schemas are less flexible less secure. Cheers, Brent Wood Scott Marlowe [EMAIL PROTECTED] 29/03/08 4:37 AM On Thu, Mar 27, 2008 at 11:29 PM, Swaminathan Saikumar [EMAIL

Re: [GENERAL] IBM investing in EnterpriseDB

Add Informix to the list of IBM's RDBMS products.. Also note that where Postgres has PistGIC as an OGC compliant geodata extension, IBM already supports this in both DB2 Informix, so an even higher degree if interoperability is there for geospatial data. Brent Wood Alex Vinogradovs [EMAIL

Re: [GENERAL] IBM investing in EnterpriseDB

I need to learn to type!!! try PostGIS (how did that become PistGIC? I have no idea) Brent Wood [EMAIL PROTECTED] 27/03/08 1:44 PM Add Informix to the list of IBM's RDBMS products.. Also note that where Postgres has PistGIC as an OGC compliant geodata extension, IBM already supports

[GENERAL] Postgres development

to arrange for funds to cover this development. Thanks, Brent Wood -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Linux distro

at www.distrowatch.com to see their comments (but remember everyone has different likes dislikes, so treat any review with caution, as your opinion may vary) HTH, Brent Wood ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [GENERAL] Normal distribution et al.?

://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01 for a new intro, pretty basic, but a good place to start Brent Wood ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Command line export or copy utility?

STDIN with delimiters = '|'; Cheers, Brent Wood ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Views- Advantages and Disadvantages

Ashish Karalkar wrote: Thanks Brent for your replay, What about the Disadvantages, Performance issues? As far as I'm aware, performance is the only real disadvantage. I tend to break DB design into stages: ER modelling to define the entities/relationships the DB needs to store/represent

Re: [GENERAL] Views- Advantages and Disadvantages

Joshua D. Drake wrote: Brent Wood wrote: Ashish Karalkar wrote: Thanks Brent for your replay, What about the Disadvantages, Performance issues? As far as I'm aware, performance is the only real disadvantage. What performance are we talking about here? Executing from a view although has

Re: [GENERAL] PG on Debian 4.0.x ?

need the latest vesrions, Debian works well. Cheers, Brent Wood ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get

Re: [GENERAL] Utility of OIDs in postgres

a common access of the common fields. Cheers, Brent Wood ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Temporal Units

periods are about to end or have just ended. Cheers, Brent Wood ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] PG service restart failure (start getting ahead of stop?)

for that PID to disappear, then run your START, it may do what you want. Or someone may have a more elegant solution :-) Brent Wood We have a line in a shell script that calls /etc/init.d/postgresql restart. In the shell script's log from this invocation I have: Stopping postgresql service: [FAILED

Re: [GENERAL] where clause help

records 4,5,9, 10 fail as num_open_issues + num_provisioned + num_canceled is not num_prods record 6 passes all constraints record 7 fails as num_open_issues is not num_prods Is this what you were after? Brent Wood ---(end of broadcast)--- TIP 5

Re: [GENERAL] selective export for subsequent import (COPY)

as the field separator in the psql command line, then change that to a tab with tr, if you do have commas in the data. It also scripts up nicely: ... FSEP=| psql -d -F $FSEP | tr $FSEP \t $FILE ... Brent Brent Wood wrote: chrisj wrote: Thanks Alan, This helped a lot

Re: [GENERAL] selective export for subsequent import (COPY)

to produce un-aligned output, if this is your problem. Brent Wood but unless I put it through a sed script, this file cannot be easily used for import. It feels like I am re-inventing the wheel. Does anybody know a better way or have a good sed script. ---(end

Re: [GENERAL] Postgres data/form entry tool

://www.knoda.org/ rekallhttp://www.thekompany.com/projects/rekall/ Maybe someome who has actually tried these could comment? Cheers, Brent Wood ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] selective export for subsequent import (COPY)

$DATABASEHOST -U $DATABASEUSER -d $DATABASE -q -P footer -A -F , -c $DETAIL_SQL | tr , \t table.csv Cheers, Brent Wood ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] seeking: advice on reordering table

on the attr with the clustered index) will cause the ordering to be broken, in which case you'll need to re-cluster. Cheers, Brent Wood ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] NEWBIE: How do I get the oldest date contained in 3 tables

) as min_date from min_dates; then just: select min_date from min_date; Cheers Brent Wood ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] inserting 4800 records at a time

copy? A bulk load via copy is generally much faster. Cheers, Brent Wood ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

  1   2   >