Hi,
I am using the npgsql postgres data adaptor in a C# ASP.NET application.
Each time the site establishes a new connection to the database a
postgres.exe process is started. For some reason this process is not
removed when the connection is closed.
Any help would be greatly appreciated.
Thank
On 15/08/2008 11:08, Fuzzygoth wrote:
but I need to be able to delete from up to 5 different tables, is
there a quick and
simple way of doing this? can someone post an example?
Just guessing without more detailed information, but are the tables
related one-to-many using foreign keys? If so, w
Hello.
Is there any open source and well-tested PHP libraries to parse and build
the following PostgreSQL data types?
- arrays (including N-dimensional): {a,b,c}
- hstore: "a=>b, c=>d"
- ROW: ("a","b","(""c"",""d"")")
E.g. I have some PHP variable and want to build corresponding PostgreSQL
value
Thanks. You suggestion helped me to find a solution!
DECLARE
...
query text;
BEGIN
query := query :='SET SESSION ROLE ' || wishedrole;
EXECUTE query;
..
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
Mark wrote:
On Thu, 2008-08-14 at 16:20 -0700, Roderick A. Anderson wrote:
Anyone aware of an ER model for holding name server records?
Working on the zone file data and I am getting close but keep running
into the differences between MX records (with a priority) and the others
that can hold
Just a suggestion:
EXECUTE 'SET SESSION ROLE wishedrole';
won't help?
2008/8/17 Oleg Vasylenko <[EMAIL PROTECTED]>
> Hi,everybody!
>
> I wish to have a function with code above, but compiller generate
> syntactic error at the line "SET SESSION ROLE wishedrole;".
>
> How to pass the wishedrole
On Thu, 2008-08-14 at 16:20 -0700, Roderick A. Anderson wrote:
> Anyone aware of an ER model for holding name server records?
>
> Working on the zone file data and I am getting close but keep running
> into the differences between MX records (with a priority) and the others
> that can hold eithe
Hi,everybody!
I wish to have a function with code above, but compiller generate
syntactic error at the line "SET SESSION ROLE wishedrole;".
How to pass the wishedrole value to the structure?
CREATE OR REPLACE FUNCTION f_switch_role(INOUT text,INOUT boolean) AS
$BODY$
DECLARE
wishedrole ALIA
You may use something like this in a stored function:
DECLARE
a INTEGER[];
BEGIN
a := '{2341548, 2325251, 2333130, 2015421,2073536, 2252374, 2273219,
2350850, 2367318, 2032977, 2032849}';
select * from users where id = any(a) order by idx(a, id);
END;
Or in the plain SQL:
select
On Wed, 13 Aug 2008 16:32:18 -0500
ries van Twisk <[EMAIL PROTECTED]> wrote:
> On Aug 13, 2008, at 4:25 PM, Ivan Sergio Borgonovo wrote:
> > I need to write an import function with enough isolation from
> > apache daemon.
> > Code has no input other than cvs files and a signal about when to
> > st
Stefan Berglund wrote on 16.08.2008 08:30:
[...]
>
First I install 8.3.1 using this command line:
> [...]
Next I do (after a reboot because the service name, service user, super
user, and super password are not known until after the reboot) an
install of version 8.3.3 using the following comm
Hi,
I am trying to delete a set of related record across the whole
database, In tests I
have managed to delete records from 2 tables using the code below.
DELETE FROM phillipsd.tablea using phillipsd.tableb WHERE tablea.one =
2;
but I need to be able to delete from up to 5 different tables, is
th
Wow, very good to know. That was driving me crazy.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm not sure if I've violated some rule or the installation is just not
working the way I'm thinking it should work.
This is a Windows XP Professional Service Pack 2 install. Yes, I know
it sucks but until I get my app rewritten in Qt it will have to do and
even after that point I will still need
On Sun, 17 Aug 2008, Amber wrote:
what I am wondering is how multiple agent process share page caches.
The database allocates a block of shared memory (sized by the
shared_buffers parameter) that all the client processes share for caching
pages.
--
* Greg Smith [EMAIL PROTECTED] http://www
>> 7. How many concurrent readers of your database, and what's the average
>> transfer rate, suppose all readers are doing one table scaning.
>
> Concurrent but idle connections in production are around 600. Active
> connections at a time are in the dozens. I can read at about 60 to 70
> Megs a
16 matches
Mail list logo
