[DOCS] NetBSD kernel resource configuration
The documentation describing NetBSD kernel configuration mentions that it uses the "option" keyword like OpenBSD, but in fact it uses the "options" keyword like FreeBSD. http://developer.postgresql.org/docs/postgres/kernel-resources.html#SYSVIPC http://cvsweb.netbsd.org/bsdweb.cgi/src/sys/arch/i386/conf/GENERIC?rev=1.674&content-type=text/x-cvsweb-markup Kris Jurka ---(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
Re: [DOCS] NetBSD kernel resource configuration
Kris Jurka wrote: > > The documentation describing NetBSD kernel configuration mentions that it > uses the "option" keyword like OpenBSD, but in fact it uses the "options" > keyword like FreeBSD. > > http://developer.postgresql.org/docs/postgres/kernel-resources.html#SYSVIPC > > http://cvsweb.netbsd.org/bsdweb.cgi/src/sys/arch/i386/conf/GENERIC?rev=1.674&content-type=text/x-cvsweb-markup Fix applied. Thanks. This problem doesn't appear in the 8.0.X docs. -- Bruce Momjian| http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 Index: doc/src/sgml/runtime.sgml === RCS file: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v retrieving revision 1.327 diff -c -c -r1.327 runtime.sgml *** doc/src/sgml/runtime.sgml 17 Jun 2005 03:25:51 - 1.327 --- doc/src/sgml/runtime.sgml 17 Jun 2005 13:04:21 - *** *** 4544,4551 FreeBSD versions before 4.0 work like NetBSD and ! OpenBSD (see below), except that the configuration file uses the ! keyword "options" instead of "option". --- 4544,4550 FreeBSD versions before 4.0 work like NetBSD and ! OpenBSD (see below). *** *** 4561,4577 to be enabled when the kernel is compiled. (They are by default.) The maximum size of shared memory is determined by the option SHMMAXPGS (in pages). The following ! shows an example of how to set the various parameters: ! option SYSVSHM ! option SHMMAXPGS=4096 ! option SHMSEG=256 ! ! option SYSVSEM ! option SEMMNI=256 ! option SEMMNS=512 ! option SEMMNU=256 ! option SEMMAP=256 --- 4560,4577 to be enabled when the kernel is compiled. (They are by default.) The maximum size of shared memory is determined by the option SHMMAXPGS (in pages). The following ! shows an example of how to set the various parameters ! (OpenBSD uses option instead): ! optionsSYSVSHM ! optionsSHMMAXPGS=4096 ! optionsSHMSEG=256 ! ! optionsSYSVSEM ! optionsSEMMNI=256 ! optionsSEMMNS=512 ! optionsSEMMNU=256 ! optionsSEMMAP=256 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [DOCS] NetBSD kernel resource configuration
On Fri, 17 Jun 2005, Bruce Momjian wrote: > Kris Jurka wrote: > > > > The documentation describing NetBSD kernel configuration mentions that it > > uses the "option" keyword like OpenBSD, but in fact it uses the "options" > > keyword like FreeBSD. > > > > Fix applied. Thanks. This problem doesn't appear in the 8.0.X docs. > It does, but in a slightly different form. It says "(On NetBSD and OpenBSD the key word is actually option singular.)" Kris Jurka ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [DOCS] NetBSD kernel resource configuration
Oh, thanks. Fixed in 8.0.X. --- Kris Jurka wrote: > > > On Fri, 17 Jun 2005, Bruce Momjian wrote: > > > Kris Jurka wrote: > > > > > > The documentation describing NetBSD kernel configuration mentions that it > > > uses the "option" keyword like OpenBSD, but in fact it uses the "options" > > > keyword like FreeBSD. > > > > > > > Fix applied. Thanks. This problem doesn't appear in the 8.0.X docs. > > > > It does, but in a slightly different form. It says "(On NetBSD and > OpenBSD the key word is actually option singular.)" > > Kris Jurka > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- Bruce Momjian| http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 Index: doc/src/sgml/runtime.sgml === RCS file: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v retrieving revision 1.301.4.6 diff -c -c -r1.301.4.6 runtime.sgml *** doc/src/sgml/runtime.sgml 9 May 2005 17:26:55 - 1.301.4.6 --- doc/src/sgml/runtime.sgml 17 Jun 2005 16:45:05 - *** *** 4375,4382 options SEMMNU=256 options SEMMAP=256 ! (On NetBSD and OpenBSD the key word is actually option singular.) --- 4375,4381 options SEMMNU=256 options SEMMAP=256 ! (On OpenBSD the key word is actually option singular.) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[DOCS] type casting reference?
hi. i need to cast from timestamp to seconds (in the form of integer). i have a table with a column: expiretime timestamp i have tried the following, it gives errors as below: SELECT expiretime::float4 AS timeleft FROM table WHERE something='1234'; ERROR: cannot cast type timestamp without time zone to real SELECT expiretime::text::float4 AS timeleft FROM table WHERE something='1234'; ERROR: invalid input syntax for type real: "2005-06-12 21:21:24.368082" postgresql 7.4.1 (i know, old) so, my question is simply, where in the docs can i find how i should perform the cast? it would help a lot if there was a table showing which types can be cased into which, and possibly an example or two for situations like this, casting from timestamp (to timestamp worked right away). /stig ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [DOCS] type casting reference? SOLVED
stig erikson wrote:
hi.
i need to cast from timestamp to seconds (in the form of integer).
i have a table with a column:
expiretime timestamp
i have tried the following, it gives errors as below:
SELECT expiretime::float4 AS timeleft FROM table WHERE something='1234';
ERROR: cannot cast type timestamp without time zone to real
SELECT expiretime::text::float4 AS timeleft FROM table WHERE
something='1234';
ERROR: invalid input syntax for type real: "2005-06-12 21:21:24.368082"
postgresql 7.4.1 (i know, old)
so, my question is simply, where in the docs can i find how i should
perform the cast?
it would help a lot if there was a table showing which types can be
cased into which, and possibly an example or two for situations like
this, casting from timestamp (to timestamp worked right away).
/stig
solved my problem this way:
UPDATE table
SET expiretime= cast( ('now'::text)::timestamp+'30 minutes'::interval AS
timestamp)
WHERE sessionID='0';
---(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: [DOCS] type casting reference?
On Jun 13, 2005, at 4:39 AM, stig erikson wrote: hi. i need to cast from timestamp to seconds (in the form of integer). i have a table with a column: expiretime timestamp i have tried the following, it gives errors as below: SELECT expiretime::float4 AS timeleft FROM table WHERE something='1234'; ERROR: cannot cast type timestamp without time zone to real SELECT expiretime::text::float4 AS timeleft FROM table WHERE something='1234'; ERROR: invalid input syntax for type real: "2005-06-12 21:21:24.368082" Are you looking for the timestamp expressed as seconds from the Unix epoch? If so, look at extract(epoch from expiretime). http://www.postgresql.org/docs/7.4/interactive/functions- datetime.html#FUNCTIONS-DATETIME-EXTRACT Michael Glaesemann grzm myrealbox com ---(end of broadcast)--- TIP 8: explain analyze is your friend
