Re: [GENERAL] Class dependencies

2011-01-10 Thread Jasen Betts
On 2011-01-10, Joel Jacobson j...@gluefinance.com wrote: Hi, Is it safe to assume all objects of a given class can be dropped/created, provided all objects of a list of other classes have already been dropped/created? I'm looking at

Re: [GENERAL] Class dependencies

2011-01-10 Thread Tom Lane
Jasen Betts ja...@xnet.co.nz writes: On 2011-01-10, Joel Jacobson j...@gluefinance.com wrote: Is it safe to assume all objects of a given class can be dropped/created, provided all objects of a list of other classes have already been dropped/created? For instance, is it correct to assume

Re: [GENERAL] Realtime Query Dashboard Results

2011-01-10 Thread Vick Khera
On Fri, Jan 7, 2011 at 5:21 PM, Oliver Kohll - Mailing Lists oliver.li...@gtwm.co.uk wrote: Charts are updated once a day overnight, or cached whenever someone looks at them in the system underlying the dashboard, so they are at most one day old. A chart is also updated when a user clicks on

Re: [GENERAL] Remote Connection

2011-01-10 Thread Bill Moran
In response to Bob Pawley rjpaw...@shaw.ca: Hi I am attempting to connect from two local interfaces to a remote database. With one interface (SharpMap developed in C#) I have no problems. With the other interface (Delphi) I have no problem connecting in design mode. However when I

[GENERAL] Para participantes extranjeros en el Tercer PGDay Latinoamericano.

2011-01-10 Thread Ing. Yunior Mesa Reyes
IMPORTANTE!!!: Para participantes extranjeros en el Tercer PGDay Latinoamericano, a desarrollarse en la Universidad de las Ciencias Informáticas, La Habana, en febrero del 2011 . Estimados, luego de realizar todas las coordinaciones previas le relacionamos la información referente

[GENERAL] migrate hashname function from 8.1.x to 8.4

2011-01-10 Thread Nicolas Garfinkiel
Hi all, I'm trying to upgrade our pgsql from 8.1 to 8.4, but our system's login uses the hashname() function in order to get the proper password validation. Now pgsql's 8.4 hashname function is not compatible with 8.1's function. Do you have any ideas how I can reproduce 8.1 function in 8.4?

Re: [GENERAL] Remote Connection

2011-01-10 Thread Bob Pawley
Hi Bill Thanks for answering. The problem turned out to be the excessive permissions required in Windows 7 Firewall. It appears to be working now. Bob -Original Message- From: Bill Moran Sent: Monday, January 10, 2011 5:55 AM To: Bob Pawley Cc: Postgresql Subject: Re: [GENERAL]

Re: [GENERAL] Unable to write inside TEMP environment variable path

2011-01-10 Thread ilpirata
PostgreSQL 8.3, 8.4 and 9.0 install on Windows seem to be failing for the same reason (at least in my experience), but with different error messages For 8.3 and 8.4 the error is An error occurred executing the Microsoft VC++ runtime installer whereas for 9.0 the error is Unable to write inside

[GENERAL] How to add template tokens to default fulltextsearch parser

2011-01-10 Thread Ferdinand Smit
Hi, We use replace strings in our text, but i do not want to match them. There is a predefined token for XML/HTML, but i was wondering if there is an easy solution to add templates tokens like %[something]% to the fulltextsearch parser. Regards, Ferdinand -- Sent via pgsql-general mailing

Re: [GENERAL] migrate hashname function from 8.1.x to 8.4

2011-01-10 Thread Craig Ringer
On 01/11/2011 02:09 AM, Nicolas Garfinkiel wrote: Hi all, I’m trying to upgrade our pgsql from 8.1 to 8.4, but our system’s login uses the hashname() function in order to get the proper password validation. Now pgsql’s 8.4 hashname function is not compatible with 8.1’s function. Do you have any

[GENERAL] Using aclitem[] at application layer

2011-01-10 Thread A.M.
Hello, In an attempt to implement ACLs at the application layer (for resources stored outside of the database), I am evaluating using aclitem[] as a column type. All the functions I would need seem to be in place: aclcontains, aclexplode, aclinsert, aclitemeq, aclitemin, aclitemout, aclremove,

Re: [GENERAL] Using aclitem[] at application layer

2011-01-10 Thread Tom Lane
A.M. age...@themactionfaction.com writes: In an attempt to implement ACLs at the application layer (for resources stored outside of the database), I am evaluating using aclitem[] as a column type. All the functions I would need seem to be in place: aclcontains, aclexplode, aclinsert,

Re: [GENERAL] migrate hashname function from 8.1.x to 8.4

2011-01-10 Thread nicolas . garfinkiel
Hi Craig, Thank you for your reply! well, what i mean is that hashname() function would return a different value depending the pgsql version. Consider this query (note that i'm using some extra implicit cast functions here): SELECT password FROM user WHERE password = hashname('AZALEA') UNION

[GENERAL] database is growing... 1GB per day basis

2011-01-10 Thread Karayappalli, Raghunath (Raghu)
Hello, my name is raghu. I work for Avaya. We uses postgres as database in our application. Our application is a jboss based enterprise application, that does some updates operations based on requests from client. We use entities and hibernate for data access within our application. I have