Re: [GENERAL] Export a column in a view without announcing it?

2005-01-31 Thread Frank D. Engel, Jr.
that it actually updates the underlying table. I did it for the first time yesterday and found the concept quite interesting. Sim Frank D. Engel, Jr. [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm fairly certain there is currently no way to do

Re: [GENERAL] Moving from Sybase to Postgres - Stored Procedures

2005-01-28 Thread Frank D. Engel, Jr.
of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16

Re: [GENERAL] Extended unit

2005-01-27 Thread Frank D. Engel, Jr.
computation toolkit with equations and units somewhere ? - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only

Re: [BUGS] [GENERAL] My postmaster just crashed !

2005-01-27 Thread Frank D. Engel, Jr.
Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible

Re: [GENERAL] text field constraint advice

2005-01-26 Thread Frank D. Engel, Jr.
if it is too long? - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth

Re: [GENERAL] Extended unit

2005-01-26 Thread Frank D. Engel, Jr.
. - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life. $ -BEGIN PGP

[GENERAL] Export a column in a view without announcing it?

2005-01-26 Thread Frank D. Engel, Jr.
automatically? Thank you! - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever

Re: [GENERAL] Splitting queries across servers

2005-01-26 Thread Frank D. Engel, Jr.
if your joining column's datatypes do not match - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only

Re: [GENERAL] What is the format of 'binary' data in the postgresql client/server protocol version 3

2005-01-25 Thread Frank D. Engel, Jr.
- --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life. $ -BEGIN PGP

[GENERAL] ODBC Driver Issue (possibly OT - wrong list?)

2005-01-25 Thread Frank D. Engel, Jr.
=168, reverse=0, errornumber=0, errormsg='(NULL)' buffer_in=18440320, buffer_out=1824 buffer_filled_in=576, buffer_filled_out=0, buffer_read_in=576 conn=18429304, PGAPI_Disconnect - --- Frank D. Engel, Jr. [EMAIL

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

2005-01-24 Thread Frank D. Engel, Jr.
commands go to [EMAIL PROTECTED] - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son

Re: [GENERAL] Best Linux Distribution

2005-01-20 Thread Frank D. Engel, Jr.
? http://archives.postgresql.org - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son

Re: [GENERAL] [ADMIN] Oracle and Postgresql Play Nice Together on Same Computer?

2005-01-20 Thread Frank D. Engel, Jr.
://archives.postgresql.org ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html - --- Frank D. Engel, Jr. [EMAIL

Re: [GENERAL] Unique Index

2005-01-20 Thread Frank D. Engel, Jr.
- --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life

Re: [GENERAL] Unique Index

2005-01-20 Thread Frank D. Engel, Jr.
checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved

Re: [GENERAL] Multiline plpython procedure

2005-01-19 Thread Frank D. Engel, Jr.
an index scan if your joining column's datatypes do not match - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he

Re: [GENERAL] sorting library of congress numbers

2005-01-19 Thread Frank D. Engel, Jr.
of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16

Re: [GENERAL] Index optimization ?

2005-01-17 Thread Frank D. Engel, Jr.
free space map settings - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever

Re: [GENERAL] ext3

2005-01-17 Thread Frank D. Engel, Jr.
)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual

Re: [GENERAL] Parsing of backslash in statements via ODBC

2005-01-14 Thread Frank D. Engel, Jr.
://archives.postgresql.org - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him

Re: [GENERAL] ntfs for windows port rc5-2

2005-01-14 Thread Frank D. Engel, Jr.
. -- only plain text format email accepted. smaller file size, no virus transfer no proprietary file formats. - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

2005-01-14 Thread Frank D. Engel, Jr.
can't go back and retest. Wes ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

2005-01-14 Thread Frank D. Engel, Jr.
. On Jan 14, 2005, at 1:38 PM, Martijn van Oosterhout wrote: On Fri, Jan 14, 2005 at 12:39:04PM -0500, Frank D. Engel, Jr. wrote: This is probably stupid for some reason, but why not use a 64-bit integer to track the number of records in the table? Increment when adding records, decrement when deleting

Re: [GENERAL] allowing connections from additional hosts without a restart?

2005-01-13 Thread Frank D. Engel, Jr.
not match - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him

Re: [GENERAL] best place to enfore rules

2005-01-13 Thread Frank D. Engel, Jr.
know why it failed?/x-tad-bigger x-tad-bigger/x-tad-bigger x-tad-bigger/x-tad-bigger --- Frank D. Engel, Jr. [EMAIL PROTECTED]> $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so lo

Re: [GENERAL] Adding UNIQUE constraint on NULL column

2005-01-13 Thread Frank D. Engel, Jr.
)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16

Re: [GENERAL] SELECT from multiple tables (not join though)

2005-01-10 Thread Frank D. Engel, Jr.
there?). I hope the question was clear. Please let me know if it wasn't. Thanks! Madison ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings - --- Frank D. Engel

Re: [GENERAL] SELECT from multiple tables (not join though)

2005-01-10 Thread Frank D. Engel, Jr.
of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual

Re: [GENERAL] problem finding the 8.0.3RC download

2005-01-05 Thread Frank D. Engel, Jr.
).   --- Frank D. Engel, Jr. [EMAIL PROTECTED]> $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not per

[GENERAL] Generating unique values for TEXT columns

2005-01-03 Thread Frank D. Engel, Jr.
this with a numeric column (I can just SELECT MAX on the column and add one, for example), but how can this be done with a TEXT column? Thank you! - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true

Re: [GENERAL] Large Objects

2004-12-31 Thread Frank D. Engel, Jr.
not match - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him

Re: [GENERAL] postgresql.conf

2004-12-22 Thread Frank D. Engel, Jr.
/Tidbits/perf.html - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth

Re: [GENERAL] default index created for primary key

2004-12-22 Thread Frank D. Engel, Jr.
PostgreSQL requires an index here. --- Frank D. Engel, Jr. [EMAIL PROTECTED]> $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten

Re: [GENERAL] postgresql.conf

2004-12-22 Thread Frank D. Engel, Jr.
amount of extra performance will mean nothing if you lose important data over it. The machine has 4 drives - should I do a RAID 1+0 or a 5? 1+0, definitely. - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual

Re: [GENERAL] Memory Errors OS X

2004-12-22 Thread Frank D. Engel, Jr.
--- Frank D. Engel, Jr. [EMAIL PROTECTED]> $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting l

Re: [GENERAL] Create a cache DB between web portal and internal DB?

2004-12-21 Thread Frank D. Engel, Jr.
: explain analyze is your friend --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever

Re: [GENERAL] Need help to organize database

2004-12-21 Thread Frank D. Engel, Jr.
6: Have you searched our list archives? http://archives.postgresql.org --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved

Re: [GENERAL] PostgreSQL training curriculum

2004-12-21 Thread Frank D. Engel, Jr.
://www.postgresql.org/docs/faqs/FAQ.html --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever

Re: [GENERAL] Need help to organize database

2004-12-21 Thread Frank D. Engel, Jr.
- is it a good idea to store 1 time's data (value1-4) per row in 24*31 rows? May be it is better and quicker to store, for example, 2 time's data per row (value1-4, day 1, value1-4, day 2) or other structure? - --- Frank D. Engel, Jr. [EMAIL PROTECTED

Re: [GENERAL] pl/pgsql oddity

2004-12-16 Thread Frank D. Engel, Jr.
---(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 --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln

Re: [GENERAL] pl/pgsql oddity

2004-12-16 Thread Frank D. Engel, Jr.
cut and pasted whole Ada routines into Oracle plsql and they work without modification. PostgreSQL doesn't do parameters and packages, so it is slightly more work to move stuff from your front-end into your back-end, but often worth it. Frank D. Engel, Jr

Re: [GENERAL] Corrupt RTREE index

2004-12-15 Thread Frank D. Engel, Jr.
--- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have

Re: [GENERAL] Select after insert to the unique column

2004-12-13 Thread Frank D. Engel, Jr.
. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God

Re: [GENERAL] table with sort_key without gaps

2004-12-13 Thread Frank D. Engel, Jr.
/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible

Re: [GENERAL] increasing max_connections on freebsd

2004-12-13 Thread Frank D. Engel, Jr.
PROTECTED] so that your message can get through to the mailing list cleanly --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world