Re: [GENERAL] Proper relational database?

2016-04-27 Thread David Bennett
> ow...@postgresql.org] On Behalf Of Eric Schwarzenbach > >> If I had a few $million to spend in a philanthropical manner, I would > >> hire some of the best PG devs to develop a proper relational database > server. > >> Probably a query language that expressed the relational algebra in a > >> sch

Re: [GENERAL] Proper relational database?

2016-04-27 Thread David Bennett
> From: Thomas Munro [mailto:thomas.mu...@enterprisedb.com] > FWIW standard SQL may not allow it but Postgres does, and it's even possible > to exclude duplicates by using an expression that references the whole row. Thank you. I didn't know that. I'll use it if I can verify it works right. It'

Re: [GENERAL] How do BEGIN/COMMIT/ABORT operate in a nested SPI query?

2016-04-19 Thread David Bennett
> From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at] > > > I am attempting to create a new language implementation. The language > > is Andl (andl.org), so the handler is plandl. > > This is a question about executing SPI queries from inside plandl. > > > > The documentation makes it clear that S

Re: [GENERAL] How to detoast a column of type BYTEAOID

2016-04-18 Thread David Bennett
OK, got it. I really wasn't expecting to have to deal with TOASTs in what looks like a rather ordinary query -- perhaps there might be a note in the documentation? But thanks, that works just fine. Problem solved. Regards David M Bennett FACS Andl - A New Database Language - andl.org > -O

Email address VERP problems (was RE: [GENERAL] Does a call to a language handler provide a context/session, and somewhere to keep session data?

2016-03-09 Thread David Bennett
> ow...@postgresql.org] On Behalf Of Alvaro Herrera > On that subject. I noticed that Outlook seems to add the "return > path" > addresses (sometimes called bounce address or envelope sender) to the > CC header, which sets a new record in the stupidity scale. Since we > use VERP, each message ge

Re: [GENERAL] Does a call to a language handler provide a context/session, and somewhere to keep session data?

2016-03-07 Thread David Bennett
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jan de Visser One thing that's probably key here is that pgsql isn't multi-threaded. Individual connections are handled by forked backends, which share a shared- memory cache that's not accessible

Re: [GENERAL] Does a call to a language handler provide a context/session, and somewhere to keep session data?

2016-03-07 Thread David Bennett
Thank you for your response. Yes, I was aware of GD and SD. My question is about what facilities Postgres provides for implementing such a thing. Where is the proper place for the root of the SD/GD? What does an implementation use to determine that two calls belong to the same session? I

Re: [GENERAL] CStringGetTextDatum and other conversions in server-side code

2016-03-04 Thread David Bennett
all the text types are simply a 32bit length and an array of characters. you need to be aware of the encoding, and null is just another character. [dmb>] Yes, I can see that. What I need is a function that will convert to and from whatever the actual encoding happens to be into Unicode, period

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

2016-03-02 Thread David Bennett
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Wednesday, 2 March 2016 1:30 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Looking for pure C function APIs for server extension: language handler and SPI On 2/29

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

2016-03-02 Thread David Bennett
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John McKown Sent: Wednesday, 2 March 2016 1:03 PM To: da...@andl.org Cc: pgsql-general-owner+M220260=david=andl@postgresql.org; Postgres General Subject: Re: [GENERAL] Looking for pure C functio