Kusuma Pabba, 17.02.2009 13:54:
while in pgsql i am thinking of to use the same as follows:
CREATE TABLE users (
user_id int(11) NOT NULL serial,
user_name varchar(50) NOT NULL,
first_name varchar(50) default NULL,
middle_name varchar(50) default NULL,
last_name varchar(50) default NULL,
p
Sameer Mahajan, 19.02.2009 07:38:
* Shared memory based connectivity: As such postgres has client
- server model. The TCP-IP nature of its connectivity further adds to
the latency of this communication. It will be nice to have a shared
memory based connectivity between libpq front end and
Matthias Hoys wrote on 16.02.2009 22:56:
Should you choose an open-source, make sure your code AND your DDL uses as
much ANSI standards as possible so when you do need to move to something
else, it won't be as painful. (auto-incrementing columns vs. sequences
etc...).
I really wouldn't go f
Linos, 27.02.2009 11:41:
Hello,
i have a query that returns a result set like this:
item | size | stock
123 | XL | 10
123 | XXL | 5
123 | XS | 3
and i would like get the results like this:
item | XL | XXL | XS
123 | 10 | 5 | 3
i have been thinking how to do it with a plpgsql
Carl Sopchak wrote on 08.03.2009 17:37:
or a way to run a function outside an implicit transaction
No sensible DBMS will let you do _anything_ outside a transaction
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.
John R Pierce wrote on 16.03.2009 00:41:
Greenhorn wrote:
Unfortunately When I execute the above files using \i I am getting
errors like
ERROR: syntax error at or near "("
LINE 4: SUB_TYPE NUMBER(3) NOT NULL,
Obviously 'number' is not PostgreSQL data type so is '
Daniel Manesajian, 17.03.2009 04:33:
Hi,
I'm trying to get an advance taste of the window function feature that I
believe is supposed to be in 8.4. I'm running 8.4devel snapshot (dated
Jan-01 which seems kind of old) grabbed from the snapshot page on the
postgresql website.
When I try a si
Richard Huxton, 17.03.2009 13:26:
Enrico Pirozzi wrote:
and i would like to retrieve the number of records without make
select count(*) from table
I could use directly the table instead of select, and in this this
case I'm searching for
something like the reltuples field in the pg_class table,
Harald Armin Massa, 17.03.2009 15:00:
That is: what table size would you or anybody consider really, really
large actually?
I recently attended and Oracle training by Tom Kyte and he said (partially joking though) that a database is only large when the size is measured in terrabytes :)
So re
Sam Mason wrote on 18.03.2009 18:15:
On Wed, Mar 18, 2009 at 04:29:24PM -, cifroes wrote:
I have a DB in utf-8 and postgres 8.3.x.
How can I do an accent insensitive search (like ...) ?
No good idea at the moment; I'd somehow expect to find this sort of
normalization in the functionality
Hi,
I'm getting a new notebook and want to confirm that my idea on how to move my
Postgres installation will work This is a development/test installation and not
a production system, so it doesn't need to be 100% fail safe.
Both systems are Windows XP 32bit.
My plan was to install the same PG
Albe Laurenz, 24.03.2009 10:34:
Thomas Kellerer wrote:
I'm getting a new notebook and want to confirm that my idea
on how to move my Postgres installation will work This is a
development/test installation and not a production system, so
it doesn't need to be 100% fail safe.
Both s
Adrian Klaver wrote on 28.03.2009 23:37:
On Saturday 28 March 2009 3:27:15 pm Eric Smith wrote:
All,
I'm trying to run two database clusters on a single machine, and am
failing. I use initdb to create the two clusters... each has their
own directory structure. I can start one server or the ot
Devrim GÜNDÜZ, 28.03.2009 10:02:
As we are moving very close to 8.4 beta, please join us for testing 8.4
release.
I just released new RPM sets, which is based on Mar 27 CVS snapshot.
Please note that these packages are **not** production ready. They are
for Fedora 9,10 and RHEL/CentOS 5. I have
Dave Page, 30.03.2009 10:34:
EnterpriseDB used to provide 8.4 "builds" for Windows, but the page I
bookmarked does not longer work.
Does anybody know if EnterpriseDB stopped this service?
No - in fact we refreshed the builds just a few days ago:
http://www.enterprisedb.com/products/pgdevdownloa
Dave Page, 30.03.2009 14:28:
On Mon, Mar 30, 2009 at 1:06 PM, Thomas Kellerer wrote:
OK, thanks. I received very strange error messages last week when I accessed
that page. (Velocity Template not found and similar errors). But now it's
working.
Yeah, we had a big website update and that
Jennifer Trey wrote on 30.03.2009 21:39:
Point me to latest JDBC for pgSQL (plus) standard server?
http://jdbc.postgresql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
JiangMiao wrote on 05.04.2009 13:14:
for table
foo
banned:boolean
When try run 'insert into foo(banned) values(0)'
It returns
ERROR: column "banned" is of type boolean but expression is of type
integer
LINE 1: insert into foo(banned) values(0)
and I found a way to add the cast
insert into
Alvaro Herrera wrote on 06.04.2009 19:39:
If that is a one-time thing, why not create the table with banned as an
integer column and another boolean column (if your INSERTs are properly
listing the column names), then after the import update the boolean to
the casted integer value, drop the int
Dann Corbit wrote on 06.04.2009 23:15:
I guess that for some collisions, sharing the name is OK.
I failed to explicitly state what the PK looked like.
entity_id(entities.id) +
identifier_type ('AKNA') +
identifier_value(entities.common_name)
There will only be a PK collision when we att
Robert Treat wrote on 08.04.2009 23:06:
http://www.databasedesign-resource.com/null-values-in-a-database.html
That is a very - hmm - strange article.
One of the proofs that nulls are bad is that "SELECT * FROM theTable" (theTable
being empty) returns nothing, whereas SELECT COUNT(*) FROM the
CM J, 09.04.2009 13:23:
I do not want start postgres as a service.Postgres will bundled
along with my application and i am only looking at starting it only from
cmd line.If there are any options to disable this cmd window which
appears after executing the "pg_ctl.exe start", that would be
Hi,
I have been actively recommending Postgres in my company but had now three
people coming back to me because they couldn't manage to install Postgres on
Windows or MacOS.
The common sympton is always that the installer (the PG installer as well as the
EnterpriseDB installers) suggests to
Now when doing this on Windows this is *bound* to fail because the "Program
Files" are usually not writeable for non-admin users. The directory is
created during installation by the user running the installation (which is
usually an admin user). The PG service runs under a regular user account and
CM J wrote on 13.04.2009 07:48:
Hi ,
I have extracted postgres from postgres-noinstaller.zip file. How
do i install postgres as a service from cmd line ? Are there are any
binaries provided by postgres to install it as a service ? Please note
that i am aware that msi installer automat
Bill Moran wrote on 16.04.2009 21:40:
The goal here is that if we're going to encrypt the data, it should
be encrypted in such a way that if an attacker gets ahold of a dump
of the database, they still can't access the data without the
passphrases of the individuals who entered the data.
I'm by
Bill Moran wrote on 16.04.2009 22:20:
I'm by far not an expert, but my naive attempt would be to store the the
database files in an encrypted filesystem.
That was the first suggestion when we started brainstorming ideas.
Unfortunately, it fails to protect us from the most likely attack
vector:
Bill Moran wrote on 16.04.2009 23:06:
which only talks about someone getting hold of the contents of the server's
harddisk.
Not really. You're making an assumption that a pg_dump can only be
run on the server itself.
Right, I forgot that.
But then it's similar to the situation where the use
Joshua D. Drake wrote on 22.04.2009 19:34:
Huh, I wonder when the windows package changed its defaults.
Could it be that Christine initially installed the pginstaller version, and now
downloaded the EnterpriseDB installer? And EnterpriseDB compiles with a
different default setting?
As far a
Raymond O'Donnell wrote on 22.04.2009 20:14:
On 22/04/2009 19:05, Christine Penner wrote:
It was a zip file with an msi installer in it. I tried to find a similar
one for the update but all I could find was the one click installer.
The initial installation sounds like it was the pgInstaller, s
Bruce Momjian wrote on 22.04.2009 20:26:
Yes, I can confirm I think pg_migrator will work for 8.3->8.4 upgrades;
I start testing this week.
This is pretty good news, cool.
Will there be Windows binaries for the pg_migrator once that 8.4 ships?
Thomas
--
Sent via pgsql-general mailing list
David, 28.04.2009 07:48:
Our internal task database is doing something odd in that the
sequence is incrementing by 2 instead of 1 and I can't find any
reason why I have checked the sequence itself to see if it had
somehow got set to increment by 2 but no. The table in question has a
number of bot
Adam B wrote on 01.05.2009 19:50:
I realize that I could set a save-point before every INSERT but that
nearly doubles the processing time.
That's interesting.
I did a quick test with JDBC inserting 500,000 rows and the time when using a
savepoint for each INSERT was not really different to t
Adam B wrote on 01.05.2009 22:59:
Perhaps I'm doing something wrong. I'm consistently taking over 20s for
the following test case. (Without savepoints it takes under 10s)
That's really strange. I can reproduce your results on my computer (25 vs. 65
seconds).
When running my import progra
Adam B wrote on 02.05.2009 00:48:
Strange indeed. Perhaps there's some background stuff happening that
messes with the results (auto VACUUM?).
In my mind, however, it makes sense that it would take longer: 2 extra
operations against the server (save&release).
Typical case of "problem sits b
ga...@schoolteachers.co.uk wrote on 03.05.2009 13:32:
Anyone know how to install Postgresql as a windows service from the command
line.
I have this as the correct syntax:
"c:\scholarpack\postgres\bin\pg_ctl.exe" runservice -w -N "P4" -D
"c:\scholarpack\data"
Where P4 is the name of the service
John R Pierce, 06.05.2009 07:33:
I use postgres database server 8.2.12 with my java
application. I was wondering if postgres supports transactions by
default or do i have to turn some parameter on to enable transaction
support ?
Postgres supports transactions by default.
Actually
Gauthier, Dave, 06.05.2009 17:40:
Maybe...
EMP EMP_NAME="FRANK" JOB="PLUMBER"/>
EMP EMP_NAME="SUE" JOB="CARPENTER"/>
...equals...
create table employees (emp_name varchar[64], job varchar[64]);
create table jobs (job_name varchar[64], salary float);
insert
Craig Ringer, 14.05.2009 14:31:
You really, really, REALLY don't want to run the server on win98.
That should be:
You really, really, REALLY don't want to run Win98 :)
SCNR
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ht
Gilles, 20.05.2009 09:32:
Is the Windows port on par with the *nix version, and with those other
alternatives? Apart from the fact that, unlike MySQL, PostgreSQL doesn't
require buying a license when developping commercial applications, are
there technical reasons why I should choose PostgreSQL
Raymond O'Donnell, 20.05.2009 12:59:
I second thisit "just works", and the fact that the installer comes
with a silent-install option means that you can roll it into your own
installer for use in this sort of scenario.
I like the fact that there is a ZIP file that I can simply extract which
Dejan wrote on 24.05.2009 01:19:
Computer which hosted a database crashed, but I managed to save "data"
folder. I copied it to another computer and pointed postgres to that folder
(stopping the service first). But, the service cannot start. Progress bar
just goes for awhile, and then a pop-up t
Craig Ringer wrote on 24.05.2009 17:58:
There isn't currently any REINDEX CONCURRENTLY option
But them manual does list this option:
http://www.postgresql.org/docs/8.3/static/sql-createindex.html
"When this option is used, PostgreSQL will build the index without taking any
locks that prevent
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 Prod
[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
followin
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 JDBC
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
se
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.
>
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 require
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'.
[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 vi
[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.2
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 datab
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 jus
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 broadcast)
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 ac
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 statem
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 different
- 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 C/C
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 regards
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? Yo
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?
ht
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 don
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?
http://ww
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 th
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 f
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 graphically
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
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 even
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 that
[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 content
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 ru
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 se
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, check
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
R
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 th
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
Ludwig Isaac Lim wrote on 15.08.2006 18:05:
Searching the web using google gives me the following
information about error 1063:
Error code 1063: ERROR_FAILED_SERVICE_CONTROLLER_CONNECT -
The service process could not connect to the service
controller. (from
http://user.tninet.se/~tdf275m/wincode2
Tom Lane wrote on 24.08.2006 20:47:
Perhaps an extremely smart optimizer could improve this using knowledge
of the specific aggregates' behaviors, but for "black box" aggregates
it sounds pretty unworkable.
I don't know how they do it, but those functions in Oracle are pretty fast.
Usually way
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 appr
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 wor
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
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
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 co
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 sur
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 build
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 FA
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
wraparou
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 g
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
701 - 800 of 804 matches
Mail list logo
