at 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
--(end 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
y condition not being satisfied.
--
Michael 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. &l
ource algebraic 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 t
n 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 lo
ll correctly
fill in these columns 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 t
etres.
- ---
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
it to the database to see 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 ga
, conn=18429304
fetch_count=0, num_total_rows=1, num_fields=15,
cursor='(NULL)'
message='(NULL)', command='SELECT', notice='(NULL)'
status=8, inTuples=0
CONN ERROR: func=PGAPI_SetPos, desc='', errnum=0, errmsg='(NULL)'
P 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 so loved the world, that he gave his only begotten
Son, that whosoe
--
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 For God so loved t
---
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
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 so loved the world, that he gave his only begotten
Son, that
)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---(end of
broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
- ---------
--
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 | grep "John 3:16"
Jo
classification:
QA76.9.D3 D685 2003
---(end of
broadcast)---
TIP 1: subscribe and unsubscribe commands go to
[EMAIL PROTECTED]
- -----------
Frank D. Engel, Jr. <[EMAIL PROTECTED]>
$ ln -s /usr/share/kjvbible /u
-
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 -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/
-(end of
broadcast)---
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
e 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, that he gave his only begotten
Son, that whosoever believeth in him sh
-(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/manual
$ tr
e, only through localhost,
the lack of security isn't a major concern.
--
only plain text format email accepted.
smaller file size, no virus transfer
no proprietary file formats.
========
- ----
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 the world,
le than it would be worth.
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 re
;ve since disposed of the Oracle
database, so can't go back and retest.
Wes
---(end of
broadcast)---
TIP 7: don't forget to increase your free space map settings
- -----------
Frank D.
---(end of
broadcast)---
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 /u
uld know what is happening. I guess the client can tell if an SQL command
failed, but will the client know why it failed?
-----------
Frank D. Engel, Jr. <[EMAIL PROTECTED]>
$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual
n'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 begot
!
Madison
---(end of
broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
- ---------------
Frank D. Engel, Jr. <[EMAIL PROTECTED]>
$ ln -s /usr/shar
nce I have all the matches in
one column the next trick is to sort the combined results (any tips
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 i
c signature" as defined in 15 U.S.C. §
7006(5).
---------------
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
thus the user-entered values can't clahs with the sequence values ;
the sequence values are by definition unique ; and all is well.
or something like that...
On Mon, 3 Jan 2005 11:53:44 -0500, Frank D. Engel, Jr.
<[EMAIL PROTECTED]> wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I
now how to do 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/kjvb
ning 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
st 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, that he gave his only begotten Son, that whosoever believeth in him should not perish,
machine.
Keep it on. The tiny 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]>
$ l
to see why 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 h
lBits/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
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. &l
d 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 l
.
---(end 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 |
f
broadcast)---
TIP 8: 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
-like I've literally 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.
rminating "e", and
that would not be a natural omission for me.
--
Guy Rouillier
---(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
---
ng 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, that he gave his only begotten
Son, that whosoever believeth in
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 /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John
---(end of
broadcast)---
TIP 3: if posting/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
-
e shema search path.
but I don't kow how!
Let's find out what the problem is before attempting a solution
that may or may not be appropriate or necessary.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of
broadcast)---
TIP 5: Have you chec
p.
Thanks & Regards
Vikas Kumawat
The postgres users should own the data directory, but otherwise should not have administrative privileges. What is the specific error you are getting?
-------
Frank D. Engel, Jr. <[EMAIL PROTECTE
the inserts.
---(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/man
49 matches
Mail list logo
