Lonni Friedman [EMAIL PROTECTED] writes:
All of a sudden last month (after about 3 years) I started getting
this warning when vacuumdb was run:
INFO: Index pg_largeobject_loid_pn_index: Pages 903; Tuples 323847:
Deleted 0.CPU 0.04s/0.07u sec elapsed 0.10 sec.
WARNING: Index
Has anyone had success loading the Postgres JDBC drivers
into WSAD ?
Whenever I attempt a connection I receive the following error:
Jeffrey
Stonebrook
attachment: image001.jpg
Mike McGavin [EMAIL PROTECTED] writes:
It also occurs to me that an even more useful utility might be one
that stores the structural state of the database at a particular time
(such as when I last updated the production server), and then generate
a diff of SQL statements to update it to the
Hello,
I've read when using embedded sql with an Oracle database, it's faster
than other methods of database interaction, due to the way it
interacts with the Oracle DB.
I've been trying to find out if this is the case for postgres as well.
I'm talking specifically about the parts of the
Hello,
I searched all through Google Groups, Google, and the Postgres docs, but
to no avail. I hope someone can help me out here!
I have a file that contains SQL, and some Postgres-specific slash commands.
This file calls an external shell script via the backtick mechanism, and
saves the value
I would like to set up a zope/database interface (using Postgres 7.4) with
the following properties:
- multiple users each with their own id and password - accessed via zope
- they will enter and access their own data via zope to Postgresql
- any specific user will not be able to see another
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin
Sent: 4. maí 2004 17:18
To: [EMAIL PROTECTED]
Subject: [GENERAL] Embedded SQL inherently faster than others?
Hello,
I've read when using embedded sql with an Oracle database,
it's
How can i get a list of all types that dont have the _before them. I
only want a list of the types that a user might need to create tables.
thanks!
--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(819) 432-3443
---(end of
Lonni Friedman [EMAIL PROTECTED] writes:
Unfortunately, i have no clue how to replicate this. It was happening
fairly consistantly before i upgraded from 7.3.3 to 7.3.4 (like nearly
every vacuumdb run).
Then nothing for a month after going to 7.3.4, and now its happening
every vacuumdb run
On Apr 29, 2004, at 9:22 AM, Yannick LOUVET wrote:
hello,
i want to call a function (function1() for example )in an other
function.
simple,i guess :
PERFORM function1() ;
You will want to use EXECUTE instead (assuming var_function is a text
variable):
EXECUTE var_function;
You may need to
Sumita Biswas wrote:
Hi Experts,
I try to write the following in my Function and it works:
ld_FromDateTemp := ld_FromDate + ''5 DAYS''::interval;
But when I have to pass a parameter in the NUMBER of days(instead of 5)
like 'li_NoOfDays'
ld_FromDateTemp := ld_FromDate + ''li_NoOfDays
Its _always_ that same index. No others have had this problem.
Unfortunately, i have no clue how to replicate this. It was happening
fairly consistantly before i upgraded from 7.3.3 to 7.3.4 (like nearly
every vacuumdb run).
Then nothing for a month after going to 7.3.4, and now its happening
GSM == Greg Sabino Mullane [EMAIL PROTECTED] writes:
I use perl scripts to import data into my db. When errors occurred
uploading files in Pg ver 7.3.x, $DBI::errstr used to return a row number
from the input file. I could then go to the file make whatever changes and
GSM 1.32 is the
-Original Message-
From: Kevin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 10:18 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Embedded SQL inherently faster than others?
Hello,
I've read when using embedded sql with an Oracle database,
it's faster than other
* [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
DB2, as far as I know, uses some precompiled SQL files which may make a
difference if used or not used.
Is it much of one if you're using prepared statements? I guess it
depends on how many different queries you do.
Stephen
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bastian,
die liste [EMAIL PROTECTED] is 99% in englisch. Deine Anfrage hat
wesentlich mehr Aussicht auf Erfolg wenn die sie in englisch stellst.
Zum Problem: kannst du die Datensätze nicht eindeutig identifizieren ? Um
erfolgreich einen Lock zu
Lonni Friedman [EMAIL PROTECTED] writes:
On Wed, 05 May 2004 12:31:21 -0400, Tom Lane [EMAIL PROTECTED] wrote:
Once the complaint starts appearing, I'd expect it to continue until you
reindex the index.
That's exactly what happens. It consistantly errors until reindexed.
Any suggestions?
On Fri, 30 Apr 2004, CS Wagner wrote:
I assume this issue has been solved repeatedly, but I cannot find any
information on it...
I have a website that runs reports on data from a postgres database. An
average report takes about 10 minutes. I'd like to load balance it so I
can have
[EMAIL PROTECTED] (Razvan Surdulescu) writes:
cspan= update contact set gender = 'M';
ERROR: cache lookup failed for function 70529
If I re-run the update, I get:
cspan= update contact set gender = 'M';
server closed the connection unexpectedly
Hm, could we see the full schema for the
On Wed, 05 May 2004 12:31:21 -0400, Tom Lane [EMAIL PROTECTED] wrote:
Lonni Friedman [EMAIL PROTECTED] writes:
Unfortunately, i have no clue how to replicate this. It was happening
fairly consistantly before i upgraded from 7.3.3 to 7.3.4 (like nearly
every vacuumdb run).
Then
Hi.
I've got a problem with using cursor in a plpgsql function. Cursor is created
via DECLARE, it's SELECT query has placeholders. I use PostgreSQL 7.4.2.
Here's a problematic plpgsql function:
create or replace function add_messages_to_folder(integer,refcursor) returns
integer security
Manfred Koizar [EMAIL PROTECTED] writes:
Vik, I guess that on your platform time_t is smaller than long.
Ok, this is pretty clear now. Apply this patch and recompile Postgres.
Yup, that's a gotcha. Patch applied to 7.4 and HEAD branches.
regards, tom lane
Manfred Koizar [EMAIL PROTECTED] writes:
I had planned to send a -c diff to -patches, as soon as I have a
suitable regression test.
Like what? The existing stats test seems to catch this just fine on
machines where the types are actually different sizes. In any case,
I don't necessary believe
Hello,
I am not personally a java fiend but it looks like you are trying to use
the PostgreSQL JDBC driver with SSL. I am unsure if that is possible
with the community version. At least it didn't used to be.
Sincerely,
Joshua D. Drake
Stonebrook, Jeff wrote:
--
Has anyone had success loading
On Wed, 05 May 2004 13:56:41 -0400, Tom Lane [EMAIL PROTECTED] wrote:
Lonni Friedman [EMAIL PROTECTED] writes:
On Wed, 05 May 2004 12:31:21 -0400, Tom Lane [EMAIL PROTECTED] wrote:
Once the complaint starts appearing, I'd expect it to continue until you
reindex the index.
That's exactly
Lonni Friedman [EMAIL PROTECTED] writes:
hrmmm, i'm not sure what would constitute 'off the beaten track'.
Neither am I ... if we knew what you were doing that triggers the bug,
we'd already be halfway there :-(
regards, tom lane
---(end of
On Mon, 3 May 2004, Stonebrook, Jeff wrote:
Has anyone had success loading the Postgres JDBC drivers into WSAD ?
Whenever I attempt a connection I receive the following error:
[Reason: Problems encountered while loading the jdbc driver.
Reason: javax.net.ssl.SSLSocket
]
Please do not
-Original Message-
From: Rob [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 12:25 PM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Embedded SQL inherently faster than others?
Dann Corbit snip:
-Original Message-
From: Kevin [mailto:[EMAIL PROTECTED]
Sent:
Dann Corbit snip:
-Original Message-
From: Kevin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 10:18 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Embedded SQL inherently faster than others?
Hello,
I'm looking for absolute maximum database result speed and if
that means writing
On Wed, 05 May 2004 13:30:19 -0400, Tom Lane [EMAIL PROTECTED] wrote:
Yup, that's a gotcha. Patch applied to 7.4 and HEAD branches.
Hey, that was a -r diff. It was not intended for you :-)
I had planned to send a -c diff to -patches, as soon as I have a
suitable regression test. I thought of
On Wed, May 05, 2004 at 03:17:02PM +, Sally Sally wrote:
Does anyone know of a good way of implementing postgres real-time
mirroring? Whether it's a program that's already out there or whether it is
something that can be done by the DBA? I know there is one in contrib
called dbmirror
Sorry for the newbie question, but how do you get PostgreSQL to list
the available databases? I know how to log into a certain database, but
not list all of them. I know this must be possible because the
phppgAdmin web site demonstrates it with their trial server.
Thanks,
Doug Hall
Doug Hall wrote:
Sorry for the newbie question, but how do you get PostgreSQL to list the
available databases? I know how to log into a certain database, but not
list all of them. I know this must be possible because the phppgAdmin
web site demonstrates it with their trial server.
select *
I heard that the sql standard for escaping quotes is
'', and not \'. Is this true?
BTW, PHP's pg_escape_string returns \' and not ''.
__
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
Sorry for the newbie question, but how do you get PostgreSQL to list
the available databases? I know how to log into a certain database, but
not list all of them. I know this must be possible because the
phppgAdmin web site demonstrates it with their trial server.
Use the \l command within
If you attach with psql then just use \l
Or this works as well
SELECT datname from pg_database;
Sorry for the newbie question, but how do you get PostgreSQL to list
the available databases? I know how to log into a certain database, but
not list all of them. I know this must be possible
Doug Hall wrote:
Sorry for the newbie question, but how do you get PostgreSQL to list the
available databases? I know how to log into a certain database, but not
list all of them. I know this must be possible because the phppgAdmin
web site demonstrates it with their trial server.
Thanks,
Doug
Igor Shevchenko [EMAIL PROTECTED] writes:
-- all other queries are sent using PQsendQueryParams
-- the bound parameter for $1 is sent with this query
declare search_messages_cursor no scroll cursor for select
folder_msg.message_id from folder_msg where folder_msg.folder_id=7866 and
38 matches
Mail list logo