On Tue, 2004-08-17 at 12:22, Pierre-Frdric Caillaud wrote:
Suppose your table is like :
key1key2
1 1
1 2
2 1
To get the next value to insert for key1=1 you can do this :
SELECT key2 FROM ... WHERE key1=1 ORDER BY key2
I've started seeing the following in my logs:
FATAL: invalid frontend message type 8
I searched back over a month and there are 5 instances of this error
of which 4 are in the last 24 hours.
I could not find this error defined. Any ideas of what it means, it's
severity, how to track the cause
Marcel,
it's very difficult from you message where do you lost.
pgsql version, OS version, cut'n paste of commands you run and
output would be fine.
To install tsearch2 most people need (as postgresql superuser):
1. install postgresql and headers
2. cd contrib/tsearch2
3. make; make install;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Robert,
On Wed, 18 Aug 2004, Robert Treat wrote:
I've still got some RH7.3 servers around, which is the best SRPM to use for
those.. RHEL3 ?
I'd use none of them for RH 7.3. I'm not sure that any of the srpms will
work.
But you might give
Bit more info (from my own findings migrating from Oracle - Postgres)
Sequences - YES
Packages - NO (concept doesn't exist in PG)
Functions - YES, Procedures - NO (also no INOUT or OUT parameters)
Full-text - YES, tSearch2
Triggers - YES
Jobs - NO, (but scheduled tasks can be implemented in other
Oleg Bartunov wrote:
Marcel,
it's very difficult from you message where do you lost.
pgsql version, OS version, cut'n paste of commands you run and
output would be fine.
To install tsearch2 most people need (as postgresql superuser):
1. install postgresql and headers
2. cd contrib/tsearch2
3.
Hello,
I have a table named USER under MySQL database. When I am trying to
move tables from MySQL to PostgreSQL, I found that I could not create a
table namely USER. I guess USER is a key string used by PostgreSQL
system so that we could not create a table named USER. Is that true?
Thanks a
Is it just me, or has there been a rash of I'm thinking about postgres
and coming from an oracle background questions recently? Was there some
writeup of postgres in a db rag in the last month or so?
On Wed, 18 Aug 2004, John Sidney-Woollett wrote:
Bit more info (from my own findings
On Wed, 2004-08-18 at 16:09 +0200, [EMAIL PROTECTED] wrote:
On of the problems I'm having is keeping a development/test-session
seperate from a production-system. I *Want* to have a seperate
production-installation, develop on my test-installation and when a
feature is complete and tested push
Ying Lu wrote:
Hello,
I have a table named USER under MySQL database. When I am trying to
move tables from MySQL to PostgreSQL, I found that I could not create a
table namely USER. I guess USER is a key string used by PostgreSQL
system so that we could not create a table named USER. Is that
If you use it enough, I think it is inevitable that something,
sometime, somewhere will really honk you
off about Oracle. With the feature bloat they're into these days, very
likely it will be something
you care nothing about that does it, too.
On Aug 18, 2004, at 2:08 PM, Ben wrote:
Is it just
Ying Lu [EMAIL PROTECTED] did write:
Hello,
I have a table named USER under MySQL database. When I am trying to
move tables from MySQL to PostgreSQL, I found that I could not create a
table namely USER. I guess USER is a key string used by PostgreSQL
system so that we could not create
could not access file$libdir/tsearch2: no such file or directory
I'm guessing that you did not first run configure in the root directory of the
postgresql source
tree (not contrib/tsearch2). Tsearch2 doesn't know where to install its files.
This might help:
Ying Lu [EMAIL PROTECTED] wrote:
Hello,
I have a table named USER under MySQL database. When I am trying to
move tables from MySQL to PostgreSQL, I found that I could not create a
table namely USER. I guess USER is a key string used by PostgreSQL
system so that we could not create a
Hello,
I have a question about date timestamp types in PostgreSQL. I want
to setup the default value '-00-00' and -00-00 00:00:00 for
them. However, it seems that PostgreSQL does not support it. Could
someone helps me please?
The example table:
T1 (col1 varchar(7) not null,
According to the current SQL language ANSI/ISO standard, the following
are reserved words:
reserved word ::=
ABS | ALL | ALLOCATE | ALTER | AND | ANY | ARE | ARRAY | AS | ASENSITIVE
| ASYMMETRIC | AT | ATOMIC | AUTHORIZATION | AVG
| BEGIN | BETWEEN | BIGINT | BINARY | BLOB | BOOLEAN | BOTH | BY
|
Thanks a lot. That is what I am looking for :)
Emi
Dann Corbit wrote:
According to the current SQL language ANSI/ISO standard, the following
are reserved words:
reserved word ::=
ABS | ALL | ALLOCATE | ALTER | AND | ANY | ARE | ARRAY | AS | ASENSITIVE
| ASYMMETRIC | AT | ATOMIC | AUTHORIZATION |
[As a note, it's a bad idea to put a new message with a new problem in the
same thread.]
On Wed, 18 Aug 2004, Ying Lu wrote:
I have a question about date timestamp types in PostgreSQL. I want
to setup the default value '-00-00' and -00-00 00:00:00 for
them. However, it seems that
Ying Lu [EMAIL PROTECTED] wrote:
I have a question about date timestamp types in PostgreSQL. I want
to setup the default value '-00-00' and -00-00 00:00:00 for
them. However, it seems that PostgreSQL does not support it. Could
someone helps me please?
if you want to store
Are you aware that there is NO zero year? The common era starts with
the year 1 AD. There is also no zero month, and there is no zero day.
All three parts of your date are hence invalid. E.g. the date
-00-00 does not exist, and neither does 0001-00-00 or -01-00
etc. If you are
On Wed, 2004-08-18 at 10:44, Gaetano Mendola wrote:
Devrim GUNDUZ wrote:
Hi,
For RPM users, (S)RPMS for 7.4.4 was just built. We have (S)RPMS for:
* Red Hat Linux 9
* Fedora Core 1
* Fedora Core 2
* Red Hat Enterprise Linux 3
They will be available in main ftp site
21 matches
Mail list logo