Re: Fwd: Receipt for PostgreSQL US Invoice #1840

I filed it under SPAM. As I do most things with a PDF or other attachment that looks even the slightest iffy. If I had my way, such people would be impaled. On Tue, Mar 12, 2024, 21:27 Adrian Klaver wrote: > On 3/12/24 19:14, Christophe Pettus wrote: > > Oops? > > > > > > >> Begin forwarded mess

Re: Why can't lseek the STDIN_FILENO?

My best advice would be to ask a C language question on a C language forum. This forum is really only for questions about the SQL language for the PostgreSQL database. I.e. no MariaDB, MySQL, MS SQL questions. First, you didn't say what OS and she'll you're using. I an guessing BASH and Linux. Se

Re: copy command - something not found

Can't really tell. You might want to post the output of the "printenv" command to show us what the shell variables you are using have in them. Oh, does ${CSVPATH} end in a slash? If it is something like "~/mycsvs" then ${CSVPATH}copycmd.z will expand to "~/mycsvscopycmd.z". Most "PATH" environmen

Re: CRecordset::Open postgresql procedure call don't work

sql.org/docs/11/xfunc.html -- We all agree on the necessity of compromise. We just can't agree on when it's necessary to compromise. -- Larry Wall Maranatha! <>< John McKown

Re: Error updating column of type text as boolean type

> PostgreSQL 10.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 > 20150623 (Red Hat 4.8.5-11), 64-bit > (1 row) > > Time: 15.989 ms > > Atenciosamente, > > Márllius de Carvalho Ribeiro > [image: EDB Certified Associate - PostgreSQL 10] > <https://www.youracclaim.com/badges/c8dd0919-86ca-4cec-9f58-5cd6fb558a91/public_url> > > -- Money is the root of all evil. Evil is the root of all money. With that in mind, money is made by the government ... Maranatha! <>< John McKown

Re: unorthodox use of PG for a customer

A, 58 can't be good. Still, the DB would be on the > workstation which seems to be what he wants. > > I can't think of anything better. Does anyone have any ideas? > Yes, but the civil authorities would prosecute you if they found the body. > > Thanks in Advance ! > > -- Between infinite and short there is a big difference. -- G.H. Gonnet Maranatha! <>< John McKown

Re: manipulating NUMERIC values in C extension

uot;, "atol()", and "atoll()" ? > > Geoff > > -- Rap music is performed by those that can not sing so others can not think. Maranatha! <>< John McKown

Re: Microsoft buys GitHub, is this a threat to open-source

GCS Griffin -- Pelaran Alliance -- TFS Guardian (book) Maranatha! <>< John McKown

Re: Control PhoneNumber Via SQL

mpany to verify some installation. The problem is, I am not installing anything. The person either gave them a bad number or mistyped it into a web page or the customer service rep mistyped it.​ -- We all have skeletons in our closet. Mine are so old, they have osteoporosis. Maranatha! <>< John McKown

Re: Enhancement to psql command, feedback.

On Wed, May 9, 2018 at 8:52 AM, Stephen Frost wrote: > Greetings, > > * John McKown (john.archie.mck...@gmail.com) wrote: > > Again, this is just a discussion point. And I'm quite willing to admit > > defeat if most people don't think that it is worth the effort

Re: Enhancement to psql command, feedback.

On Wed, May 9, 2018 at 8:56 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, May 9, 2018 at 6:44 AM, John McKown > wrote: > >> Again, this is just a discussion point. And I'm quite willing to admit >> defeat if most people don't think th

Re: Enhancement to psql command, feedback.

On Wed, May 9, 2018 at 8:17 AM, Ron wrote: > On 05/09/2018 02:59 AM, John McKown wrote: > > I just wanted to throw this out to the users before I made a complete fool > of myself by formally requesting it. But I would like what I hope would be > a minor change (enhancement) to t

Re: Enhancement to psql command, feedback.

On Wed, May 9, 2018 at 3:05 AM, Pavel Stehule wrote: > > > 2018-05-09 9:59 GMT+02:00 John McKown : > >> I just wanted to throw this out to the users before I made a complete >> fool of myself by formally requesting it. But I would like what I hope >> would be a min

Enhancement to psql command, feedback.

ing _every_ line that start with that "magic", just the first.​ -- We all have skeletons in our closet. Mine are so old, they have osteoporosis. Maranatha! <>< John McKown

Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN

to do subselects, unions, or other things containing both PostgreSQL data & CSV data, then I guess you're stuck with the foreign data wrapper. > ​ > > -- > == > Jim Michaels > > -- We all have skeletons in our closet. Mine are so old, they have osteoporosis. Maranatha! <>< John McKown

Re: Enforce primary key on every table during dev?

On Wed, Feb 28, 2018 at 7:57 AM, Adrian Klaver wrote: > On 02/28/2018 05:52 AM, John McKown wrote: > >> On Wed, Feb 28, 2018 at 7:34 AM, Jeremy Finzel > <mailto:finz...@gmail.com>>wrote: >> >> We want to enforce a policy, partly just to protect those who

Re: Enforce primary key on every table during dev?

ent​ of every table having a primary key. Of course, you could amend the policy to say a "non-NULL primary key". -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown

Re: License question regarding distribution of binaries

problems with the software. There is also the requirement that this copyright appear in all copies of the software. Here is the license we use: ... ​ -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown

Re: Notify client when a table was full

stgres with the "Class 53 — Insufficient > > Resources" error codes. > > Please refer to official documentation like: > > > > https://www.postgresql.org/docs/10/static/errcodes-appendix.html > > > > For specific programming languages more details need to be checked. > > > > Cheers, > Steve > -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown

Re: Getting started with first user.

all 127.0.0.1/32trust # IPv6 local connections: hostall all ::1/128 trust -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown

Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?

ut from parallel runs of an application from both an EBCDIC host and and ASCII host, to make sure they are "the same". -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown

Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?

o true at all! The C locales are 0-9A-Za-z > ​Thanks for the correction. Turns out that I forgot that my default locale on Linux was en_US.utf8.​ -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown

Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?

ach letter in order like: "aAbB...zZ". Comparing identical data which is not presented in exactly the same order would be very difficult. ​ > > Regards > Takayuki Tsunakawa > > -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown