2017-03-28 9:51 GMT+02:00 Jan Kechel :
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
>
> Hi PostgreSQL Hackers,
>
>
> I'm developing software using PostgreSQL for several years and want to
> propose a feature to improve security of (badly written?) Web-Apps.
>
> I call it 'Database Secu
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Hi PostgreSQL Hackers,
I'm developing software using PostgreSQL for several years and want to
propose a feature to improve security of (badly written?) Web-Apps.
I call it 'Database Security Modules', derived from
Linux-Security-Modules (aka S
> On 5 Oct 2016, at 8:11 PM, Pantelis Theodosiou wrote:
>
> This can be solved by chaining modifying CTEs.
>
> Something like this (not tested) that can work with multiple rows inserted:
Thanks for the suggestion, but it was actually slower than our current
implementation, I believe due to
This can be solved by chaining modifying CTEs.
Something like this (not tested) that can work with multiple rows inserted:
WITH
vals (bk1, bk2, other_t1_columns, other_t2_columns) AS
( VALUES (bk1val, bk2val, other_t1_values, other_t2_values),
(bk1val, bk2val, other_t1_values
Hi all
We recently moved to using 9.5 and were hoping to use the new upsert
functionality, but unfortunately it doesn’t quite do what we need.
Our setup is something like this:
CREATE TABLE t1 (
id BIGSERIAL NOT NULL PRIMARY KEY,
bk1 INT,
bk2 UUID
— other columns
);
CREATE UNIQUE INDEX
Peter Eisentraut writes:
> Start here:
> http://developer.postgresql.org/pgdocs/postgres/plhandler.html
> I notice that this has not been updated for the new inline handlers, but
> that shouldn't stop you.
Actually, that chapter is so old it didn't get updated for language
validators either :-(.
Kiswono Prayogo escribió:
> i guess v8 still the best javascript interpreter
> http://waynepan.com/2008/09/02/v8-tracemonkey-squirrelfish-ie8-benchmarks/
> nitro from apple safari would be the second best..
> http://www.computerworld.com/s/article/9128638/Safari_4_rivals_Google_Chrome_in_JavaScrip
On Thu, 2009-10-08 at 07:06 +0700, Kiswono Prayogo wrote:
> > Said slides are available here:
> > http://www.pgcon.org/2009/schedule/events/159.en.html
> >
> > I hope they can be useful.
> >
> > --
> > Joshua Tolley / eggyknap
>
> ok i will read it, thanks ^^
And video:
http://www.vimeo.com/3728
> Said slides are available here:
> http://www.pgcon.org/2009/schedule/events/159.en.html
>
> I hope they can be useful.
>
> --
> Joshua Tolley / eggyknap
ok i will read it, thanks ^^
On Wed, Oct 7, 2009 at 11:18 PM, David E. Wheeler wrote:
> On Oct 7, 2009, at 7:55 AM, Andrew Dunstan wrote:
>
>
On Wed, Oct 07, 2009 at 11:29:15AM -0400, Alvaro Herrera wrote:
> Joshua Tolley escribió:
> > On Wed, Oct 07, 2009 at 10:22:02AM -0400, Alvaro Herrera wrote:
> > > Kiswono Prayogo escribió:
> > > > by using latest v8 engine from google, is it possible to build PL/Js
> > > > just like other PL in Po
On Wed, Oct 7, 2009 at 5:00 AM, Kiswono Prayogo wrote:
> by using latest v8 engine from google, is it possible to build PL/Js
> just like other PL in Postgre? such as PL/PHP
> what should i learn if i want to build PL/Js?
> thanks in advance.
>
> regards,
> Kis
> GB
>
>
You also can see this link
On Oct 7, 2009, at 7:55 AM, Andrew Dunstan wrote:
BTW I've seen requests for PL/Js so I'm sure it'll be welcome. What
license is v8 under?
It's a BSD license, but it's a C++ API. While it looks cool, I think
SpiderMonkey is possibly a better bet.
SquirrelFish? http://webkit.org/blog/189/a
>
> I think Josh Tolley has some slides on how we built PL/LOLCODE that
> could prove useful.
>
> BTW I've seen requests for PL/Js so I'm sure it'll be welcome. What
> license is v8 under?
>
>
the new BSD License
http://code.google.com/p/v8/
--
GHUM Harald Massa
persuadere et programmare
Haral
Joshua Tolley escribió:
> On Wed, Oct 07, 2009 at 10:22:02AM -0400, Alvaro Herrera wrote:
> > Kiswono Prayogo escribió:
> > > by using latest v8 engine from google, is it possible to build PL/Js
> > > just like other PL in Postgre? such as PL/PHP
> > > what should i learn if i want to build PL/Js?
On Wed, Oct 07, 2009 at 10:22:02AM -0400, Alvaro Herrera wrote:
> Kiswono Prayogo escribió:
> > by using latest v8 engine from google, is it possible to build PL/Js
> > just like other PL in Postgre? such as PL/PHP
> > what should i learn if i want to build PL/Js?
>
> I think Josh Tolley has some
Alvaro Herrera wrote:
Kiswono Prayogo escribió:
by using latest v8 engine from google, is it possible to build PL/Js
just like other PL in Postgre? such as PL/PHP
what should i learn if i want to build PL/Js?
I think Josh Tolley has some slides on how we built PL/LOLCODE that
could p
Kiswono Prayogo escribió:
> by using latest v8 engine from google, is it possible to build PL/Js
> just like other PL in Postgre? such as PL/PHP
> what should i learn if i want to build PL/Js?
I think Josh Tolley has some slides on how we built PL/LOLCODE that
could prove useful.
BTW I've seen re
On Wed, 2009-10-07 at 15:00 +0700, Kiswono Prayogo wrote:
> by using latest v8 engine from google, is it possible to build PL/Js
> just like other PL in Postgre? such as PL/PHP
> what should i learn if i want to build PL/Js?
Start here:
http://developer.postgresql.org/pgdocs/postgres/plhandler.ht
by using latest v8 engine from google, is it possible to build PL/Js
just like other PL in Postgre? such as PL/PHP
what should i learn if i want to build PL/Js?
thanks in advance.
regards,
Kis
GB
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscr
Well. Ok.
Then I'll just do it myself.
Just thought it would be good for thousands of users.
As I said, it was just a suggestion.
I surely aint the only one who ever thought about it.
Thanks anyway.
2007/7/31, Josh Berkus <[EMAIL PROTECTED]>:
>
> Rafael,
>
> > This is just a PLUS. I just don't s
On 8/1/07, Rafael Azevedo <[EMAIL PROTECTED]> wrote:
> Imagine that you have about 30 fields.
> Ok, then your first SQL is done.
> Now, you just have to add 10 more fields.
> Its very easy to get lost. If we have this implementation, you could just
> add
>
> Field31 = 'text',
> Field32 = 'text'
I
Rafael,
> This is just a PLUS. I just don't see any problem by doing this.
> Even knowing that this is not Standard SQL-Syntax, I just see this as a
> benefit feature.
Our project has a policy of upholding the SQL standard whereever possible.
For that reason, we don't approve non-standard synta
Imagine that you have about 30 fields.
Ok, then your first SQL is done.
Now, you just have to add 10 more fields.
Its very easy to get lost. If we have this implementation, you could just
add
Field31 = 'text',
Field32 = 'text'
...
wherever you want.
This is just a PLUS. I just don't see any probl
Gregory Stark wrote:
> "Rafael Azevedo" <[EMAIL PROTECTED]> writes:
>
> > Unstead of having to type all the insert syntax, using ("column") names, you
> > could do the same as MySQL does.
> > for example:
> >
> > INSERT INTO Table SET
> > "Field1" = 'text',
> > "Field2" = 'text';
> >
> > So it wou
"Rafael Azevedo" <[EMAIL PROTECTED]> writes:
> Unstead of having to type all the insert syntax, using ("column") names, you
> could do the same as MySQL does.
> for example:
>
> INSERT INTO Table SET
> "Field1" = 'text',
> "Field2" = 'text';
>
> So it would make it easier and faster to develop app
Rafael Azevedo wrote:
> People,
>
> I'd like to suggest you guys to implement a new feature.
> Actually is an alias for a existent feature.
>
> Unstead of having to type all the insert syntax, using ("column") names, you
> could do the same as MySQL does.
> for example:
>
> INSERT INTO Table SET
People,
I'd like to suggest you guys to implement a new feature.
Actually is an alias for a existent feature.
Unstead of having to type all the insert syntax, using ("column") names, you
could do the same as MySQL does.
for example:
INSERT INTO Table SET
"Field1" = 'text',
"Field2" = 'text';
So
I don't think that this has been up for discussion yet but I think it
would be good concept/feature that someone might want to take up or
shoot down. However some may have already. I am not sure where it falls
PGAdmin, psql, optimizer, gborg... all.
Recommended Feature: Index Tuning Wizard
Des
Hi Lincoln,
Not sure why you would want to run multiple instances, since you can run
multiple dbs if you want to maintain separate environments but if you really
need to do this, the postmaster has some options which control ip/port
binds:
[pritchma@blade pritchma]$ /usr/local/pgsql/bin/postmast
Lincoln Yeoh <[EMAIL PROTECTED]> writes:
> I'm using a redhat style postgresql init and somehow postgresql seems to
> ignore the postgresql.conf file.
That seems unlikely, assuming you are running a PG version recent enough
to have a postgresql.conf file (ie 7.1 or better). What exactly are you
At 11:16 PM 03-10-2001 -0400, Tom Lane wrote:
>Lincoln Yeoh <[EMAIL PROTECTED]> writes:
>> Is it possible for Postgresql to bind to one IP address?
>
>See 'virtual_host' GUC parameter.
>
> regards, tom lane
Thanks!
I'm using a redhat style postgresql init and somehow postg
Lincoln Yeoh <[EMAIL PROTECTED]> writes:
> Is it possible for Postgresql to bind to one IP address?
See 'virtual_host' GUC parameter.
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi people,
Is it possible for Postgresql to bind to one IP address?
I'm trying to run multiple postgresql installations on one server.
The unix socket could be named accordingly:
Postgresql config bound to a particular port and all IPs.
.s.PGSQL.
Postgresql config bound to a particular port
33 matches
Mail list logo
