Re: [GENERAL] Function to return per-column counts?

2017-09-28 Thread John McKown
part of your application code. > > cheers > > -- > Tomas Vondra http://www.2ndQuadrant.com > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > -- I just child proofed my house. But the kids still manage to get in. Maranatha! <>< John McKown

Re: [GENERAL] Create Action for psql when NOTIFY Recieved

2017-08-29 Thread John McKown
ur custom > action. > ​Sounds like a job for "expect". https://www.tcl.tk/man/expect5.31/expect.1.html​ > > > Best regards, > -- > Daniel Vérité > -- Caution! The OP is an hyperpolysyllabicsesquipedalianist and this email may cause stress to those with hippopotomonstrosesquipedaliophobia. Maranatha! <>< John McKown

Re: [GENERAL] PG and database encryption

2017-08-22 Thread John McKown
mbed the encryption/decryption into the application itself so that the data is encrypted before it is passed to PostgreSQL to store. But I think that violates your original requirements. -- If you look around the poker table & don't see an obvious sucker, it's you. Maranatha! <

Re: [GENERAL] PG and database encryption

2017-08-22 Thread John McKown
ny off-filesystem backups, which would need to be separately encrypted. LUKS is a good method, IMO, to protect the data if the media is stolen, but not for protecting the individual files from improper access. SELinux is pretty good at that. -- If you look around the poker table & don't se

Re: [GENERAL] About using IMCS moldule

2017-08-10 Thread John McKown
look at IMCS. Just one day ago (9 Aug 2017), someone put in a new file which says that it addresses the LWLocks in 9.6.3 . Perhaps if you got this newest version, this is fixed?​ -- If you look around the poker table & don't see an obvious sucker, it's you. Maranatha! <>< John McKown

Re: [GENERAL] bidirectional mapping?

2017-08-02 Thread John McKown
On Wed, Aug 2, 2017 at 10:55 AM, Chris Travers wrote: > > > On Wed, Aug 2, 2017 at 5:44 PM, John McKown > wrote: > >> Is there a simple way to do bidirectional mapping of a table with itself? >> I am thinking of a "spousal" type relationship, where it is tru

[GENERAL] bidirectional mapping?

2017-08-02 Thread John McKown
-- Veni, Vidi, VISA: I came, I saw, I did a little shopping. Maranatha! <>< John McKown

Re: [GENERAL] Backward compatibility

2017-07-22 Thread John McKown
4-redhat-linux-gnu, co mpiled by gcc (GCC) 6.3.1 20161221 (Red Hat 6.3.1-1), 64-bit (1 row) ​ -- Veni, Vidi, VISA: I came, I saw, I did a little shopping. Maranatha! <>< John McKown

Re: [GENERAL] Postgresql - commercial version

2017-07-07 Thread John McKown
html you might try: SELECT * FROM PRODUCT_COMPONENT_VERSION; This table does not exist in the version which I have, and so I am guessing that it would be a decent test. -- Veni, Vidi, VISA: I came, I saw, I did a little shopping. Maranatha! <>< John McKown

Re: [GENERAL] libpg sources

2017-05-23 Thread John McKown
oesn't let you see anything. Maranatha! <>< John McKown

Re: [GENERAL] Top posting....

2017-05-11 Thread John McKown
phone!​ > > Regards. > Francisco Olarte. > -- Advertising is a valuable economic factor because it is the cheapest way of selling goods, particularly if the goods are worthless. -- Sinclair Lewis Maranatha! <>< John McKown

Re: [GENERAL] browser interface to forums please?

2017-04-05 Thread John McKown
iques > of the Successful Technologist > http://www.troubleshooters.com/techniques > > -- "Irrigation of the land with seawater desalinated by fusion power is ancient. It's called 'rain'." -- Michael McClary, in alt.fusion Maranatha! <>< John McKown

Re: [GENERAL] browser interface to forums please?

2017-03-27 Thread John McKown
SteveT > > Steve Litt > March 2017 featured book: Troubleshooting: Why Bother? > http://www.troubleshooters.com/twb > > > -- "Irrigation of the land with seawater desalinated by fusion power is ancient. It's called 'rain'." -- Michael McClary, in alt.fusion Maranatha! <>< John McKown

Re: [GENERAL] Postgres backup solution

2017-03-14 Thread John McKown
postgresql.org/mailpref/pgsql-general > > -- "Irrigation of the land with seawater desalinated by fusion power is ancient. It's called 'rain'." -- Michael McClary, in alt.fusion Maranatha! <>< John McKown

Re: [GENERAL] import CSV file to a table

2017-03-08 Thread John McKown
hich does the load into a PostgreSQL database (multiple tables). Ya, a bit perverted.​ -- "Irrigation of the land with seawater desalinated by fusion power is ancient. It's called 'rain'." -- Michael McClary, in alt.fusion Maranatha! <>< John McKown

Re: [GENERAL] import CSV file to a table

2017-03-08 Thread John McKown
te out columns 5 & 7 } done printf "%s\n" '\.' # write EOF delimiter for COPY [tsh009@it-johnmckown-linux junk]$ ./ptest.sh < John McKown

Re: [GENERAL] SELECT x'00000000F'::int leading zeros causes "integer out of range"

2017-02-24 Thread John McKown
uot;. > ​A better reply would be good. Another possibility is for the parser to remove unneeded leading zeros.​ > > David J. > -- "Irrigation of the land with seawater desalinated by fusion power is ancient. It's called 'rain'." -- Michael McClary, in alt.fusion Maranatha! <>< John McKown

Re: [GENERAL] Foreign Data Wrapper for filesystem

2017-02-15 Thread John McKown
en't it could be a security (or privacy) violation.​ -- "Irrigation of the land with seawater desalinated by fusion power is ancient. It's called 'rain'." -- Michael McClary, in alt.fusion Maranatha! <>< John McKown

Re: [GENERAL] postgresql how to duplicate rows in result.

2017-02-14 Thread John McKown
uot;Irrigation of the land with sewater desalinated by fusion power is ancient. It's called 'rain'." -- Michael McClary, in alt.fusion Maranatha! <>< John McKown

Re: [GENERAL] postgresql how to duplicate rows in result.

2017-02-14 Thread John McKown
---+---+--+ 1 | | 3 | 123 | 2 1 | | 3 | 123 | 2 2 | aassdsds | 33322 | 211 | 1 3 | | 21221 | 221 | 1 (4 rows) > . > > thanks in advance. > > Alessandro. > -- "Irrigatio

Re: [GENERAL] Why is table not found?

2017-01-31 Thread John McKown
IVaCqz0bj > 71kA0ewgZ9NMay6ch1VjqSPPFhAZHc1Ho3xIAa0BsZpvEdccDBsL+yk/6DGDYua9 > 5oT1p6CZqfDJqxEIoUiNaJEKm3An5ySN8hHn527/apG9yA9QMh5qJPHA0wRqtLxN > hNSxugKhS6UOw/Wivbx0OIhN8jqBv4m22UgO9pFGgxHLs1hheSTMUSbExFCLuK+z > sS1Kw9syplk+lFTzK6mqNpr3BQ6v2fmkPmRTZoID4e9T3DY8Bna2JXG2U1QGEzwa > kwpJOMAvY3DDPv3pIK8= > =i8FY > -END PGP SIGNATURE- > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- There’s no obfuscated Perl contest because it’s pointless. —Jeff Polk Maranatha! <>< John McKown

Re: [GENERAL] COPY: row is too big

2017-01-03 Thread John McKown
st (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- There’s no obfuscated Perl contest because it’s pointless. —Jeff Polk Maranatha! <>< John McKown

Re: [GENERAL] COPY: row is too big

2017-01-02 Thread John McKown
greSQL guru. Perhaps I made a stupid mistake in my analysis and the truly knowledgeable will have a better answer for you. ​ -- There’s no obfuscated Perl contest because it’s pointless. —Jeff Polk Maranatha! <>< John McKown

Re: [GENERAL] pg_dump and quoted identifiers

2016-12-13 Thread John McKown
#x27;'; SET default_with_oids = false; -- -- Name: Status; Type: TABLE; Schema: public; Owner: tsh009 -- CREATE TABLE "Status" ( x integer ); ALTER TABLE "Status" OWNER TO tsh009; -- -- Data for Name: Status; Type: TABLE DATA; Schema: public; Owner: tsh009 -- COPY "Status" (x) FROM stdin; 1 \. -- -- PostgreSQL database dump complete -- -- Heisenberg may have been here. http://xkcd.com/1770/ Maranatha! <>< John McKown

Re: [GENERAL] When to use COMMENT vs --

2016-12-07 Thread John McKown
| | tmc| tsh009 | | (6 rows) ​ ​ -- Heisenberg may have been here. Unicode: http://xkcd.com/1726/ Maranatha! <>< John McKown

Re: [GENERAL] Postgres and LibreOffice's 'Base'

2016-12-04 Thread John McKown
uld need a commercial license if your software is not licensed as "open source". A possible alternative to QT is GTK+ (https://www.gtk.org/)​. It is both GPL & LGPL licensed, so you can freely use it in commercial software. Sorry if I went off into left field on this. -- Heisenberg may have been here. Unicode: http://xkcd.com/1726/ Maranatha! <>< John McKown

Re: [GENERAL] About the MONEY type

2016-11-30 Thread John McKown
ONE. I guess a MONEY type should contain a modifier identifying the issuer of the currency (E.g. U.S. Dollar vs Canadian Dollar vs. Yen vs. Yuan vs. "precious metal"). -- Heisenberg may have been here. Unicode: http://xkcd.com/1726/ Maranatha! <>< John McKown

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

2016-11-22 Thread John McKown
to use another reference than res. > > Thanks. > > /Poul > > -- Heisenberg may have been here. Unicode: http://xkcd.com/1726/ Maranatha! <>< John McKown

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

2016-11-21 Thread John McKown
hat the $n in the command string is not too large for the array. Note: please keep the discussion on the list, not to me personally. It may be of help to others (or maybe not, I don't know.) -- Heisenberg may have been here. Unicode: http://xkcd.com/1726/ Maranatha! <>< John McKown

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

2016-11-21 Thread John McKown
stand. That is documented here: https://www.postgresql.org/docs/9.5/static/ecpg.html .​ -- Heisenberg may have been here. Unicode: http://xkcd.com/1726/ Maranatha! <>< John McKown

Re: [GENERAL] Force pg_hba.conf user with LDAP

2016-08-01 Thread John McKown
prefix which, if used, runs the given SQL statement as a PG superuser. You then GRANT(?) authority to that facility like you would to a table or database or ... . E.g. GRANT SUDO TO SOMEBODY; who could then do SUDO some other SQL statement; and that SQL statement would be done as if the PG user was a superuser. -- Klein bottle for rent -- inquire within. Maranatha! <>< John McKown

Re: [GENERAL] How to stop script executions

2016-07-26 Thread John McKown
; type policy. Or I'd "sandbox" the PostgreSQL server code using something like docker, or under in a virtual machine with little access to other services. > > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. > -- Klein bottle for rent -- inquire within. Maranatha! <>< John McKown

[GENERAL] Congratulations (EDB) on U.S. Security Technical Implementation Guide.

2016-07-18 Thread John McKown
ot;Worry was nothing more than paying interest on a loan that a man may never borrow" From: "Quest for the White Wind" by Alan Black Maranatha! <>< John McKown

Re: [GENERAL] Memory usage per session

2016-07-08 Thread John McKown
ed between session. -- "Pessimism is a admirable quality in an engineer. Pessimistic people check their work three times, because they're sure that something won't be right. Optimistic people check once, trust in Solis-de to keep the ship safe, then blow everyone up." "I think you're mistaking the word optimistic for inept." "They've got a similar ring to my ear." >From "Star Nomad" by Lindsay Buroker: Maranatha! <>< John McKown

Re: [GENERAL] Memory usage per session

2016-07-08 Thread John McKown
ineer. Pessimistic people check their work three times, because they're sure that something won't be right. Optimistic people check once, trust in Solis-de to keep the ship safe, then blow everyone up." "I think you're mistaking the word optimistic for inept." "They've got a similar ring to my ear." >From "Star Nomad" by Lindsay Buroker: Maranatha! <>< John McKown

Re: [GENERAL] Full text search on Chemistry text

2016-06-08 Thread John McKown
" and got a lot of hits. Are you asking for a "canonical" and "official" list?​ -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

Re: [GENERAL] PostgreSql Doubts

2016-05-20 Thread John McKown
ing SQLite are. I think there are some very intelligent, articulate, and _nice_ people over there (unlike some forums I've been on). > > > Thanks & Regards, > aluka > -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

Re: [GENERAL] Postgres RFC3339 datetime formatting

2016-05-10 Thread John McKown
tgres 9.3 > or 9.5 using to_char. > > http://www.postgresql.org/docs/9.5/static/functions-formatting.html > > Is there any hidden option/functions you use to achieve the same? Any help > regarding is appreciated. > > -- > Thanks & Regards > skype: jasim.mk > -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-04 Thread John McKown
On Wed, May 4, 2016 at 9:55 AM, Pierre Chevalier Géologue < pierrechevalierg...@free.fr> wrote: > Le 04/05/2016 15:25, John McKown a écrit : > >> On Wed, May 4, 2016 at 8:13 AM, Geoff Winkless > <mailto:pgsqlad...@geoff.dj>>wrote: >> >> ​ >> &

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-04 Thread John McKown
, I can write Excel formulas. I know very well that an new function on the web site could be written in less than a day, if you'd just get off you a$$ and do it." > > Geoff > > > -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-04 Thread John McKown
and other SQL experts. That group has hard control over the enterprise data. If the programmers need something, they become like end-user in that they simply describe what data they need and why. The programmers basically know enough to be able to ask for something. Completely unlike back in the da

Re: [GENERAL] Allow disabling folding of unquoted identifiers to lowercase

2016-05-02 Thread John McKown
this might be a "quote everything which is not a keyword" option for a psql replacement. Or whatever the front end is that the users use. -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

Re: [GENERAL] Allow disabling folding of unquoted identifiers to lowercase

2016-04-29 Thread John McKown
On Fri, Apr 29, 2016 at 3:38 PM, John R Pierce wrote: > On 4/29/2016 12:56 PM, John McKown wrote: > > I suspect this would be painful for the parser, unless you also enforced >> that all SQL keywords were in a specific case (all lower would be the >> minimal impact to the c

Re: [GENERAL] Allow disabling folding of unquoted identifiers to lowercase

2016-04-29 Thread John McKown
On Fri, Apr 29, 2016 at 3:38 PM, John R Pierce wrote: > On 4/29/2016 12:56 PM, John McKown wrote: > > I suspect this would be painful for the parser, unless you also enforced >> that all SQL keywords were in a specific case (all lower would be the >> minimal impact to the c

Re: [GENERAL] Allow disabling folding of unquoted identifiers to lowercase

2016-04-29 Thread John McKown
itten in C. So use strncasecmp() instead of strncmp() or strcasecmp() instead of strcmp() to test for a token. > -- > john r pierce, recycling bits in santa cruz > > -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

Re: [GENERAL] Primary Keys

2016-04-29 Thread John McKown
via multiple SELECT statements which I haven't reviewed yet. > > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. > -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

Re: [GENERAL] "Keyed" sequence?

2016-04-28 Thread John McKown
o -- 1 (1 row) UPDATE 1 > > > -- > > Vik Fearing +33 6 46 75 15 36 > > http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support > > > > -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

Re: [GENERAL] Proper relational database?

2016-04-22 Thread John McKown
omething else. I need to read the "internals" documentation on the web site.​ -- "He must have a Teflon brain -- nothing sticks to it" Phyllis Diller Maranatha! <>< John McKown

Re: [GENERAL] Proper relational database?

2016-04-21 Thread John McKown
stgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- "He must have a Teflon brain -- nothing sticks to it" Phyllis Diller Maranatha! <>< John McKown

Re: [GENERAL] $foo $bar is BAD

2016-04-15 Thread John McKown
this is a fantasy. [sigh]​ -- How many surrealists does it take to screw in a lightbulb? One to hold the griffon and one to fill the bathtub with brightly colored LEDs. Maranatha! <>< John McKown

Re: [GENERAL] Fastest way to duplicate a quite large database

2016-04-12 Thread John McKown
On Tue, Apr 12, 2016 at 10:14 AM, John R Pierce wrote: > On 4/12/2016 7:55 AM, John McKown wrote: > >> Hum, I don't know exactly how to do it, but on Linux, you could put the >> "Customer" database in a tablespace which resides on a BTRFS filesystem. >>

Re: [GENERAL] Fastest way to duplicate a quite large database

2016-04-12 Thread John McKown
> Thanks, > > -- > Atenciosamente, > > Edson Carlos Ericksson Richter > -- How many surrealists does it take to screw in a lightbulb? One to hold the griffon and one to fill the bathtub with brightly colored LEDs. Maranatha! <>< John McKown

Re: [GENERAL] psql question: aborting a "script"

2016-03-15 Thread John McKown
On Tue, Mar 15, 2016 at 9:57 AM, Melvin Davidson wrote: > > > On Tue, Mar 15, 2016 at 10:49 AM, John McKown < > john.archie.mck...@gmail.com> wrote: > >> On Tue, Mar 15, 2016 at 9:38 AM, Adrian Klaver > > wrote: >> >>> On 03/15/2016 07:33 AM, Jo

Re: [GENERAL] psql question: aborting a "script"

2016-03-15 Thread John McKown
On Tue, Mar 15, 2016 at 9:38 AM, Adrian Klaver wrote: > On 03/15/2016 07:33 AM, John McKown wrote: > >> I'm likely abusing the psql program. What I have is an awk program which >> reads a file and produces a number of INSERT INTO commands. I then feed >> these comma

[GENERAL] psql question: aborting a "script"

2016-03-15 Thread John McKown
missing where it already exists? -- A fail-safe circuit will destroy others. -- Klipstein Maranatha! <>< John McKown

Re: [GENERAL] Looking for pure C function APIs for server extension: language handler and SPI

2016-03-01 Thread John McKown
S > *------* > > *Andl - A New Database Language - andl.org <http://andl.org>* > > > -- The man has the intellect of a lobotomized turtle. Maranatha! <>< John McKown

Re: [GENERAL] Attachments

2016-02-02 Thread John McKown
uot; Computer Science is the only discipline in which we view adding a new wing to a building as being maintenance -- Jim Horning Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. He's about as useful as a wax frying pan. Maranatha! <>< John McKown

Re: [GENERAL] A motion

2016-01-25 Thread John McKown
nce is the only discipline in which we view adding a new wing to a building as being maintenance -- Jim Horning Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. He's about as useful as a wax frying pan. Maranatha! <>< John McKown

Re: [GENERAL] regexp_replace

2016-01-14 Thread John McKown
riving down the autobahn. A police officer pulls him over. The officer says, "Excuse me, sir, do you know how fast you were going?" "No," replies Dr. Heisenberg, "but I know where I am." Computer Science is the only discipline in which we view adding a new wing to a building as being maintenance -- Jim Horning Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. He's about as useful as a wax frying pan. Maranatha! <>< John McKown

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread John McKown
fast you were going?" "No," replies Dr. Heisenberg, "but I know where I am." Computer Science is the only discipline in which we view adding a new wing to a building as being maintenance -- Jim Horning Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. He's about as useful as a wax frying pan. Maranatha! <>< John McKown

Re: [GENERAL] Unique index problem

2015-12-21 Thread John McKown
s. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

2015-11-18 Thread John McKown
Klaver > adrian.kla...@aklaver.com > > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] postgreSQL.conf has become zero byte file

2015-11-17 Thread John McKown
is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] can postgres run well on NFS mounted partitions?

2015-11-12 Thread John McKown
know why the OP wants to put the database files on an NFS. -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] can postgres run well on NFS mounted partitions?

2015-11-09 Thread John McKown
ted, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] Processing data from table using awk.

2015-10-06 Thread John McKown
; > bobb > > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] Processing data from table using awk.

2015-10-06 Thread John McKown
On Tue, Oct 6, 2015 at 9:25 AM, Reid Thompson wrote: > On Tue, 2015-10-06 at 09:04 -0500, John McKown wrote: > > > I'm wanting to do some reporting on data which I have an a PostgreSQL > table. > > For lack of anything better, I've decided to see if I can do

[GENERAL] Processing data from table using awk.

2015-10-06 Thread John McKown
l be a "leaning experience" (with associated scars, I'm sure). -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] Selecting pairs of numbers

2015-10-05 Thread John McKown
> http://www.postgresql.org/mailpref/pgsql-general > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] looking for old rpm

2015-09-21 Thread John McKown
wn until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] @ operator

2015-09-17 Thread John McKown
x frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] [R] Issues with RPostgres

2015-08-27 Thread John McKown
On Thu, Aug 27, 2015 at 4:19 PM, Abraham Mathew wrote: "test" is not in the postgres database. In fact, there is no table or column named "test" The user is "postgres" and the dbname is also "postgres" On Thu, Aug 27, 2015 at 4:13 PM, John McKown w

Re: [GENERAL] [R] Issues with RPostgres

2015-08-27 Thread John McKown
e local host are automatically logged in as their Linux (in my case) id. Your code is connecting via TCPIP because you have the host= & port= parameters. This is not normally needed for users running on the same physical machine as the PostgreSQL data base server. So I'm too lazy to do it [

Re: [GENERAL] PostgreSQL Developer Best Practices

2015-08-26 Thread John McKown
's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] fastes way to retrieve segmented without using loop

2015-08-23 Thread John McKown
Melvin's use of DISTINCT ON (...) is superior to my use of DISTINCT(...) because it doesn't return the value to your program. I keep forgetting this way. I learned it the other way. Old dog + new trick == problem. On Sun, Aug 23, 2015 at 5:04 PM, John McKown wrote: > On Sun, Aug

Re: [GENERAL] fastes way to retrieve segmented without using loop

2015-08-23 Thread John McKown
le to ONLY and ALWAYS specify the variable names. The only exception is if your program actually examines the schema of the table before doing a SELECT and dynamically constructs it. -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] Count of non-null values per table column

2015-08-14 Thread John McKown
would be 2, not 12. Or do you really want the 12? I'm unsure. -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] PostgreSQL - The Best Overall Database

2015-08-13 Thread John McKown
of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] SQL pre-processor, like ecpg, for other languages?

2015-08-11 Thread John McKown
r now, but not even a novice really. ​ -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[GENERAL] SQL pre-processor, like ecpg, for other languages?

2015-08-11 Thread John McKown
is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] official rpm build spec file

2015-08-08 Thread John McKown
d my own Postgresql rpm. > > Thanks. > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] json ->> operator precedence

2015-08-05 Thread John McKown
On Wed, Aug 5, 2015 at 8:42 AM, Geoff Winkless wrote: > On 5 August 2015 at 14:35, John McKown > wrote: >> >> ​Looks correct to me. As I understand it the ::jsonb is NOT an operator! >> It is a syntactic construct for a CAST(). An equivalent which might make >> m

Re: [GENERAL] json ->> operator precedence

2015-08-05 Thread John McKown
On Wed, Aug 5, 2015 at 8:35 AM, John McKown wrote: > ​​ > > ​Looks correct to me. As I understand it the ::jsonb is NOT an operator! > It is a syntactic construct for a CAST(). An equivalent which might make > more sense is: > > select CASE WHEN CAST('{"a"

Re: [GENERAL] json ->> operator precedence

2015-08-05 Thread John McKown
l is ->> actually running at? > > Or am I missing something? > ​​ ​Looks correct to me. As I understand it the ::jsonb is NOT an operator! It is a syntactic construct for a CAST(). An equivalent which might make more sense is: select CASE WHEN CAST('{"a":null}' AS JSONB)->>'a' IS NULL THEN 'yes' ELSE 'no' END;​​ Oh, an CAST() may look like a function call, but it is also a syntactic element. I.e. there is not a function called "CAST". > Cheers > > Geoff > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] running script on the server

2015-07-28 Thread John McKown
ore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] I lost my password

2015-07-26 Thread John McKown
x frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] Bounded Zone Offset Query

2015-07-10 Thread John McKown
ckup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

2015-07-08 Thread John McKown
are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

2015-07-08 Thread John McKown
On Wed, Jul 8, 2015 at 3:55 AM, Karsten Hilbert wrote: > On Tue, Jul 07, 2015 at 06:57:45AM -0500, John McKown wrote: > > > >>> >at a bare minimum, a database administrator needs to create database > > >>> >roles (users) and databases for an app like you

Re: [GENERAL] pg_dump (PostgreSQL) 9.4.1 - delay in checking if file exists

2015-07-07 Thread John McKown
ondition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

2015-07-07 Thread John McKown
erce, recycling bits in santa cruz > > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] use null or 0 in foreign key column, to mean "no value"?

2015-06-26 Thread John McKown
n until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. My sister opened a computer store in Hawaii. She sells C shells down by the seashore. If someone tell you that nothing is impossible: Ask him to dribble a football. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] Between with a list of ranges possible ?

2015-05-29 Thread John McKown
> -- My sister opened a computer store in Hawaii. She sells C shells down by the seashore. If someone tell you that nothing is impossible: Ask him to dribble a football. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] dba scripts & queries

2015-05-26 Thread John McKown
-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- My sister opened a computer store in Hawaii. She sells C shells down by the seashore. If someone tell you that nothing is impossible: Ask him to dribble a football. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] Different result depending on order of joins

2015-05-22 Thread John McKown
>> > >> >and the FULL JOIN will add a row for b_val=2 with NULL a_val. >> > >> >The second query will first produce >> > >> > a_val | b_val >> >---+--- >> > 1 | 1 >> > 2 | 2 >> > 3 | >> > >> >an since none but the first row matches a_val=1, you'll get only that >> row in the result. >> > >> >Yours, >> >Laurenz Albe >> >> >> Thank you! >> >> Sorry for not finding it myself, but now I understand why it behaves >> like this :-) >> >> Thanks >> >> Nicklas >> > > > > -- > Tim Rowe > -- My sister opened a computer store in Hawaii. She sells C shells down by the seashore. If someone tell you that nothing is impossible: Ask him to dribble a football. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] date with month and year

2015-05-21 Thread John McKown
you that nothing is impossible: Ask him to dribble a football. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] Stellar Phoenix File Recovery Software

2015-05-01 Thread John McKown
start an >> undelete process before Windows overwrites that part of hard disk with new >> files. You can set that flag back to "on" and get your file using >> ​> > >> > -- If someone tell you that nothing is impossible: Ask him to dribble a football. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] New column modifier?

2015-04-29 Thread John McKown
ght to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. > -- If you sent twitter messages while exploring, are you on a textpedition? He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[GENERAL] New column modifier?

2015-04-29 Thread John McKown
-- If you sent twitter messages while exploring, are you on a textpedition? He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

Re: [GENERAL] Workaround for bug #13148 (deferred EXCLUDE constraint violation)

2015-04-28 Thread John McKown
PostgreSQL.​ Sorry about delay but: (1) I was on Jury duty yesterday & (2) I was hoping a more experienced person would speak up. -- If you sent twitter messages while exploring, are you on a textpedition? He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

  1   2   >