Well, you could always make a table that has no constraints on duplicates
and COPY TO that one. Then, make a query that inserts the data into your
production table that handles the duplicates.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From
at is true, what would be the solution? Create the sequence manually,
don't drop the sequence in the script, and have the create table script not
as a SERIAL, but have it set to a default value of the sequence?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
Oh wow (after reading over pg_dump and trying it). I didn't know about
that. That's very nice.
Is it safe and accurate? Should I be able to feel mostly secure about using
that to dump my database definitions?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
ar(10) references models
on delete cascade);
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
But wouldn't the dependencies be there whether I compile from scratch or use
an RPM?
What the main issue that stumped was the libc.6.so dependency. According to
epm -a -q, it is installed.
I guess I can blow out 6.5 and download the 7.0 source and reinstall a
compiled version.
Adam
a>logfile 2>&1
I do not know what to do from this point. I would have thought if this was
missing I would have had an error on compile.
(Hence my infatuation with RPMs :) )
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
/usr/local/pgsql/lib in the ld.so.conf file.
I'm not sure what else to try, but I really hope the answer of "compile php"
isn't the answer.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
Nevermind... apparently if I rpm it with --nodeps it ignores it, but the php
script still runs correctly.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Adam Lang" <[EMAIL PROTECTED]>
To: "PGSQL General" <[EMA
I'm still having difficulties getting postgres to start on boot.
Any chance someone can give me an example of how they have it on their
system?
(Seemed to have been lost in the list being down).
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
Does it work the same for linux?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "David Veatch" <[EMAIL PROTECTED]>
To: "Adam Lang" <[EMAIL PROTECTED]>; "PGSQL General"
<[EMAIL PROTECTED]>
Sent:
#x27;t understand the point of the 1's and 2's in the command though.
Why is everyone else's script working without the -l and mine wasn't?
Thanks.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -
From: "David Veatch" <[E
ocal/pgsql/postgres.log 2>&1 &"
stop)
restart)
end case
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
From: "Adam Lang" <[EMAIL PROTECTED]>
To: "Alfred Perlstein" <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 4:28 PM
Subject: Re: [GENERAL] Starting postmaster at boot
> I did, and that is why I don't understand.
>
> Adam Lang
> Syst
oh... so since I did a su -l, I could have just used the command,
postmaster -i >>postgres.log 2>>1 & ? Since I had the appropriate variables
in postgres's .bash_profile?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From:
he command: postmaster -i
because I have the variables for the location of postmaster and pgdata set.
But, I would assume that typing the absolute paths would have gotten around
that for when I was doing the su. Are there other environment variables I
didn't take insto consideration?
Adam Lang
S
ed it, would do something like find rows in table
1 which aren't in the second database, append them database two, same with
the second table, etc.)
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.postgresql.org/docs/awbook.html
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: "Adam Haberlach" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, September 22
Did you start postmaster with the -i option?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Randall Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 25, 2000 4:51 PM
Subject: Re: [GENERAL] Postgr
ly use Java for every level of development.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Michelle Murrain" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 25, 2000 9:15 PM
Subject: [GENERAL] web programming
Well, I only want them to access it through a front end. No one is actually
going to be running straight out queries, creating tables, etc.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Danny" <[EMAIL PROTECTED]>
To: &qu
I'd assume a problem with changing all the commands now is that it may break
a lot of people's scripts and programs.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Keith L. Musser" <[EMAIL PROTECTED]>
To: "PGSQL-Ge
issues, correct?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Travis Bauer" <[EMAIL PROTECTED]>
To: "Keith L. Musser" <[EMAIL PROTECTED]>
Cc: "PGSQL-General" <[EMAIL PROTECTED]>
Sent: Thursday, S
Not to mention the fact that PHP 4 installs with MySQL support native.
If RedHat did do MySQL by default, technically Apache, PHP, and MySQL would
be a pretty straightforward Web Serving bundle.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From
Well, I treat upgrading RedHat like I treat upgrading any OS... clean
install.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Jeff Hoffmann" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 29, 200
an be extracted, but it looks like the modules are a lot
tighter together.
So, in the php 4 RPM, you still need to add myql explicitly?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
> - Original Message -
> From: "Trond Eivind Glomsrød" <[EMAIL PROT
Create a new table and select insert from the old one to the new one without
the column of data.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Andrew Gould" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, Oct
package that I didn't have installed, because I reinstalled the OS and
tried again and it picked it up fine.
Sorry.. i gave more of a theoried explanation than a solution...
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: <[EMAIL PROTEC
t is tough what to say because there are basically two camps: make a rule
now to prevent possible issues later on, or not worry too much about it and
deal with it if an issue develops.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Alfred Per
attack
that it would be done with evil intent.
But, as many others have said, the core team seems to have a good hold on
reality and their ethics, so it probably won't come to an issue. :)
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "To
May bad... sometimes it is too easy assuming everything open source is GPL.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Lamar Owen" <[EMAIL PROTECTED]>
To: "Adam Lang" <[EMAIL PROTECTED]>
Cc: <[EMAIL PRO
Yeah, but I can't sit and read stuff like that on a screen... Granted I can
print it and get a binder, etc... but stuff like that really is easier in
publication and as long as the price isn't gouged and the book is good, I
don't mind forking out cash for it.
Adam Lang
Systems E
lanning on
doing will make it easier to keep up to date without having to weed through
a whole new book and pick apart the new info and how to use it.
Open source is great and all, but soo many times it takes a long time to
find useful and relevant info.
Adam Lang
Systems Engineer
Rutgers Casualty
Hmmm... interesting concept... Warez for Books. :)
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Louis Bertrand" <[EMAIL PROTECTED]>
Cc: "Adam Lang" <[EM
he best option is to have a form that they fill in and the script
constructs the query on its own... (as well as the user security enabled).
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Rikul Patel" <[EMAIL PROTECTED]>
To: <[E
ave more info. They
have a couple install procedures detailed out.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Travis Bauer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 17, 2000 7:26 AM
Subject: [GENE
I assume redhat does... I believe I patched it with an RPM from them.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "luc" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>;
I don't think that is it. It has been a while, but I thought if you didn't
compile php with psql, it returned an "undefined function" error.
By the way... I just found out a little bit ago that the pgsql-php list is
still alive. :)
Adam Lang
Systems Engineer
Rutgers Casual
Did you have those two dependency packages installed? I know, silly
question, but...
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Darrin Ladd" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 24
But I think he wants to know how to have 3 different databases in three
different locations.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Wade D. Oberpriller" <[EMAIL PROTECTED]>
To: "Brian C. Doyle" <[EMAIL
wierd that so many
people ask where to find them...
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Lamar Owen" <[EMAIL PROTECTED]>
To: "Adam Lang" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, Octo
It also relates back to a post I made many moons ago. I don't upgrade any
OS (outside of minor patches). If it is a new OS version, backup and then
clean install. Just too many variables to contend with to trust a type of
upgrade script.
Adam Lang
Systems Engineer
Rutgers Casualty Insu
tributions.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "os390 ibmos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 31, 2000 5:14 PM
Subject: Re: [GENERAL] postgres on redhat 7.0
>
> Exactly my point
select * from myTable where upper(myField) like 'TEST';
Upper will change the fields to upper case for testing purposes.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Yann Ramin" <[EMAIL PROTECTED]>
To: <[EMAI
PHP 4 was having problems with persistent connections (not sure if with just
pgsql or all dbs). Maybe that is why they didn't use it.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: <[EMAIL PROTECTED]>
To: "carl garland" &
It is possible. I think the problems were arising before the currentpatch.
Problems involved not properly releasing conenctions and they were
eventually filling up as used.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Charles Tassell&quo
What do you mean by "what language"? You can use PHP if you want it web
based application.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Enrico Comini" <[EMAIL PROTECTED]>
To: "ML-Postrges-general" <[EMAI
Replies inline.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Adam Lang" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 12:40 PM
Subject: Re: [GENERAL] Can
Here is a link that explains memory. It is from a windows2000 magazine, but
it isn't very NT specific. It speaks in genaralities. I thought it was a
rather good atrticle.
http://www.win2000mag.com/Articles/Index.cfm?ArticleID=7290
I don't think you need to be a subscriber to read
But there is an OLE DB provider for ODBC, so you can use ADO with an ODBC;
just not as nice.
As for the multiple connections thing, I do not know anything about that.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From
I have a friend that networked his iMac and MacTV to his Linux file server.
There is a program out there called Netatalk (?). Basically it is the
equivalent of Samba for Appletalk.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original
7.1 isn't released yet, let alone the rpm's.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Gordan Bobic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 12,
Do you do a lot of updates and/or deletes? If so, you need to VACUUM your
database. When rows are modified, they are not actually deleted. They are
just flagged to be ignored.
Vacuum cleans up the rows.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http
And beware the Y2K + 1 bug. :)
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Partyka Robert" <[EMAIL PROTECTED]>
To: "Rod Taylor" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]
be best suited
for internet applications and the performance is not as big of an issue.
Plus, if you plan on using XML, you are expecting to take performance hits
anyway.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From
I'd assume you'd need to make your own up (or whoever develops it.) I'd say
develop a schema that can be accessible from the internet so the XML can be
interpreted.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Mes
Beta 3 of 7.1 has been released. You won't have to worry about the row
limit and you'll also help check for any possible bugs. :)
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Mike Cannon-B
I don't recall names, but it came up in the interfaces list. Like I said,
if anyone is actually working on it, I do not know, we just chatted and
threw out some ideas and said it would be really neat. :)
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
I wasn't following the thread too closely, but database for a filesystem has
been done. BeOS uses a database for a filesystem as well as AS/400 and
Mainframes.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
Any type of commerce or site that tracks user profiles... That's a LOT of
sites that would have a need for a enterprise level DB.
Remember, the goal is 5 nines uptime. :)
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Me
There have been several recent benchmarks by non-mysql and postgres people
and the speed argument does not seem to be valid.
Even though MySQL still beats postgres in speed if they are compared with
one user on the DB, postgres seems to destroy MySQL in speed as you tend to
add users.
Adam Lang
You should probably ask the MySQL people that.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Marten Feldtmann" <[EMAIL PROTECTED]>
To: "David Wall" <[EMAIL PROTECTED]>
Cc: <
The field data type is TEXT. I don't think you need to do anything special
(as long as you are using 7.1).
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Clinton James" <[EMAIL PROTECTED]>
Location of Linux World? Links to find info? I didn't know about it.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "PostgreSQL-announce" &
Oh well, I wish I knew ahead of time... boss said it is too short of
notice... blah.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Adam Lang" <[EMAI
Plus, it allows you to add more functionality later. Say you later want to
keep track of phone numbers. Add another table with a phone number field
linked to the master table with the users instead of making your one table
consistently larger.
Adam Lang
Systems Engineer
Rutgers Casualty
Now I just need someone to write me a note and get me out of work. ;)
I'd be going up from the philly area also.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
http://www.borland.com/kylix/
I'm assuming this is Delphi, correct? The page says about dbExpress drivers
for several databases (MySQL being one of them). How does this package
interact with postgres?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
The driver has had several updates. The people on the odbc list will have
more info. I believe they have been updating the driver for 7.1 ... or was
it 7.0.1 ... I forget. :)
[EMAIL PROTECTED]
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
On another list, someone posted this question. Are they correct, old
problem, etc.? I'll pass whatever info there is back to the originating
list.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Brent
It is in the list archives several times.
All you need is to use some basic SQL.
select * from mytable where upper('my criteria') = upper(mytable.info);
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: &
70 matches
Mail list logo
