Paul Tomblin <[EMAIL PROTECTED]> writes:
> I've got PostgreSQL 7.1 installed from rpms on a RedHat 6.2 system. I
> want the data directory on a separate partition, so I shut down, tar the
> whole directory into the other directory, mount it, and when I start up
> postgresSQL it says it's up, but
I've got PostgreSQL 7.1 installed from rpms on a RedHat 6.2 system. I
want the data directory on a separate partition, so I shut down, tar the
whole directory into the other directory, mount it, and when I start up
postgresSQL it says it's up, but I can't connect to any databases using
psql.
psql
R Talbot <[EMAIL PROTECTED]> writes:
> errors or Should I wait for .. AC_EGREP_HEADER.. to be added to source
It's already in 7.1.1.
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Thu, May 17, 2001 at 09:43:41AM -0400, D0 wrote:
> Also how do I get a listing of the sequences already created?
/ds from inside psql. To get the actual SQL that is used, start
psql with '-E'.
Cheers,
Neil
---(end of broadcast)---
TIP 3: if p
I believe it's:
insert into product default values;
(Don't blame us, blame the standard... :) )
On Sat, 19 May 2001, Per-Olof Pettersson wrote:
> Hi
>
> How would one goabout creating an empty record (for use in relations).
>
> I have tried INSERT INTO product() VALUES(); but as expected it
Oh I forgot
Naturally it works with setting eg procuct in this case to null but it
does not seem very clean.
INSERT INTO product(product) VALUES(null);
Does anybody have a clean way to do this?
Best regards
Per-Olof Pettersson
>> Original Message <<
On 2001-0
Tom Regarding message below...
With all said and done below does this all indicate to compile and
ignore the
errors or Should I wait for .. AC_EGREP_HEADER.. to be added to source
before I attempt to compile under Caldera 2.3 eDesktop
BoB T
***
Hi!
I wonder why following SQL-sequence will fail:
-- DROP TABLE car;
-- DROP TABLE vehicle;
-- DROP SEQUENCE vehicle_id_seq;
CREATE TABLE vehicle(
id SERIAL,
color TEXT,
--
CONSTRAINT PK_vehicle PRIMARY KEY (id)
);
CREATE TABLE car(
driver TEXT
)IN
