[GENERAL] Getting sequence name for a non-serial column

Hi, I've read several solutions to get the sequence name for a field defined as serial by create/alter table, but when I define a default expression (e.g. like next_val('foo_seq') ) for an integer column pg_depend will not contain information to describe this relation. Is there a backward compa

Re: [GENERAL] Database schema & data synchronizer software for PostgreSQL?

>-Original Message- >From: David Fetter [mailto:da...@fetter.org] >Sent: Tuesday, January 20, 2009 4:44 PM >To: Csaba Együd >Cc: pgsql-general@postgresql.org >Subject: Re: [GENERAL] Database schema & data synchronizer software for >PostgreSQL? > >On Tue, Jan 20, 2009 at 03:03:33PM +0100, Cs

Re: [GENERAL] Database schema & data synchronizer software for PostgreSQL?

>-Original Message- >From: Robert Treat [mailto:xzi...@users.sourceforge.net] >Sent: Wednesday, January 21, 2009 3:51 AM >To: pgsql-general@postgresql.org >Cc: David Fetter; Csaba Együd >Subject: Re: [GENERAL] Database schema & data synchronizer software for >PostgreSQL? > >On Tuesday 20 Ja

Re: [GENERAL] Database schema & data synchronizer software for PostgreSQL?

>dbsolo does a decent job. >I think they main thing here is to check for inconsistencies and see >what they are, rather >then a tool that takes over the administrative task. > >We all understand David's point of view, but it can't hurt to have a >tool in place that can verify the consistency of bot

[GENERAL] Best practices: Handling Daylight-saving time

Hi All, I'd like to ask your opininon about how to handle DST on an 7/24 system. Where should it be handled: on the server side or on the client side? And how could I (at all could I???) make it transparent? Or we must bow to the fact that twice a year there are two unusable hours? If it cannot b

[GENERAL] Where to find translation of Postgres error messages?

Hi, I'd like to use a Postgres 8 server from different locales (english, german, hungarian, etc.). I can implement gettext into my client application so the only thing i'd need (at least I think so) is a .po (or an .mo) file for each locale. I looked into Postgres installation directories and fou

Re: [GENERAL] Where to find translation of Postgres error messages?

nd no such lines. I also tried to search for portions of the message. No result. :( What should I do? Regards, -- Csaba Együd -Original Message- From: John DeSoi [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 1:45 PM To: Együd Csaba Cc: pgsql-general@postgresql.org S

FW: [GENERAL] Where to find translation of Postgres error messages?

-Original Message- From: Együd Csaba [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 4:31 PM To: 'Tom Lane' Subject: RE: [GENERAL] Where to find translation of Postgres error messages? Ah, I see. OK. So there are two ways of mine: 1. to translate myself the whol

[GENERAL] PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps

Hi, there is a very intensively used database. The "usage" means that there are many-many changes in it. It is 24/7 application. One table is used to insert 200+ rows per minute from a datacolletor driver application. 200+ deletions are also performed on the same table. It is very very important

Re: [GENERAL] PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM

sults. Thank you very much. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 10:45 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps =?iso-8859-2?Q?Egy=FCd_

[GENERAL] Strange Create function behavior

Hi, I tried to "create or replace" a function via PGAdmin3. The first line immediatelly after the begin keyword was a comment line (--X). The Function did not create at all - with no error messages or similar, just did nothing. Removing the comment from the first line the function was create

[GENERAL] How to set an expiration date for a WHOLE user account

Hi, I'm wonder how I can disable a user (without droping of course). Is there a way to set an expiration date to prevent logins after that date? I know the VALID UNTIL clause of CREATE USER command, but it is about the password only. I think something similar but regarding the whole user account.

Re: [GENERAL] PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM

Hi, thank you very much for suggestions. It seems to be OK. I set the FSM related variables 200 times higher then the default values. The database has been working stable for 3 days. Just as before, when the databas was empty. BTW, isn't it too high to increase these values to 200 times higher?

Re: [GENERAL] Making the DB secure

secure. Thank you, -- Csaba -Original Message- From: Sean Davis [mailto:[EMAIL PROTECTED] Sent: Friday, June 17, 2005 3:09 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Making the DB secure On Jun 17, 2005, at 8:49 AM, Együd Csaba wrote: > Hi, > we p

Re: [GENERAL] Making the DB secure

you think we need VPN or other enhancement? Bye, -- Csaba -Original Message- From: Karl O. Pinc [mailto:[EMAIL PROTECTED] Sent: Saturday, June 18, 2005 12:23 AM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Making the DB secure On 06/17/2005 07:49:07 AM, Együd

Re: [GENERAL] Making the DB secure

provides some functions regarding this. Where to serch for more info? How thay name this feature? Many thanks, -- Csaba -Original Message- From: hubert depesz lubaczewski [mailto:[EMAIL PROTECTED] Sent: Monday, June 20, 2005 7:58 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject

Re: [GENERAL] Making the DB secure

. The clients will run Windows XP. Are Windows based clients able to cooperate with these kind of Linux servers? Thanks, -- Csaba -Original Message- From: Karl O. Pinc [mailto:[EMAIL PROTECTED] Sent: Monday, June 20, 2005 8:51 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject

[GENERAL] How to DES encrypt/decrypt strings from PL/pgSQL

Hi, I'd like to encrypt/decrypt a given string from a stored procedure. The encryption method is DES. Is there any way to do such? Thank you, Csaba -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 2005.08.18.

Re: [GENERAL] How to DES encrypt/decrypt strings from PL/pgSQL

Thank you very much. -- Csaba -Original Message- From: Tino Wildenhain [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 1:34 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to DES encrypt/decrypt strings from PL/pgSQL Együd Csaba schrieb: >

[GENERAL] Error restoring bytea from dump

Hi, the restoration of a dump stops at the line above. The dump was created with pgsql 7.3.2 and I need to pump it into a 7.4.3 one. Should anybody tell me what the problem can be and how I can solve it. (There are double apostophes [''] many times in the string - is it normal??? Besides of the f

[GENERAL] Postgres8 win2k server autovacuum

Hi, is it possibile to use an autovacuum feature on the win32 platform? Or should I write a service application (or use the at service) to run vacuumdb regularly? thank you, -- Csaba Együd --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Vers

[GENERAL] Posgres8 beta5 on WinXP won't start

Hi, Before anything I'm very sorry for sending that "RTFM" style question about pg_autovacuum. I found it, but I couldn't try it out... I faced a problem starting the postgres service. After installation everything had gone well until I started pg_autovacuum.exe. I do not think that something is

[GENERAL] Sheduler in Postgres

Hi, I should schedule the execution of several stored procedures. Now I use an NT service for this, but as far as I know e.g. the Oracle has such a thing. It would be great if I could fire procedures on a timer basis. Is there a better solution for this than mine? Many thanks, -- Csaba --- O

Re: [GENERAL] Scheduler in Postgres

TED] Sent: Friday, December 10, 2004 11:29 PM To: Együd Csaba Cc: '[EMAIL PROTECTED]' Subject: Re: [GENERAL] Sheduler in Postgres cron works pretty well in unix. Scheduled tasks on windows have, in my experience, been on the flakey side. On Tue, 7 Dec 2004, [iso-8859-2] Együd Csaba wrot

[GENERAL] Deadlock detected during vacuum analyze

Hi, one more question: how can I set up vaccum handling in postgres to make it less agressive? I'm faceing a problem where a batch process (inserting 184 records at once which takes 1 second in normal cases) stops because of a dead lock. This occures (seemingly) only when a vacuum analyze is runnin

[GENERAL] Insufficient memory for this operation.

(WinXP, PG8b5, 1GB, 3,2GHz) Hi, I regulary get the above error message when I run my applications in parallel. There are minimum of 5 applications which have to access the server in parallel, but in the production environment this number will about 30-50 (with the additional clients). Each of th

[GENERAL] PG8 final when

Dear Developers, when do you plan to announce the final version of 8.0.0? As far as I can remember it was promised by 15. dec. No hurrying, just would like to know. I should install it on the site and thougt I wait for the final version. many thaks, -- Csaba --- Outgoing mail is certified Virus

Re: [GENERAL] PG8 final when

oaldo Pinto [mailto:[EMAIL PROTECTED] Sent: Sunday, December 19, 2004 3:24 PM To: Együd Csaba; [EMAIL PROTECTED] Subject: Re: [GENERAL] PG8 final when --- Együd Csaba <[EMAIL PROTECTED]> escreveu: > Dear Developers, > when do you plan to announce the final version of 8.0.0? As far as

[GENERAL] Strange Index behavior

Hi, Is it a normal behavior that if I give a where clause with an existent index key, then postgres uses the index, but if I give it a non existent value than it refuses to use the index. An example to make it more clear: CREATE TABLE measured_1 ( tstamp timestamp(0) NOT NULL, meterid int4 NO

Re: [GENERAL] Strange Index behavior

width=38) (actual time=0.000..140.000 rows=18424 loops=1)" " Index Cond: ((tstamp >= '2004-12-22 13:00:00'::timestamp without time zone) AND (tstamp <= '2004-12-22 23:59:00'::timestamp without time zone))" "Total runtime: 200.000 ms" Tom and Martij

[GENERAL] Very slow stored proc

Hi, I have a stored proc which is for filling 2 tables with empty rows in every minutes. If the server has been stopped for more then 3 hours the insertion takes too much. I switched off the insert execution, and debugged the proc and realized that the loop increasing the timestamp takes so long.

[GENERAL] pgsqlODBC problems

Hi, I need some information regarding pgsqlODBC driver on Windows2000. We use an application which inserts records pallely into an SQL database via ODBC. It estableshes 16 pallel connections and continously inserts data. The software works well on a test environment with MS Access and MS ODBC driv

[GENERAL] Any function for calculating inersect of intervals?

Hi, wondering if exists any functions which aim to calculate intersect of two intervals. E.g. I have four dates (D1, D2, D3, D4) and I want to know if (D1,D2) intersects (D3,D4) or not. I konw that it can be done by comparing the dates (>=,<=), but I'm wonder if I can do it simpler and shorter.

Re: [GENERAL] Any function for calculating inersect of intervals?

Thank you Tom. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, January 17, 2005 5:37 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Any function for calculating inersect of intervals? =?iso-8859-2?Q?Egy=FCd_Csaba?= <[EM

[GENERAL] Best practices - permission handling

Hi All, I'd like to ask some help on finding out which is the best way to automatically give permissions for users to access database objects. I try to plan a system where there are users who are sorted into groups (mirror of the orgaization). The groups should have permissions for functionaliti

[GENERAL] Howto determin the number of elemnts of an array

Hi, how can I determin the number of elements of an array? I saw function array_dims() which returns a string value representing the dimensions of the array. Is there a function which returns only the number of elements as an integer. -- Csaba -- No virus found in this outgoing message. Checke

Re: [GENERAL] Howto determin the number of elemnts of an array

Message- From: Sven Willenberger [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 4:27 PM To: pgsql-general@postgresql.org Cc: Együd Csaba Subject: Re: [GENERAL] Howto determin the number of elemnts of an array Együd Csaba wrote: > Hi, > how can I determin the number of elements

Re: [GENERAL] Howto determin the number of elemnts of an array

day, January 31, 2005 4:27 PM > To: pgsql-general@postgresql.org > Cc: Együd Csaba > Subject: Re: [GENERAL] Howto determin the number of elemnts of an > array > > > > Együd Csaba wrote: >> Hi, >> how can I determin the number of elements of an array? I saw functio

Re: [GENERAL] Howto determin the number of elemnts of an array

riginal Message- From: PFC [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 8:48 PM To: Együd Csaba; 'Sven Willenberger'; pgsql-general@postgresql.org Subject: Re: [GENERAL] Howto determin the number of elemnts of an array contrib/intarray On Mon, 31 Jan 2005 20

[GENERAL] Any functions to convert bit(5) to text?

Hi, I use pg8 and ZeosLib 6.5.1. Zeos can't read fields type of array and bit, so I need to convert these fields to text on the server side. In case of arrays I can use array_to_string(), but I couldn't find any functions to convert bit(*) to string (in a format like this: e.g. '10011'). Could

Re: [GENERAL] Any functions to convert bit(5) to text?

Hi Michael, at the first glance it seems to be perfect. In addition it works even for arrays. Wow! :) Thank you very much, -- Csaba -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Thursday, February 10, 2005 8:32 AM To: Együd Csaba Cc: pgsql-general@postgresql.org

[GENERAL] Syntax Error in COPY

Hi, could anybody help me? The backend (8.0) complains about the syntax of the following command. (This row is from a dump created by pgadmin 1.4, using pg_dump.exe v8.0.0.5017) The syntax error is located at the first 'DE' after the stdin;. What's the problem? COPY eden_countries (countrycod

Re: [GENERAL] Syntax Error in COPY

25, 2005 5:31 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Syntax Error in COPY On 11/25/05, Együd Csaba <[EMAIL PROTECTED]> wrote: > Hi, > could anybody help me? > > The backend (8.0) complains about the syntax of the following command. > (This

Re: [GENERAL] Syntax Error in COPY

[mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 5:50 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Syntax Error in COPY On 11/25/05, Együd Csaba <[EMAIL PROTECTED]> wrote: > Source machine: FC4 + Pg8.0.3 (dumped out from) Target machine: WinXP > SP

[GENERAL] GRANT question

Hi, As a superuser I created a normal user: CREATE USER probauser NOCREATEDB NOCREATEUSER; ALTER GROUP eden_users ADD USER probauser; a function: CREATE OR REPLACE FUNCTION edenproc_usesysid(text) RETURNS int4 AS . -- Note that the owner of this

Re: [GENERAL] GRANT question

ath; search_path -- $user,public (1 row) What else could cause this problem? -- csaba -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Saturday, November 26, 2005 5:29 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] GRANT quest

Re: [GENERAL] GRANT question

moson.gdb (1 row) -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Saturday, November 26, 2005 6:28 PM To: Együd Csaba Cc: 'Tom Lane'; pgsql-general@postgresql.org Subject: Re: [GENERAL] GRANT question On Sat, Nov 26, 2005 at 06:13:21PM +0100, Egyd

Re: [GENERAL] GRANT question

, November 27, 2005 12:07 AM To: Michael Fuhr Cc: Együd Csaba; pgsql-general@postgresql.org Subject: Re: [GENERAL] GRANT question Michael Fuhr <[EMAIL PROTECTED]> writes: > Oops, I forgot that \df uses pg_function_is_visible(), so it won't > show functions that aren't in your searc

[GENERAL] Login limitation?

Hi All, I'd like to know if there is a method to let a user login into only predefined databases? I know that I could edit pg_hba.conf to achive this, but - there will be many databases on the server with the same structure but with different data - there will be "local admins" who must be able t

Re: [GENERAL] Login limitation?

Hi Jim, so IIUC, I will have to schedule a program on the server which reads all user information and if a new user is added it modifies the pg_hba.conf and reloads the server? thanks, -- csaba -Original Message- From: Jim C. Nasby [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29,

Re: [GENERAL] Login limitation?

I see. Thank you very much. -- csaba -Original Message- From: Jim C. Nasby [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 10:48 PM To: Egy?d Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Login limitation? Yes, that's probably true. Depending on your pain you

[GENERAL] Error Starting postmaster.exe (8.1.2-1) on XP - GPF

Hi, I can't start potmaster on XP. After the installation it started and I were able to reload the modified conf file. But after a reboot the postmaster.exe generated a GPF and won't start anymore. I tried to restore the original conf file but no success. Any idea? thanks, -- Csaba -- No

[GENERAL] importing Npgsql provider into VS2005Express

Hi All, does anybody have experiences importing npgsql support into VS2005 express edition? I mean the built in database support in the gui. I try to add a new datasource but I cant see a Postgres provider. Neither the ODBC connection works (no tables, views etc.). I would prefer the .net way. Th

[GENERAL] Moving the database from a filesystem to another

/var/lib/pgsql/data to eg. /data/pgsql/data and set $PGDATA to that directory? Thank you, -- Együd Csaba ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes d

[GENERAL] ERROR: cache lookup for type 0 of ... pg.dropped.14........ failed

Hi All, I run into an error message. I have the following function where t_stockchanges is one of my tables. create or replace function get_last_open(int, int) returns setof t_stockchanges AS ' declare ProductID alias for $1; StockID alias for $2;

[GENERAL] What does count(*) count?

Hi all, I tried to dump out a single table and just for a verification I counted the number of 'INERT INTO' rows. I found that count(*) results less rows than grep. *** [EMAIL PROTECTED] ~ $ pg_dump -d -t t_stockchanges alumil6 > sc.dump *** alumil6=# select count

Re: [GENERAL] What does count(*) count?

Hi Tom, > Another possibility is that t_stockchanges has child table(s). Your > SELECT would count rows in the child tables, but I don't think that That's the case. I tried to copy the content of t_stockchanges table into a temp table. Being very lazy:) I created the temp table using create tabl

Re: [GENERAL] Query performance question on a large table

Hi Tom, thank you, I'll upgrade as soon as I can. Anyway I've already planned to do so for a while. I'll keep in mind your remarks concerning the DISTINCT clause too. Bye and Best Regards, -- Csaba > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Tom La

[GENERAL] Using regular expressions in LIKE

re adate LIKE "2004.01.10 __:(30/15)" ... which means that I need only those rows which has an "adate" field holding dates on 2004.01.10 every 30 or 15 minutes at the end. Is it possible to use some regular expressions or is it worth at all talking about? thanks, -- Csaba

Re: [GENERAL] Using regular expressions in LIKE

ions-matchi > ng.html#FUNCTI > ONS-POSIX-REGEXP > > Terry Fielder > Manager Software Development and Deployment > Great Gulf Homes / Ashton Woods Homes > [EMAIL PROTECTED] > Fax: (416) 441-9085 > > > > -Original Message- > > From: [EMAIL PROTECTED] >

[GENERAL] How to kick out automatically stuck in queries

Hi All, I'm wonder if there is any possibility to kick out automatically stuck in queries after say 10 minutes or so? I mean some kind of queries which calls eg. buggy functions with dead loops or something similar. Time to time I face such kind of problems which are solved automatically after some

Re: [GENERAL] How to kick out automatically stuck in queries

Ahh! Thanks Kris! That works! -- Csaba > -Original Message- > From: Kris Jurka [mailto:[EMAIL PROTECTED] > Sent: 2004. február 2. 10:14 > To: Együd Csaba > Cc: [EMAIL PROTECTED] (E-mail) > Subject: Re: [GENERAL] How to kick out automatically stuck in queries > >

[GENERAL] Storing images in a field

Hi All, I use PG 7.3.2 an 7.4.1 on RH 7.1. I'd like to store small (~ 100x100 px jpeg, or gif) images in a field in binary format. I tried to understand the documentation of the large objects but I'm afraid I coluldn't. I found some functions to import and export binary files into the db, but these

Re: [GENERAL] Removing OIDs without recreate

cygwin/7.3.4 The doc contains the option but doesn't work - at least for me. --Csaba > -Original Message- > From: Karel Zak [mailto:[EMAIL PROTECTED] > Sent: 2004. május 7. 13:48 > To: Együd Csaba > Cc: '[EMAIL PROTECTED] (E-mail)' > Subject: Re: [GENERA

Re: [GENERAL] Removing OIDs without recreate

OTECTED] > Sent: 2004. május 7. 14:06 > To: Együd Csaba > Cc: '[EMAIL PROTECTED] (E-mail)' > Subject: Re: [GENERAL] Removing OIDs without recreate > > > On Fri, May 07, 2004 at 01:59:39PM +0200, Együd Csaba wrote: > > cygwin/7.3.4 > > The doc c

Re: [GENERAL] pg_dump, bytea, dump order questions

ROTECTED] > Cc: '[EMAIL PROTECTED] (E-mail)' > Subject: Re: [GENERAL] pg_dump, bytea, dump order questions > > > Együd Csaba wrote: > > > Hi, > > answering partially my questions the first problem is > actualy solved. My > > text editor inserted a linebr

Re: [GENERAL] Trigger isn't fired

es. :) Now the trigger does its task. Thank you very much. Best regards, -- Csaba Együd > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Stephan Szabo > Sent: 2004. június 26. 22:32 > To: Együd Csaba > Cc: [EMAIL PROTECTED] (E-m

Re: [GENERAL] Trigger isn't fired

half Of Harald Fuchs > Sent: 2004. június 27. 12:12 > To: [EMAIL PROTECTED] > Subject: Re: [GENERAL] Trigger isn't fired > > > In article <[EMAIL PROTECTED]>, > Együd Csaba <[EMAIL PROTECTED]> writes: > > > Hi Stephan, > > it was the problem, but

Re: [GENERAL] Performance problem on RH7.1

hing wrong. Thank you all. Best regards, -- Csaba Együd > -Original Message- > From: Alvaro Herrera [mailto:[EMAIL PROTECTED] > Sent: 2004. június 27. 3:38 > To: Együd Csaba > Cc: [EMAIL PROTECTED] (E-mail) > Subject: Re: [GENERAL] Performance problem on RH7.1 > > &g

Re: [GENERAL] Performance problem on RH7.1

> The major time sink is clearly here: > > > -> Index Scan using t_stockchanges_fullindex on > t_stockchanges > > (cost=0.00..28.74 rows=7 width=46) > > (actual time=0.14..9.03 rows=6 loops=1) > >Index Cond: ((date <= '2004.06.28'::bpchar) > AND (stockid = 1)

Re: [GENERAL] Performance problem on RH7.1

Hi Tom, I did the modifications you suggested on the t_stockchanges_fullindex and the result tells everthing: - explain analyze select date,time from t_stockchanges where stockid='1' and productid='234' and date<='2004.06.29' and changeid=1 order by stockid, productid, changeid, date, time

Re: [GENERAL] Performance problem on RH7.1

Hi Tom, > Good, but you're not there yet --- the Sort step shouldn't be there at > all. You've still got some inconsistency between the ORDER BY and the > index. Check my example again. yes yes I missed that, sorry. Now don't mention the performance because I couldn' see anything but the result.

Re: [GENERAL] Performance problem on RH7.1

Hi, > Generally you want '=' conditions on the leftmost index keys; any > inequality or range constraint should be on the rightmost > keys. You can see this by thinking about the range of index entries that > the scan will have to pass over. I see. Just like in your earlier example, where you red

[GENERAL] Modifying users password in pg_shadow from php

Hi All, I'm wonder if there is any possibility to modify a users password by updating the pg_shadow table. I'd like to ensure that when the user modifies his/her http password (htpasswd) than his database password also changes. It is important to have the same password for both services. I plan to

[GENERAL] Getting one row for each subquery row...?

adding comments to a tableHi All, here are my three tables. I wold like to list them in the following way: I need all the columns from t_stockchanges, and one field for the pgoductgroup the t_stockchanges.productid belongs to. But one product can belong to many group, so i would need one row for e

[GENERAL] Stored Proc error after modifying field type

Hi, I've a problem with some of my stored procs. My config is: RH7.1, Postgres 7.3.2 I had converted a few fields of a few tables from one type to another and after this I made all the necessary changes on the functions and recreated all my types and functions. It seemd to be all right, but the ne

[GENERAL] Fw: Stored Proc error after modifying field type

> Hi, > I've a problem with some of my stored procs. My config is: RH7.1, Postgres > 7.3.2 > > I had converted a few fields of a few tables from one type to another and > after this I made all the necessary changes on the functions and recreated > all my types and functions. > It seemd to be all ri

Re: [GENERAL] Stored Proc error after modifying field type

- -- This trace is provided by the psqlODBC driver. Can you find anything in this log, which can cause the error? Thank you, -- Csaba - Original Message - From: "Tom Lane" <[EMA

Re: [GENERAL] Stored Proc error after modifying field type

Sorry for posting many times! -- Csaba --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 2003. 06. 18. ---(end of broadcast)--- TIP 9: the p

Re: [GENERAL] Stored Proc error after modifying field type

I had set the "Int8 As numeric" option before converting my fields. Anyway, I subscript pgsql-odbc list. Thank you very much. -- Csaba - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Együd Csaba" <[EMAIL PROTECTED]> Cc: <[E

Re: [GENERAL] Stored Proc error after modifying field type

Tom, what do you think about the folowing: I updated the server field of my DSN to point to the postgres runniong under cygwin on the localhost. The error does not appear at all. -- 1 06:29:42 SQL Prepare: PostgreSQL - { call "addincominginvoice" (?,?,?,?,?,?

Re: [GENERAL] drop function all - ?

uch a flexible DBMS like Postgres. Best Regards -- Csaba - Original Message - From: "elein" <[EMAIL PROTECTED]> To: "Együd Csaba" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, July 13, 2003 10:44 PM Subject: Re: [GENERAL] drop function

Re: [GENERAL] drop function all - ?

quirement which could make it more popular. Best Regards, -- Csaba - Original Message - From: "Robert Treat" <[EMAIL PROTECTED]> To: "Együd Csaba" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 14, 2003 10:53 P

Re: [GENERAL] cannot open multi-query plan as cursor

Tom, I 'raise notice'd the whole query by the function (which was quoted in my previous letter). Actually I generate the query on the fly according to the given parameters. I call it in a for R in execute Query statement. As the function is a bit long I quote only a portion of it. FieldLi

[GENERAL] How to delete unclosed connections?

t option should do this. Aren't I right? Tank you in advance. Best Regards, -- Együd Csaba --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.522 / Virus Database: 320 - Release Date: 2003. 09. 29.

Re: [GENERAL] Best practices: Handling Daylight-saving time

After a few days of working on the problem I can state that - IMHO - this is the best way: Using UTC (or any other timezone) with NO DST (this is the most important) is the only reliable way to store continous data. On the client we can convert the server time easily to local time. Even if the s

Re: [GENERAL] Error restoring bytea from dump

Hi there, isn't there any idea? :((( -- Csaba Együd -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Együd Csaba Sent: Monday, October 25, 2004 10:44 PM To: '[EMAIL PROTECTED]' Subject: [GENERAL] Error restoring bytea from dump Hi, the r

Re: [GENERAL] Error restoring bytea from dump

, 2004 at 08:51:31PM +0200, Együd Csaba wrote: > > the restoration of a dump stops at the line above. What line above? Are you referring to "Error restoring bytea" in the subject header? Is that the *exact* error message? > The dump was created with pgsql 7.3.2 and I need to pump

Re: [GENERAL] Error restoring bytea from dump

- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr Sent: Tuesday, October 26, 2004 10:05 PM To: Egy?d Csaba (Freemail) Cc: '[EMAIL PROTECTED]' Subject: Re: [GENERAL] Error restoring bytea from dump On Tue, Oct 26, 2004 at 08:51:31PM +0200, Együd Csaba wrot

Re: [GENERAL] Sheduler in Postgres

rld rejoiced as [EMAIL PROTECTED] (Együd Csaba) wrote: > Hi, I should schedule the execution of several stored procedures. Now > I use an NT service for this, but as far as I know e.g. the Oracle has > such a thing. It would be great if I could fire procedures on a timer > basis. > &g

Re: [GENERAL] Insufficient memory for this operation.

D. If you have a problem, you can be sure, that the problem is somewhere else ... Should avoid using BDE?... Maybe. Bye, -- Csaba -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Együd Csaba Sent: Tuesday, December 14, 2004 9:50 AM To: [EMAIL PROTECTED] Su

Re: [GENERAL] Insufficient memory for this operation.

Sent: Tuesday, December 14, 2004 6:25 PM To: [EMAIL PROTECTED] Subject: Re: [GENERAL] Insufficient memory for this operation. Együd Csaba (Freemail) <[EMAIL PROTECTED]> writes: > shared_buffers = 2 # min 16, at least max_connections*2, 8KB each You can lower this to 10,000

Re: [GENERAL] PG8 final when

ECTED] Subject: Re: [GENERAL] PG8 final when On Mon, 20 Dec 2004 14:13:40 +0100, Együd Csaba <[EMAIL PROTECTED]> wrote: > Hi, > as far as I can remember I somewhere read an article - maybe somwhere > on a dbforum or the postgresql.org - which stated that after the RC1 > the fi

Re: [GENERAL] PG8 final when

OK, now I am well informed. Thank you. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Browne Sent: Monday, December 20, 2004 3:06 PM To: [EMAIL PROTECTED] Subject: Re: [GENERAL] PG8 final when The world rejoiced as [EMAIL PROTECTED] (Együd

Re: [GENERAL] Strange Index behavior

-- Csaba -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: Wednesday, December 22, 2004 5:47 PM To: Együd Csaba Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Strange Index behavior =?iso-8859-2?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes: >

Re: [GENERAL] Strange Index behavior

r way... -- Csaba -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 6:34 PM To: Együd Csaba (Freemail) Cc: 'Együd Csaba'; pgsql-general@postgresql.org Subject: Re: [GENERAL] Strange Index behavior =?iso-8859-2?Q?Egy=FCd_Csaba

Re: [GENERAL] Very slow stored proc

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Együd Csaba Sent: Thursday, December 23, 2004 8:01 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Very slow stored proc Hi, I have a stored proc which is for filling 2 tables with empty rows in every minutes. If the server has

Re: [GENERAL] Very slow stored proc

Dear Alvarao, would you please so kind explaining me your opinion in details. thanks, -- Csaba -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alvaro Herrera Sent: Thursday, December 23, 2004 3:58 PM To: Együd Csaba (Freemail) Cc: pgsql-general

Re: [GENERAL] Very slow stored proc

-Original Message- From: Alvaro Herrera [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 11:12 PM To: Együd Csaba (Freemail) Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Very slow stored proc On Thu, Dec 23, 2004 at 09:48:56PM +0100, Együd Csaba (Freemail) wrote: Hi

Re: [GENERAL] Any function for calculating inersect of intervals?

Thak you Alban, Tom's solution (OVERLAPS) is the best for me. bye, -- Csaba -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alban Hertroys Sent: Monday, January 17, 2005 5:49 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL

  1   2   >