I completely agree with Thomas.
If the world journal has the same meaning I give to it I suggest the OP
to give a look to Open Journal System:
http://pkp.sfu.ca/?q=ojs
Maybe it goes further than the OP wants.
I never used it wiht Postgres , because my customers wanted to use
MySQL :-(
But it
Il 08/02/2011 10.42, Pavel Stehule ha scritto:
Hi
2011/2/8 Thomas Markus t.mar...@proventis.net:
hi,
i would prefer many schemas. advantages:
- one backup/restore for all (or selective)
But this also means if one crashes all crash.
And lack of flexibility in deployments.
It heavily
Kalai this is not the proper list to ask, in my opinion. And sincerely I
don't know if a proer list exists.
What you want to achieve is to build a web application and the most
followed way to do that is to use a web framework.
Web frameworks are software that allows you build a web application,
One of the benefits of writing views instead of using SQL in your code,
is that any developer or developer tool can use the view.
So the DB developer writes the view and maybe define indexes that can
speed up the query and any developer of any software that uses the DB
can refer to the View
If you build a web-app the user doesn't connect to the db . It connects
to the application.
It is the web app that should have an auth mechanism.
The web app will perform predefined and limited operations and it is the
web programmer that has to guarantee that only operations provided by
the web
Sorry to post this again, but I have seen no response at all and this is
strange on this list.
Maybe I have not properly submitted my question ?
I wish also to add another parameter: the size problem is usually
associated with the following log messages:
2010-02-02 00:00:14 GMTLOG: checkpoints
Richard Huxton ha scritto:
On 02/02/10 14:46, Ivano Luberti wrote:
Sorry to post this again, but I have seen no response at all and this is
strange on this list.
Maybe I have not properly submitted my question ?
You've replied to an existing question, which means your message is
hidden
Ok I definitely food for thought and that is what I was searching for,
as stated in my first message.
Thanks to Richard and Bill for that.
But I have a few things that still I don't understand and I think I had
not outlined enough.
What really worries and puzzles me is the size of the table
Hello, I have a software that uses Posgtres 8.4.2 on Windows.
I have a database with data splitted into schemas, so that every schema
replicates the same set of tables.
One of the table is called code: it has 16 columns, almos all numerics
except for a carachtervarying(1024) and two text fields.
Sure the url looks bad.
Shoudl be something like:
http://jdbc.postgresql.org/dbname
Anyway you cen find more help about jdbc connectivity to postgres here:
http://jdbc.postgresql.org/
Dave Coventry ha scritto:
I'm not sure this is the right place to enquire...
I'm trying to connect to a
Oh sorry, cut and paste mistake
By the way using that syntax he is using he is assuming the server is
running on localhost and the port is the default one
John R Pierce ha scritto:
Ivano Luberti wrote:
Sure the url looks bad.
Shoudl be something like:
http://jdbc.postgresql.org/dbname
I read books about software products when I need to get introduced to
the whole picture: architecture, underlying technologies.
In this way I also understand what to search for when I need detailed
information or tip and tricks.
Rikard Bosnjakovic ha scritto:
On Sat, Nov 21, 2009 at 18:10,
The problem is how you use those data ?
I have used schemas to split data when I had to manage large amount of
data (hundred of thousand records) that are (almost) never going to be
used together, if not for statistic purposes and offline processing.
If you never need to select those data all
Hi all, I use PostgresSQL 8.3 through JDBC
Recently one transaction has failed with the following error message:
Detail: Process 10660 waits for AccessShareLock on relation 36036 of
database 34187; blocked by process 2212.
Process 2212 waits for AccessExclusiveLock on relation 36044 of database
Tom, thanks for your answer: the reason I failed to find
AccessExclusiveLock
is beacuse that string of character is never written in the manual while
AccessShareLock
is written as it is written above in the manual in the section about index
lockin.
Not knowing the manual in detail I
in the section you pointed out I have
been able to identify the other process involved in deadlock: we are
going to analyze when the two threads can conflict. I suspect we will
have to use the list again...
Regards
Tom Lane ha scritto:
Ivano Luberti lube...@archicoop.it writes:
My problem is I
We used power architect but not really satisfied with it.
Currently using Mogwai ERDesigner but still early to make an evaluation
even if seems really promising.
http://mogwai.sourceforge.net/?Welcome:ERDesigner_NG
Peter Hunsberger ha scritto:
Check out Power Architect. Pre-major release, it
Hi all, executing the following command inside pgAdmin on my Windows
Vista (please avoid comment, I pray you) :
copy anagrafica_import from 'c:\\temp\\anagraficaANIDIs.csv' WITH CSV
I get the following error:
WARNING: nonstandard use of \\ in a string literal
LINE 1: copy anagrafica_import
Stato SQL: 58P01
I have also tried uppercasing C without success.
I'm sure about the path because I have copied and pasted from the
properties window.
Raymond O'Donnell ha scritto:
On 17/03/2009 14:45, Ivano Luberti wrote:
Hi all, executing the following command inside pgAdmin on my
I'm sorry, you are right that is the problem
I had interpreted that as the file should reside on the same machine
where pgAdmin (or another client) runs , not the server.
Thank you again
Raymond O'Donnell ha scritto:
On 17/03/2009 15:04, Ivano Luberti wrote:
Thanks but it keeps
Can you please publicly share a link to this document ?
Abdul Rahman ha scritto:
Thanks a lot Ray!
I have found the document and going to follow this. If I face any
difficulty then will prompt to archive.
Regards,
Abdul.
--- On *Mon, 10/27/08, Raymond O'Donnell /[EMAIL PROTECTED]/*
Does this means that the two features are independent one from each other ?
In other words, can we say that JDBC batch will limit information
exchange between client and server while Postgres prepared statements
will optimize their execution ?
Kris Jurka ha scritto:
On Sun, 20 Apr 2008,
Richard, I was convinced that it was not necessary to provide detailed
SQL to not introduce any noise in the information I was giving to the list.
Anyway you proved right at last, since trying to sample some sql to make
others able to reproduce the problem we were also able to identify the
Hello everybody, I have searched for a long time about this issue but I
was not able to find what is the cause. Maybe because I have not been
able to identify the right keywords.
We are experiencing the following problem using postgres8.3 and postgres8.1
On client1 we execute
begin;
insert
24 matches
Mail list logo
