Hello List,
I'm writing a program to be run on WinCE. Are there dll's for wince
client (pglib.dll and others)?
--
Julius Tuskenis
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have found via cmd prompt. My Computer (GUI) is not showing the path and file
(pgpass.conf). However, the size of this file is 0kb i.e. nothing is written in
this file.
- Forwarded Message
From: Abdul Rahman <[EMAIL PROTECTED]>
To: Vishal Arora <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
Tom Lane wrote:
Scara Maccai <[EMAIL PROTECTED]> writes:
-> Index Scan using id_idx on tab1 (cost=0.00..8.27 rows=1
width=4) (actual time=0.010..0.011 rows=1 loops=1)
Index Cond: (id = 10)
-> Index Scan using out_id_idx on tab_outer (cost=0.00..8.83
rows
I searched but didn't find any pgpass.conf file.
From: Vishal Arora <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 27, 2008 5:27:26 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT runni
Hi everyone,
In pg 8.2 to 8.3 transition there is a new behavior: Non-character data
types are no longer automatically cast to TEXT
I understand the reasons, however while we manage to migrate the our
system, is there a way to get back this behavior? I searched the
internet and the mailing lists b
Qiang, you can do this for yourself. At the bottom of every email sent
to the list are instructions for modifying your subscription, including
unsubscribing. I'll copy and paste them for you here:
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Qiang wr
thank you!
[EMAIL PROTECTED] (Ioana Danes) writes:
> I've been wondering if anybody tried to use the postgresql csv log
> file to replicate sql statements. I've been looking into it in the
> past days and after a brief testing it doesn't look bad at all...
It's *plausible*, but you have to ensure that you *
On 27/11/2008 23:09, Bill Todd wrote:
> Raymond O'Donnell wrote:
>> You could write a pl/pgsql function which constructs the query as a
>> string and then runs it with EXECUTE.
>>
> According to the PostgreSQL help file EXECUTE is used to execute a
> prepared statement. I tried that but when I
Raymond O'Donnell wrote:
On 27/11/2008 20:52, Bill Todd wrote:
Substituting the input parameter for the literal path does not work and
neither does using PREPARE/EXECUTE. How can I pass the file path as a
parameter?
You could write a pl/pgsql function which constructs the query as a
s
Raymond O'Donnell wrote:
On 27/11/2008 20:52, Bill Todd wrote:
Substituting the input parameter for the literal path does not work and
neither does using PREPARE/EXECUTE. How can I pass the file path as a
parameter?
You could write a pl/pgsql function which constructs the query as a
s
Scara Maccai <[EMAIL PROTECTED]> writes:
> Aggregate (cost=31.91..31.92 rows=1 width=4) (actual
> time=14.185..14.185 rows=1 loops=1)
> -> Nested Loop Left Join (cost=0.00..17.11 rows=2959 width=4)
> (actual time=8.608..13.400 rows=2953 loops=1)
> -> Index Scan using id_idx on
"Andrus" <[EMAIL PROTECTED]> writes:
> Server logs files contain a lot of messages
> Expected password response, got message type 88
> This occurs when user tries to log-in but login fails for strange reason.
> User must enter password several times to log-in to application.
> What causes this me
On 27/11/2008 20:52, Bill Todd wrote:
> Substituting the input parameter for the literal path does not work and
> neither does using PREPARE/EXECUTE. How can I pass the file path as a
> parameter?
You could write a pl/pgsql function which constructs the query as a
string and then runs it with EXE
I want to execute the following COPY command in a stored procedure,
however, I need to pass the path to the file as an input parameter.
Substituting the input parameter for the literal path does not work and
neither does using PREPARE/EXECUTE. How can I pass the file path as a
parameter?
cop
Server logs files contain a lot of messages
Expected password response, got message type 88
This occurs when user tries to log-in but login fails for strange reason.
User must enter password several times to log-in to application.
What causes this message ?
I'm using ODBC driver from windows cl
Hey,
I am struggling a bit here with a query, that I would like to rewrite to use
window functions, if they ever get to 8.4 (and I hope they will).
But since I never used them before, I have trouble even figuring out how to
approach it.
a table:
Table "public.sta
Then you might wanna look at slony. We use it and it's quite stable
and reliable, and if the slave can't keep up it's no big deal to the
master.
On Thu, Nov 27, 2008 at 11:33 AM, Ioana Danes <[EMAIL PROTECTED]> wrote:
> Thanks for the tip Scott but am looking for an asynchronous replication that
Thanks for the tip Scott but am looking for an asynchronous replication that
does not interfere with the performance of the application. Also I don't
necessary need the latest changes to be applied right away. Even a day
difference is enough...
Thanks a lot,
Ioana
--- On Thu, 11/27/08, Scott
I have statements in db upgrade script like
ALTER TABLE mytbl ALTER mycol TYPE CHAR(240)
This takes 80 seconds if table contains 9000 rows even if mycol type is
already 240 characters.
How to check in sql or in pgsql and run this statement only of mycol width
is not 240 characters ?
Andrus
If you want the same thing in real time look into pgpool II
On Thu, Nov 27, 2008 at 10:28 AM, Ioana Danes <[EMAIL PROTECTED]> wrote:
> I know there are some limitations abut it:
> - copy statements cannot be executed,
> - the use of now() function
> - even database restore scripts I don't want to
I know there are some limitations abut it:
- copy statements cannot be executed,
- the use of now() function
- even database restore scripts I don't want to be replicated
but these are not a problem for me because I don't use them in the
application...
--- On Thu, 11/27/08, Csaba Nagy <[EMAI
On Thu, 2008-11-27 at 09:20 -0800, Ioana Danes wrote:
> I've been wondering if anybody tried to use the postgresql csv log file to
> replicate sql statements.
> I've been looking into it in the past days and after a brief testing it
> doesn't look bad at all...
Try to execute something like:
UP
Hi Everyone,
I've been wondering if anybody tried to use the postgresql csv log file to
replicate sql statements.
I've been looking into it in the past days and after a brief testing it doesn't
look bad at all...
Thanks,
Ioana
__
Query is:
"explain analyze select sum(A), count(*) from tab1 left outer join
tab_outer on id=out_id where id=10;"
output:
Aggregate (cost=31.91..31.92 rows=1 width=4) (actual
time=14.185..14.185 rows=1 loops=1)
-> Nested Loop Left Join (cost=0.00..17.11 rows=2959 width=4)
(actual ti
Well in that case you need to check if you have relevant entries in pgpass.conf
file.
Date: Wed, 26 Nov 2008 23:43:25 -0800From: [EMAIL PROTECTED]: Re: [ADMIN]
PgAgent Job Scehduler is NOT runningTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]:
pgsql-general@postgresql.org
Thanks Vishal,I followe
On 2008-11-17 23:26, Blazej wrote:
CREATE TABLESPACE ram_space LOCATION '/mnt/ram0/pgspace';
And then:
CREATE TABLE (...) TABLESPACE ram_space;
and table is in memory.
And when your server will loose power or hang now then your database
will not start after reboot.
I'd rather start a new, t
27 matches
Mail list logo