[GENERAL] column size in libpq

[Piotr Filipczuk]

How to determinate column size in query in libpq? Especially when column 
is declared for exapmle as varchar(64).  PQfsize return -1 which mean 
that is variable and PQfmod returns 68.

Piotr Filipczuk
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] beta3 winxp initdb problems

[Piotr Filipczuk]

Hi.
I understand that you are using NOD32 software. To correct install 
postgres you must first uninstall IMON from NOD32.
IMON is som how intgerete with windows socket and somehow brake 
communication with postgresql database.

Piotr Filipczuk
BARTKO, Zoltn wrote:
Hello, folks,
I am trying to install pgsql8 on winxp. I tried first to install as
is with pginstaller beta2-dev3, no luck, it froze, switched off
Nod32, froze a little later, ran through the list of services,
switched off anything that seemed to be a firewall, no luck.
So I compiled beta3 with mingw, installed, and now initdb keeps
telling me this:
listing
Microsoft Windows XP [Verzia 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\WINDOWS\system32d:
snip/
D:\tmp\datainitdb
The files belonging to this database system will be owned by user
postgresql.
This user must also own the server process.
The database cluster will be initialized with locale Slovak_Slovakia.1250.
fixing permissions on existing directory d:/tmp/data ... ok
creating directory d:/tmp/data/global ... ok
creating directory d:/tmp/data/pg_xlog ... ok
creating directory d:/tmp/data/pg_xlog/archive_status ... ok
creating directory d:/tmp/data/pg_clog ... ok
creating directory d:/tmp/data/pg_subtrans ... ok
creating directory d:/tmp/data/base ... ok
creating directory d:/tmp/data/base/1 ... ok
creating directory d:/tmp/data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in d:/tmp/data/base/1 ... FATAL:  could
not select a
suitable default timezone
DETAIL:  It appears that your GMT time zone uses leap seconds.
PostgreSQL does n
ot support leap seconds.
child process was terminated by signal 1
initdb: failed
initdb: removing contents of data directory d:/tmp/data
D:\tmp\data
/listing
now, beta2 reported no problems with initdb, it just never finished
the installation and even if I tell my computer I am located in
London, UK, use Greenwich Mean Time, I still get this fatal error.
I have no idea what to do...
please, give me some advice.
Thanks in advance
Zoltan
== REKLAMA 
Spolocnost SUN Microsystems uviedla na trh novy server Sun Fire V20z
zalozeny procesoroch AMD Opteron.
Viac informacii najdete na : http://www.somi.sk/sun/v20z.php
===
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
 


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly

[GENERAL] Re: sort order problem

[Piotr Filipczuk]

On Sun, 18 Feb 2001 [EMAIL PROTECTED] wrote:

 hi!

 could somebody tell me where is the problem?

 i have postgres 7.0.3-4 comming with unstable debian distribution (locales 2.2.1-1, 
libc6 2.2.1-1)
 i am unable to force postgres to sort in correct order when I have national 
characters (polish)
 I tried differents locales settings (i thik that LANG=pl_PL, LC_CTYPE=iso_8859_2 
worked previously)
 on the backend side and from the clients side. the result is always the same.

Backend should be started with locale set (LC_ALL=pl_PL) and database
should be create with encoding LATIN2 (createdb -E LATIN2) and that's all.
I tried this with postgres 6.5.x and 7.0.x on RedHat 6.2 and RedHat 7.0.

Piotr Filipczuk
[EMAIL PROTECTED]