[GENERAL] Connection loosing at some places - caused by firewall

Dear Members! Windows 10, PGSQL 9.4 and 9.6 (Debian with SSL, and Windows without it - it doesn't matter). When I (or my boss) work(s) at home, I got connection lost errors from PGAdmin (3/4) or from other applications too. server closed the connection unexpectedly This probably means the ser

Re: [GENERAL] Restore LargeObjects on different server

Hi! Somebody wrote me that: The pg_catalog schema is system schema, but it is IN the DB. Is this true? So OID is not global (out from DB)? So we can dump and restore the DB with OIDs without collision in new server? Thank you! dd 2017-10-12 11:35 GMT+02:00 Durumdara : > Dear Memb

[GENERAL] Restore LargeObjects on different server

Dear Members! Because of upload/download progress we used LargeObjects to store some files in one of our database (and not bytea). Only this database uses the OID-s of these files. In the near future we must move to another server. This new server is also working now, the moving of databases is

[GENERAL] Error: "cached plan must not change result type"

Dear Members! At Friday one of our clients got this error: "cached plan must not change result type" He restarted the application and the problem vanished. We used PGDAC to access the database. Firstly we didn't know nothing about this kind of error. But later we realized that somebod

[GENERAL] pg_stat_activity extra Fields are NULL

Dear Members! Windows Clients, PG 9.4 on Linux. I used [PID + Client IP + Port + BackEnd Start] for unique identification of a connection. Every connection store it's unique connection info in a table (per DataBase). F.e: "8574|195.12.4.3|50120|2017-01-01 08:12:15" Yesterday I realized that BackE

Re: [GENERAL] Maximum of connections in PG

termination. Thank you! dd 2017-03-14 15:29 GMT+01:00 Melvin Davidson : > > > On Tue, Mar 14, 2017 at 10:15 AM, Durumdara wrote: > >> Dear Members! >> >> In a very strong Linux machine (with many 16-30 GB RAM) what is the limit >> of the PGSQL server (9.4-9.

[GENERAL] Maximum of connections in PG

Dear Members! In a very strong Linux machine (with many 16-30 GB RAM) what is the limit of the PGSQL server (9.4-9.5) "maximum connections"? 1000? 2000? The clients are native applications (Windows executables) with persistent connections, with more than 100 databases (every client have only one

Re: [GENERAL] Who dropped a role?

Hello! Sorry, meanwhile I found it as Group Role. I never used this kind of role. How to restore it to normal login role? Thanks for it! dd 2016-12-08 9:53 GMT+01:00 Durumdara : > Dear PG Masters! > > In a server today I didn't find an important role. > I don't know

[GENERAL] Who dropped a role?

Dear PG Masters! In a server today I didn't find an important role. I don't know what my colleagues did with it, but it seems to be lost. Do you know a trick, how get info about it? 1.) Who dropped it? 2.) If not dropped what happened with it? Does role dropping logged somewhere? Thanks for you

Re: [GENERAL] Surviving connections after internet problem

Dear Laurenz! 2016-11-07 16:06 GMT+01:00 Albe Laurenz : > Durumdara wrote: > > Linux server, 9.4 PG, Windows clients far-far away. > > May we must limit these parameters in clients after the starting of the > connection? > > Don't bother about the clients, just see

[GENERAL] Surviving connections after internet problem

Hello! Linux server, 9.4 PG, Windows clients far-far away. They called us that they had an "internet reset" at 13.00, but many client locks are alive now (14:00). I checked server status, and and saw 16 connections. In Windows PG server I read about keepalive parameters which are control and re

Re: [GENERAL] Cannot delete role because it depends on "default privileges"

Wow... I found it. The postgres database contained more default privs. But PGAdmin III nothing say about dependents in it's reports. Thanks! 2016-10-21 16:19 GMT+02:00 Durumdara : > Dear Tom! > > Is there any tool what can show me the dependents or depend

Re: [GENERAL] Cannot delete role because it depends on "default privileges"

Dear Tom! Is there any tool what can show me the dependents or dependencies? In PGAdmin I don't see any dependencies or dependents... :-( Thanks dd 2016-10-21 16:08 GMT+02:00 Tom Lane : > Durumdara writes: > > The DB_X dropped, so I can't choose it as "actual dat

Re: [GENERAL] Cannot delete role because it depends on "default privileges"

iers in the background, I will be in trouble... Thanks 2016-10-21 15:27 GMT+02:00 Tom Lane : > Durumdara writes: > > We have a ROLE_MAIN. > > This gave default privileges to all next objects in DB_X to ROLE_X. > > Somebody dropped DB_X, and later he tried to drop ROLE_X. &

[GENERAL] Cannot delete role because it depends on "default privileges"

Hello! We created a DB named DB_X, and a role ROLE_X. We have a ROLE_MAIN. This gave default privileges to all next objects in DB_X to ROLE_X. Somebody dropped DB_X, and later he tried to drop ROLE_X. But he got errors in PGAdmin. --- pgAdmin III

Re: [GENERAL] Restricted access on DataBases

T+02:00 Albe Laurenz : > Durumdara wrote: > [...] > > --- login with postgres: > [...] > > ALTER DEFAULT PRIVILEGES > > GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, > TRIGGER ON TABLES > > TO u_tr_db; > > > > log

Re: [GENERAL] Restricted access on DataBases

Dear Charles! Sorry for late answer. Now I got a little time to check this again... 2016-09-14 18:43 GMT+02:00 Charles Clavadetscher : > Hello > > > > > > Also try this: > > > > ALTER DEFAULT PRIVILEGES FOR ex_mainuser GRANT INSERT, SELECT, UPDATE, > DELETE, TRUNCATE, REFERENCES, TRIGGER ON TAB

Re: [GENERAL] Restricted access on DataBases

table t_mainuser3 (id integer); commit; -- login as ex_dbuser -- select * from t_mainuser3; -- ERROR! Thanks: dd 2016-09-14 16:52 GMT+02:00 Adrian Klaver : > On 09/14/2016 06:52 AM, Durumdara wrote: > >> Dear Charles! >> >> > >> I thought before this te

Re: [GENERAL] Restricted access on DataBases

Dear Charles! I checked your solution. For example: db - database dbuser, mainuser 1. dbuser own the database, and the objects in it. 2. mainuser member of dbuser. 3. public connection revoked. Ok. Then dbuser can see all tables, and mainuser too. Ok. The operation (overlord): 1. set role to

Re: [GENERAL] Restricted access on DataBases

Dear Everybody! I read the documentation based on your example. First reactions. 2016-09-05 18:25 GMT+02:00 Charles Clavadetscher : > >> GRANT us_a, us_b, us_c TO main_admin; >> > Ah, it's good. I can merge the "owner" rights to one. :-) It's like "doubling"! :-) > >> > > Here an example (obv

Re: [GENERAL] Restricted access on DataBases

Dear Everybody! I'm sorry because lack of answer - I try to do it now. 2016-09-05 16:19 GMT+02:00 Adrian Klaver : > On 09/05/2016 05:45 AM, Durumdara wrote: > >> Dear PG-masters! >> >> We want to put more databases to one server, to "public" schema: >&g

[GENERAL] Restricted access on DataBases

Dear PG-masters! We want to put more databases to one server, to "public" schema: DB_A, DB_B, DB_C. And users: US_A, US_B, US_C, and Main_Admin. We want to setup the environment. Every simple user can access his database: DB_A - US_A DB_B - US_B DB_C - US_C They can't access other databases only

[GENERAL] Field size become unlimited in union...

Hello! As I experienced, PGSQL changes the result field sizes to unlimited varchar, when I passed different field size in same column of the union. SP.Key - varchar(100) SP.Value - varchar(200) Example: select 'a', value from sp union all select key, value from sp The first field is not

Re: [GENERAL] 9.5 - Is there any way to disable automatic rollback?

Dear All! >In PG it's seems to be different. PG silently rollback the actual > transaction. >> > > I am not seeing silent: > ERROR: current transaction is aborted, commands ignored until end of > transaction block > I say "silently", because first I didn't recognize that all things lost, not on

Re: [GENERAL] Really unique session ID - PID + connection timestamp?

Dear All! 2016-04-10 18:03 GMT+02:00 Adrian Klaver : > On 04/10/2016 06:29 AM, durumd...@gmail.com wrote: > >> >> Products, offers are edited for long time. >> > > Define long time, a session, a day, days, etc? > For 1 minute to 1-2 hours. > > But we must save subdata. This is not a "word like

Re: [GENERAL] Really unique session ID - PID + connection timestamp?

t have danger (like guid repetition). Yes, it have. And not the BAD SYSADMIN, but the summer/winter time changes are dangerous (the backward version). In PG we can extend our "guid" with IP and Port too, and this could be enough safe for us. Thanks 2016-04-09 16:05 GMT+02:00 Adrian Kl

Re: [GENERAL] Really unique session ID - PID + connection timestamp?

t lock the object because locked by another user!') Thanks for your inspiration! 2016-04-09 12:30 GMT+02:00 John R Pierce : > On 4/9/2016 1:30 AM, Durumdara wrote: > >> In MS we had... >> > > If you want Microsoft's unique version of SQL, run Microsoft SQL.

[GENERAL] Really unique session ID - PID + connection timestamp?

Dear Everybody! In MS we had a "persistent lock" structure and method. This over transactions because based on real records in a real table with pri key (tablename + id). For garbaging we had a special session info. In MS the session id is smallint, so it can repeats after server restarts, but

[GENERAL] Drop only temporary table

Dear PG Masters! As I experienced I can create normal and temp table with same name. create table x (kod integer); CREATE TEMPORARY TABLE x (kod integer); select tablename from pg_tables where schemaname='public' union all select c.relname from pg_class c join pg_namespace n on n.oid=c.relname

[GENERAL] Phantom read example for new Repeatable Read level

Dear Everybody! Can somebody show me an example for phantom read in "Repeatable Read" mode (in 9.1, new, serialized kind of isolation level)? The help wrote that it is possible: Repeatable read Not possible Not possible Possible But I don't understand, why, and how. C1, C2 are clients. Every of

[GENERAL] Re: One transaction by connection - commit subdetails without release master transaction?

also showing one tx state/statement per connection) So if I want to make two transactions in client am I must duplify the connections in this period? Thanks for your help: dd 2012/2/17 Durumdara : > Dear PGSQL Masters! > > > What do you thinking about this? Can I do this without

Re: [GENERAL] Correct way for locking a row for long time without blocking another transactions (=nowait)?

Dear Filip! 2012/2/28 Filip Rembiałkowski : > On Tue, Feb 28, 2012 at 10:26 AM, Durumdara wrote: > Just some loose comments. > > http://www.postgresql.org/docs/current/static/explicit-locking.html#LOCKING-ROWS > > A way to explicitly lock given row without updating it: >

[GENERAL] Correct way for locking a row for long time without blocking another transactions (=nowait)?

Hi! In FireBird I can set the transaction to "nowait". When I want to protect a row for long time (showing a dialog, and on closing I release the row), I need to do this: trans.StartTransaction(); sql.execute('update thetable set afield = afield where idfield = anyvalue'); This is locking the ro

Re: [GENERAL] Stability in Windows?

Hi! 2012/2/24 > We are using it on a rather beefy server with no problems with a Win32 > client/server app. Which programming language you use in clients? Which adapter? If Delphi then which components? > There are additonal things you can do to tune the > database. Some word please abou

[GENERAL] Stability in Windows?

Hi! We planned to port some very old DBASE db into PGSQL. But somebody said in a developer list that he tried with PGSQL (8.x) and it was very unstable in Windows (and it have problem when many users use it). Another people also said that they used PGSQL only in Linux - and there is no problem w

[GENERAL] One transaction by connection - commit subdetails without release master transaction?

Dear PGSQL Masters! I got a new project: porting a DBASE based application to PGSQL. Some theoretic question I have before I coding/typing. OS: Win, IDE: Delphi. Preface: Delphi uses TDataSet-s (every of them have records/rows). When use Post method to save the actual record. In DBASE or flat ta

Re: [GENERAL] Extending Session / Logged User info

Hi! 2012/1/31 Guillaume Lelarge > On Tue, 2012-01-31 at 04:16 -0800, durumdara wrote: > > Dear PGSQL Masters! > > > > I have a complicated question. > > > > Is there any way to extend the session information (what visible in > > pgadmin's "Ser

[GENERAL] Extending Session / Logged User info

Dear PGSQL Masters! I have a complicated question. Is there any way to extend the session information (what visible in pgadmin's "Server Status")? I explain what I want to do: We used alternative DB in a place and I need to port this. In this DB we using different db users for every real users.

Re: [GENERAL] When the Session ends in PGSQL?

Hi! 2011/7/6 Durumdara : >> Most importantly, PostgreSQL's "stored procedures" cannot control >> transactions. They cannot commit, rollback, or begin a new transaction. They >> have some control over subtransactions using PL/PgSQL exceptions, but that's >

Re: [GENERAL] When the Session ends in PGSQL?

Hi! 2011/7/4 Craig Ringer : > On 4/07/2011 7:50 PM, Durumdara wrote: > >> As I understand you then running Queries forced to abort on the end of >> Session and no more Query running over the session's ending point (or >> after TCP connection broken). > > Correc

Re: [GENERAL] When the Session ends in PGSQL?

Ahoj! 2011/7/4 Vincent de Phily : > On Monday 04 July 2011 12:49:24 Durumdara wrote: >> What happens with running statements and stored procs at Session's end? >> >> They will be aborted and destroyed, or they can continue the running? >> >> For example: >

Re: [GENERAL] When the Session ends in PGSQL?

Hi! 2011/7/4 Vincent de Phily : > On Monday 04 July 2011 10:48:48 Durumdara wrote: >> 1.) DataBases need to close the resources kept by Sessions. >> 2.) There is need some "border", or a rule to split - which Session is >> considered as "finished". &

Re: [GENERAL] When the Session ends in PGSQL?

Another thing is sign (packet). We must do something periodically to keep alive the connection. For example: every 1 minutes we do some dummy thing one server, like "select date" or etc. The reflections: 2011/6/30 Bill Moran : > In response to Durumdara : > >> Hi! >&

Re: [GENERAL] When the Session ends in PGSQL?

Hi! 2011/6/30 Bill Moran : > In response to Durumdara : > > Session ends when the connection is terminated.  I.e., a PostgreSQL > session is synonymous with a TCP connection (or domain socket in some > cases). In Windows OS what's this meaning? I know there is a differen

[GENERAL] When the Session ends in PGSQL?

Hi! I asked same thing in the list formerly, http://archives.postgresql.org/pgsql-general/2011-06/msg00888.php And because of lack of answers now I asked here also: http://stackoverflow.com/questions/6534654/postgresql-session-timeout I'm very wondering that I don't (and can't) found a system va

[GENERAL] Long Query and User Session

Hi! I want to ask that what happens if a long query running and user session timeout reached? 1.) For example: somebody starts a very long query or statistical stored procedure. The session timeout is 5 minutes, and the session exhausted this time. What happens? a.) The Query/STP automat

[GENERAL] An example for WITH QUERY

Hi! I have 3 tables. I want to run a query that collect some data from them, and join into one result table. I show a little example, how to do this in another DB with script: create temp table tmp_a as select id, name, sum(cost) cost from items where... group by id, name with data; create temp

[GENERAL] Unique Session ID in PGSQL?

Hi! Is there any function in PGSQL that returns an unique Session identifier of the actual session? For example a Bigint, or GUID, or etc? Can I get the living Session identifiers from PG? We have a little application that uses these infos which are basically came from another database system, an

[GENERAL] Set transaction waiting mode and timeout

Hi! In Firebird the transaction can be parameterizable as: SET TRANSACTION ... [WAIT | NO WAIT] [LOCK TIMEOUT seconds] The "NO WAIT" is force transaction to return instantly with errormsg when some deadlock situation happened, Timeout is define the seconds for wait. This can be set for

Re: [GENERAL] Read Committed transaction with long query

Hi! 2011/5/12 Albe Laurenz : > Durumdara wrote: >>Two table: >>Main >>Lookup >> >>The query is: >>select Main.*, Lookup.Name >>left join Lookup on (Main.Type_ID = Lookup.ID) > > hat's not correct SQL, but I think I understand what you me

[GENERAL] Read Committed transaction with long query

Hi! Two table: Main Lookup The query is: select Main.*, Lookup.Name left join Lookup on (Main.Type_ID = Lookup.ID) Lookup: ID Name 1 Value1 2 Value 2 3 Value 3 Many records is in Main table (for example 1 million). What happens in this case (C = connection): C1.) begin read committed C1.) sta

[GENERAL] ZEOS or PGDAC - How to lock a resource?

Hi! We will porting an application to PGSQL from some table based app (BDE like). The older application used a special technic of the driver: if a record edited, some exclusive (over transaction), "forever living" lock put on it. On exit, cancel, or post this lock removed. We used this to l

[GENERAL] Multiple instances with same version?

Dear Everybody! I want to ask that have some way to install PGSQL 9.0 as two instances in one machine? Most important question. The OS is can be Windows or Linux. I asked this, because formerly we heard about a story. I cite this as I remember: We have some product, and in the only one

[GENERAL] Bug in PGSQL 9.0 with handling chr(1..255) in Win1250 context?

Hi! Windows 7x64, PG9.0, PGAdmin 1.12.1. First I sent this problem to PGADMIN support list, you can see it, but I repeat the description. http://archives.postgresql.org/pgadmin-support/2011-04/msg00012.php I tried to fillup a text field with all ANSI characters chr(1)..chr(255). Except 0 becaus

[GENERAL] Blob handling with Delphi...

Hi! PG9.0, Delphi 6, Zeos. I want to use PGSQL bytea field as normal BLOB field in Delphi. But when I insert a value into this field, for example all characters (chr 0..255), and I fetch, and save it as blob stream into a file, I got interesting result, not what I stored here previously. It is

Re: [GENERAL] How to get index columns/dir/ord informations?

Best Regards, Raghavendra EnterpriseDB Corporation On Fri, Apr 1, 2011 at 8:54 PM, Durumdara <mailto:durumd...@gmail.com>> wrote: Hi! I want to migrate some database to PG. I want to make intelligens migrator, that makes the list of the SQL-s what need to do to get sa

[GENERAL] How to get index columns/dir/ord informations?

Hi! I want to migrate some database to PG. I want to make intelligens migrator, that makes the list of the SQL-s what need to do to get same table structure in PG as in the Source DB. All things I can get from the views about tables, except the indices. These indices are not containing the const

[GENERAL] Disconnect/Resource releasing/PING

Hi! Many databases (like Firebird) have some time limitation for the clients. These cases possible with client: a.) It is working, but network connection is temp. down. b.) The client is crashing c.) The client is on, but it is not working for N minutes. When the server experience that client is

[GENERAL] Linux, Hungarian charset (Win1250) is supports the hungarian collation?

Dear Everybody! We need to choice a DB for our new project. Two of the databases are possible to choose. 1.) PGSQL 9.x 2.) FireBird 2.x We needs to serve 75/80 users in a time. The client platform is Windows, Delphi based applications with [Zeos/PGDAC] or [IBX/ZEOS]. The server is may Windows,

Re: [GENERAL] PG and dynamic statements in stored procedures/triggers?

= ?' using :part_id into :sumof update :tbl set sumof = :sumof where part_id=:part_id end; Can you show me same example? Thanks: dd 2011/3/7 Adrian Klaver > On Monday, March 07, 2011 6:32:44 am Durumdara wrote: > > Hi! > > > > In other RDBMS I found a way to m

[GENERAL] PG and dynamic statements in stored procedures/triggers?

Hi! In other RDBMS I found a way to make dynamic statements. I can use variables, or concat the SQL segments, and execute it all. :tablename = call CreateTempTable; insert into :tablename drop table :tablename or (FireBird like cursor handling): sql = "select * from " || :tablename || " wh

[GENERAL] Bytea/Text blob deletion is very slow...

Hi! PG8,4, Window XP, Python. I have a program that makes many picture version from an original with XNView effects. Because I want preserve the integrity, previous datas, I used transactions, and PGSQL. The main problem with blobs that insertion is good, the select is good, but the deletion is

[GENERAL] Opened ports vs. Packages...

Hi! I want to ask about PGSQL-crack/hack-web-database. So: We have a web site with python. The DB engine is PGSQL. The first theory was that PGSQL is locally used, and each of other operations are realized with encoded XML packages. These operations are: fill up partner data, fill up offer da

Re: [GENERAL] Charset Win1250 on Windows and Ubuntu

Hi! 2009/12/21 Albe Laurenz > Durumdara wrote: > >> - Change the client encoding to WIN1250 (e.g. by > >> setting the environment variable PGCLIENTENCODING). > > > > So if I have Python and pygresql, can I set this value in Python? > > The main prob

Re: [GENERAL] Charset Win1250 on Windows and Ubuntu

Hi! 2009/12/19 Albe Laurenz > If you need the data in WIN1250 on the client side, change the client > encoding to WIN1250. > > So: > - Create the database with UTF8. > - Change the client encoding to WIN1250 (e.g. by setting the environment > variable PGCLIENTENCODING). > - Import the dump of th

[GENERAL] Charset Win1250 on Windows and Ubuntu

Hi! I have a software that uses Postgresql. This program (and website) developed and working on Window (XP/2003), with native charset (win1250). Prior week we got a special request to install this software to a Linux server. Yesterday I installed Ubu9.10 on VirtualBox, and tried to moving the da

[GENERAL] Can I get Field informations from system tables?

Hi! I must get informations about the tables. For example: Tnnn: 1. [Field Name, Type, Size, NotNull] 2. [Field Name, Type, Size, NotNull] ... The test table is this: CREATE TABLE testfields ( fbigint bigint NOT NULL, fbool boolean, fchar character(100), fcharv character varying(100),

[GENERAL] "= Null" <> "is Null"?

Hi! select * from any where is_deleted = Null select * from any where is_deleted in (Null) They are show 0 record. select * from any where is_deleted is Null It is show all records. Some of other DBs are uses Null as Null in >=< comparisons. Is PG not? What are the rules? Thanks: dd

Re: [GENERAL] An example needed for Serializable conflict...

er report) thread actually read the rows that they are want to modify? This is the main question about it. Thanks for your read/answer! dd 2009.07.07. 11:36 keltezéssel, Albe Laurenz írta: Durumdara wrote: Please send me an example (pseudo-code) for Serializable conflict. And I

[GENERAL] An example needed for Serializable conflict...

Hi! Please send me an example (pseudo-code) for Serializable conflict. And I wanna know, if possible, that if more transactions only read the tables in Serializable mode, and one or others write to it, can I got some conflicts in read operation? c = client t = transaction c1t1 begin serial c1t1 s

Re: [Fwd: Re: [GENERAL] Python client + select = locked resources???]

Hi! 2009.07.01. 9:43 keltezéssel, Craig Ringer írta: On Wed, 2009-07-01 at 09:23 +0200, durumdara wrote: Firebird have repeatable read, but PG is not have it. Hmmm... Then that is meaning that every statement is in new transaction context which can makes inconsistency in the views

Re: [GENERAL] Am I in intransaction or in autocommit mode?

Hi! 2009.06.29. 15:34 keltezéssel, A. Kretschmer írta: In response to durumdara : Hi! Can I check with something that I'm in "in-transaction" or in autocommit mode? I wanna avoid the notices I got when I'm also in mode I need... For example: "begin&

Re: [GENERAL] Python client + select = locked resources???

Hi! 2009.06.29. 18:26 keltezéssel, Craig Ringer írta: On Mon, 2009-06-29 at 13:36 +0200, durumdara wrote: I wanna ask something. I came from IB/FB world. InterBase / FireBird ? Yes, sorry for short descriptions. In this world I was everytime in transaction, because of

[GENERAL] Am I in intransaction or in autocommit mode?

Hi! Can I check with something that I'm in "in-transaction" or in autocommit mode? I wanna avoid the notices I got when I'm also in mode I need... For example: "begin" "begin" --- error notice... Thanks for your help: dd ps: in my prev. mail I asked this too, but in another context... pos

[GENERAL] Python client + select = locked resources???

Hi! I wanna ask something. I came from IB/FB world. In this world I was everytime in transaction, because of reads are also working under transactions. In the FB world the transactions without any writes/updates are not locking the database, so another clients can makes a transactions on any r

Re: [GENERAL] Transaction settings: nowait

Hi! 2009.05.06. 11:54 keltezéssel, Richard Huxton írta: durumdara wrote: So: have PGSQL same mechanism like nowait? When you take a lock: http://www.postgresql.org/docs/8.3/interactive/sql-lock.html http://www.postgresql.org/docs/8.3/interactive/sql-select.html#SQL-FOR-UPDATE-SHARE As I

[GENERAL] Transaction settings: nowait

Hi! In FireBird the transactions have these settings: SET TRANSACTION [NAME/|hostvar|/] [READ WRITE | READ ONLY] [ [ISOLATION LEVEL] { SNAPSHOT [TABLE STABILITY] | READ COMMITTED [[NO] RECORD_VERSION] } ] [WAIT | NO WAIT] [LOCK TIMEOUT/|seconds|/] And thi

Re: [GENERAL] Web + Slicing/Paging datas

Hi! 2009.04.23. 9:23 keltezéssel, John R Pierce írta: durumdara wrote: Hi! In a mod_py application I wanna write a wrapper that handle all PSQL data view with paging/slicing. .. Inserts all records to a temp table. Check the affected rows (as count). Slicing the records. Fetch the slice

[GENERAL] Web + Slicing/Paging datas

Hi! In a mod_py application I wanna write a wrapper that handle all PSQL data view with paging/slicing. For example: I have 1.500 records. I wanna show only N (f. ex: 15) records in the view, other records are accessable with a pager (links): [First, P-2, P-1, P, P+1 P+2, Last] F. Ex: First

[GENERAL] Is there any special way to a trigger send a signal to outer application?

Hi! Windows Server, PGSQL. When a new records arrived to the database, I want process them in the background. I have a processor service. This is periodically (5-10 minutes) checking the "message" table, and if there is some message, it is process them. This periodic processing is good, but

[GENERAL] PGAdmin and user privileges - what I do wrong?

Hi! Please help me a little. I used PGAdmin to administrate my databases. I created a new user named "zx". CREATE ROLE zx LOGIN ENCRYPTED PASSWORD '*' NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE; When I want to manually assign this user to a table, I have problem in the PGAdmin's Privil

[GENERAL] PGAdmin and records as inserts (like in SQLyog)

Hi! I wanna ask, that have the PGAdmin same possibility (like in SQLyog) to copy records (from the Query, from the Table View) to clipboard in the "INSERT SQL" format? This can speed up the work, and I can insert the record to another table that have similar (but a little different) format

Re: [GENERAL] PGSQL or other DB?

Hi! 2009.01.31. 10:13 keltezéssel, Erik Jones írta: On Jan 30, 2009, at 11:37 AM, durumdara wrote: The main viewpoints: - quick (re)connect - because mod_python basically not store the database connections persistently mod_python is not a database adaptor. Yes, I know. But because of

[GENERAL] PGSQL or other DB?

Dear PG Users! I don't want to make a heated debate

[GENERAL] Can I separate my Databases as in FireBird? Working with DataBases...

Hi! I came from SQLite, FireBird and DBISAM world. These database systems have a speciality that they stores one database in one file, or in one directory. Each of databases have separated file (or dir with files), and when I want to copy a database, I have MORE possibility to do this. First solu