Hi,
does postgresql have a datatype 'other' which in hsqldb is an Object? I am trying to convert the table below into postgreSQL 8:
create table TIMERS (
TIMERID varchar(50) not null,
TARGETID varchar(50) not null,
INITIALDATE timestamp not null,
INTERVAL bigint,
INSTANCEPK other,
INFO oth
Why can you not use simple insert statements (sql insert).
Copy is meant to transfer large amount of data from text files to
databases and vice versa.
- Goutam
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Marek Lewczuk
> Sent: Monday, Novembe
Andrei Bintintan wrote:
//Is it possible to have another transatction in a transaction??? In the
following example the last ROLLBACK is totally ignored(transaction1).
///connect to database/
$database = dbConnect($dbhost, $dbuser, $dbpass, $dbname);
dbExec($database, "BEGIN"); //transaction1
///*
This is what I get with postgres-7.3 (from Redhat Enterprise !!)
Here below a select with a regexp
ansroc=# explain select * from s12hwdb where host~'^tna2582t';
QUERY PLAN
-
Seq Scan on s12hwdb (cost=0.00..3066
On Tue, 9 Nov 2004, carex wrote:
> And it works also perfectly with Gentoo.
>
> So,is this a typical "Redhat Enterprise" problem ?
> Or do I overlook something ??
IIRC, in 7.3.x, index scans are only considered in "C" locale for
regexp/LIKE. In 7.4.x, non-"C" locale databases can use a special
i
> does postgresql have a datatype 'other' which in hsqldb is an Object? I
> am trying to convert the table below into postgreSQL 8:
>
> create table TIMERS (
> TIMERID varchar(50) not null,
> TARGETID varchar(50) not null,
> INITIALDATE timestamp not null,
> INTERVAL bigint,
> IN
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Tue, 9 Nov 2004, carex wrote:
>> And it works also perfectly with Gentoo.
>> So,is this a typical "Redhat Enterprise" problem ?
>> Or do I overlook something ??
> IIRC, in 7.3.x, index scans are only considered in "C" locale for
> regexp/LIKE. In 7.4.
Hi Markus,
I tried different types of encoding, LATIN1 to LATIN 9, still the same
behavior. I read a few forums, but there I couldn't find a concrete answer
for this.
So... still searching.
Best regards,
Andy.
- Original Message -
From: "Markus Schaber" <[EMAIL PROTECTED]>
To: "Andrei B
Is it possible for an UPDATE/INSERT query string to function in such a way that it requires two like fields in different tables to be equal to/'in sync with' one another:
Example: I have two tables: registration & schedules
they both record a class_id, start_date, end_date... I want to
