-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, Csaba Együd
-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 January
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 both
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
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
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
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
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 to
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
;
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 question
-
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 Csaba wrote:
Regarding the search_path it is the same in both
, 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 search path. Try this:
Or try
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
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 row is from a dump created by pgadmin 1.4, using
[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
SP2. + Pg8.0.0
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.
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:
Hi
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
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
. 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
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?
Dear Sean,
yes, maybe.
But actually I thought some suggestions. The only real problem of mine is to
configure the SSL. I am able configure the pg_hba.conf (at least I think so
now), we have a firewal on the server too.
I meant that maybe somebody can suggest something to make the thing more
Dear Tom, Bruno,
thank you for your reply. Since these parameters
(max_fsm_pages,max_fsm_relations) can be set at server startup, I have to
wait for at least the evening - and plus a few days letting the system going
wrong or better, staying good. :)
I'm going to inform you about the results.
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 created
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
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
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
Hi John,
thank you very much for your suggestion. I downloaded the file (hu.po) and
tried to find the given error message in it (using a text editor) with no
success. There was no e.g. SQL Error: fe_sendauth: no password supplied
lines in the po file. A also searched over the de.po and no such
-Original Message-
From: Egyd 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 whole stuff in my
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 not realy understand the reason.
The documentetion
sais that perform doesn't porvide
.
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
On Sat, Jun 26, 2004 at 12:16:17PM +0200
in such 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 all - ?
You don't keep the SQL for your functions
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 PM
Subject: Re: [GENERAL] drop function all - ?
this seems like
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,
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
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
36 matches
Mail list logo