Re: [GENERAL] POSTGRES to ORACLE dump

l-general -- He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown -- 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] Creating composite keys from csv

gres, or is this something we can do in > postgres? We'd really appreciate any help you all may be able to offer. > > Best! > Eli Murray > > -- He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown -- 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] Creating composite keys from csv

es and right now there are only null values in > rawdata.personid. What query should I write to SET rawdata.personid = > assignid.personid WHERE rawdata.employeename && rawdata.totalsalary = > assignid.name && assignid.totalsalary? > -- He's about as useful as a wa

Re: [GENERAL] Windows installer

s useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown -- 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] Windows installer

postgresql/postgresql-9.3.4-3-windows-x64.exe clicking on the second of those downloaded an exe, which I have not tried to run because I'd catch hell from our security people for doing it. On Wed, Mar 18, 2015 at 6:46 AM, John McKown wrote: > Interesting. I can bring that page up on

Re: [GENERAL] :Posgres - performance problem

anything permanently . Also, doing a simple ANALYZE on the table might help some. I'm not sure. ANALYZE master_items; -- 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

[GENERAL] OT? Turing Award goes to one of original authors of proto-PostgreSQL

ut as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown -- 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] How to recover or resent the password for the user 'postgres'

re 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 -- 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] The case of PostgreSQL on NFS Server (II)

o restorecon -R /var/lib/pgsql/data # update SELinux attributes The restorecon is only needed if you run SELinux > > > Thanks so much in advance, > > -- > Octavi Fors > -- If you sent twitter messages while exploring, are you on a textpedition? He's abou

Re: [GENERAL] The case of PostgreSQL on NFS Server (II)

thing like a file or directory) which don't work very well on some NAS boxes. At least, that is what Dr. Richard Hipp, who wrote and maintains SQLite, maintains in his support forum. And he is much brighter than I! > > > Thanks so much in advance, > > -- > Octavi Fors > >

Re: [GENERAL] The case of PostgreSQL on NFS Server (II)

od explanation of the NFS mount options, IMO, are on this site: http://www.dbaexpert.com/blog/nfs-options-for-performance/ Some interesting "speed test" code: https://github.com/sabujp/nfsSpeedTest > > Thanks a lot in advance, > -- > Octavi Fors -- If you sent twitter me

Re: [GENERAL] Cannot connect from local network to my postgresql server

mailing list archive at Nabble.com. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- 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] On using doubles as primary keys

t; -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- 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] DB on mSATA SSD

lue is an empty string, which results in all temporary objects being created in the default tablespace of the current database. ​I agree that is sounds like you're not using quality SSD drives.​ -- 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)

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

[GENERAL] New column modifier?

-- 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] New column modifier?

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

Re: [GENERAL] Stellar Phoenix File Recovery Software

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] date with month and year

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

>> > >> >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] dba scripts & queries

-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] Between with a list of ranges possible ?

> -- 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] use null or 0 in foreign key column, to mean "no value"?

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] [pg_hba.conf] publish own Python application using PostgreSQL

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] pg_dump (PostgreSQL) 9.4.1 - delay in checking if file exists

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

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] Oracle to PostgreSQL Migration - Need Information

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] Bounded Zone Offset Query

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] I lost my password

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

Re: [GENERAL] running script on the server

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] json ->> operator precedence

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] json ->> operator precedence

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

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] official rpm build spec file

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

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

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?

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

Re: [GENERAL] PostgreSQL - The Best Overall Database

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

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] fastes way to retrieve segmented without using loop

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] fastes way to retrieve segmented without using loop

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] PostgreSQL Developer Best Practices

'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] [R] Issues with RPostgres

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] [R] Issues with RPostgres

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] @ operator

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

Re: [GENERAL] looking for old rpm

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] Selecting pairs of numbers

> 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

[GENERAL] Processing data from table using awk.

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] Processing data from table using awk.

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

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

; > 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] can postgres run well on NFS mounted partitions?

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] can postgres run well on NFS mounted partitions?

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] Full text search on Chemistry text

" 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] Memory usage per session

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] Memory usage per session

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

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

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] How to stop script executions

; 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

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

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] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

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] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

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

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

Re: [GENERAL] About the MONEY type

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] Postgres and LibreOffice's 'Base'

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] When to use COMMENT vs --

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

Re: [GENERAL] pg_dump and quoted identifiers

#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] COPY: row is too big

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] COPY: row is too big

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] Why is table not found?

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] postgreSQL.conf has become zero byte file

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] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

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] Unique index problem

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] Moving a large DB (> 500GB) to another DB with different locale

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] regexp_replace

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] A motion

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] Attachments

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] Looking for pure C function APIs for server extension: language handler and SPI

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

[GENERAL] psql question: aborting a "script"

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

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

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

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

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] Fastest way to duplicate a quite large database

> 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] Fastest way to duplicate a quite large database

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] $foo $bar is BAD

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] Proper relational database?

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] Proper relational database?

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] "Keyed" sequence?

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] Primary Keys

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] Allow disabling folding of unquoted identifiers to lowercase

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] Allow disabling folding of unquoted identifiers to lowercase

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

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

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] Thoughts on "Love Your Database"

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] Thoughts on "Love Your Database"

, 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"

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] Postgres RFC3339 datetime formatting

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] PostgreSql Doubts

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

[GENERAL] Design ? table vs. view?

your thoughts on if this is OK, given that performance is currently acceptable. Mainly because this work is basically only done one a week, on Sundays. And I don't do it myself, it is done via a scheduler (not cron, but similar) which runs some scripts. -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown

Re: [GENERAL] Design ? table vs. view?

On Tue, Jul 15, 2014 at 8:46 AM, David G Johnston < david.g.johns...@gmail.com> wrote: > John McKown wrote > > I have a table which has some "raw" data in it. By "raw", I mean it is > > minimally processed from a log file. Every week, I update this table b

Re: [GENERAL] Petition: Treat #!... shebangs as comments

> took a few hours on irc to hack this one together. FWIW - I like #! also. Even though it may cause the Windows users to want something equivalent. Assuming there are any Windows people who really use a command prompt. -- There is nothing more pleasant than traveling and meeting new people!

Re: [GENERAL] select top_countries and for each country, select top_cities in that country, in 1 query

n the SELECT, but if you do be sure to change the values in the ORDER BY to still be the same column values. Again, I'm too lazy to type in the column names. I am not saying the above is the best possible SQL. But it did work for me in my testing. -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown

Re: [GENERAL] How to insert either a value or the column default?

my "no string interpolation" > rule of thumb unless I absolutely have to. > > And I know I could switch to some gigantic library like SQLAlchemy, > but I really don't want to. > > Any advice is welcome. Thanks in advance! > > > Matt > > -- > W. Matthew Wilson > m...@tplus1.com > http://tplus1.com > > -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown

Re: [GENERAL] POWA tool

e Java SDK can be used. Java "jar" files are simply zip files. And the jar command can list, create, and extract from jar files. jar xf powa-REL_1_1.zip # unzip === jar cf new.file.zip set.txt of.txt subdir/files.bin # create new jar lf new.file.zip # list contents -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown

  1   2   >