No, I didn't, I'm just courious.
Regards,
Zlatko
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Sunday, July 22, 2007 5:41 AM
Subject: Re: [GENERAL] encodings
On Sat, Jul 21, 2007 at 10:24:38PM
Hello.
If I have an UTF8 database, dump it and the restore as WIN1250 database, then
dump it again and restore as UTF8, would structure of the database (schema) be
exactly the same as initial database, or something will change in the process?
In other words, does encoding influence only data
Is it possible to have few independant PostgreSQL 8.2 installations on the same
PC, WIndows XP?
Thanks,
Zlatko
Message -
From: Anoo Sivadasan Pillai
To: Zlatko Matić
Cc: pgsql-general@postgresql.org
Sent: Friday, July 20, 2007 8:40 AM
Subject: Re: [GENERAL] several postgres installations on the same machine?
If you mean multiple instances, Then it can be.
Have a look on Pauls personal Blog
Hello.
I use following statements for temporarily disable triggers and enable them
again:
--Disable triggers.
UPDATE pg_class SET reltriggers = 0 WHERE relname = 'orders';
--Enable triggers.
UPDATE pg_class SET reltriggers = (
SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid)
tried to find that postgres.bki file, but it seems it doesn't exist.
What now?
Regards,
Zlatko
- Original Message -
From: Anoo Sivadasan Pillai
To: Zlatko Matić
Cc: pgsql-general@postgresql.org
Sent: Friday, July 20, 2007 8:40 AM
Subject: Re: [GENERAL] several postgres
Hello.
Is there any way to hide database structure (at least functions and triggers)
from a superuser/administrator?
Regards,
Zlatko
I have a plpgsql function that returns dataset.
First it was defined to return SETOF someview.
Then I changed it to return SETOF RECORD, in order to be able to return dataset
with varying number of columns.
But, I get the following error:ERROR: a column definition list is required for
functions
OK. Thanks.
Regards,
Zlatko
- Original Message -
From: Pavel Stehule [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Tuesday, July 17, 2007 12:14 PM
Subject: Re: [GENERAL] ERROR: a column definition list is required for
functions returning
What authorizations are needed for the following statement:
UPDATE pg_class SET reltriggers = 0 WHERE relname = 'orders'; ?
Hello, Tom.
I don't understand relation between constraints and indexes.
By using EMS PostgreSQL Manager Lite, I created indexes on columns, some of
them are unique values.
But when I open it in PgAdmin, all such unique indexes are listed as
constraints and there are no indexes in Indexes
When using multirow INSERT INTO...VALUES command, are all rows inserted in a
batch, or row by row?
Regards,
Zlatko
Thank you for the answer.
At least I'm glad it is possible!
But , as I don't know Perl, could you, please, tell me how to accomplish it
in plpgsql.
Thanks,
Zlatko
- Original Message -
From: Greg Sabino Mullane [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Saturday, July
Is there any free program that can
graphically/schematically display relations between all tables in a database?
Regards,
Zlatko
Does anybody has a clue?
Somebody experienced similar problem?
Should I be logged to Windows as regular user
(administrator) or as "postgres" service account?
Thanks.
- Original Message -
From:
Zlatko Matić
To: pgsql-general@postgresql.org
Sent: Tuesday, Se
first and then install new version of the server. I don't want to uninstall
the server this time
Zlatko
- Original Message -
From: Scott Marlowe [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql general pgsql-general@postgresql.org
Sent: Tuesday, September 05, 2006 7
test
In Windows XP Pro (SP2) I tried to upgrade
PostgreSQL server from 8.1.2 to 8.1.4., by using upgrade.bat. Everything
goes nice until end of installation when the following error apears:
"Service 'PostgreSQL Database Server 8.1' (pgsql-8.1) could not be
installed. Verify that you have
OK. Thanks for clarification.
- Original Message -
From: Doug McNaught [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org; Tony Caduto
[EMAIL PROTECTED]
Sent: Sunday, January 22, 2006 2:39 PM
Subject: Re: [GENERAL] numeric data type?
Zlatko Matić
exact. Am I right or I missunderstood?
Thanks,
Zlatko
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Sent: Saturday, January 21, 2006 5:15 PM
Subject: Re: [GENERAL] numeric data type?
Zlatko Matić wrote:
Is numeric data type good choice
Is "numeric" data type good choice for a field that
would store integer values in most cases, but sometimes decimal values as
well?
Thanks,
Zlatko
Is it possible to use temporary tables from MS
Access, as linked tables?
I was not able to link, but maybe someone
succeeded?
Hello.
Is it better to use A) or B) ?
A)
SELECT"public"."departments".*,"public"."plants".*,"public"."batches_microbs".*,"public"."results_microbs".*FROM"public"."departments","public"."plants","public"."batches_microbs","public"."results_microbs"WHERE"plants"."department"
=
In Postgres 8.1.1, Win XP, I tried to create some
temporary tables by using pgAdmin. For example, I executed :
CREATE TEMP TABLE privremena() INHERITS
(plants)WITHOUT OIDSTABLESPACE pg_default;ALTER TABLE privremena
OWNER TO matalab;
Although query was successfully executed, I just
can't
Thanks
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED];
pgsql-general@postgresql.org
Sent: Monday, January 16, 2006 3:01 PM
Subject: Re: [GENERAL] visual query builder for Postgres?
Zlatko Matić wrote:
Is there any visual tool
thanks.
- Original Message -
From:
Michael
Schmidt
To: pgsql-general@postgresql.org ;
Zlatko Matić
Sent: Sunday, January 15, 2006 11:40
PM
Subject: Re: [GENERAL] visual query
builder for Postgres?
A Visual Query Builder is available in PG Lightning
Is there any visual tool for creating queries in
PostgreSQL?
Zlatko
PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, December 29, 2005 6:12 PM
Subject: Re: [GENERAL] POstgreSQL 8.1.X/Lazarus?
Are you running Lazarus on win32 or Linux?(I assume win32 because you
mentioned a dll)
I have successfully used Zeos with Delphi
Hello.
Is there anybody using lazarus with new POstgreSQL 8.1.X ?
I couldn't connect using Zeos, because it seems zeos work only with old
versions of PostgreSQL.
Also, I couldn't connect by using TPSQL, because it can't find libpg.dll
installed (?)...
Regards,
Zlatko
Hello.
Could you, please, help me to optimize my
connection string (MS Access 2003, PostgreSQL 8.1.1. and
psqlodbc-08_01_0102)?
'
PG_ODBC_PARAMETER
ACCESS_PARAMETER'
*'
READONLY
A0'
PROTOCOL
A1'
FAKEOIDINDEX
A2 'A2 must be 0 unless A3=1'
Hello.
I was using psycopg2/Python with Postgres 8.0.4, on
Win XP.
Now, when I installed Postgres 8.1.0 and was trying
to connect with Python/psycopg2, an error occured: "This application has failed
to start because lipq.dl was not found. Re-installing the application may fix
the
What needs to be configured in order autovacuum
processbe active?
Hello.
I had the following function in Postgres 8.0.4 for creation of users inside
existing groups. Now I need to adjust it for new Roles system. What do I
neeed to change?
Especially regarding: CMD := 'CREATE USER ' || l_username || ' WITH
ENCRYPTED PASSWORD ''' || l_password || ''' IN GROUP
Hello.
In Postgres 8.1 I have a message that there is a
missing FROM clause in the following query:
select into
l_validity "rok_valjanosti"."rok_valjanosti" FROM ( SELECT
min("rok_valjanosti"."rv_id") AS "rv_id", "rok_valjanosti"."rok_valjanosti" FROM
"rok_valjanosti" GROUP BY
from it?
Thanks,
Zlatko
- Original Message -
From: Greg Campbell [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, October 21, 2005 5:12 PM
Subject: Re: [ODBC] versions of oDBC driver
Did you changed the Postgresql server
Hello.
Is there any way to check the version of PostgreSQL
by a query? Maybe by querying catalog tables?
Thanks,
Zlatko
When installing pg_autovacuum as Windows service,
should user that makes connection be the service account or a superuser
?
For example, I have service account
"postgres_service" and database superuser "postgres". Which one should be used
in following script:
@echo off
set
Hello,
I was reading release notes for 8.1 and there is
something about changes concerning replacing ::text with ::regclass in default clauses. There is a query in Release
notes,that should be executed to update dump from previos
versions.
But, even without it, I see that all serial
fileds
Hello.
Could someone say which versions of ODBC drivers
are recommended for PostgreSQL/MS Access 2003 combination, for:
a) Postgres 8.0.4
b) Postgres 8.1 beta
Namely, I was not able to connect from my Access
front-end when I migrated from Postgres 8.0.4 to Postgres 8.1
beta3
Arethere
OK. but, is it required that the user is a superuser, owner of tables or
just needs to have select rights on tables?
Thanks,
Zlatko
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: Matthew T. O'Connor matthew@zeut.net; pgsql-general
Hello.
It seems that for all automated tasks (backup,
autovacuum etc.) passwords should be provided by pgpass file.
But, anyone can read pgpass file
How can I make it secure that nobody can read it,
except programs for backup and autovacuum ?
Thanks,
Zlatko
For pg_dump minimum privilages is to have select
right on tables.
For vacuumdb, one must be owner of tables or a
superuser.
What are minimum rights foruser that is
trying to execute pg_autovacuum ?
How can I monitor vacuuming by pg_autovacuum
?
Thanks,
Zlatko
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Tuesday, October 11, 2005 4:00 PM
Subject: Re: [GENERAL] user privilages for executing pg_autovacuum?
Zlatko Matić wrote:
For pg_dump minimum privilages is to have select right on tables.
For vacuumdb, one must be owner
]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Sunday, October 09, 2005 5:37 PM
Subject: Re: [GENERAL] pg_autovacuum
=?iso-8859-2?Q?Zlatko_Mati=E6?= [EMAIL PROTECTED] writes:
How to use pg_autovacuum ?
Read the README file for it.
regards, tom lane
How to use pg_autovacuum
?
Hello.
I downloaded 8.0.4 Windows installer and wanted to
update my previos 8.0.3 installation, by using upgrade.bat.
Unfortunately I was not able to do it. Just before
the end of installation an error apears "Service 'PostgreSQL Database Server
8.0' (pgsql-8.0) could not be installed.
with recordset object...
Thanks,
Zlatko
- Original Message -
From: Greg Campbell [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Tuesday, October 04, 2005 3:34 PM
Subject: Re: [INTERFACES
Hello.
I have the following problem with MS
Access/PostgreSQL combination:
There is a form in Access thathas an unbound
text box, used for entering a commentary of a batch of records.
There is a DAO Append Query that has a parameter
that is passed from the text box using parameter of DAO
thanks.
- Original Message -
From: Magnus Hagander [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED];
pgsql-general@postgresql.org
Sent: Friday, September 30, 2005 12:58 PM
Subject: RE: [GENERAL] installing several PostgreSQL instances on Windows
Hello.
Is it possible to
Hello.
There are some columns in my tables that I should
change from varchar to text, in order to have enough space for long textual
commentaries.
Before I do that, I would like to know is there any
restriction regarding text type in comparison to varchar type?
Especially concerning
Hello.
Is it possible to install several completely
independent instances of PostgreSQL on the same Windows machine?
I'm asking this mostly because I want to have
complete control over my database, which is not possible if there is some other
superuser. Therefore I need dedicated Postgres
Hello.
I have a strange problem when trying to use pg_restore to restore data from
a backup, on WIN XP, PostgreSQL 8.0.3.
If I use PgAdmin it works, but if I copy the command to .bat file
authentication fails although I enter correct password.
The .bat script is the following:
cd D:\Program
Hello.
I will install a database on a remote server. There
is pg_hba.config file that should be adjusted to protect from unauthorized
access. It requires IP adresses.
Now, I would like to be able to connect to the
server from my personal computer, in order to do some maintenance job on the
Hello.
I just read all about TCP/IP, pg_hba.conf,
listen_adresses and similar topics regarding remote TCP/IP
connections,
but where can I find explanations about how to
remotely connect using ODBC andDSN-less connection string.
For example, how to connect to PostgreSQL server
from remote
Hello.
Postgres automatically included some tables in my
public domain:
pg_ts_cfg, pg_ts_cfgmap,pg_ts_dict, pg_ts_parser,
spatial_ref_sys.
I suppose it's because I switched on all
additional optionsduring initdb...
My question regarding those tables iswheter I
candelete them safelyfrom
Could you, please, give me short description of functionalities of those
modules?
I don't know whether I need it, because I don't know what is the purpose of
those tables...
- Original Message -
From: Magnus Hagander [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED];
pgsql
OK.thanks...I suppose I don't need it.
- Original Message -
From: Magnus Hagander [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED];
pgsql-general@postgresql.org
Sent: Saturday, August 06, 2005 9:55 PM
Subject: RE: [GENERAL] tables in public
Could you, please, give me short
Thank you for answer. It seems that %HOMEDRIVE% is just enough to solve this
problem.
Thanks.
- Original Message -
From: Glenn Davy [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, August 04, 2005 12:15 AM
Subject: Re: [GENERAL
Hello.
I would like to install database schema on a server
using files with dumped schema and globals (produced by dumpall), that are
placed on CD. The installation script (batch file)that restores these two
files is also placed on the same CD, (let's say E:) in the same
folder.
cd
Why there is no Unicode as option during initdb. There are some encodings,
but not all alisted in PostgreSQL manual ? How different SQL ASCII is from
Unicode ?
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Hello.
Somone helped me toset properA6
parameter in ODBC connection string, for WIN1250 encoding, as following
CLIENT%5fENCODING%3dWIN1250.
If A6 is blank string, I suppose that ODBC driver
uses default UNICODE ?
Could someone tell me how to set other encodings in
A6 parameter ?
Is there
I performed vacuum freeze instead vacuum full, by
mistake, using PgAdmin.
Is there any danger for my database ?
Zlatko
My template0 and template1 have SQL ASCII encoding,
while I created a database with UNICODE encoding.
Could it cause some conflicts ? If so, how can I
change templates databases to be UNICODE as well ?
. The old 5.x only worked with Delphi. See the
Lazarus forums for more information.
Ben
Zlatko Matić [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi.
Someone mentioned Lazarus as good IDE for working with PostgreSQL, so
that's the reason I started to learn Lazarus...
Now, I
Hi.
Someone mentioned Lazarus as good IDE for working
with PostgreSQL, so that's the reason I started to learn Lazarus...
Now, I was told that I need to install ZEOS library
in order to work with PostgreSQL.
I downloaded the following .zip files:
zeosdbo-5.0.7-beta, zeosctrl-1.0.0-beta. I
I tried to work with postgres temporary tables from
MS Access, but unsuccessfully...
I was able to create temporary table by
pass-through query, also I succeeded in creating linked table through code, but
when I try to open it, an error apears and Access says there is no
schema...
Also, I
MYDB_mm_dd_yy. When you run the little test .bat
script above, you will get:
datestr is 06_30_2005
backup file name is MYDB_06_30_2005
Hope this helps.
Susan
Zlatko Matić
[EMAIL PROTECTED]To:
pgsql-general@postgresql.org
.hr
Hello.
I would
appreciate if someone helps me to resolve this problem about regular backups on
Windows. I have a batch file (.bat)for backup, but don't know how to
include timestamp in backup file name. In this way I allways have only one, the
most recent, backup file. I want Windows to
How could I truncate, delete all content of all
tables in one step ?
Hello!
I have implemented solution for enabling regular
user (from group "ADMINS") to create new users in predefined groups, by your
modified function:
CREATE OR REPLACE FUNCTION "public"."alter_group"
(name, boolean, name, varchar, timestamp) RETURNS boolean
AS$body$DECLARE l_group ALIAS
Great! It works.
Thanks.
- Original Message -
From:
[EMAIL PROTECTED]
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, June 23, 2005 10:18
AM
Subject: Re: [GENERAL] help about the
function
Hi,
Why
not :
Berend,
Thank you for the function code. It helped me a lot!
Regards,
Zlatko
---Original Message---
From: Berend Tober
Date: 06/15/05 18:08:22
To: Zlatko Matić
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] enebling regular user to create new users ?
Zlatko Matić wrote
Thank you very much !
- Original Message -
From: John DeSoi [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Monday, June 20, 2005 3:40 AM
Subject: Re: [GENERAL] user/groups query ?
On Jun 19, 2005, at 3:56 PM, Zlatko Matić wrote:
How
Hello.
How to make a query that will include information
both about user and group (or groups)he belongs to?
Thanks.
How to start pg_dumpall
?
Per-database user, right, that's what I need...hope it will be included in
future releases...
Separating the power to create new users from the power of being superuser,
also. It is very important.
Greetings,
Zlatko
- Original Message -
From: Richard Huxton dev@archonet.com
To: Tom
Done. Thanks.
- Original Message -
From: Sean Davis [EMAIL PROTECTED]
To: Zlatko Mati [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, June 16, 2005 11:51 AM
Subject: Re: [GENERAL] pg_dumpall
See:
http://www.postgresql.org/docs/8.0/static/app-pg-dumpall.html
If you
Hi.
Thank you for information. How can I dump_all from pgAdmin III ?
Thanks.
- Original Message -
From: John DeSoi [EMAIL PROTECTED]
To: Zlatko Mati [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Wednesday, June 15, 2005 1:25 AM
Subject: Re: [GENERAL] user groups
On Jun
Hi.
Concerning Egyd's question, I also wanted to ask about setting expiration
date for database. But, I would like to set validity in sense of certain
actions.
For example, I would like to prevent adding new records after expiration,
but would allow viewing existing records
Is there any
When I create some user group and set permissions
and then dump (backup) database and install on some other computer, what will
happen with groups and permissions? Should they exist on other computers too
?
I don't understand whether permissions to groups
are something that is integrated in
Does anyone have some experience with users
management from MS Access front-end ?
Hi.
I'm forwarding you what I answered to Rolland about it. This #deleted
phenomena is something often, but can be easily solved.
It seems to be common problem with Access connectiong to ODBC data source.
Access has some problems to determine primary key...
You should not use textual fields as
Thanks.
- Original Message -
From: Volkan YAZICI [EMAIL PROTECTED]
To: Zlatko Mati [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED]
Sent: Monday, June 13, 2005 8:47 AM
Subject: Re: [GENERAL] [INTERFACES] retrieving information about password
from MS Access
Hello.
If we have a database with defined user groups,
users and permissions on database objects, what happens when we backup database
(dump) and try to install on some other server ? Does information about user
groups, users and permissions migrate along with database itself or I need to
How could I retrieve information about actual user
password, if md5 method is set in pg_hba.conf ?
I want to create VBA procedure that compares value
in text box with actual password to determine if it is the same. As the password
is encrypted (md5) I can't read it from pg_shaddow system
Hi!In MS
Access/PostgreSQL combination I have login form. After user writes all
neccessary inputs and push the button, a startup procedure creates DSN-less
connection string, receates all linked tables and change connection string
in all pass-through queries. It works nice...But, how to
Hello.
I have a
problem when working with MS Access/PostgreSQL.
Namely,
as PostgreSQL syntax uses doble quotes for table names and field
names,when I write it as a string of a pass-through query or Command text
of ADO Command object it looks like:"select * from
public."Customers""and
87 matches
Mail list logo