On Fri, Aug 26, 2005 at 10:59:50 -,
RAJU kumar <[EMAIL PROTECTED]> wrote:
>
>
> i want to find out the difference between the btree index and hash index and
> how exactly the hash index work.
Why? You probably don't want to use hash indexes as btrees are virtually
always better in th
i want to find out the difference between the btree index and hash index and how exactly the hash index work.
Hello there!
My app is using the charset ISO-8859-1 to write and
read data, using jdbc for PG 8.0, and it works fine. But when I try to read
and write these data using pgAdminIII, the accented characters are strange. Why
does it happen? Can I set pgAdmin charset?
Please, I need some light!
Adi Alurkar wrote:
Greetings,
There is no direct way to achieve what you want, the easiest hack is to
create a temp table with you query i.e.
create table tmp_foo as select col1, col4, col7 from table1, table2
where ;
copy table tmp_foo to [stdout|]
HTH
I ended up using pgadmin3 -
On Fri, Aug 26, 2005 at 02:27:04PM +0100, Aldor wrote:
> Aug 25 14:53:33 forgehouse-s1 postgres[23723]: [2-1] LOG: duration:
> > 1192.789 ms statement: UPDATE session SET hit_time=now() WHERE
> > md5='d84613009a95296fb511c2cb051ad618';
>
> > Aug 25 14:53:53 forgehouse-s1 postgres[23727]: [2-1] L
Aug 25 14:53:33 forgehouse-s1 postgres[23723]: [2-1] LOG: duration:
> 1192.789 ms statement: UPDATE session SET hit_time=now() WHERE
> md5='d84613009a95296fb511c2cb051ad618';
> Aug 25 14:53:53 forgehouse-s1 postgres[23727]: [2-1] LOG: duration:
> 12159.162 ms statement: UPDATE session SET hit
On Aug 26, 2005, at 3:57 AM, Bouchard Sylvie wrote:
I use Postgres 8.0.2, Windows 2000.
My batch file use pg_dump for backup my database. I specifie a
superuser for connecting to server.
How must I make to avoid putting the password in light in the order?
http://www.postgresql.org/docs/8.0
Hi all,
I was going through pg_resetxlog manual page.
and found the following line confusing.
"For example, if 00FF003A is the largest entry in pg_xlog, -l
0xFF,0x3B will work. " with respect to calculating the -l value for
pg_resetxlog .
please could someone explain this calculation in s
The version of Postgres is 7.4.
When I said the process had terminated abnormally - what I meant was a UNIX
process (C program) had opened a database connection, run some updates
without a COMMIT and then exited without closing the connection to the
database or committing the transactions.
F
On Thu, Aug 25, 2005 at 07:31:54PM -0400, Colin E. Freas wrote:
>
> In the Makefile for pgcrypto there's a cryptsrc variable you can set to
> 'builtin' or 'system'.
>
> Makefile only references the variable when it's set to 'builtin'... I
> can't figure out what it's supposed to do when set to
Hi,
I use Postgres
8.0.2, Windows 2000.
My batch file use
pg_dump for backup my database. I specifie a superuser for connecting to
server.
How must I make to
avoid putting the password in light in the order?
Thank's
Sylvie
11 matches
Mail list logo
