Re: [GENERAL] Feature request - psql --quote-variable

2017-03-09 Thread Caleb Cushing
igint) `insert into foo ( id ) values ( :'var' )` maybe the docs should mention sql injection? (if for nothing more than google indexing and ctrl+f page searching) On Tue, Feb 21, 2017 at 12:35 PM Pavel Stehule wrote: > Hi > > 2017-02-21 15:19 GMT+01:00 Caleb Cushing : > >

[GENERAL] Feature request - psql --quote-variable

2017-02-21 Thread Caleb Cushing
e trusted... in theory though you can provide a UI that gives them access to manage the container with no actual access to the container. I don't actually have that problem it's more of a hypothetical to me, but I'm sure it will exist at some point. Just sharing my pain in hopes that improvements can be developed. p.s. pg is still hashing its passwords with md5? :( -- Caleb Cushing http://xenoterracide.com

Re: [GENERAL] Can row level security policies also be implemented for views?

2015-12-03 Thread Caleb Meredith
Yes it probably could be solved by this. Just a trigger which replaces SELECT right? On Wed, Dec 2, 2015 at 6:01 PM Jim Nasby wrote: > On 12/2/15 4:59 PM, Caleb Meredith wrote: > > What is an SRF? > > Set returning function. > > CREATE FUNCTION srf() RETURNS SETOF pg_

Re: [GENERAL] Can row level security policies also be implemented for views?

2015-12-03 Thread Caleb Meredith
What is an SRF? On Wed, Dec 2, 2015 at 5:46 PM Jim Nasby wrote: > On 11/25/15 7:40 AM, Stephen Frost wrote: > >> It seems easy conceptually, RLS just adds a WHERE clause to queries if > I'm > >> >not mistaken, and conceptually a view is just a query. The CURRENT_USER > >> >issue is valid, but pe

[GENERAL] Can row level security policies also be implemented for views?

2015-11-24 Thread Caleb Meredith
I'm developing an application where strict control of my data is important. Views allow me to build a strict custom reading experience, allowing me to add computed columns and hide private and metadata columns. Row level security allows me strict write control of my data. However, I can't use both

[GENERAL] Web-based Graphical Query Building Tool for PostgreSQL

2011-07-13 Thread Caleb Palmer
rably web-based. I know that Pgadmin as a graphical query building. Thanks in advance, Caleb Palmer

Re: [GENERAL] do I need replication or something else?

2005-03-29 Thread Caleb Simonyi-Gindele
hn D. Burger MITRE Yes, we use it successfully with the SQL Server edition of our product. Does anyone know if this is available with Postgre? Caleb begin:vcard fn:Caleb Simonyi-Gindele n:Simonyi-Gindele;Caleb org:Advanced Technology Corp. adr:;;79 N. Franklin Turnpike;Ramsey;NJ;07446;USA e

[GENERAL] do I need replication or something else?

2005-03-29 Thread Caleb Simonyi-Gindele
the db level rather than doing this in our app. What is the best tool to accomplish this with? Caleb begin:vcard fn:Caleb Simonyi-Gindele n:Simonyi-Gindele;Caleb org:Advanced Technology Corp. adr:;;79 N. Franklin Turnpike;Ramsey;NJ;07446;USA email;internet:[EMAIL PROTECTED] title:R&D Specialist

[GENERAL] Unicode support on Win32

2005-02-28 Thread Caleb
Hi, I am using Windows as a development environment (and database design), and it seems that Unicode is not supported on Win32. Is there word on when Unicode support will be implemented on the Windows port of PostgreSQL? I was used to using mySQL and it supported Unicode on Windows properly.. B