[GENERAL] Another PostgreSQL Diff Tool 2.4 released!

: http://apgdiff.startnet.biz/faq.php If you still have issues with running apgdiff, you can email me at apgd...@startnet.biz If you find any issue with apgdiff or you miss a feature, you can file an issue at https://github.com/fordfrog/apgdiff/issues Best regards. Miroslav Šulc Another PostgreSQL

[GENERAL] VACUUM FULL cannot be VERBOSE?

hi, is it correct behavior that when i issue command "VACUUM VERBOSE", i get output with DETAIL info, but when i issue "VACUUM FULL VERBOSE", no details are displayed? here are some samples: VACUUM VERBOSE; INFO: vacuuming "pg_catalog.pg_type" INFO: scanned index "pg_type_oid_index" to remove

[GENERAL] Another PostgreSQL Diff Tool 2.3 released

apgdiff.startnet.biz/bugs.php for information about filing bugs and feature requests. Best regards. Miroslav Šulc Another PostgreSQL Diff Tool Developer|

[GENERAL] Another PostgreSQL Diff Tool 2.2.2 released

.startnet.biz/bugs.php for information about filing bugs and feature requests. Best regards. Miroslav Šulc Another PostgreSQL Diff Tool Developer|

Re: [GENERAL] ERROR: variable not found in subplan target lists

Thank you for the fix. -- Miroslav Tom Lane napsal(a): > I wrote: > >> Bottom line seems to be that we should run through the in_info_list and >> force Vars mentioned therein to be propagated up at least to the >> "righthand" join level, ensuring they're available if we decide to >> unique-ify

Re: [GENERAL] ERROR: variable not found in subplan target lists

Just an explanation why I create such a weird WHERE clause. I have a form definition that should on initialization load no records in list, that's the reason why 'false' is there. But every query goes through layer that adds extra clause to the original one to allow access only to records the user

Re: [GENERAL] ERROR: variable not found in subplan target lists

Tom Lane napsal(a): > Alvaro Herrera <[EMAIL PROTECTED]> writes: > >> Miroslav Ĺ ulc wrote: >> >>> I just verified that the problem is in pg 8.2.5 too. >>> > > >> Can you show us the table definitions? >> > > We need a *complete* test case, ie, a SQL script to provoke the err

Re: [GENERAL] ERROR: variable not found in subplan target lists

Tom Lane napsal(a): > Alvaro Herrera <[EMAIL PROTECTED]> writes: > >> Miroslav Ĺ ulc wrote: >> >>> I just verified that the problem is in pg 8.2.5 too. >>> > > >> Can you show us the table definitions? >> > > We need a *complete* test case, ie, a SQL script to provoke the err

Re: [GENERAL] ERROR: variable not found in subplan target lists

suppose because the planner chose different plan to execute it as I provided just few records. -- Miroslav Šulc Alvaro Herrera napsal(a): > Miroslav Šulc wrote: > >> I just verified that the problem is in pg 8.2.5 too. >> > > Can you show us the table definitions?

Re: [GENERAL] ERROR: variable not found in subplan target lists

I just verified that the problem is in pg 8.2.5 too. -- Miroslav Šulc Miroslav Šulc napsal(a): > Just copied client database from production server to my dev database > and ran the query on my dev database and it fails too so it seems it > also depends on whether some data are contain

Re: [GENERAL] ERROR: variable not found in subplan target lists

Just copied client database from production server to my dev database and ran the query on my dev database and it fails too so it seems it also depends on whether some data are contained in the tables or not. -- Miroslav Šulc Miroslav Šulc napsal(a): > Hi, > > I get this error when run

[GENERAL] ERROR: variable not found in subplan target lists

e any help as the problem occurs on production server and I need to solve it ASAP. -- Miroslav Šulc ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Updating database structure

ew schemas. The project is called apgdiff (Another PostgreSQL Diff Tool) and can be found at apgdiff.sourceforge.net. It is still in beta but might be useful. Sorry if this post is not to the topic. Miroslav Šulc Alban Hertroys napsal(a): > Guido Neitzer wrote: >> I mostly use the

Re: [GENERAL] psql file restore - problem with encoding

John DeSoi wrote: On Mar 16, 2005, at 9:34 AM, Miroslav Šulc wrote: I have problem on one of our potentional client's linux server with data encoding. I have played with this for some time but with no success. Here is the problem: Maybe try setting the client side encoding explicitly at th

Re: [GENERAL] Internal account lookup failure

sferriol wrote: hello on windows 2000 (chinese) during postgres8.0.0-rc1.msi installation, it fails in 'Service configuration': Internal account lookup failure Is there a reason for not using version 8.0.1? Maybe this one will install without problem. sylvain Miroslav begin:vcard fn;quoted-printa

Re: [GENERAL] Localization problems between Access and PostgresSQL

Secrétariat wrote: Hello, I've dumped the content of MS-Access 2002 SP3 tables on a PC with Windows XP Pro in French localization. Then I COPY these files, on the same PC hosting an PostgreSQL 8.0.1 database. I've problems with the accents !? Why ? Luc, what encoding did you set for your PostgreS

Re: [GENERAL] free space map settings

go wrote: Hi Tell me please what does it mean the next hint: "TIP 7: don't forget to increase your free space map settings" where can i read about this settings? http://www.postgresql.org/docs/8.0/interactive/runtime-config.html -- Igor Miroslav begin:vcard fn;quoted-printable:Miroslav =C5=A0

Re: [GENERAL]

Mohsen Pahlevanzadeh wrote: Dears, When i wanna insert to my following code,I receive following error: Insert into c(t) values('ccc'); --> It's my qurey. Insert command failed!So i can't continue to insert in your table! ERROR: pg_atoi: error in "ccc": can't parse "ccc" Usually atoi

Re: [GENERAL] prelimiary performance comparison pgsql vs mysql

Hi Rick, the work you are doing is important (at least I think so). From my experience PosgreSQL performance is also very slow in case there are several LEFT JOINs and there are varchar() fields. You can see an example in archive where my problem is described (Subject: "How to read query plan").

Re: [GENERAL] General query optimization howto

Peter Eisentraut wrote: Miroslav ¦ulc wrote: is there on the net any general howto on SQL query optimizations? We have recently moved our project from MySQL to PostgreSQL and are having problem with one of our queries. I doubt that there is a generic documentation on SQL optimization, beca

Re: [GENERAL] General query optimization howto

Bruce Momjian wrote: Have you read the FAQ? Yes, but I have found only some useful information saying when indexes are not used. Miroslav Šulc begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable

[GENERAL] General query optimization howto

the query so I'm looking for some intro that could help me. -- Miroslav Šulc begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 repub

Re: [GENERAL] postgres 7.4 build for win

Hi Amin, maybe I'm little off but why don't you try the 8.0.1 version which should run on Windows platform? Miroslav Šulc Amin Abdulghani wrote: Hi, I am trying to build postgres 7.4.5 on windows (200) on mingw/msys env. I have installed win32-pthreads to enable-thread safet feature.

Re: [GENERAL] Locale problem

ame encoding for the database (= in this example 'UNICODE'). Then the sorting should be correct. I'm just a newbie for PostgreSQL so somebody might explain it more precisely. People, help pls to megrate to PG 8.01 properly Thanks, and have a nice day!! Igor Miroslav Šulc begin

Re: [GENERAL] PRoblems instalation PostgreeSQL8.0.1 in WindowsXP

nvert your FAT to NTFS for you. Miroslav Šulc begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika email;internet:[EMAIL PROTECTED] title:CEO