Re: How to reply to an existing bug?

2018-05-27 Thread Thomas Kellerer
Erwin Brandstetter schrieb am 28.05.2018 um 02:00: > I found an existing bug report and have something to add to it. > > What's the best way to reply to it? Just using a browser, with no newsreader > installed. > > This one: > https://www.postgresql.org/message-id/flat/20170925084522.1442.32786%

Re: Help with SQL

2018-05-27 Thread Rob Sargent
> On May 27, 2018, at 6:42 PM, anand086 wrote: > > Hi, > > I have a requirement of writing plpgsql function to create partial indexes > on child tables if it exists on parent table. The function will have > schemname, childtablename, tableowner as input. > > I am using the below code to ident

Help with SQL

2018-05-27 Thread anand086
Hi, I have a requirement of writing plpgsql function to create partial indexes on child tables if it exists on parent table. The function will have schemname, childtablename, tableowner as input. I am using the below code to identify the indexname and index definition from parent table -- ``` wi

How to reply to an existing bug?

2018-05-27 Thread Erwin Brandstetter
I found an existing bug report and have something to add to it. What's the best way to reply to it? Just using a browser, with no newsreader installed. This one: https://www.postgresql.org/message-id/flat/20170925084522.1442.32786%40wrigleys.postgresql.org#20170925084522.1442.32...@wrigleys.postg

Re: case statement within insert

2018-05-27 Thread tango ward
On Fri, May 25, 2018 at 10:19 PM, Adrian Klaver wrote: > On 05/25/2018 07:05 AM, Adrian Klaver wrote: > >> On 05/25/2018 06:52 AM, Adrian Klaver wrote: >> >>> On 05/25/2018 02:04 AM, tango ward wrote: >>> I want to insert data from mysql into a table in postgresql. I want to c

Re: existence of a savepoint?

2018-05-27 Thread David G. Johnston
On Sunday, May 27, 2018, Stuart McGraw wrote: > Is there some way to to test if a savepoint of a given name > exists? Or better yet, the number of stacked savepoints of > that name? > A scan of the documentation doesn't show any commands or functions that would provide this information. David

existence of a savepoint?

2018-05-27 Thread Stuart McGraw
Is there some way to to test if a savepoint of a given name exists? Or better yet, the number of stacked savepoints of that name?

Re: Syndicating PostgreSQL mailing list to Discourse

2018-05-27 Thread Peter Geoghegan
On Sun, May 27, 2018 at 6:13 AM, Stephen Frost wrote: > I'm curious what would be different here from what our archives provide. > We could certainly have a single "all lists" archive page but that seems > more likely to be just completely confusing than actually useful at all. Any replacement to

Re: UPDATE from CTE syntax error

2018-05-27 Thread Alexander Farber
On Sat, May 26, 2018 at 6:37 PM, Adrian Klaver wrote: > > > https://www.postgresql.org/docs/10/static/sql-update.html > "column_name > > The name of a column in the table named by table_name. The column name > can be qualified with a subfield name or array subscript, if needed. Do not > includ

Re: Syndicating PostgreSQL mailing list to Discourse

2018-05-27 Thread Stephen Frost
Greetings, * Erlend Sogge Heggen (e.so...@gmail.com) wrote: > Since it's read-only it would only be used for things like: > >- Fast search with advanced filters (Discourse puts PostgreSQL full text >search to good use!) While it might not be the case for other projects, we actually do us