[ADMIN] Locks with no database or relation

Hello. I see Exclusive lock on my server (using pgAdmin) but cant understand what does it lock, because Database and Relation fields are left blank. What does it mean? (Attaching screenshot). -- Julius Tuskenis <> -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) T

[ADMIN] pg_get_expr

Hello one simple question - since which version postgresql has pg_get_expr(text, oid) in it? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] what is the origin of postgreSQL time

the SELECT current_timestmap is 1 hour late. Postgresql 8.1.4 OS: Gentoo Linux -- Julius Tuskenis -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] what is the origin of postgreSQL time

time. Julius Tuskenis Thomas Markus rašė: beware of timezone dst offset. try select current_timestamp AT TIME ZONE 'MEST' thomas Julius Tuskenis schrieb: Hello, I have problem with postgreSQL current_timestramp. Where does it get its value, because it doesnt match system time. The pro

Re: [ADMIN] what is the origin of postgreSQL time

> by default? The thing is we have 8 servers working and none of them is > affected by this issue. Only one refuses to switch to summer time. > > Julius Tuskenis > > Thomas Markus rašė: > > beware of timezone dst offset. try > > select current_timestamp AT TIME ZONE

Re: [ADMIN] what is the origin of postgreSQL time

Just empty strings in datconfig. "postgres";"" "sportlog";"" "template1";"" "template0";"" "sport";"" Tommy Gildseth rašė: How about database specific config settings? SELECT datname, datconfig FROM pg_database; -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make chan

Re: [ADMIN] what is the origin of postgreSQL time

hare/timezone the file is in there. What could be wrong? Julius Tuskenis Tom Lane rašė: Julius Tuskenis <[EMAIL PROTECTED]> writes: I have problem with postgreSQL current_timestramp. Where does it get its value, because it doesnt match system time. The problem appeared after th

Re: [ADMIN] what is the origin of postgreSQL time

too). In fact works only abbreviated timezones like MEST, EEST, GMT etc This beats me. I cant even imagine what to look for further. -- Julius Tuskenis Tom Lane rašė: Julius Tuskenis <[EMAIL PROTECTED]> writes: I've noticed that statement SELECT current_timestamp AT TIME ZO

Re: [ADMIN]store different tables in different locations

800-81-569-6201 E-Mail : [EMAIL PROTECTED] -- Julius Tuskenis Programuotojas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN]store different tables in different locations

we use postgresql to store so little data as only 600MB or so, while for this, we have to do consume some efforts on managing and maintaining the database. I am not sure whether it is a good and wise design. Is there any more wiser design for this case? In my case postgresql is like "fire an

Re: [ADMIN] postgres 8.1 usermanagement problem

ssion denied for relation tbl_a_a_container What's wrong? -- Julius Tuskenis -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Data Synchronization between client and server

Hello. If by saying "Synchronize Data between client and server" you mean you have replicated servers "master to multiple slaves" then http://slony.info/ is a link for you. Otherwise please explain what do you have in mind. -- Julius Tuskenis Kranti K K Parisa™ rašė:

[ADMIN] [Fwd: performance: view or function?]

. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

[ADMIN] how to get a number of seconds in some interval ?

Hello, Is there a good method of knowing how mutch seconds does some interval have?? I tried my_interval / (interval '1 second'), but there is no operator interval / interval defines (I wonder why). Is there a method to do so? -- Julius Tuskenis Programavimo skyriaus vadovas UAB

Re: [ADMIN] how to get a number of seconds in some interval ?

Thank you, it's now clear to me. Tom Lane rašė: Achilleas Mantzios <[EMAIL PROTECTED]> writes: Στις Monday 12 May 2008 17:32:39 ο/η Julius Tuskenis έγραψε: do you know why division of intervals was not implemented? As I see it - there should be an easy way to do so. '1

[ADMIN] translating exception messages of postgresql functions

or raised exceptions. Have enyone tried to distinguish one exception from the other in the application? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.post

Re: [ADMIN] translating exception messages of postgresql functions

Alvaro Herrera rašė: Julius Tuskenis wrote: Hello, I'd like to ask how is translation of raised exceptions done in postgresql applications? You want it translated or not translated? I want to translate the exception message. For example I raise an exception in pg function

Re: [ADMIN] translating exception messages of postgresql functions

Alvaro Herrera rašė: Julius Tuskenis wrote: I want to translate the exception message. For example I raise an exception in pg function like RAISE EXCEPTION 'my exception', then in my application that calls the function I catch the exception. But before I show it to t

Re: [ADMIN] roles and inheritance

I do want John and Mary to inherit the privs of the database_name_select role. Do I set database_name_select with the option inherit or no inherit? The implication is that roles can inherit from other roles; is that correct? Thanks for your help, Carol -- Julius Tuskenis Programavimo s

[ADMIN] changing sequence in serial field

b_prekes_br_kodas_pbk_id_seq1 because table b_prekes_br_kodas column pbk_id requires it SQL state: 2BP01 Hint: You may drop table b_prekes_br_kodas column pbk_id instead. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make

Re: [ADMIN] changing sequence in serial field

"...column pbk_id requires it." Any way I can't find a way to find and alter this dependency. Achilleas Mantzios rašė: Στις Thursday 03 July 2008 18:19:27 ο/η Julius Tuskenis έγραψε: Sorry - that doesnt work. That was in 8.3.3 Your mileage may vary. But the key is to

Re: [ADMIN] query optimization

issue. Thanks & Regards, Suresh Borse -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] query optimization

y help me for troubleshooting and for resolving the > performance issue. > > > Thanks & Regards, > Suresh Borse > > -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)

Re: [ADMIN] Duplicate records in a table inspite of a primary key

p me out in finding the reason for such dupicate records existing Could you pls help me out in finding the reson for duplicate records being inserted. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresq

[ADMIN] CVS for postgresql

Hello we develop applications on postgresql, use alot of functions, edit them very often so there is a need for a version control. Is there a solution like CVS or something for PG databases? Well - for schemas at least. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob

Re: [ADMIN] can I update multiple table at a time?

., state and date. I'm writing an update statement to set 'open' state records to 'closed' state after 7. both table can be joined using id. Any thoughts? Thanks -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin

Re: [ADMIN] can I update multiple table at a time?

I don't know a way to edit 2 tables in 1 SQL statement. If you have 2 sql statements then the performance should be almost the same with the function and maybe slightly worse with a trigger. Jagadeesh rašė: Hi Julius Tuskenis, Many thanks for helping me. These are good solutions. But I

[ADMIN] function executes sql 100 times longer it should

kainorastis ON (ks_kainorastis=ptk_kainorastis) WHERE (grup_id=42 OR 42 is Null) AND ptk_pardavimotaskas=18 AND ((prek_pavadinimas ILIKE ('%'||null||'%')) OR null is NULL) AND fnk_grafikas_galioja(kag_grafikas) = true ORDER BY prek_pavadinimas; Total query runtime: 47 ms. 0 rows ret

Re: [ADMIN] function executes sql 100 times longer it should

First run probably put the plan and results into the query cache. The second run could just pull it from there instead of going to the tables on the disk. I dont think its true, because even if I change parameter values in SQL it still returns results fast. So my guess is that the problem is somewhere else. Maybe theres a way to see Explain plan for function body?? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] function executes sql 100 times longer it should

quot; Index Cond: ((b_pardavimo_tasko_kainorastis.ptk_pardavimotaskas = 18) AND (b_pardavimo_tasko_kainorastis.ptk_kainorastis = b_kainorascio_sudetis.ks_kainorastis))" " -> Seq Scan on b_grupe (cost=0.00..1.52 rows=1 width=4) (actual time=

Re: [ADMIN] function executes sql 100 times longer it should

like this get wrapped (to TRUE in your case), so with plain SQL planner does not even try to estimate ILIKE filter effect. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your

[ADMIN] postgresql client on WinCe

Hello list. I'm writing a program that should be run on WinCe and connect to postgresql. The problem I cant find libpq.dll for WinCe. Is there any? How would you suggest connecting to postgresql server? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 --

Re: [ADMIN] String concatenation work in version 8.2.11 and 8.3.6

casts. is it a bug in 8.2.11 or I install 8.3.6 not completely? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Database in use?

can I do about it? Thanks, Carol -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Query related

Hello postgres=# create table name(fn text,ln text); fn and ln could be nulls, so instead of postgres=# select fn||' '||ln as name from name; SELECT COALESCE(fn,'')||' '||COALESCE(ln,'') from name should be used. This is because NULL||TEXT = NULL

Re: [ADMIN] Default instance?

to reverse these so that the 8.3 instance is the default, and users who use the 8.2 instance will have to specify the port. How do I make this change? Thanks, Carol PS I'm on a Solaris 10 box. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent

Re: [ADMIN] Cannot connect to postgresql

listen on; # comma-separated list of addresses; # defaults to 'localhost', '*' = all listen_addresses = '*' #port = 5432 That seems ok. I don't know what OS you use, but check if postgres is listening to port 5432. A

Re: [ADMIN] Cannot connect to postgresql

s 10. Carol On Jul 24, 2009, at 3:07 AM, Julius Tuskenis wrote: #--- # CONNECTIONS AND AUTHENTICATION #--- # - Connection Settings - #listen_ad

Re: [ADMIN] pg_dumapp does not save objects added in pg_catalog

e the cluster with pg_dumpall I do not find my function definitions in the output file. Is this normal ? Have I to redefine theses functions in my new data base ? Thanks a lot Best Regards Ali -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 smime.p7s Descri

[ADMIN] where the stored function meta data can be found?

on by function -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 smime.p7s Description: S/MIME Cryptographic Signature

Re: [ADMIN] where the stored function meta data can be found?

Hello, Rafael Thank you. Don't know how I've missed that table in pg_catalog... 2009.10.02 19:35, Rafael Domiciano rašė: Hello, I Think you can this kind of information at pg_proc.prosrc Best Regardas, Rafael Domiciano On Fri, Oct 2, 2009 at 3:57 AM, Julius Tuskenis <mailto:ju

[ADMIN] find query beening executed

Hello, I'd like to know if it is possible to find out the query beeing processed for some connection? I know theres a "Select * from pg_stat_activity", but if query is very long it gets "cut" and it is the end of it that interests me. -- Julius Tuskenis Programa

Re: [ADMIN] find query beening executed

Thank you. I'll ask to log long lasting queries, but still - isn't there a way to see on what postgres works in real time? 2009.10.22 11:14, Scott Marlowe rašė: On Thu, Oct 22, 2009 at 1:52 AM, Julius Tuskenis wrote: Hello, I'd like to know if it is possible to find out t

Re: [ADMIN] Need help in enabling remote connection

work. What else should i do to make remote connection work? I'm lost! Please help! Thanks a lot, Shruthi -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 smime.p7s Description: S/MIME Cryptographic Signature

[ADMIN] Practice of backups

abase without setting permission on every database component (tables, sequences, functions, etc)? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 smime.p7s Description: S/MIME Cryptographic Signature

Re: [ADMIN] Practice of backups

Thank you guys for advice. It's nice to have someone with experience around. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

[ADMIN] estimating size of query result

years you know :) -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] starting postgres with several Data directories

Thank you, Scott & Scott :) I appreciate your help. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] XML support in pgsql

Hello, I need XML support in postgresql. I recompiled source --with-libxml flag. And restarted the database. Unfortunately I am still getting error that I need XML support. Any thoughts ? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin

[ADMIN] how to speed ilike

could be a lot more. How would you advice to improve performance? Maybe some special index would help? As user names are update rarely it's the read speed I'm interested in. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list

Re: [ADMIN] how to speed ilike

7;m using username ilike '%blablabla%' , so maybe theres no way for ilike to benefit from an index. It might also help to specify varchar_pattern_ops. I added varchar_pattern_ops to index declaration, but this didn't help either. Do you have any other ideas? -- Julius Tuske

[ADMIN] operator does not exist

queries, but is the first example ok? Should it not raise error ? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] operator does not exist

Thank you for your informative answer. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] insert in function writen in pgplsql

r. Must I change the names of parameters? using PG 8.3 -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] insert in function writen in pgplsql

nk of such case. Can you provide an example? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Strange deletion problem

.. - Is it possible that data corruption of either the index/table is making my delete statements removed more rows? Maybe you have foreign key with "On delete cascade" ? - Is it a possibly bug? I don't know of such bug, but I'm no bug expert as well. I guess everything is p

[ADMIN] when does postgresql read from pg_hba.conf ??

f file 2010-04-24 13:57:46 EEST HINT: See server log for details. 2010-04-24 13:58:05 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:59:28 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:59:58 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050

Re: [ADMIN] when does postgresql read from pg_hba.conf ??

? The pg_hba.conf is read each time the client connects to the postgresql ? Why there is nothing about that in documentation ? (Or did I manage to mis this?) -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.or

Re: [ADMIN] when does postgresql read from pg_hba.conf ??

2010.04.26 19:33, Alvaro Herrera rašė: Do you want to say that on windows postgresql acts differently? Yes. Thank you, Alvaro, Your answer was a big surprise for me. On the other hand now I at least know there is nothing wrong with postgresql server. -- Julius Tuskenis

Re: [ADMIN] query execution time

he settings for autovacuum were not changed so it is enabled by default on every table. Please, could you provide information what actions does the postgres take after it does actions monitored by EXPLAIN ANALYZE? Could it be libpq issue (pgAdmin uses it)? -- Julius Tuskenis Programavimo skyriaus vadova

Re: [ADMIN] query execution time

goes back to normal. The top command on the server shows it has enough of ram (~200Mb free all the time). -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http:

[ADMIN] possible memory leak in Server Status window

ns as before. Today I have opened the Server Status tool, and during an hour or so the VM size used by pgAdmin increased from 13Mb to 28Mb. I tried to reproduce the behavior on other systems but with no success yet. Could you give me a hint what I should try? -- Julius Tuskenis Programavimo sky

Re: [ADMIN] possible memory leak in Server Status window

ocate from the system nonpaged pool because the pool was empty." I tried to google - found an explanation that this could mean there is a memory leak in kernel or in drivers. Maybe something is wrong in system... This is the first time I encounter such a problem. -- Julius Tuskenis Programa

Re: [ADMIN] possible memory leak in Server Status window

2011.02.07 13:14, Julius Tuskenis rašė: 2011.02.07 11:52, Guillaume Lelarge rašė: Did you lower each report? because each individual report has its own timer. I'm sorry, I have only one report (Server status window). When you say "lower" do you mean "minimize" ? No,

Re: [ADMIN] currval()

is prek_id and the sequence is b_preke_prek_id_seq -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050

[ADMIN] commiting transaction from outside

ction would get rollbacked. I've tried google'ing but without results - this might mean, that there is no way, but I thought asking is an option.. Thank you in advance for any advice. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-adm

Re: [ADMIN] commiting transaction from outside

you correctly I can not rely on xmin and xmax values after the commit. Anyway Thank You for the Idea. I solved the problem by using sql injection methods (I was lucky the application was buggy enough). -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via