Hi,
Is Solaris 10
supported platform for pgAdmin III.
If yes, where is the
distribution or what's the way to compile it on Solaris 10.
Thanks
Patrick
---
Patrick Fiche email : [EMAIL PROTECTED] tél :
I wanted to see which tables/transaction have acquired or are waiting for which locks
as far as i know there are two ways to do it
1) pg_locks ::: but we need to continously keep getting data from the table and it also locks lock manager data structures which is not a good thing to do...
Hi,
I've been testing Delphi 2005 with Postgresql 7.4.5, through ZEOS Lib 6.5.1,
and I have a question:
How do you implement an optimistic locking strategy with these tools? With an
Access front-end, and the ODBC driver, this is completely transparent. A test
showed me that the Delphi client w
How can i calculate table and index size on hard disk?
i think there is a bug in the checkpoint warning system.
i had set =>
checkpoint_timeout = 2000
checkpoint_warning = 2100
checkpoint_segments = 256 (for 1st run) and 64 (for 2nd run)
now i ran my test application my Wal-logs in PGDATA/pg_xlog increased by around 1.9 GB while in my log
Hi,
this is an answer of thread
http://archives.postgresql.org/pgsql-general/2003-08/msg00694.php
You say it exist a funktion to fin positions an frequency of lexems for
own calculate of an ranking since this time.
But where is the description of this?
May Im to blind but I spend a lot of time t
got it i think i need to sleep
i forgot each segment is 16 Mb... sorry for buggung u all
himanshuTom Lane <[EMAIL PROTECTED]> wrote:
Himanshu Baweja <[EMAIL PROTECTED]>writes:> i am trying to optimise postgres 8 running on a system is there any way to know how wht should be the valu
Dan Black wrote:
How can i calculate table and index size on hard disk?
See contrib/dbsize in the PostgreSQL source tarball.
-Neil
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Thu, 12 May 2005, Peter Schmelzer wrote:
Hi,
this is an answer of thread
http://archives.postgresql.org/pgsql-general/2003-08/msg00694.php
You say it exist a funktion to fin positions an frequency of lexems for own
calculate of an ranking since this time.
But where is the description of this?
browsing through the archives i came across this::
http://pgfoundry.org/pipermail/testperf-general/2004-December/80.html
which seems to be of the time when bgwriter was in development stage
i need some clarifications..
is there a separate list of dirty buffers and clean buffers...
On Thu, 2005-05-12 at 00:33, Jerome Macaranas wrote:
> On Tuesday 10 May 2005 22:00, Scott Marlowe wrote:
> > On Mon, 2005-05-09 at 23:35, Jerome Macaranas wrote:
> > > i didnt set fsm... the config i paste is all that i put into place...
> >
> > OK, that's likely a part of your problem.
> >
> > Di
Hello !
How can I use stored procedures (functions) with
MS-Access 2002 connected to PostgreSQL 8.0 ?
Best regards.
Luc
Hi,
1) The simplest way to call a function from MS Access is to use a "pass-through
query", like:
SELECT * FROM public."search_article"();
2) If the parameter is/are dynamic, that's more complicated. You have to edit
the query at run-time, like with this kind of code:
Su
> How can I use stored procedures (functions) with MS-Access
> 2002 connected to PostgreSQL 8.0 ?
An alternative to Philippe's solution is to use ADO.
Here is an sample function :
(assuming ActiveX Data Object lib is checked in the Tools/References menu)
Function ADO_PG()
Dim cnn As ADODB.Connec
Hi Philippe,
It still works the same way as the ODBC driver, because of Postgresql's multi
version concurrency.
Zeos uses libpq exactly like the ODBC driver does, except it talks directly to
libpq without the overhead of ODBC, and all
you have to deploy with your app is the super small libpq.dll.
Hi,
Thanks for your answer, but I'm not sure we are talking about the same thing.
What I was used to with MS Access/ODBC/Postgresql, in a multiuser network
scenario, is the following:
- User A loads data in a form
- User B loads the same data in a form.
- Before user A makes changes, B makes hi
Is there any solution to this other than adding memory, or am I
mis-understanding the error?
pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064)
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "table_name" failed:
PQendco
Thanks to both Elein and Tom. pgstattuple (and dbsize) from contrib
gave me exactly what I wanted. The statistics views give me something
extra.
__
Marc
signature.asc
Description: This is a digitally signed message part
Hi everybody,
I'm a PG newbie, and I'm trying to write a function that returns a set of
records.
These records come from 2 or more tables (joined).
When I have only 1 table, the return type of the function can be SETOF
mytable.
When I have 2 tables or more, am I obliged to create a type (CREATE T
[EMAIL PROTECTED] wrote:
> Hi everybody,
>
> I'm a PG newbie, and I'm trying to write a function that returns a
> set of records.
> These records come from 2 or more tables (joined).
>
> When I have only 1 table, the return type of the function can be SETOF
> mytable.
> When I have 2 tables or mo
"Reid Thompson" <[EMAIL PROTECTED]> writes:
> Is there any solution to this other than adding memory, or am I
> mis-understanding the error?
> pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064)
> pg_dump: lost synchronization with server, resetting connection
My bet is that this is act
Why not just add a onenter event handler to the forms field in question and
just check the data before they edit it.
If it's different update the field with the most current data.
Access probably just does something similar under the hood for you.
I don't think that's a feature of the ODBC driver
Tom Lane wrote:
"Jimmie H. Apsey" <[EMAIL PROTECTED]> writes:
At this point, I am unable to do a pg_dump using our new Rec Hat
Enterprise Linux AS 4 version of Postgres which is version 7.4.
Here's what I get when I try to do a pg_dump of our database:
[ ~]$ /usr/bin/pg_dump dcf_2005040
Hi!
On Thu, 12 May 2005 19:19:10 +0200
"Philippe Lang" <[EMAIL PROTECTED]> wrote:
> Thanks for your answer, but I'm not sure we are talking about the
> same thing. What I was used to with MS Access/ODBC/Postgresql, in a
multiuser network scenario, is the following:
>
> - User A loads data in a f
Tom Lane wrote:
> "Reid Thompson" <[EMAIL PROTECTED]> writes:
>> Is there any solution to this other than adding memory, or am I
>> mis-understanding the error?
>
>> pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064)
>> pg_dump: lost synchronization with server, resetting connection
>
Hi Hervé,
You should perhaps use record instead of a particular type.
... RETURNS SETOF record AS ...
Otto
- Original Message -
From: "Hervé Inisan" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 12, 2005 8:31 PM
Subject: [GENERAL] About Types
Hi everybody,
I'm a PG newbie, and I'm trying t
Hello...This is very interesting. I have also asked myself how to prepare
and execute stored procedures on POstgre from MS Access.
Could you, please, give some example of Postgre function with parameters
that is executed as stored procedure from MS Access? How would you pass
parameters ? Using A
On Wed, 2005-05-11 at 12:04 -0400, Tom Lane wrote:
> "Madeleine Theile" <[EMAIL PROTECTED]> writes:
> > After I've dropped one of the superusers that created and thus
> > owns some of the views and reinstalled it again with a different usesysid
>
> So reinstall it with the same usesysid --- that's
Do you know if this program will do forward-engineering.
I would like to be able to take a copy of my live database.
Reverse engineer it into SQLManager, modify it.
Then forward-engineer, do you know if SQLManager allows me to do that?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[
"Madeleine Theile" <[EMAIL PROTECTED]> writes:
> But what if he doesn't? Then the only possibility is to drop all the
> views and recreate them as another user in order to fix the issue with
> the acl rights.
See ALTER OWNER. The intention is to make you give away all the owned
objects before get
On Thu, 2005-05-12 at 16:15 -0400, Tom Lane wrote:
> "Madeleine Theile" <[EMAIL PROTECTED]> writes:
> > But what if he doesn't? Then the only possibility is to drop all the
> > views and recreate them as another user in order to fix the issue with
> > the acl rights.
>
> See ALTER OWNER. The inte
> > This works fine, but I'm trying to avoid building a
> specific type for
> > each row returning function.
> > Is there any other solution (SQL or PLPGSQL)?
>
> Yes, return setof record, look at this site, it helped me a lot.
>
> http://techdocs.postgresql.org/guides/SetReturningFunctions
>
> Hello...This is very interesting. I have also asked myself
> how to prepare and execute stored procedures on POstgre from
> MS Access.
> Could you, please, give some example of Postgre function with
> parameters that is executed as stored procedure from MS
> Access? How would you pass paramet
I was using ADO command object and both refresh method and method with
creating parameter object while working with Access Project...but I didn't
try to use it with PostgreSQL...
I would rather like to have all queries on client side anyway. Therefore I
use pass-through queries. But it doesn't a
Newbie - please help me choose a direction.
I want to know what would be the best front-end app/language to use for
postgresql for exact form replication and ease of use. PHP, Python,
Java, Rekall (the Kompany), other? All suggestions welcome and appreciated.
Background---
I
On May 12, 2005, at 7:06 PM, Kurt Gibson wrote:
One important solution I created in Filemaker Pro requires very
detailed and exact replication of official court forms with database
data entered on the forms. Imagine a form with small type, boxes and
spacing that must be exactly as on the offici
with Filemaker, a database is a table. Each file only has one table
and all layouts/reports/forms and scripts are in the same file. This
setup has pros and cons that are irrelevant now.
I'm not familiar with FileMaker, but my understanding is that it can
communicate with other databases via O
Kurt, you might want to take a look at OpenRPT
(http://pgfoundry.org/projects/openrpt/) - it's a Crystal/Access type report
builder for PostgreSQL that works great on any of the feline Mac products.
We don't do print to PDF yet, however, someone has raised his hand to work on
that with some exis
On Thu, May 12, 2005 at 02:56:35PM -0400, Tom Lane wrote:
> "Reid Thompson" <[EMAIL PROTECTED]> writes:
> > Is there any solution to this other than adding memory, or am I
> > mis-understanding the error?
>
> > pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064)
> > pg_dump: lost synchro
Hi Folks,
I hope that you are well. Don't mean to rush anybody but just curious
as to when the RPMS and SRPMS for 8.0.3 will show up ? Thanks !
Cheers,
Aly.
--
Aly Dharshi
[EMAIL PROTECTED]
"A good speech is like a good dress
that's short enough to be interesti
Though I haven't embarked on any expeditions into the world of printing
yet, I've found Python to be a terrific language for db access. My
solution uses Apple hardware, OSX, postgres, the psycopg programming
interface to Python, Python, and my slowboat hacking with wxPython to
build a GUI fro
On May 12, 2005, at 7:44 PM, John DeSoi wrote:
On May 12, 2005, at 7:06 PM, Kurt Gibson wrote:
One important solution I created in Filemaker Pro requires very
detailed and exact replication of official court forms with database
data entered on the forms. Imagine a form with small type, boxes and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 12 May 2005, Aly Dharshi wrote:
I hope that you are well. Don't mean to rush anybody but just curious
as to when the RPMS and SRPMS for 8.0.3 will show up ? Thanks !
They are already on main FTP site (and its mirrors, if synced).
Regards,
Hello,
I guess I was looking for the x86-64 version, I never bothered to check
whether there were 32 bit ones. Anybody going to create the 64bit RPMS ?
Cheers,
Aly.
Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 12 May 2005, Aly Dharshi wrote:
Hi,
Yes, I'm sure this kind of feature is application-based. There is nothing in
the driver itself. If I'm not wrong, MS Access uses a timestamp column to check
if the record was updated meanwhile, or the column values if not timestamp is
available. This might be true only with a MS SQL Databas
45 matches
Mail list logo
