is is after a reboot) and won't continue.
What do I have to do to convince the installer that I'm NOT running
another instance of the install program? Is something written in the
registry?
len morgan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
thout losing
anything.
len morgan
> create table table1 (id int primary key, col1 int);
> create table table2 (id int primary key references table1(id), col2 int);
>
> and the 2 updates :
>
> 1) update table2 set id = 1001 where id = 1;
> 2) update table1 set id = 1001 where id = 1
rrors.
Try replacing 00/00/00 with NULL in the text file. If the text file is
organized to be read by the COPY command, then use \N instead.
len morgan
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister
uot; from the program, I'm not sure you
can capture just that value. You might also want to make sure that you are
doing a real "exit" from your script and not just letting it "fall through"
len morgan
----- Original Message -
From: <[EMAIL PROTECTED]>
To: &qu
>From psql:
test => \o
test =>
test => \o
This will leave the results of your query in the file "output-file-name"
This IS covered in the documentation and from within psql with \h
len morgan
-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]&g
execute();
>
I believe it's just trying to figure out if "nextscreen" is odd or even. 1
would odd, 0 even.
len morgan
you've got any advice on how I can save these two tables I need so I can
get them to my customer I'd appreciate it.
Redhat 6.0 OS
len morgan
to
watch out for (i.e, I have NEVER been able to get ACCESS to support fix char
length fields, it will only export varchar).
Len Morgan
-Original Message-
From: chris markiewicz <[EMAIL PROTECTED]>
To: Postgres (E-mail) <[EMAIL PROTECTED]>
Date: Friday, September 15, 2000 12:5
C will put the highest commentid first and the LIMIT 1
will only return one record.
Len Morgan
and
not the table definitions, etc.
The last version I saw was 3.0 but that's been a couple of years.
len morgan
;ll be more than glad to upload my finished RPMs when I'm done.
Len Morgan
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
s got rebuilt (I occationally forget an index when doing it "by
hand").
len morgan
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
>CREATE TABLE foo (test INT4) AS SELECT number FROM account;
I think you want something like:
SELECT number INTO TABLE foo FROM account ;
len morgan
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ork as I'd expect it
>too?
SELECT * FROM table WHERE last_name BETWEEN 'A' AND 'Fz' ;
worked for me.
You could also use BETWEEN 'A' AND 'G' to avoid all of the s at the
end. Crude but effective.
len morgan
Is it possible that there are spaces after the 'IDC16W' in the field? Try:
LIKE 'IDC16W%'
and see if that makes a difference.
len
>A direct query gets appropriate rows of data:
>
>dbname=# select * from partdef where shpname = 'IDC16W';
> pn_id | class | num | mt | ver | loc_id | unit_id | s
I believe COPY is limited to reading ENTIRE records into a table not pieces
of them.
len morgan
-Original Message-
From: Jeff Boes <[EMAIL PROTECTED]>
To: Postgres-general <[EMAIL PROTECTED]>
Date: Friday, May 25, 2001 9:20 AM
Subject: [GENERAL] COPY with default values?
You are correct and if you did your bulk insert with INSERT commands, it
will work just fine. The difference is the COPY command which AFAIK was/is
intended for backup and restore use.
len morgan
-Original Message-
From: Jeff Boes <[EMAIL PROTECTED]>
To: Postgres-general &
tion level.
You might also be able to use pl/tcl's after function to do the same thing.
len morgan
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
to
have. I'd rather not roll out 6.4.2 and then have to go to 20 different
sites and upgrade them to 6.5 later unless that upgrade process will be
easier than it has been in the past.
Thanks
Len Morgan
-Original Message-
From: Joseph Shraibman <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, May 17, 2000 4:33 PM
Subject: [GENERAL] why so big?
>I've just created a new database and I am wondering...
>
>Why are all sequence files 8K? They're one freaking int
the
rpm maintainer could create the postgres user account with a home directory
of /home/postgres instead of PG_DATA?
Anyway, my 0.02 dollar's worth.
len morgan
21 matches
Mail list logo
