On Fri, Jul 29, 2011 at 7:23 PM, Brent Wood wrote:
> Apologies for the cross posting, but this thesis may be of interest to a
> wide array of FOSS related lists.
>
> It just went public:
>
> Title: Factors Influencing Participant Satisfaction with Free/Libre and
> Open Source Software Projects
On Thu, Jul 28, 2011 at 2:31 PM, Rebecca Clarke wrote:
> I want to search and list all the functions in a database that reference a
> particular table within its code. Is there a way to do this?
No, because functions can execute SQL dynamically.
--
Simon Riggs http://www.2nd
On 30/07/11 10:45, bricklen wrote:
[...]
CREATE OR REPLACE VIEW table_dependencies AS (
WITH RECURSIVE t AS (
SELECT
c.oid AS origin_id,
c.oid::regclass::text AS origin_table,
c.oid AS referencing_id,
c.oid::regclass::text AS referencing_table,
c2
On 30/07/11 10:45, bricklen wrote:
A coworker of mine* was looking for a way to quickly and easily be
able to tell which tables were referencing particular table(s) she
wanted to load (for unit testing). Using the examples from David
Fetter**, she submitted a revised version that seems to work qu
Hi,
I am using postgresql on Glassfish server and I have EJB 3.0 for ORM. I am
trying to run a query in PSQL but receiving following error:
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services -
2.0.0.v20091031-r5713): org.eclipse.persistence.exceptions.DatabaseExcept
On 30/07/11 10:45, bricklen wrote:
A coworker of mine* was looking for a way to quickly and easily be
able to tell which tables were referencing particular table(s) she
wanted to load (for unit testing). Using the examples from David
Fetter**, she submitted a revised version that seems to work qu
My guess is some one moved the data folder or the directory got deleted
(/var/lib/pgsql/9.0/data/.../...1663/16384/16564). Without server restart. I am
sure some experts gonna answer this very well.
Thanks
Deepak
On Jul 30, 2011, at 2:01 AM, Deniz Atak wrote:
> Hi,
>
> I am using postgresql
Deniz Atak writes:
> I am using postgresql on Glassfish server and I have EJB 3.0 for ORM. I am
> trying to run a query in PSQL but receiving following error:
> Local Exception Stack:
> Exception [EclipseLink-4002] (Eclipse Persistence Services -
> 2.0.0.v20091031-r5713): org.eclipse.persistence.
Dne 28.7.2011 13:03, Samba napsal(a):
> One concern that is being coined by the our management team is regarding
> the relative stability and 'industrial-strength' of streaming
> replication. Considering that this feature is just one year old, doubts
> are expressed about
>
> * data integrity --
On 07/28/2011 05:11 PM, Tom Lane wrote:
Merlin Moncure writes:
Couple points:
*) why a special case for boolean values?
That seemed weird to me too ...
I'm using 8.2 and "cannot cast type boolean to text"
*) this should be immutable
What if the passed expression is volatile? Better to be
On 07/28/2011 06:28 PM, Chris Travers wrote:
On Thu, Jul 28, 2011 at 8:08 AM, David Johnston wrote:
At best, based upon the example using "current_timestamp()", you could only
mark it as being stable, right?
Also not mentioned; what risk is there of this function being hacked? It
places the
2011/7/30 Sim Zacks :
>
> On 07/28/2011 05:11 PM, Tom Lane wrote:
>
>> Merlin Moncure writes:
>>>
>>> Couple points:
>>> *) why a special case for boolean values?
>>
>> That seemed weird to me too ...
>
> I'm using 8.2 and "cannot cast type boolean to text"
are you aware that support for 8.2 will
We are in the process of building regression tests for our 700+ functions.
I hope to have it finished in about 6 months.
Sim
On 07/31/2011 08:31 AM, Jaime Casanova wrote:
2011/7/30 Sim Zacks:
On 07/28/2011 05:11 PM, Tom Lane wrote:
Merlin Moncurewrites:
Couple points:
*) why a speci
On Sat, Jul 30, 2011 at 9:50 PM, Sim Zacks wrote:
>
> On one hand the hole can't be plugged because as you mentioned that is the
> point of the function. On the other hand, if the function is not being run
> as security definer, the account running it would need to have the rights to
> do whatever
14 matches
Mail list logo
