[GENERAL] Postgres stored proc that extracts data from Oracle

? I am not expecting an easy solution but I wish to get started asap. Any advice would be appreciated. Thanks in advance, James __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com

[GENERAL] psql -h host ...

In this command psql -h host ... does it look for pg_hba.conf in the client or in the server? James ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] psql -h host ...

Thanks all for the reply. Once pg_hba.conf is modified, do I have to run pg_ctl reload ? James louis gonzales wrote: > James, > the "psql" command as you know is just the command line program that > requests connection to a database and depending how you issue the > comma

Re: [GENERAL] auto increment

i believe you're interested in creating a sequence. bruce momjian's book, in .pdf, covers this in section 7.4. the book can be found @ www.postgresql.org/docs/awbook.html i've found it a great reference for those topics covered. cheers, james On Thu, 23 Mar 2000, [EMAIL PROTECTED

[GENERAL] Re: Under Mac OS X

try http://osx.hyperjeff.net/Apps several database ports for osx, including postgresql, are available by hyperlink. james On Wed, 28 Feb 2001, liam wrote: > Has anyone tried successfully or unsuccessfully to install postgresql > under the new Mac OS X mach/netBSD kernel Darwin? > --

Re: [GENERAL] PostgreSQL On the Mac? OS9 or OSX?

i've got it installed and running on osx on an imac :) james - Original Message - From: "Peter Eisentraut" <[EMAIL PROTECTED]> To: "Israel Evans" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, August 31, 2001 1:17 PM Subject: Re: Po

Re: [GENERAL] PostgreSQL compatible with Real Time Linux ?

Title: Message I haven't run it on an embedded system but I have run it at real-time linux priority. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Murdia, Swati -GilSent: Wednesday, November 16, 2005 1:28 PMTo: pgsql-general@postgresql.o

[GENERAL] Controlling memory of session

Hi, I'm using Postgresql 8.1 on windows2000 and I have a hard time understanding how to limit the memory of the sessions to 1 MB. What I have right now is that each connection (opened with jdbc) takes about 3MB (some take a little more, some a little less). I think that this is a waste of memory

Re: [GENERAL] Controlling memory of session

Richard Huxton wrote: > Is there a particular problem you're trying to solve? yes I'm trying to know how many connections can open to the database without running out of memory. Ideally I would like to optimize stuff so that I can open the maximum number of connection/session. In total I can gi

Re: [GENERAL] Controlling memory of session

ard Huxton wrote: James Im wrote: Richard Huxton wrote: > Is there a particular problem you're trying to solve? yes I'm trying to know how many connections can open to the database without running out of memory. Ideally I would like to optimize stuff so that I can open the maxim

Re: [GENERAL] Practical question.

louis gonzales wrote: Is it better to have 1 monolithic table and have to search it, or small individual tables but many of them? Ron Johnson wrote: Yes, 1 large table. This is what RDMS were designed for. ---(end of broadcast)--- TIP 1: if p

[GENERAL] VACUUM ANALYZE

I see in all the docs to run VACUUM ANALYZE periodically. My host told me that in Postgres 8.2 this is not needed as it is done automatically. Is that true? How can I see the results of the automatic vacuum analyze? Or configure them?

Re: [GENERAL] question: knopixx and postgresql on flash drive

Mark wrote: I would like to use postgresql with knopixx, Sounds like a simple idea :-) and I would like to get full version of postgresql stored on flash drive. I remeber I've seen postgresql tar files before, but do not recall the location - can anybody point? Also, how big (in MB) postgresql

[GENERAL] pg_dump without psql rights

I'd like to run pg_dump on a database that I have full read/write/create/drop access to, but am not running as psql. I'm getting this error: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: permission denied for relation pg_ts_dict pg_dump: The command was: LOCK TABLE public

[GENERAL] VACUUM ANALYZE

I see in all the docs to run VACUUM ANALYZE periodically. My host told me that in Postgres 8.2 this is not needed as it is done automatically. Is that true? How can I see the results of the automatic vacuum analyze? Or configure them?

[GENERAL] Postgres Printed Manuals

The Postgres docs are great. Unfortunatelty, at 1600 pages, my printer is a little weary. Are bound & printed editions available? If not, has anyone had any good experience printing them via any of the online services? (The ones I contacted said it was too big for them to print...) Also: woul

Re: [GENERAL] Postgres Printed Manuals

Excellent! Two questions: 1. Might it be better to include the index and TOC (in both volumes), and do something like this: http://www.postgresql.org/files/documentation/pdf/8.2/postgresql-8.2.1-US.pdf Vol I: 1-621, 1674-end Vol II: 1-38, 622-1395, 1672-end (Dropped some other things, I think...)

[GENERAL] UNION help

Is there anyway to tell if the records in a union came from the 1st query or the second? Can I modify the individual queries to let me know this?

[GENERAL] Installing contrib / fuzzystr

Is there anyway to install contrib (fuzzystr) so it's available to all databases (even ones created previously)? thanks

Re: [GENERAL] Postgres Printed Manuals

an include a list of what exactly is included in each volume - (Example: Volume II is TOC, Reference, and Index, pages 1-35, 503-912, and 1651-end of http://postgresql.org/...original.pdf) http://www.lulu.com/iharding Now in 3 Volumes! On 5/17/07, Robert James <[EMAIL PROTECTED]> wrote

[GENERAL] Privs on deleted objects

1. Is there anyway to give a role privs on a certain table, delete that table, recreate it, and have those privs persist? 2. Is there anyway to give a role privs to all tables in a database, without having to name each one individually? Can I use this to apply to tables created later on?

[GENERAL] Postgres / Jaro Winkler fuzzy string matching

Anyone have an implementation of the Jaro Winkler fuzzy string matching algo for Postgres? * http://en.wikipedia.org/wiki/Jaro-Winkler * http://forums.oracle.com/forums/thread.jspa?threadID=385950&tstart=0 It's rumored to (sometimes?) work better than the Levenshtein algo included in contrib/fuz

[GENERAL] Creating a function if it's not there in Postgres

I use a set of DDL scripts to automatically create the database for an app. I need to create certain functions (from contrib), if they're not there already. If they are there, I don't want to DROP or REPLACE them, since they may be used in certain indexes and triggers. Is there a way to only CR

[GENERAL] Will a DELETE violate an FK?

Is there anyway to know if a DELETE will violate an FK without actually trying it?

[GENERAL] psql Tab Completion in Windows

Any way to get psql Tab Completion in Windows?

Re: [GENERAL] Will a DELETE violate an FK?

I'd like to be able to detect if a record has associations. I don't want to actually delete it, just know if it could be deleted. (This is to build an intelligent menu on a GUI) On 5/29/07, Albe Laurenz <[EMAIL PROTECTED]> wrote: > Is there anyway to know if a DELETE will violate an FK > withou

[GENERAL] Languages and Functions

1. How can I get a list of available functions (ie, user defined or contrib) using SQL? 2. Is there any performance or other advantage to using PL/pgsql over Pl/Perl or Python?

[GENERAL] Out Of Memory Error on GiST Index

or. I get the error also if I try creating the GiST index on the table with the 33,000,000 rows. Are there limitations with the GiST index? Has anyone seen this? Thanks. Jim - James Cradock, [EMAIL PROTECTED] - James Cradock, [EMAIL PROTECTED] me3 Technology Consultants, LLC 24 P

Re: [GENERAL] Out Of Memory Error on GiST Index

Thanks. I'm using PostgreSQL 8.0.2. On Sep 1, 2005, at 6:35 AM, Richard Huxton wrote: James Cradock wrote: Hello. I'm getting an Out Of Memory error when I try to create a GiST index on a geometry column (PostGIS) with approximately 33,000,000 rows. I can truncate the data in

Re: [GENERAL] to drop a 30GB database. is it slow?

database the table (or index) was dropped from may free up disk space too. Jim - James Cradock, [EMAIL PROTECTED] me3 Technology Consultants, LLC 24 Preble Street, 2nd Floor Portland, ME 04101 207-772-3217 (office) 207-838-8678 (mobile) www.me3.com ---(end of broadcast

[GENERAL] rh7.3 binaries

given a 7.4.2 slave and an 8.0.x master? -JimC -- James H. Cloos, Jr. <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

s to set the format output, and a sql statement redirected to our line printer. I haven't used Oracle since the mid 90s so I don't have a working example but a description of some of the commands can be found here http://www.siue.edu/~dbock/cmis564/otext3.htm Take

CLI Reporting Tool Was: Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

> > > > I haven't used Oracle since the mid 90s so I don't have a working example > > but a description of some of the commands can be found here > > > > http://www.siue.edu/~dbock/cmis564/otext3.htm > > Given the choice, I'd *MUCH* rather have a good, easy-to-use CLI than a > reporting tool. I'm

Re: [GENERAL] FOSS Reporting tools (was Oracle 10g Express - any danger for Postgres?)

> (There are many, many others that don't have a GUI designer > available. There's at least one on pgfoundry that explicitly supports > postgresql. They usually seem to take XML as an input template and > render to HTML or PDF.) Our reports tool does this as well and works with most major datab

Re: [GENERAL] Data types

Try pg_type. typname should give you what you're looking for. On Dec 30, 2005, at 1:57 PM, Jonel Rienton wrote: Hi guys, Does Postgres store all the possible column datatypes somewhere in its system tables? Like int8, int4, character varying, etc. I'm trying to write another GUI client tha

Re: [GENERAL] A tale of two similar databases

Have you vacuum'd and/or analyzed D2? http://www.postgresql.org/docs/8.1/static/maintenance.html http://www.postgresql.org/docs/8.1/static/sql-analyze.html James Robinson Socialserve.com ---(end of broadcast)--- TIP 3:

[GENERAL] Transact SQL compatibility layer

modification. If not, has such a thing been considered? What would be the obstacles to developing such a proxy? Thanks James (Not subscribed to the list at the moment - I'll check the archives but please cc me on a response) ---(end of broadcast)---

[GENERAL] Temporary table visibility

mind that other sessions contain temp tables using the same names? Many thanks, James -- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify

Re: [GENERAL] Temporary table visibility

| 16317551 session_data | 16118447 | 16317563 session_data | 15035529 | 16317579 (14 rows) How can I determine if one of the above relations is a temporary table in the current session (one of them, the first in ns 2200, is a normal permanent table)? Thanks, James -- This email and any

[GENERAL] libpq questions

happens? Are all the rows read into memory on the client before returning the result? Or are rows only fetched from the server as required? Thanks James ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] libpq questions

answer your questions: > > http://archives.postgresql.org/pgsql-interfaces/2005-11/msg00010.php Found that eventually. I'd seen the thread earlier but assumed that the word 'incremental' in the subject was to do with auto-incrementing fields. An interesting read. Thanks James ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] libpq questions

> On Tue, Jan 31, 2006 at 10:23:54PM +1100, James Harper wrote: > > For the libpq interface: > > > > I need to be able to know if a column in a result from a query is > > nullable or not. From reading the documentation it seems that I can > > obtain the followin

[GENERAL] plpgsql direct from C?

quot; THEN SELECT * FROM fnord END IF;", "xyzzy"); ? Thanks James ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[GENERAL] old style outer joins

here's a system option to turn it on??? Thanks James ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] old style outer joins

> On Mon, Feb 06, 2006 at 09:42:22PM +1100, James Harper wrote: > > I think the answer is no, but can anyone tell me if postgresql supports > > the older (pre sql-92?) style outer join syntax, eg: > > I think you're referring to some kind of non-standard > invente

Re: [GENERAL] Insert into other database

stion it was suggested that if you want to do this then you should use different schema's within the same database, instead of different databases. Maybe it's in the FAQ too? Given that your trigger is written in C, couldn't you use libpq to connect to and updat

[GENERAL] owner as namespace?

he form db_owner, eg mydb_james and mydb_fred, to emulate this? There would also be the schema of the dbo which mydb_dbo, which is also searched given an unqualified table name. If I'm logged in as james, my search path would be mydb_james then mydb_dbo. ? Thanks James ---

Re: [GENERAL] owner as namespace?

> > Martijn van Oosterhout writes: > > IIRC, the idea of a schema came from Oracle where the schema is the > > username. If you create a schema with the same name as the user what > > you describe above works. ie mydb.james.myview is in the james schema > > in th

[GENERAL] implicit cast of empty string to timestamp

E CAST' command, I can't just create a cast that only kicks in on empty strings whilst leaving casts of other strings as is... Thanks James ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] implicit cast of empty string to timestamp

> am 10.02.2006, um 20:22:57 +1100 mailte James Harper folgendes: > > Is there anything I can do to make postgres allow an implicit cast of an > > empty string to a timestamp, so that a badly behaved application can do: > > > INSERT INTO SomeTable (timestampfield) VA

Re: [GENERAL] implicit cast of empty string to timestamp

7;' AS timestamp); SELECT CAST(char '' AS timestamp); SELECT CAST(varchar '' AS timestamp); But this doesn't yet: SELECT CAST('' AS timestamp); I can probably get it working, but is it really a good idea to be fiddling with the pg_cast table like

[GENERAL] Composite type versus Domain constraints.

ith a separate oid for object / relational mapping. James Robinson Socialserve.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Composite type versus Domain constraints.

On Apr 12, 2005, at 4:48 PM, Tom Lane wrote: James Robinson <[EMAIL PROTECTED]> writes: insert into simple_table values (null, '(43)'); -- GRR works!!! It'll let any smallint in. What happened to the constraint? The composite-type input routine doesn't check any constra

Re: [GENERAL] Composite type versus Domain constraints.

ving only two lines of SQL to build to educate the database about each one would be a real winner. Not to sound ungrateful -- the scalar type tricks can work, but with more SQL-level effort. James Robinson Socialserve.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Performance difference between ANY and IN, also array syntax

-- okay -- eat it now for testrow in execute query loop return next testrow; end loop; return; END; $$ language plpgsql; social=# select * from dynamic_test('{2,3}'); NOTICE: query: "select * from test where id in (2, 3)" id

[GENERAL] Composite types as columns used in production?

hat they just aren't true members of the relational model, but, aside from constraint inheritance, what is known to be lacking, aside from the plethora of parenthesis they inflict? James Robinson Socialserve.com ---(end of broadcast)---

Re: [GENERAL] Composite types as columns used in production?

rebuilding any indices on the old type columns, then dropping the old type. Inconvenient, not insurmountable. That said -- anyone stepping up to claiming using 'em? Are these things seen as against the data normalization grain? James Robinson Socialserve.com

Re: [GENERAL] CREATE TABLE problem in plpgsql trigger

James Croft wrote: The problems seems to be with the table_name arg being a variable and not a literal but can't see how to fix this. If anyone knows what's going on here or has any pointers it would be appreciated. Thanks, James Sorry, I'm running PgSQL 7.4.7 on RedHat Ent

[GENERAL] CREATE TABLE problem in plpgsql trigger

ALTER COLUMN snapshottime SET DEFAULT CURRENT_TIMESTAMP; END IF; The problems seems to be with the table_name arg being a variable and not a literal but can't see how to fix this. If anyone knows what's going on here or has any pointers it would be appreciated. Thanks, James -

Re: [GENERAL] CREATE TABLE problem in plpgsql trigger

Stephan Szabo wrote: On Thu, 19 May 2005, James Croft wrote: Hi all, I'm trying to create a trigger function for a few tables that will store old versions of rows prior to any update on them. Part of the function needs to creates other tables (the table to store these snapshots in). When

[GENERAL] Temp tables as session var containers

g_temp_N schema belongs to my session. Is this possible? TIA, James ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] PostgreSQL release schedule

round the corner and if it has any features that would benefit the app. Thanks, James ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] PostgreSQL release schedule

Scott Marlowe wrote: I'd go for 8.0. It's quite stable now, and 8.1 will take as long as it needs to take to come out, which could be anything, but will likely be no earlier than the end of the year. I believe there was talk about an 8.1 coming out to replace the caching algorithm, but I believ

Re: [GENERAL] PostgreSQL release schedule

Marc G. Fournier wrote: I'd almost think taht this shuld be much more prominently put in a section on the main page of the web site, actually ... make it nice and visible instead of buried on a sub page ... I agree it would be good to have a link on the main page. Possibly near "What's ne

Re: [GENERAL] createlang

or me? Thanks Eoghan ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match - James Cradock, [EMAIL PROTECTED] ---

Re: [GENERAL] createlang

(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match - James Cradock, [EMAIL PROTECTED] me3 Technology Consultants, LLC 24

[GENERAL] Ordering by a complex field

I have a one varchar field. I'd like to order so that records where field='2' come first, then '1', then '9', then anything but '0', then '0'. Is there anyway to do this in a standard order by clause (that is, without writing a new SQL function)?

[GENERAL] Help tuning a large table off disk and into RAM

I'm stuck trying to tune a big-ish postgres db and wondering if anyone has any pointers. I cannot get Postgres to make good use of plenty of available RAM and stop thrashing the disks. One main table. ~30 million rows, 20 columns all integer, smallint or char(2). Most have an index. It's a tabl

Re: [GENERAL] reporting tools

Can you clarify the need / value added for reporting tool, over just running queries and packaging the output in HTML (with a little CSS for styling, you can get near PDF quality). This can be done in SQL and a tad of PHP (or Ruby). On 10/15/07, Geoffrey <[EMAIL PROTECTED]> wrote: > > Ned Lilly w

[GENERAL] Collation sequence and use of operatings system's locale

I'm working with a issue where it seems the PostgreSQL server collation sequence for certain locales don't match the operating system's collation sequence for the same locale (set during initdb). I can reproduce this on both 8.1.9 & 8.2.5 on Solaris (both Nevada & 10). 1) First I have a text

[GENERAL] COPY data and referential triggers ...

rence manual page on the COPY command. James Robinson Socialserve.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] Data entry - forms design or other APIs etc. - what is there?

We're happy to answer questions on our mailing list. Or in IRC at #gnuenterprise on irc.freenode.net Take Care, James ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [GENERAL] Python Interface

SIG. pyscopg though seems to give us the least trouble. Though if IIRC it does round timestamps which can burn a person at times :) I don't have a test case to verify if my memory is correct about this though. Take Care, James ---(end of broadcast)--

Re: [GENERAL] Python Driver

re supported to varying degrees. You can switch out databases by editing that one file. Providers are not limited to just databases either, our application server is just another provider in our system. Differences between providers are handled transparently to the developer. Take Care, Jame

[GENERAL] Privileges question

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, ~ I created a schema, database, tables, users and a user group. create user sma_user password 'x'; create group sma_user_group; alter group sma_user_group add user sma_user; create table sma_apps.ordr_dat ( ... ); grant select,delete,insert

[GENERAL] tsearch2 problems / limitations

SET idxfti=to_tsvector('default', field); it runs for a while then aborts with the following message ERROR: value is too big Does anyone know what the problem might be here? Does tsearch2 have configurable (or compilable) settings that could get around this? Many Thanks, James --

Re: [GENERAL] GUI

-designer. Several of the developers hang out in #gnuenterprise on irc.freenode.net if you'd like more info. Take Care, James ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Anyone using "POSIX" time zone offset capability?

tamps are technically ambiguous as to whether the specify real UTC-based time or POSIX time (Currently there is a 23-second difference between the two.) -- James Cloos <[EMAIL PROTECTED]> OpenPGP: 0xED7DAEA6 ---(end of broadcast)--

Re: [GENERAL] PostGIS

using geo-spatial coordinates. Software like MapServer (web) and Qgis (desktop) use PostGIS to provide data in map applications. The Refractions site already noted is a good start. The MapServer site is another: http://mapserver.gis.umn.edu/gallery Jim  -James Cradock, [EMAIL PROTECTED]

Re: [GENERAL] PostGIS

On Nov 2, 2006, at 10:41 AM, Sandeep Kumar Jakkaraju wrote:After all it is open source ...so how can one trust it fully If you have a question about how something is working, and you find the end-user documentation to be lacking, you can look at the software's source.  -James Cr

[GENERAL] user defined C-lang pg function bug

- 1 (1 row) The incoming text indicates there are extraneous characters making there way in somehow. James ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

[GENERAL] 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...

else insert into housing.terse_listing (id, last_modified) values (NEW.id, now()); end if; return null; END; | James Robinson Socialserve.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...

Many thanks! \a before \df+ does the trick. James On Dec 21, 2006, at 10:31 AM, Martijn van Oosterhout wrote: Well, in unaligned mode it's still the old way. There was some discussion at the time about whether tabs should be converted to spaces on output, but I don't thin

[GENERAL] slow speeds after 2 million rows inserted

up? Database is 8.2.0 on x86_64-unknown-linux-gnu. There is nothing else running on this database server (other than standard linux background programs). PS ax did not show anything else running. No locks other than the occasional lock by the INSERT query. I have done a FULL vacuum on thi

Re: [GENERAL] slow speeds after 2 million rows inserted

Joshua D. Drake wrote: Also as you are running 8.2 you can use multi valued inserts... INSERT INTO data_archive values () () () Would this speed things up? Or is that just another way to do it? Thanks, James ---(end of broadcast)--- TIP 6

Re: [GENERAL] slow speeds after 2 million rows inserted

Joshua D. Drake wrote: You need to vacuum during the inserts :) Joshua D. Drake I ran the vacuum during the INSERT and it seemed to help a little, but its still relatively slow compared to the first 2 million records. Any other ideas? Thanks, James ---(end of

Re: [GENERAL] slow speeds after 2 million rows inserted

hat did it, thank you! --James ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] psql script error handling

a way in a psql script to try to execute the INSERT statement and if theres a problem to dump it to a log file and go on with the others? Thanks in advance, James ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your

Re: [GENERAL] About auto_increment

Yesh wrote: Hi, I need to know how to increment a primary key field automatically in run time. If you use the "serial" data type, the database does this for you automatically and you don't have to worry about it. Is this the data type your using? -- James Neff Techno

Re: [GENERAL] Database versus filesystem for storing images

f you need to control security than you have to prevent physical access to the file (which means no file system storage) and pull the image from the database through the application. My two cents, James John McCawley wrote: Don't store your images in the database. Store them on the fi

[GENERAL] pg_dump and very slow database

quot; the pg_dump process? Or is there a more graceful way to stop the pg_dump process. Thanks in advance, James ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joi

[GENERAL] Sharing static data among several databases

We have an application in which every customer has their own database, all running from our Postgres server. There is a large, mostly static, database of information (chemical information), which each customer needs read access to. Lots of customer data points to this static db, with foreign keys

Re: [GENERAL] Sharing static data among several databases

18/07, Douglas McNaught <[EMAIL PROTECTED]> wrote: > > "Robert James" <[EMAIL PROTECTED]> writes: > > > 1.) Is there a way of separating, isolating, and sharing the shared data > that > > will still allow FKs to it? > > The only approach I know of woul

Re: [GENERAL] Sharing static data among several databases

Comedy aside, this makes a lot of sense: The shared data has nothing private in it at all - it's chemical info. Sharing it is no worse than sharing the application code, or the OS's libraries. It's the customer's data which needs to be isolated. On 11/18/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> w

[GENERAL] tsearch2 text::TSVECTOR cast not working for me on Pg 8.1.6

ype text to tsvector What is interesting is that a basic select works probably because the pseudo type 'cstring' is in effect. select 'To a Vector'::TSVECTOR; tsvector --- 'a' 'To' 'Vector' (1 row) Time: 3.2

[GENERAL] no-arg cluster and locks ...

me observed an undetected deadlock-ish issue, and the juciest aspect was that a db-wide cluster was running. Thanks! James Robinson Socialserve.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Normalizing denormalization with materialized views

When forced to denormalize for performance reasons, how do you ensure data integrity? I like to, instead of denormalizing, use materialized views, which offer lots of the same benefits without the costs. Yet, in Postgres they're only experimental add-ons, not to be relied on for production use. I

Re: [GENERAL] query question really cant give a summary here so read the body ;-)

This works in oracle: SELECT aid, bid FROM aidbid WHERE aid < bid UNION SELECT bid, aid FROM aidbid WHERE bid < aid Rhys Stewart <[EMAIL PROTECTED]> wrote: Hi all, have the following table aid| bid -- 1|5 2|6 3|7 4|9 5|1 6|2 7|3

[GENERAL] Problem revoking a user's 'create' privilege on schema public

to create a table in the database. Why does user2 still have create privilege on schema public? I am expecting that user2 should not be permitted to create a table in the database that user1 created. If someone could point out to me what I'm doing wrong, I'd be very grateful. Thank you, Jam

[GENERAL] Undocumented Postgres error: "failed to fetch old tuple for AFTER trigger"

I'm running a very large series of commands - mainly DDL but some DML as well - in a large transaction. I get the following error, which doesn't seem to be documented: "ERROR: failed to fetch old tuple for AFTER trigger : COMMIT" There are no triggers that I'm aware of. I've gotten this error w

  1   2   3   4   >