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 ava
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 determine
"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
[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 seem
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:
::=
ABS | ALL | ALLOCATE | ALTER | AND | ANY | ARE | ARRAY | AS | ASENSITIVE
| ASYMMETRIC | AT | ATOMIC | AUTHORIZATION | AVG
| BEGIN |
According to the current SQL language ANSI/ISO standard, the following
are reserved words:
::=
ABS | ALL | ALLOCATE | ALTER | AND | ANY | ARE | ARRAY | AS | ASENSITIVE
| ASYMMETRIC | AT | ATOMIC | AUTHORIZATION | AVG
| BEGIN | BETWEEN | BIGINT | BINARY | BLOB | BOOLEAN | BOTH | BY
| CALL | CALLED
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,
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
> 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:
http://www.sai.msu.su/~megera/post
"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 co
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 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 t
Hi folks,
I'm busy with analyzing some data and therefore will
have to store 2 big tables containing 50 million obs &
25 million obs. Selecting some interesting obs can
decrease these tables with maybe a factor 10 but
eventually I will have to combine them using a join.
These tables contain almost
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 p
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 migrat
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?
Than
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. make;
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
-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
Steve Crawford <[EMAIL PROTECTED]> writes:
> 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 w
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; mak
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
On Tue, 2004-08-17 at 12:22, Pierre-FrÃdÃric 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
23 matches
Mail list logo
