Re: [GENERAL] Deleting a table file does not raise an error when the table is touched afterwards, why?

nage the physical filesystems correctly and not damage them. - -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* david.w.n...@googlemail.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -BEGIN PGP SIG

Re: [GENERAL] Deleting a table file does not raise an error when the table is touched afterwards, why?

-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* david.w.n...@googlemail.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -BEGIN PGP SIGNATURE- Version: GnuPG v2 iEYEARECAAYFAldMcjcACgkQogYgcI4W/5T/xgCfaQBh6g0WCBRkeNOlRK4Kbc43 Gs4An0UXb+piw+BQUGJup

Re: [GENERAL] Tablespace limit feature

his causes the filesystem itself to limit the amount of disk space the tablespace can use. - -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* david.w.n...@googlemail.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

Re: [GENERAL] EBCDIC conversion

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/03/14 00:31, David W Noon wrote: > I think the real issue is that you need icu or libiconv installed. > You will also need to know which EBCDIC code page you want: U.S. > EBCDIC is cp37, IIRC. > > I suspect you will need

Re: [GENERAL] EBCDIC conversion

fficult if you can write C or Python. - -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* david.w.n...@googlemail.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -BEGIN PGP SIGNATURE- Version: GnuP

Re: [GENERAL] Set returning functions in select column list

== david.w.n...@ntlworld.com (David W Noon) === -- 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] Set returning functions in select column list

==== dwn...@ntlworld.com (David W Noon) == signature.asc Description: PGP signature

Re: [GENERAL] Let-bindings in SQL statements

now(). I don't have an ANSI standard handy, so I cannot be certain when now() was added, if ever; but I have been using CURRENT TIMESTAMP (space instead of vinculum) under DB2 for 20 years or more. -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

Re: [GENERAL] hash options

QL, written in C, and will make them available to anybody who wants them. -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* dwn...@ntlworld.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* signature.asc Description: PGP signature

Re: [GENERAL] Duplicated Fields

-*-*-*-*-*-*-*-*-* dwn...@ntlworld.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* signature.asc Description: PGP signature

Re: [GENERAL] Weird problems with C extension and bytea as input type

aybe you should be encoding the data to text (say, to hex) first? Better to use the supplied length in the varlena descriptor. -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* dwn...@ntlworld.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* signature.asc Description: PGP signature

Re: [GENERAL] Read binary records

at code can be added to the "contrib" modules, if anybody is interested. The dwn_read_binary_file() function returns a bytea. If you want a private copy, contact me off-list. -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* dwn.

Re: [GENERAL] What is "return code" for WAL send command

Clean out the work directory for Lazarus. %daily 18 05 cd "$HOME/Lazarus_projects/tmp/" && for fn in *(N); do rm - -rf "$fn"; done # Clean out the cache subdirectories under $HOME. %daily 28 07 cache_clean.zsh As

Re: [GENERAL] use of IN() with literals

’); You have the word "IN" twice. -- Regards, Dave [RLU #314465] ========== dwn...@ntlworld.com (David W Noon) == signature.asc Description: PGP signature

Re: [GENERAL] Order of execution in shell echo to psql

======== dwn...@ntlworld.com (David W Noon) == -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.14 (GNU/Linux) iEYEARECAAYFAkvdeiwACgkQRQ2Fs59Psv/1FQCgw+m+tBm+5VtnMPFrMn+q6xnV gwMAoNIHaCb3vVSyu35w8aJ9IZfmKV6g =

Re: [GENERAL] regexp_replace puzzle

passed to sha224enc(), then that function's result is passed to regexp_replace. -- Regards, Dave [RLU #314465] === david.w.n...@ntlworld.com (David W Noon) === -- 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] continuous copy/update one table to another

===== david.w.n...@ntlworld.com (David W Noon) === -- 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] Can the string literal syntax for function definitions please be dropped ?

value. -- Regards, Dave [RLU #314465] === david.w.n...@ntlworld.com (David W Noon) === -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To m

Re: [GENERAL] numeric field overflow

, both to the left and to the right of the decimal point. -- Regards, Dave [RLU #314465] === david.w.n...@ntlworld.com (David W Noon) === -- Sent via pgsql-g

Re: [GENERAL] UPDATE statement with syntax error doesn't raise a warning?

here is no syntax error. It just doesn't mean what you wanted. -- Regards, Dave [RLU #314465] === david.w.n...@ntlworld.com (David W Noon) === -- 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] where clauses and multiple tables

n't this be written... > >SELECT DISTINCT foo.foo_id, foo.name >FROM foo JOIN bar ON bar_id >WHERE bar.name='martini'; The DISTINCT qualifier potentially changes the semantics, so the immediate answer is "No". -- Regards,

Re: [GENERAL] where clauses and multiple tables

mi-join. -- Regards, Dave [RLU #314465] ======= david.w.n...@ntlworld.com (David W Noon) === -- 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] Can SQL return a threaded-comment-view result set?

it would be more on-topic there. However, I recommend Joe Celko's book, as it explains the technique as well as demonstrates it. -- Regards, Dave [RLU#314465] ====== [EMAIL PROTECTED] (David W Noon) Remove spam trap to reply via e-mail. ===

Re: [GENERAL] move to usenet?

et. Thus, top-posting and full-quoting are rife all across Usenet. -- Regards, Dave [RLU#314465] ====== [EMAIL PROTECTED] (David W Noon) Remove spam trap to reply via e-mail. == --

Re: [GENERAL] move to usenet?

[RLU#314465] == [EMAIL PROTECTED] (David W Noon) Remove spam trap to reply via e-mail. == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]