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
> f
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
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
> 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 wit
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
http://hotjobs.sweepstakes.yahoo.com
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 * from
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
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
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 o
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 so
> -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
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
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 bro
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.
>
>
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 t
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 beli
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
-
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 define
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).
>
>
[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 t
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 hav
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 sugg
-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 se
* [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
signature.
> -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 ot
> "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>
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
e
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 DAYS''::interv
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
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 vacuumd
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 broadcast)
> -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,
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 user
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
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 program
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
Has anyone had success loading the Postgres JDBC drivers
into WSAD ?
Whenever I attempt a connection I receive the following error:
Jeffrey
Stonebrook
<>
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 pg_la
38 matches
Mail list logo
