Hi,
Has anyone tried to install Postgres on Windows Sever 2003 version R2? R2 is actually shipping as a 'new' Microsoft product- it's basically an interim update to Windows Server (
http://www.microsoft.com/windowsserver2003/r2/whatsnewinr2.mspx).
I've installed Postgres on other versions of W
On Sat, 2006-01-07 at 20:38 +, Marcos José Setim wrote:
> I want to use the Prepare and Execute resources of PostgreSQL to
> increment the performance of my SQL's.
> $sSQL = 'INSERT INTO teste (nome) VALUES( ? )';
>
> $oDB->Prepare( $sSQL );
The PREPARE documentation states:[1]
Prep
On Sun, 2006-01-08 at 00:12 +, Marcos José Setim wrote:
> I'd like that create functions in plpgsql with prepared SQL and plan
> saved, to that the Postgresl increase the performance of executions.
>
> This is possible?
plpgsql internally caches query plans the first time a function is
invoke
Hi All,
I am quite confused (PLEASE PLEASE Help), I cannot find anything on
the web). I read that you can declare a class that implements SQLData
(in this case I set up a class called Complex from the /src/tutorial
datatype that mimics the user-defined datatype in the db) and then set
the mapping
Hi,
I'd like that create functions in plpgsql with prepared SQL and plan
saved, to that the Postgresl increase the performance of executions.
This is possible?
I would like to see a simple example of use this, if this is possible, i
find for examples in the google, but the joined result is littl
Carlos Moreno wrote:
> Any comments? If it is the first option above, then it feels like
> by definition there is absolutely nothing that can be done, now or
> ever :-(
I got an IMAP account with BurntMail.com. I belong to a dozen mailing
lists, and haven't received any spam since getting th
Dave Steinberg <[EMAIL PROTECTED]> writes:
>> You're not using the same PG connection from two different threads, or
>> fork()ing and trying to use the same connection in the parent and the
>> child, or anything like that?
>
> Aha! In the ruby code, I am forking! I'll make the child reconnect
>
You're not using the same PG connection from two different threads, or
fork()ing and trying to use the same connection in the parent and the
child, or anything like that?
Aha! In the ruby code, I am forking! I'll make the child reconnect and
see if that helps (I am almost sure this will fix i
Carlos Moreno wrote:
> today I notice a phishing e-mail ("Your PayPal account"), meaning
> that it took less than two weeks for my e-mail address to go from
> PG's mailing list to a spammers' database of addresses...
Normally you get turnaround times of less than two hours on this, so you
got a
Ok thanks AndreasOn 1/7/06, Andreas Kretschmer <[EMAIL PROTECTED]> wrote:
Angshu Kar <[EMAIL PROTECTED]> schrieb:> Thanks Andreas. But how can I run this from the pgAdmin III Query tool in a> WinXP m/c?Sorry, i don't using pgAdmin nor windows...
I mean, use the CLI-Interface psql.Andreas--Really, I
Magnus Hagander wrote:
> archives.postgresql.org properly "hides" the addresses.
If you think that spammers are unable to do s/ (at) /@/ you're living in
a dream world.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Angshu Kar <[EMAIL PROTECTED]> schrieb:
> Thanks Andreas. But how can I run this from the pgAdmin III Query tool in a
> WinXP m/c?
Sorry, i don't using pgAdmin nor windows...
I mean, use the CLI-Interface psql.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
Dave Steinberg <[EMAIL PROTECTED]> writes:
>>>My biggest problem is the lack of any real error message on the server.
>>>I don't see anything wrong in the system logs, and there's no core
>>> file in the /var/postgresql directory.
>> Are you sure core files are enabled; i.e. the server is runn
Hi,
I want to use the Prepare and Execute resources of PostgreSQL to
increment the performance of my SQL's.
I do tests using the PHP and ADODB inserting 5000 registers and
counting the time of execution. But the results was pratically
identical.
See below the results:
Time of Execution (ADODB
Hi Pgsql,Could anyone please advise whether the following program can be implemented using pgsql cursors/anythign else (or do we need some external scripts)?If yes, could you give please some function names etc?
select A from Bcluster where pvalue = 0.3--say we get A=8
select B, A_child from CClust
My biggest problem is the lack of any real error message on the server.
I don't see anything wrong in the system logs, and there's no core
file in the /var/postgresql directory.
Are you sure core files are enabled; i.e. the server is running with
'ulimit -c unlimited' ?
Yes:
$ whoami
_po
Thanks Andreas. But how can I run this from the pgAdmin III Query tool in a WinXP m/c?On 1/7/06, A. Kretschmer <
[EMAIL PROTECTED]> wrote:am 07.01.2006, um 14:13:28 -0600 mailte Angshu Kar folgendes:
> Hi Pgsql,>> I want to copy the output of a SELECT query onto a text file. I'm trying to> use the
Dave Steinberg <[EMAIL PROTECTED]> writes:
> My biggest problem is the lack of any real error message on the server.
> I don't see anything wrong in the system logs, and there's no core
> file in the /var/postgresql directory.
Are you sure core files are enabled; i.e. the server is running w
Hello list,
I've been working a bit today to resolve the error I'm seeing mentioned
in the title, and I was hoping you might have some insight. I've
managed to semi-reliably reproduce this based on two different tasks:
- a pg_dumpall from my backup server will throw this, but not always on
the
am 07.01.2006, um 14:13:28 -0600 mailte Angshu Kar folgendes:
> Hi Pgsql,
>
> I want to copy the output of a SELECT query onto a text file. I'm trying to
> use the COPY command for that as :
>
> COPY (SELECT ) to 'outfile'
Wrong.
\o output.txt
select ...
\o
And now you have the result in
Christopher Browne <[EMAIL PROTECTED]> writes:
>> A recent article about an Oracle worm:
>> http://www.eweek.com/article2/0,1895,1880648,00.asp
>> got me wondering.
> PostgreSQL doesn't allow network access, by default, which more than
> makes up for that.
You would have to both alter postgresql.
Hi Pgsql,I want to copy the output of a SELECT query onto a text file. I'm trying to use the COPY command for that as :COPY (SELECT ) to 'outfile'But its throwing some error. Is it possible? Else, are there any means to do it?
Thanks,AK-- Ignore the impossible but honor it ...The only enviable
On Thursday 05 January 2006 17:04, Russ Brown wrote:
> On Thu, 5 Jan 2006 22:25:21 +0100
>
> Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> > Am Donnerstag, 5. Januar 2006 21:58 schrieb Scott Marlowe:
> > > But it's not consistent. Imagine we do the one where we take one
> > > from peter and give i
You should be able to do this now using pg_depend, it would just take a bit of
leg-work. Pretty sure it would be easier than solving physical/logical
attribute separation. Someone writing a pg_list_all_dependencies function
would make for a really good head start... I wonder if the newsysviews
I created an account for perl-cpan and it got hit with spam/phishing attempts in less than a week.
There's not a lot that can be done about it. It's a losing battle to try and fight. There are some things you can do, but it won't be 100% effective. The closer you get to 100% effective, the mor
> A recent article about an Oracle worm:
> http://www.eweek.com/article2/0,1895,1880648,00.asp
> got me wondering.
> Could a worm like this infect a PostgreSQL installation?
> It seems to depend on default usernames and passwords -
> and lazy DBAs, IMO.
> Isn't it true that PostgreSQL doesn't have
What does your code look like? And have you tried using Npgsql instead of
the ODBC driver?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Saturday, January 07, 2006 4:39 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] The c
> A recent article about an Oracle worm:
> http://www.eweek.com/article2/0,1895,1880648,00.asp
> got me wondering.
> Could a worm like this infect a PostgreSQL installation?
> It seems to depend on default usernames and passwords - and
> lazy DBAs, IMO.
> Isn't it true that PostgreSQL doesn't have
A recent article about an Oracle worm:
http://www.eweek.com/article2/0,1895,1880648,00.asp
got me wondering.
Could a worm like this infect a PostgreSQL installation?
It seems to depend on default usernames and passwords -
and lazy DBAs, IMO.
Isn't it true that PostgreSQL doesn't have any default u
Bruce Momjian writes:
> Carlos Moreno wrote:
>> Any comments? If it is the first option above, then it feels like
>> by definition there is absolutely nothing that can be done, now
>> or ever :-(
> Yes, I came to that conclusion long ago.
Aggressive spam filtering is about the only thing that
"Craig" <[EMAIL PROTECTED]> writes:
> I am trying to prevent anyone that inhertis from role1 to not be able to =
> select from any database table, unless they execute a function that I =
> have provided. How do I setup the security for this?=20
You need to mark the function as SECURITY DEFINER, wh
> > This is truly worrisome... I wonder if spammers today are
> basically
> > subscribing to mailing lists so that they receive the
> e-mails (seems
> > like a very obvious trick), or if they're moving to the
> next level of
> > "decrypting" the "encrypted / anti-spam" form of e-mail
> addr
Carlos Moreno wrote:
>
> This is worrisome...
>
> I decided to create a separate account for my subscription to PG's
> mailing lists (to avoid all replies bouncing back due to my strict
> whitelist anti-spam filter) -- I created the account on Dec 22, and
> today I notice a phishing e-mail ("You
This is worrisome...
I decided to create a separate account for my subscription to PG's
mailing lists (to avoid all replies bouncing back due to my strict
whitelist anti-spam filter) -- I created the account on Dec 22, and
today I notice a phishing e-mail ("Your PayPal account"), meaning
that i
Hi.
I have a problem - I run pl/sql script on postgresql base using command line in
windows and I need to view some data in this command line, but I don't know how
to send them in the script.Pleas help
---(end of broadcast)---
TIP 1: if posting/rea
Hi
I am trying to understand how permissions work with
plpgsql functions.
I have created a role (lets call it role1) and
assigned EXECUTE to a function (lets call it func_1). In func_1, I select
data from tableA.
I have then created another role (role2) that
inherits from role1.
When I l
Hi,
I'm running PostgreSQL 8.1.1 on the WindowsXP box with following
information:
1. Programming Language C# MS .NET Framework
2. ADO NET connection through PostgresODBC
3. Using "Connection.BeginTransaction(IsolationLevel.ReadCommitted) and
Transaction.Commit to update database.
4. Update record
37 matches
Mail list logo
