Re: [HACKERS] Autonomous Transaction (WIP)

2014-04-06 Thread Craig Ringer
On 04/07/2014 12:06 PM, Rajeev rastogi wrote: > Syntax to create autonomous transaction can be as: > > */PRAGMA AUTONOMOUS TRANSACTION;/* Wouldn't you want to use SET TRANSACTION for this? Or a suffix on BEGIN, like BEGIN AUTONOMOUS TRANSACTION ? What's the logic behin

Re: [HACKERS] Autonomous Transaction (WIP)

2014-04-06 Thread Pavel Stehule
Hello +1 for feature -1 for Oracle syntax - it is hardly inconsistent with Postgres Autonomous transactions should be used everywhere - not only in plpgsql Regards Pavel 2014-04-07 6:06 GMT+02:00 Rajeev rastogi : > I would like to propose “Autonomous Transaction” feature for 9.5. > Details

[HACKERS] automatically updating security barrier views

2014-04-06 Thread Drew Crawford
Hello list, I am posting here since Craig Ringer suggested user feedback on this feature at this time may make a difference for 9.4 inclusion. I apologize if I am in the wrong place. Row-level security is probably THE major element the FOSS databases are behind compared to proprietary databas

Re: [HACKERS] [bug fix] pg_ctl always uses the same event source

2014-04-06 Thread Amit Kapila
On Sat, Apr 5, 2014 at 8:24 PM, Tom Lane wrote: > Amit Kapila writes: >> Are you concerned about the case when user passes event_source name >> in command line at the time of start: >> pg_ctl start -o "-c event_source=PG9.4" -D > > Right. > >> If my understanding is right about your concern, the

Re: [HACKERS] [review] PostgreSQL Service on Windows does not start if data directory given is relative path

2014-04-06 Thread Rajeev rastogi
On 05 April 2014 04:14, Tom Lane > > [ pgctl_win32service_rel_dbpath_v6.patch ] > > Committed with minor corrections, mostly but not all cosmetic. Thanks a lot... -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.

Re: [HACKERS] Downsides of scanning all .o files for typedefs

2014-04-06 Thread Andrew Dunstan
On 04/06/2014 12:06 PM, Tom Lane wrote: I'd been getting weird results for the last couple of days while pgindent-ing various patches. I eventually realized that the cause was that the current typedefs list marks "c", "string", and a few other common words as typedefs. This seems pretty uncool

Re: [HACKERS] four minor proposals for 9.5

2014-04-06 Thread Pavel Stehule
2014-04-04 6:51 GMT+02:00 Amit Kapila : > On Tue, Apr 1, 2014 at 11:42 PM, Pavel Stehule > wrote: > > 2014-03-27 17:56 GMT+01:00 Pavel Stehule : > >> So I'll prepare a some prototypes in next month for > >> > >> 1. log a execution time for cancelled queries, > >> 2. track a query lock time > >> >

[HACKERS] FastPathStrongRelationLocks still has an issue in HEAD

2014-04-06 Thread Tom Lane
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=rover_firefly&dt=2014-04-06%2017%3A04%3A00 TRAP: FailedAssertion("!(FastPathStrongRelationLocks->count[fasthashcode] > 0)", File: "lock.c", Line: 1240) [53418a51.6a08:2] LOG: server process (PID 27631) was terminated by signal 6 [53418a51.6a

[HACKERS] Downsides of scanning all .o files for typedefs

2014-04-06 Thread Tom Lane
I'd been getting weird results for the last couple of days while pgindent-ing various patches. I eventually realized that the cause was that the current typedefs list marks "c", "string", and a few other common words as typedefs. This seems pretty uncool. Further investigation shows that the rea

[HACKERS] tds_fdw for Sybase and MS SQL Server

2014-04-06 Thread Geoff Montee
If anyone is interested, I've developed a foreign data wrapper that can be used to connect to Sybase databases and Microsoft SQL Server. You can get it on GitHub here: https://github.com/GeoffMontee/tds_fdw I did my testing with FreeTDS, an open source TDS library. I've talked to Greg Smith abou