Kallol Nandi schrieb:
I am not able to get the mistake.What might be the problem with the url?
Please do reply.It is urgent.
Thanks and Regards,
Kallol.
Did you try to use Sun's JDK?
---(end of broadcast)---
TIP 5: Have you checked our extensive
Arjen van der Meijden schrieb:
According to Sun, http://jcp.org/en/jsr/detail?id=221, it is not yet
available:
2.11 Please describe the anticipated schedule for the development of
this specification.
This specification will be available towards the end of the calendar
year, 2004.
So I wonder why
Tom Lane schrieb:
Thomas Kellerer [EMAIL PROTECTED] writes:
But isn't that exactly the problem? Once the sequence wraps around how do I
know that id=1 is actually later then id=2 without a date column?
If you use an int8 sequence column, I doubt you need to worry about
wraparound. A date
Andrew Gould schrieb:
I have a couple trips coming up; and need PostgreSQL
to coexist with MS Access on my laptop.
Should I go the Cygwin route? Or are we close to 7.4
and the Windows port? (Is it a matter of weeks or
months?)
To my understanding 7.4 won't include the windows port. I wouldn't
Terence Chang schrieb:
I am still getting the error. would this matter with 7.3.3 on windows with
cygwin?
From my experience I'd never user quotes at any place (neither during creation
of the table nor in the SELECT, UPDATE statements). All DBMS I know behave like
Postgres. So if you never quote
Hello all,
just out of curiosity: how can I find out which files in the PG_DATA directory
belong to which database/table?
I have looked through the documentation of the system catalogs, but couldn't
find any reference to that.
The field datpath in pg_database is empty in my system (7.2 on
Shridhar Daithankar schrieb:
On 25 Jul 2003 at 8:45, Thomas Kellerer wrote:
just out of curiosity: how can I find out which files in the PG_DATA
directory belong to which database/table?
There is a contrib module oid2name. Use that.
You can just find the oid of the object from catalog
Holger Marzen schrieb:
How can I list defined triggers on PostgreSQL 7.1.3?
I'm using the following statement:
select trg.tgname, tbl.relname,
case trg.tgtype cast(2 as int2)
when 0 then 'AFTER'
else 'BEFORE'
end as trigger_type,
case trg.tgtype cast(28
[EMAIL PROTECTED] wrote on 11.10.2006 16:54:
Do a simple test to see my point:
1. create table test (id int4, aaa int4, primary key (id));
2. insert into test values (0,1);
3. Execute update test set aaa=1 where id=0; in an endless loop
As others have pointed out, committing the data is a
[EMAIL PROTECTED] wrote on 11.10.2006 16:54:
Do a simple test to see my point:
1. create table test (id int4, aaa int4, primary key (id));
2. insert into test values (0,1);
3. Execute update test set aaa=1 where id=0; in an endless loop
I just did the test on PostgreSQL 7.4.12 and MySQL 5.0.22
On 17.10.2006 10:36 Andreas Kretschmer wrote:
http://techdocs.postgresql.org/#convertfrom
I just noticed that the link Porting from Oracle PL/SQL still points
to the 7.4 manuals. Shouldn't that be updated to point to the current
release?
And the link Ora2Pg - Oracle to PostgreSQL
On 23.10.2006 16:14 Csaba Nagy wrote:
Hi all,
I know of 2 causes:
- hit CTRL-C in the psql client;
- have a non-zero statement timeout and have the statement actually
time out;
But I am seeing this via JDBC which can't cancel a statement AFAIK
JDBC *can* cancel a running statement. You
Ritesh Nadhani wrote on 01.11.2006 07:51:
We have a server where Postgresql is running without any problem with
postgres username and admin rights.
Interesting. On Windows, PG will *refuse* to run on an account with admin
rights.
---(end of
Ritesh Nadhani wrote on 01.11.2006 07:51:
Hello All
Me and my professor are planning to work upon machine learning in
postgresql over tsearch2. So I have some questions:
We have a server where Postgresql is running without any problem with
postgres username and admin rights. I have a user
On 27.10.2006 10:13 Csaba Nagy wrote:
JDBC *can* cancel a running statement. You just need to call cancel()
from another thread.
http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html#cancel()
Works great in my SQL front end.
Are you sure ? Ever tried to cancel a long running
On 21.11.2006 15:20 Wm.A.Stafford wrote:
Distinct is the equivalent
aggregate function as many pointed out. A co-worker said that Oracles
'unique' is probably an optimized version of distinct that takes
advantage of some Oracle specific indexing.
I don't think so. They are merely two
- Of the few multiple-db GUIs, 99% (or probably 100%) use JDBC/ODBC
layer to connect and work with the databases and JAVA or some other kind
of high level toolkit/language to develop the GUI. This results in
applications being bulky and slow and never able to provide the speed
that a low level
Hi,
I am maintaining such an application and it is neither bulky nor slow.
It's all
a matter of implementation.
Can I have a link to the application or more info on that? I would be
interested to take a look into it.
Sure: http://www.sql-workbench.net
I have nothing against JDBC or JAVA
On 27.11.2006 17:36 Tony Caduto wrote:
The closest to Delphi in a cross platform system is
NetBeans and even with their form designer it's still tedious working
with databases compared to Delphi.
What about Lazarus? It claims to be cross-platform, but I don't know how
it compares with
Andrus wrote on 28.11.2006 18:17:
5. Java is not LGPL and does not support Generic at bytecode level
I have heard this Java is not open source over and over again.
What's the issue with wanting the language to be open source? Where is the
problem with using Java from a license perspective? You
Joshua D. Drake wrote on 29.11.2006 17:30:
I forgot that NetBeans was open source now...
Now? It has been open source way before Eclipse even dawned ;)
Thomas
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On 08.01.2007 17:24 Scott Marlowe wrote:
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
Hello everybody,
In Oracle i use the command connect by prior and i need to use it in
PostgreSQL, what is the sintax?
What does connect by prior do? Reuse a connection from one db to
another? I
On 23.01.2007 15:10 [EMAIL PROTECTED] wrote:
Now what?
1. Where's the interactive shell?
http://www.postgresql.org/docs/8.2/static/app-psql.html
How can I start creating a database,
http://www.postgresql.org/docs/8.2/static/app-createdb.html
creating users, testing things out?
Phoenix Kiula wrote on 14.08.2007 19:46:
There are some cases where I would like to bunch queries into a
transaction purely for speed purposes, but they're not interdependent
for integrity. E.g.,
BEGIN TRANSACTION;
UPDATE1;
UPDATE2;
UPDATE3;
COMMIT;
If UPDATE2 fails because it, say,
Ned Lilly wrote on 23.08.2007 15:44:
This is specifically why we released OpenRPT as open source - it's very
lightweight, no Java required. http://sf.net/projects/openrpt
I am a Java developer and thus I have no problems in using Java based tools.
Especially because I ususally only have a
Alexander Staubo wrote on 24.08.2007 23:49:
So actually the remark shouldn't be that the multi-threaded
architecture is only advantageous on Windows, but more like the
multi-process architecture is disadvantageous on Windows and hence a
multi-threaded architecture is preferred (on that
Stephen Ince wrote on 27.08.2007 18:02:
Derby and hsqldb are the only free embedded databases for commercial use.
Well, there are some more:
H2 Database, OneDollarDB (OpenSource version of DaffodilDB), Berkely DB and
McKoi are free as well (although McKoi seems to be dead).
Then there are a
Zenaan Harkness wrote on 08.09.2007 07:03:
Hi, a friend of mine on Windows, is attempting to convert to using
PostgreSQL (and of course, I'm helping him).
The installation gave an option to run as an application, rather than as
a service.
Turns out, my friends login account has Admin privs,
Shelby Cain wrote on 08.09.2007 20:57:
Compared to that, I don't really understand follow your argument as to why
installing Postgresql as a service and stopping/starting it through the
service control panel such a big deal.
Or stopping/starting using a batch file (with net start pgsql)
Panagiotis Pediaditis, 14.09.2007 16:45:
Well the problem is I am working on rdf query engine for persistent RDF
data. The data is stored/structured in a specific way in the database.
When i perform updates in parallel, because there are cross table
dependencies, I end up with inconsistencies,
Hello,
when I create a view, e.g.:
CREATE VIEW my_view
AS
SELECT col1,
col2,
col3
FROM mytable;
And I later retrieve the view's source using SELECT definition FROM pg_view,
the source I supplied has been altered by Postgres.
The formatting has been removed completely and PG
Richard Huxton wrote on 16.10.2007 18:59:
The formatting has been removed completely and PG actually re-wrote
the query. For the above example I would get:
Is there a way to tell PG _not_ to alter my SQL, so I can retrieve the
same (or at least a very similar) version of the original
snacktime wrote on 21.10.2007 08:11:
I have a group
of otherwise very bright people trying to convince me that a rdbms is
not a good place to store relational data
Hmm.
Those bright people say that a /relational/ database management system is not a
good place to store /relational/ data?
I
Craig Hawkes, 24.10.2007 05:14:
- running as a service
What happens in the unlikely event that they already have a version of
Postgres installed?
As far as I know you can happily install different versions in parallel.
You just need to make sure the service name is unique (e.g. by
Craig Hawkes, 24.10.2007 22:04:
If I could reword:
Given that we have a large estiblished client base running a
Delphi/Paradox solution, and that we would like to replace Paradox with
a much better SQL engine, I was looking for comments as to how Postgres
maybe suitable.
Not sure if I'll
Tom Lane wrote on 28.10.2007 23:18:
Oh, I just twigged that you are using a plain-SQL dump file (that is,
you didn't specify -Fc or -Ft to pg_dump). For plain-SQL dumps you
should not use pg_restore at all; you feed those to psql.
While we are on the topic of pg_dump/pg_restore:
Why is it,
Tom Lane wrote on 29.10.2007 00:55:
Thomas Kellerer [EMAIL PROTECTED] writes:
Why is it, that pg_dump can use a compressed output directly but pg_dumpall is
always using a SQL (i.e. plain text) output?
The custom and tar formats are not designed to support data from more
than one database
Ilan Volow wrote on 30.10.2007 23:01:
I'm personally interested in the idea of versioning for a drawing.
Instead of storing the entire drawing for each version, one could
theoretically just store the vector additions/changes/deletions that
happen from one revision to the next.
Which could
Anton Andreev wrote on 31.10.2007 15:34:
Hi,
I have records with date column. Is there a way I can get which day of
week this date is?
What about the extract() function with the dow parameter?
http://www.postgresql.org/docs/8.2/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
Tom Lane wrote on 06.11.2007 21:21:
The real point here is that when writing to a mailing list, you should
make an effort to conserve other peoples' time. Hundreds of people are
going to read what you wrote, possibly thousands when you count in
people searching the list archives in the future.
Tom Lane, 07.11.2007 06:14:
Thomas Kellerer [EMAIL PROTECTED] writes:
If everyone simply top-posted, there would be no need for me to scroll down,
just to find a two line answer below a forty line quote - which I personally
find more irritating than top-posting.
I think you're ignoring my
Russ Brown wrote on 09.06.2005 23:12:
Currently we just store a dump of the data structure. However, what I
think is really needed is a specialist diff tool which works out the
commands needed to move from one schema to another. That would be
*extremely* useful, but would also probably
Hello all,
I'm trying to change the server messages back to english (initdb created
'German_Germany.1251' because I'm running a German Windows) by setting
the lc_messages property to 'C'. But the messages from e.g. pgsql or
pg_ctl still show up in German. I reloaded the config and I restarted
Tom Lane wrote on 27.09.2005 03:19:
Thomas Kellerer [EMAIL PROTECTED] writes:
I'm trying to change the server messages back to english (initdb created
'German_Germany.1251' because I'm running a German Windows) by setting
the lc_messages property to 'C'. But the messages from e.g. pgsql
RPK wrote on 25.02.2007 09:44:
Select * from tablename;
the un-necessary field gets displayed in the last. However, you I can ignore
that field altogether using filtered fields only in Select statement, but
still sometimes it is necessary.
No it's not. SELECT * should be avoided by all means
Randall Smith wrote on 14.03.2007 18:59:
I'm trying to get Postgresql to work with software that uses JDBC and
Oracle for a large government project. So I have to report that the
application won't work with Postgresql because it (PG) doesn't adhere to
the standard. That's usually something I
Merlin Moncure wrote on 05.04.2007 23:24:
I think most reasons why not to store binaries in the
database boil down to performance.
Having implemented an application where the files were stored in the filesystem
instead of the database I have to say, with my experience I would store the
files
William Garrison wrote on 06.04.2007 00:22:
I have actually never stored data in the database.
Hmm, funny statement somehow ;)
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Marek Lewczuk wrote on 23.05.2007 21:37:
I would like to know your opinion about pljava and its future
I have never used Java-in-the-database with any of the DBMS I have used and I
have never understood the reasoning behind it.
My personal opinion is, that it's not needed. Most of the time
Alexander Staubo wrote on 24.05.2007 17:30:
[2] Nobody else has this, I believe, except possibly Ingres and
NonStop SQL. This means you can do a begin transaction, then issue
create table, alter table, etc. ad nauseum, and in the mean time
concurrent transactions will just work. Beautiful for
EBIHARA, Yuichiro wrote on 22.06.2007 06:09:
It seems like PG JDBC driver CANNOT handle 'bytea' as BLOB nor 'text' as CLOB.
getBlob()/setBlob()/getClob()/setClob() can work with only Large Objects (at
least with
postgresql-8.1-405.jdbc3.jar).
org.postgresql.util.PSQLException: Bad Integer
EBIHARA, Yuichiro wrote on 22.06.2007 08:34:
Thomas,
Thank you for your comment.
I found that using getBinaryStream(), setBinaryStream(),
getCharacterStream()
and setCharacterStream() to handle LOBs across different DBMS
is much more
portable (and reliably) than using the Clob()/Blob()
EBIHARA, Yuichiro wrote on 22.06.2007 09:28:
Hmm. At least for updating LOBs, my method should be
legal. This is a quote from jdbc-3_0-fr-spec.pdf
The setBinaryStream and setObject methods may also be used
to set a Blob object as a parameter in a PreparedStatement
object. The setAsciiStream,
x asasaxax wrote on 19.11.2007 12:17:
Hi,
I´m interested in running xml with postgre. I use postgre version 8.2 and
windows xp. I would like to know how can i enable the xml in the postgresql.
Did you know if its secure to use this xml function of postgre in
commercial applications? How
Alvaro Herrera, 26.11.2007 15:07:
EnterpriseDB has no replication solution that I know of.
Quote from
http://www.enterprisedb.com/products/enterprisedb_replication.do
EnterpriseDB Replication Server replicates data across the enterprise
in near real time to meet a wide array of business
Peter Childs, 30.11.2007 14:25:
I found ingres website but no mention of a database system so I though
they were something else that had taken on the name...
http://www.ingres.com/downloads/prod-comm-download.php
Found this using Google ;)
Thomas
---(end of
Joshua D. Drake, 11.12.2007 17:43:
O.k. this might be a bit snooty but frankly it is almost 2008. If you
are still a top poster, you obviously don't care about the people's
content that you are replying to, to have enough wits to not top post.
I personally find non-trimmed bottom postings at
Richard Huxton, 12.12.2007 16:12:
Hmm - I'm not sure it does benefit that much. I mean, if you're going to
be accessing XXXA, then XXXB, XXXC etc. in order then it clearly helps
to have the table with the same order as your primary key. Otherwise,
I'd be doubtful you'd see that much benefit.
Anu Padki wrote on 12.12.2007 20:09:
Hello all,
I am contemplating to use postgresql for a product that requires to
manipulate many blobs.
From the documentation I am not clear if one has to use postgres api to
insert/update/select blobs or one can use standard jdbc api?
Can I just execute a
Kris Jurka, 13.12.2007 08:24:
Using a PreparedStatement with setBinaryStream() to insert the blob
and getBinaryStream() to read the BLOB works fine for me.
It depends how you want to handle binary data on the server side.
get/setBinaryStream only work with the bytea data type.
Gauthier, Dave, 11.01.2008 15:55:
Is there a way to alter a varchar column’s length? Maybe something like
“alter table foo alter column xyz varchar(256)”.
A quick look into the manual would have revealed the correct syntax:
http://www.postgresql.org/docs/8.2/static/sql-altertable.html
Steven De Vriendt wrote on 28.02.2008 21:42:
Hi list,
I'm using the latest postgreSQL with the lastest postgis.
When executing every command I want to use, I get the following error
message:
postgis=# createdb;
ERROR: syntax error at or near createdb
LINE 1: createdb;
^
I can use
abracadabuda wrote on 29.02.2008 19:28:
Hi,
i need to export pgsql structure of tables, vies, PK, FK etc. etc.
into simple XML structure.
My 3 hour searching ended with one result: postgresql-autodoc, but i
don't have enough rights on server to install it.
Is there any solution for my problem
Hello,
I was writing a statement retrieve dependency information out of the system
catalog, when I noticed something that I didn't expect.
I wanted to use the following statement to translate the relkind column to a
more descriptive value:
select c.relname
case
when
Adam Rich wrote on 01.03.2008 01:02:
The data types of all the result expressions must be convertible to a
single output type.
The type of the field pg_class.relkind appears to be char which is
described in the notes as:
The type char (note the quotes) is different from char(1) in that it
robert, 06.03.2008 15:32:
Hi all,
I've successfully converted a huge mssql ddl to postgres 8.1.9 - I
could upgrade if need be. We run both db's for our app depending on
the customer. We have a new feature, storing serialized java objects
in the db, and I'm having trouble with on this insert:
Conor McTernan wrote on 06.03.2008 04:33:
I have been using DBDesigner by FabForce for a couple of years, but
development has stopped
It seems that someone picked up the source. There is a new project on
sourceforge that seems to continue the work on DbDesigner:
A. Kretschmer wrote on 11.03.2008 19:50:
am Tue, dem 11.03.2008, um 10:51:21 -0700 mailte CaseT folgendes:
Hi All,
I'm a novice but learning quickly and I'm stumped on how to do this.
I need to convert postgres timestamp to date format -mm-dd in a
sql statement.
pt.created_date below is
Marc Horvath, 14.03.2008 12:35:
I was wondering if anyone had any working sample code of inserting a
blob into a table and then retrieving one from a table for viewing?
I’m using Postgres 8.2, the jdbc is postgresql-8.2-504.jdbc3, and the
Java is 1.6.
I’m also running on a Windows XP Pro
Jeff Williams wrote on 22.03.2008 05:20:
I would like to install PostgreSQL manually as part of my applications
install using InnoSetup.
Is there anywhere the steps required to do this and if so where would I find
them?
Many thanks
Jeff
I think you should be able to use the -no-binaries
Alain Roger wrote on 24.03.2008 15:45:
SELECT count(*) INTO existing_email FROM cust_portal.tmp_newsletterreg;
if (existing_email 0) then
{
result = false;
}
else
{
result = true;
INSERT INTO cust_portal.tmp_newsletterreg VALUES
(
Bill Wordsworth wrote on 25.03.2008 19:16:
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't they similar to Oracle's RAC
clusters, except that they are not aware of each other?
No, absolutely not. Each client request is handled by a
Bill Wordsworth wrote on 25.03.2008 21:04:
On Tue, Mar 25, 2008 at 2:24 PM, Thomas Kellerer [EMAIL PROTECTED] wrote:
Bill Wordsworth wrote on 25.03.2008 19:16:
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't they similar to Oracle's
On 15.04.2005 13:58 Alex wrote:
Hi,
i have a table
ProdId | LastUpdate
---+
100| 2005-04-01
100| 2005-03-01
100| 2005-02-01
200| 2005-04-01
200| 2005-03-01
200| 2005-02-01
- How can i select only the newest record for each ProdId ?
100
[EMAIL PROTECTED] wrote on 15.04.2005 16:42:
select max(lastupdate),prodid
from tablename
group by prodid
Even better :)
Thomas
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hello,
I'm having a bit of trouble with the error message from the subject. Is
there a way to simply go on with my commands if I hit this error?
One example would be when I drop a table (and it doesn't exist) I still
want to run the following CREATE TABLE. But due to the error even the
Joshua D. Drake wrote on 19.04.2005 00:21:
I'm having a bit of trouble with the error message from the subject.
Is there a way to simply go on with my commands if I hit this error?
Only if you are using savepoints (nested transactions) otherwise you
must rollback.
Is this a problem with the
Scott Marlowe wrote on 19.04.2005 00:26:
One example would be when I drop a table (and it doesn't exist) I still
want to run the following CREATE TABLE. But due to the error even the
following valid command will fail.
This problem is not limited to DDL. When I try to write the result sets for
On 19.04.2005 02:33 Kris Jurka wrote:
Is this a problem with the JDBC interface that I'm using, or is this a
general Postgres problem?
This is an open todo item for the JDBC driver. It could be done by
automatically wrapping all statements in savepoints behind the scenes.
Then any error
Richard Huxton schrieb:
On Wednesday 03 September 2003 12:19, Amin Schoeib wrote:
Hi,
How can I make textoutput (for example for tracing the code) in PLPGSQL.
In Oracle you can do that using dbms.output.put_line
RAISE NOTICE ''My counter is % with total %'',i,run_tot;
Double-quoted string as
Paul Ganainm schrieb:
ANSI SQL compliant
X
FB does not support inline views/derived tables, e.g.:
SELECT count(*) FROM (SELECT col1, col2 FROM table)
Thomas
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
Paul Ganainm schrieb:
FB does not support inline views/derived tables, e.g.:
SELECT count(*) FROM (SELECT col1, col2 FROM table)
If you have IB/FB, there is a sample db that comes with it, Employee.
There is a view in that db called phone_list.
I did select count(*) from phone_list and it
Paul Ganainm schrieb:
SELECT count(*) FROM (SELECT col1, col2 FROM table)
OK, so that's what you call an inline view is it?
Yep :-)
What then is a derived table, or is a derived table just a synonym for
inline view?
I'm not sure what the official name for this is. I have heard both. So
from my
anwar schrieb:
How can i get a list of database in postgresql
anwar
psql -l
for details see: http://www.postgresql.org/docs/7.4/static/app-psql.html
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
Carlos Correia wrote on 06.12.2005 21:13:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas Hallgren wrote:
| Hi,
| I'm about to start a new project where the first task is to design a
| database. I'm looking for some tool that will allow me to model the
| tables and relationships
Matthew Hixson wrote on 28.01.2006 00:53:
I'm trying to get a large Java application which makes use of an Oracle
JDO layer to work with Postgres. Set aside for a moment the discussion
of whether or not that is going to work.
What I have found is that different parts of this application are
Tim Penhey wrote on 30.08.2004 23:12:
I have got a table which is supposed to contain only one row. It does
not have any primary keys defined.
So, essentially, when a new insert happens in that table, I would like
it (the insert) to fail if there is already a row existing in that table.
You
Mike Nolan wrote on 31.08.2004 21:46:
But should you also prevent DELETE's from that table? Otherwise you could
wind up with no rows at all. I guess that would have to be done using a rule...
Why not just revoke the delete privilege?
That was one of my first guesses as well, but then I'm not
Randy Yates wrote on 27.09.2004 01:35:
Hi,
I want to do develop some C++ to interface with a remote postgresql
database via ODBC on a win32 platform (windows 2000) via unix
style. For example, I like using the mingw (minimum gnus for windows)
distribution, gnumake, xemacs, cygwin, and non-IDE
Hello,
I'm trying to use XML with PG, and I a descriptioin of the XML support for
PostgreSQL at http://www.throwingbeans.org/postgresql_and_xml_updated.html
As I could not find the mentioned package in my Windows installation (8.1.3) I
thought I'd give the package from that website a try
John Gray wrote on 26.05.2006 22:01:
I can't claim to have great Windows compilation skills, but another
contributor posted a zipped dll some time
ago:
http://archives.postgresql.org/pgsql-novice/2005-11/msg00216.php
That may help you out.
Thanks for the pointer, but I can't seem to get
[EMAIL PROTECTED] wrote on 29.05.2006 13:06:
Thanks. What about DIA - http://www.gnome.org/projects/dia/
...or DB Designer - http://fabforce.net/dbdesigner4/ (this one claims
to be feature-equivalent, or in the sphere of, products like Oracle's
Designer, ERWin, and Rational Rose.
This is not
On 14.06.2006 13:56 Guido Neitzer wrote:
Hi.
Is there an easy way to copy the content including the table structure,
indexes and so on from one db to another?
Let's say I have a production db called db_production and want to create
a development db called db_dev with exactly the same
Hello,
i have a PostgreSQL (8.1) installation for testing purposes which was
running fine for several months now (Windows XP). I was working with it
yesterday, and today after booting my computer and restarting the
service (I'm starting the service manually, because I don't need the
server
On 07.07.2006 09:20 Thomas Kellerer wrote:
Hello,
i have a PostgreSQL (8.1) installation for testing purposes which was
running fine for several months now (Windows XP). I was working with it
yesterday, and today after booting my computer and restarting the
service (I'm starting the service
Magnus Hagander wrote on 08.07.2006 06:21:
This looks exactly like the issues we've seen with broken antivirus or
personal firewall software. Make sure you don't have any such installed
(actualy installed, not just enabled), and if you do try to uninstall
them. If you don't, but had before,
On 21.07.2006 11:12 Volkan YAZICI wrote:
As Tom mentioned, there's support for this feature in the protocol
level, but I don't know any API supports this yet.
I think if you run a query like the suggested one (or SELECT ... WHERE
1=2) the JDBC API will provide the necessary information via
Jorge Godoy wrote on 12.08.2006 01:33:
I was trying to solve a problem on an old system and realized that there might
be some better approach for doing what I need.
We have some documents that need to be ordered sequentially and without gaps.
I could use a sequence, but if the transaction fails
Harald Armin Massa wrote on 13.08.2006 10:46:
Do you know for what benefit that happens? I have seen similiar stupidity
with EJB, having RI within that layer. Why are people doing this? Do they
know something I miss, or did they just not vivist Databases 101 ?
I think this happens because of
Ashley Moran wrote on 13.08.2006 13:46:
I can't understand how developers employed to created database-backed
applications think they can get anywhere with so little understanding of what
they are doing.
Well spoken!!
I have actually written a 10-page introduction to relational theory, based
1 - 100 of 803 matches
Mail list logo