Re: [GENERAL] Trouble with RPM
Gilles DAROLD wrote: > Please don't use RPM if you don't want to have a Win$ based install. > It's remember me a very old question: Where are the DLL ? > The better way is to get the tarball and do a fresh compilation, you will > learn more about postgres (see the INSTALL file and other documentation). > And then all your files will go in /usr/local/pgsql by default ! You know, it's responses like this that make me think... why do I pour so much energy in trying to get the RPM's right? And then I remember all those folks that have thanked me for the good RPMs. RPMs are in no way comparable to Win. But, then again, if you want to really learn X, or the linux kernel, you should really go do the 'roll-your-own-distribution' thing -- not use RedHat at all. The RPM's have been built to simply and easily allow things that are not easily possible with the standard tarball installation -- such as not having the postmaster/backend on a client-only system. Or picking and choosing amongst the clients. Or not having to have the source taking up space after the system is built. Some folks actually want to run PostgreSQL on secure boxen that won't even have a compiler installed -- such as my production database server. And, if you build from source, and put everything in /usr/local/pgsql, you have all that added work to get everything working right. If you just simply want to _use_ PostgreSQL to get some work done, then there is nothing at all wrong with using the RPM set. To answer the original question, refer to the /usr/doc/postgresql-7.0.2/README.rpm file -- then install postgresql-server RPM. As to 'DLL Hell' -- thanks to the way rpm works, you are never in danger of this -- rpm -ql package-name gives you a complete list of files in a particular rpm. The companion 'rpm -qf /some/file/some/where' gives you the inverse, showing what package a file belongs to. Of course, you do need a recent RedHat distribution -- but you need that anyway. (I am working on getting the source RPM to build on other distributions/OS's) Comparing the RPM installation to Win is a low blow -- so, yes, it does strike a nerve. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Re: [GENERAL] Trouble with RPM
BTW, Lamar, thanks for the RPMs. Fine job. Lamar Owen wrote: > > Gilles DAROLD wrote: > > Please don't use RPM if you don't want to have a Win$ based install. > > It's remember me a very old question: Where are the DLL ? > > > The better way is to get the tarball and do a fresh compilation, you will > > learn more about postgres (see the INSTALL file and other documentation). > > And then all your files will go in /usr/local/pgsql by default ! > > You know, it's responses like this that make me think... why do I pour > so much energy in trying to get the RPM's right? And then I remember > all those folks that have thanked me for the good RPMs. > > RPMs are in no way comparable to Win. But, then again, if you want to > really learn X, or the linux kernel, you should really go do the > 'roll-your-own-distribution' thing -- not use RedHat at all. > > The RPM's have been built to simply and easily allow things that are not > easily possible with the standard tarball installation -- such as not > having the postmaster/backend on a client-only system. Or picking and > choosing amongst the clients. Or not having to have the source taking > up space after the system is built. Some folks actually want to run > PostgreSQL on secure boxen that won't even have a compiler installed -- > such as my production database server. > > And, if you build from source, and put everything in /usr/local/pgsql, > you have all that added work to get everything working right. If you > just simply want to _use_ PostgreSQL to get some work done, then there > is nothing at all wrong with using the RPM set. > > To answer the original question, refer to the > /usr/doc/postgresql-7.0.2/README.rpm file -- then install > postgresql-server RPM. > > As to 'DLL Hell' -- thanks to the way rpm works, you are never in danger > of this -- rpm -ql package-name gives you a complete list of files in a > particular rpm. The companion 'rpm -qf /some/file/some/where' gives you > the inverse, showing what package a file belongs to. Of course, you do > need a recent RedHat distribution -- but you need that anyway. (I am > working on getting the source RPM to build on other > distributions/OS's) > > Comparing the RPM installation to Win is a low blow -- so, yes, it does > strike a nerve. > > -- > Lamar Owen > WGCR Internet Radio > 1 Peter 4:11
Re: [GENERAL] Trouble with RPM
Gilles DAROLD <[EMAIL PROTECTED]> writes: > Hi, > > Please don't use RPM if you don't want to have a Win$ based install. > It's remember me a very old question: Where are the DLL ? > > The better way is to get the tarball and do a fresh compilation, you will > learn more about postgres (see the INSTALL file and other documentation). > And then all your files will go in /usr/local/pgsql by default ! > > Note: I use rh6.2 :-) Except that with tarball, you have a much higher chance of not compiling, misconfiguring, or botching the install (I dont't mean postgress specifically here.) And when this happens to your friends and coworkers, and you are the local Linux expert, who do you think will be doing the 'learning'? :-) -- Prasanth Kumar [EMAIL PROTECTED]
Re: [GENERAL] Trouble with RPM
* Prasanth A. Kumar <[EMAIL PROTECTED]> [000717 08:49] wrote: > Gilles DAROLD <[EMAIL PROTECTED]> writes: > > > Hi, > > > > Please don't use RPM if you don't want to have a Win$ based install. > > It's remember me a very old question: Where are the DLL ? > > > > The better way is to get the tarball and do a fresh compilation, you will > > learn more about postgres (see the INSTALL file and other documentation). > > And then all your files will go in /usr/local/pgsql by default ! > > > > Note: I use rh6.2 :-) > > Except that with tarball, you have a much higher chance of not > compiling, misconfiguring, or botching the install (I dont't mean > postgress specifically here.) And when this happens to your friends > and coworkers, and you are the local Linux expert, who do you think > will be doing the 'learning'? :-) Depends on the size of your LART. :) -Alfred
Re: Re: [GENERAL] Logging Help Needed
> "Oakley " <[EMAIL PROTECTED]> writes: > > When I did the configure, I did it with > > --enable-syslog and with the --without-CXX > > options. I read the online docs and created a > > file in the /usr/local/pgsql/data directory > > called postgresql.conf, and put in the options > > I wanted, those being: > > Sigh. We've *really* got to rearrange the website so that the most > visible set of docs are for the latest release, not for the development > tip version. You're trying to use configuration features that will be > in 7.1, but they're not there now. See the docs that came with 7.0.* > instead. > > regards, tom lane > Hee ... I was caught by that one... http://www.postgresql.org/mhonarc/pgsql-general/2000-06/msg00687.html So many programs apologize for not having the docs updated with the software... Postgres must be the only one having docs on line that apply to a future version :- Regards Hernan
Re: [GENERAL] COUNT DISTINCT
> Bruce Momjian wrote: > > Hey, we didn't design SQL, we just implement it. :-) Oh, that's quotable... ;) - Jeff -- [EMAIL PROTECTED] - http://linux.conf.au/ -- linux.conf.au - coming to Sydney in January 2001 Installing Linux Around Australia - http://linux.org.au/installfest/
Re: Re: [GENERAL] Logging Help Needed
-- On Mon, 17 Jul 2000 13:19:33 leonbloy wrote: >> "Oakley " <[EMAIL PROTECTED]> writes: >> > When I did the configure, I did it with >> > --enable-syslog and with the --without-CXX >> > options. I read the online docs and created a >> > file in the /usr/local/pgsql/data directory >> > called postgresql.conf, and put in the options >> > I wanted, those being: >> >> Sigh. We've *really* got to rearrange the website so that the most >> visible set of docs are for the latest release, not for the development >> tip version. You're trying to use configuration features that will be >> in 7.1, but they're not there now. See the docs that came with 7.0.* >> instead. >> >> regards, tom lane >> > >Hee ... I was caught by that one... >http://www.postgresql.org/mhonarc/pgsql-general/2000-06/msg00687.html > >So many programs apologize for not having the docs >updated with the software... >Postgres must be the only one having docs on line that >apply to a future version :- > >Regards > >Hernan > First off, lemme say thanks to everyone... now I have one more thing... where are the docs that go along with the current version? I have browsed and rebrowsed the site and everything seems to stick right with the forthcoming version... oak Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com
[GENERAL] Quoting routines in libpq
Hello, Just a small question: why there is not any quoting routine in libpq. This is very handy to have one. And also it is quite hard always write quoting routing for database if you want to have cross database code. -- Sincerely Yours, Denis Perchine -- E-Mail: [EMAIL PROTECTED] HomePage: http://www.perchine.com/dyp/ FidoNet: 2:5000/120.5 --
Re: Re: [GENERAL] Logging Help Needed
On Mon, 17 Jul 2000, Oakley wrote: > > -- > > On Mon, 17 Jul 2000 13:19:33 leonbloy wrote: > >> "Oakley " <[EMAIL PROTECTED]> writes: > >> > When I did the configure, I did it with > >> > --enable-syslog and with the --without-CXX > >> > options. I read the online docs and created a > >> > file in the /usr/local/pgsql/data directory > >> > called postgresql.conf, and put in the options > >> > I wanted, those being: > >> > >> Sigh. We've *really* got to rearrange the website so that the most > >> visible set of docs are for the latest release, not for the development > >> tip version. You're trying to use configuration features that will be > >> in 7.1, but they're not there now. See the docs that came with 7.0.* > >> instead. > >> > >>regards, tom lane > >> > > > >Hee ... I was caught by that one... > >http://www.postgresql.org/mhonarc/pgsql-general/2000-06/msg00687.html > > > >So many programs apologize for not having the docs > >updated with the software... > >Postgres must be the only one having docs on line that > >apply to a future version :- > > > >Regards > > > >Hernan > > > > First off, lemme say thanks to everyone... now I have one more thing... > > where are the docs that go along with the current version? I have browsed and >rebrowsed the site and everything seems to stick right with the forthcoming version... It's not yet ready for prime time, but you can find the docs here: http://www.Postgresql.org/users-lounge/index.html Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Logging Help Needed
[EMAIL PROTECTED] writes: > So many programs apologize for not having the docs > updated with the software... > Postgres must be the only one having docs on line that > apply to a future version :- Yup ;-). It's nice having the devel docs up there, but seems like they ought to be labeled or segregated or something. I have the following bookmarks: http://www.postgresql.org/docs/postgres/index.html">PostgreSQL manual (development version at hub.org). http://www.postgresql.org/users-lounge/docs/7.0/postgres/postgres.htm">PostgreSQL manual (7.0 release at hub.org). regards, tom lane
Re: [GENERAL] Logging Help Needed
Well, I did some *more* reading, and created the pg_options file which contains:
syslog=0
debug_level=0
log_connections=yes
log_timestamp=yes
showportnumber
port=5432
and restarted the thing with the command: (of course all on one line):
su postgres -c 'nohup /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -d 4
>/var/log/postgres.log 2>&1' &
and while I am doing this, I am running a tail -f on the postgres.log file... here is
the results of logging in and running a query:
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
binding ShmemCreate(key=52e2c1, size=1104896)
DEBUG: Data Base System is starting up at Mon Jul 17 12:33:27 2000
DEBUG: Data Base System was shut down at Mon Jul 17 12:33:06 2000
DEBUG: Data Base System is in production state at Mon Jul 17 12:33:27 2000
proc_exit(0)
shmem_exit(0)
exit(0)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: ServerLoop:handling reading 4
/usr/local/pgsql/bin/postmaster: ServerLoop:handling reading 4
/usr/local/pgsql/bin/postmaster: ServerLoop:handling writing 4
/usr/local/pgsql/bin/postmaster: ServerLoop:handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop:handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop:handling writing 5
/usr/local/pgsql/bin/postmaster: ServerLoop:handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop:handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop:handling writing 5
/usr/local/pgsql/bin/postmaster: BackendStartup: environ dump:
-
PWD=/usr/local/pgsql/data
HZ=100
HOSTNAME=skate
LD_LIBRARY_PATH=/usr/local/pgsql/lib
MANPATH=:/usr/local/pgsql/man
USER=root
MACHTYPE=i386-pc-linux-gnu
MAIL=/var/spool/mail/root
LANG=C
LOGNAME=root
SHLVL=3
SHELL=/bin/sh
HOSTTYPE=i386
OSTYPE=linux-gnu
TERM=vt100
HOME=/usr/local/pgsql
PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games
POSTPORT=5432
POSTID=2147483646
PGDATA=/usr/local/pgsql/data
IPC_KEY=5432000
PG_USER=oakley
-
/usr/local/pgsql/bin/postmaster: BackendStartup: pid 12115 user oakley db oakley
socket 5
/usr/local/pgsql/bin/postmaster child[12115]: starting with (/usr/local/pgsql/bi
n/postgres -d4 -v131072 -p oakley )
invalid option: /usr/local/pgsql/bin/postmaster
invalid option: 5432invalid option: 64
invalid option: /usr/local/pgsql/bin/postgres
invalid option: 4
invalid option: 32
read_pg_options: /usr/local/pgsql/bin/postmaster,-p,5432,-D,/usr/local/pgsql/dat
a,-B,64,-b,/usr/local/pgsql/bin/postgres,-d,4,-N,32
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
started: host=localhost user=oakley database=oakley
InitPostgres
StartTransactionCommand
query: SELECT usesuper FROM pg_user WHERE usename = 'oakley'
parser outputs:
{ QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBi
nary false :isTemp false :unionall false :distinctClause <> :sortClause <> :rtab
le ({ RTE :relname pg_user :ref { ATTR :relname pg_user :attrs <>} :relid 17280
:inh false :inFromCl true :inJoinSet true :skipAcl false}) :targetlist ({ TARGET
ENTRY :resdom { RESDOM :resno 1 :restype 16 :restypmod -1 :resname usesuper :res
key 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :vara
ttno 5 :vartype 16 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5}}) :qu
al { EXPR :typeOid 16 :opType op :oper { OPER :opno 93 :opid 0 :opresulttype 16
} :args ({ VAR :varno 1 :varattno 1 :vartype 19 :vartypmod -1 :varlevelsup 0 :
varnoold 1 :varoattno 1} { CONST :consttype 19 :constlen 32 :constisnull false :
constvalue 32 [ 11
1 97 107 108 101 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ]
:constbyval false })} :gr
oupClause <> :havingQual <> :hasAggs false :hasSubLinks false :unionClause <>
:intersectClause <> :li
mitOffset <> :limit Count <> :rowMark <>}
plan:
{ SEQSCAN :startup_cost 0.00 :total_cost 1.01 :rows 1 :width 1 :state <> :qptarg
etlist ({ TARGETENTR
Y :resdom { RESDOM :resno 1 :restype 16 :restypmod -1 :resname usesuper :reskey 0
:reskeyop 0 :ressor
tgroupref 0 :resjunk false } :expr { VAR :varno 4 :varattno 5 :vartype 16 :vartypmod
-1 :varlevelsup
0 :varnoold 4 :va roattno 5}}) :qpqual ({ EXPR :typeOid 16 :opType op :oper { OPER
:opno 93 :opid 6
2 :opresulttype 16 } :args ({ VAR :varno 4 :varattno 1 :vartype 19 :vartypmod -1
:varlevelsup 0 :var
noold 4 :varoattno 1} { CONST :consttype 19 :constlen 32 :constisnull false
:constvalue 32 [ 111 97
107 108 101 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ] :constbyval
false })}) :lefttr
ee <> :righttree <> :extprm () :locprm () :initplan <> :nprm 0 :scanrelid 4 }
ProcessQuery
CommitTransactionCo
Re: [GENERAL] Logging Help Needed
On Mon, 17 Jul 2000, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > So many programs apologize for not having the docs > > updated with the software... > > Postgres must be the only one having docs on line that > > apply to a future version :- > > Yup ;-). It's nice having the devel docs up there, but seems like they > ought to be labeled or segregated or something. > > I have the following bookmarks: > > http://www.postgresql.org/docs/postgres/index.html">PostgreSQL > manual (development version at hub.org). > > HREF="http://www.postgresql.org/users-lounge/docs/7.0/postgres/postgres.htm">PostgreSQL > manual (7.0 release at hub.org). It changed from that one, and I don't know how. Originally it was users-lounge/7.0/docs/... Then it became users-lounge/docs/7.0/... I checked it earlier when it didn't work and now it's: users-lounge/docs/v7.0/... I just can't wait to see what it'll become in August! so the corrected link is: http://www.postgresql.org/users-lounge/docs/v7.0/postgres/postgres.htm Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
[GENERAL] Adding a colum
I'm pretty new using postgres, but is there any way to add a field to a table without droping the table and recreating it?
Re: [GENERAL] Adding a colum
www.postgresql.org select Info Central select Documentation select Integrated Document select I - 19 ALTER TABLE ALTER TABLE ADD COLUMN -Original Message- From: Steven <[EMAIL PROTECTED]> To: Postgres-Gen List <[EMAIL PROTECTED]> Date: Monday, July 17, 2000 1:28 PM Subject: [GENERAL] Adding a colum >I'm pretty new using postgres, but is there any way to add a field to a >table without droping the table and recreating it? >
Re: [GENERAL] Adding a colum
* Steven <[EMAIL PROTECTED]> [000717 11:28] wrote: > I'm pretty new using postgres, but is there any way to add a field to a > table without droping the table and recreating it? it's in the docs: http://www.postgresql.org/docs/user/sql-altertable.htm -- -Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]] "I have the heart of a child; I keep it in a jar on my desk."
Re: [GENERAL] Trouble with RPM
Lamar Owen wrote: > > The better way is to get the tarball and do a fresh compilation, you will > > learn more about postgres (see the INSTALL file and other documentation). > > And then all your files will go in /usr/local/pgsql by default ! > > You know, it's responses like this that make me think... why do I pour > so much energy in trying to get the RPM's right? And then I remember > all those folks that have thanked me for the good RPMs. Sorry but I don't want to minimate your well done work. I just want to say that installing some software distribution (postgresql or others) need to take a look of what it is, what there are and where do it goes. If you don't know about rpm, typing rpm -i package.rpm it's very simple and powerfull but it's just like installing binaries and no matter if it really works or not. Wait and see ! > RPMs are in no way comparable to Win. But, then again, if you want to > really learn X, or the linux kernel, you should really go do the > 'roll-your-own-distribution' thing -- not use RedHat at all. I'm agree with you, I use RedHat because it's easy to install and I don't want to spend all my time to intall. Why not at all ? I just do rpm -e and reinstall Postresql with the last version with all customization needed. > The RPM's have been built to simply and easily allow things that are not > easily possible with the standard tarball installation -- such as not > having the postmaster/backend on a client-only system. Or picking and > choosing amongst the clients. Or not having to have the source taking > up space after the system is built. Some folks actually want to run > PostgreSQL on secure boxen that won't even have a compiler installed -- > such as my production database server. Agree, this is the power of rpms... I just asked a question about rpm because in few years perhaps no one will read the readme and install files which are certainly plain of important informations. But perhaps we'll never need them anymore. > And, if you build from source, and put everything in /usr/local/pgsql, > you have all that added work to get everything working right. If you > just simply want to _use_ PostgreSQL to get some work done, then there > is nothing at all wrong with using the RPM set. Yes, where are the files ? > As to 'DLL Hell' -- thanks to the way rpm works, you are never in danger > of this -- rpm -ql package-name gives you a complete list of files in a > particular rpm. The companion 'rpm -qf /some/file/some/where' gives you > the inverse, showing what package a file belongs to. Of course, you do > need a recent RedHat distribution -- but you need that anyway. (I am > working on getting the source RPM to build on other > distributions/OS's) > > Comparing the RPM installation to Win is a low blow -- so, yes, it does > strike a nerve. Sorry for your nerve this was just and informative reflexion not a comparison otherwise I promise you I'll never use rh anymore :-) I understand that my message heart you a little, I don't like such of words on my work... I like rpm, especialy for system update. Congratulation ! Gilles
Re: [GENERAL] Trouble with RPM
DAROLD Gilles wrote: > Yes, where are the files ? > > of this -- rpm -ql package-name gives you a complete list of files in a > > particular rpm. The companion 'rpm -qf /some/file/some/where' gives you Or, for laughs: rpm -qa|grep ^postgresql|xargs -n 1 rpm -ql This will give you a listing of all files on your system that belong to any of the postgresql rpms. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Re: [GENERAL] Quoting routines in libpq
Denis Perchine writes: > Just a small question: why there is not any quoting routine in libpq. Can you give an example of what it should do? -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden
Re: [GENERAL] Quoting routines in libpq
On Tue, 18 Jul 2000, Peter Eisentraut wrote: > Denis Perchine writes: > > > Just a small question: why there is not any quoting routine in libpq. > > Can you give an example of what it should do? Just as a guess, something that parses a string and escapes single quotes, backslashes and stuff like that. I rolled my own for apps that I worked on that needed one, lately I've been using PHP which has such a function and a reversing function. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
[GENERAL] Mailing list archives?
Does an archive of the various pgsql- mailing lists exist? If so, would you be so kind as to tell me how to access them? Thank you, John McKown
Re: [GENERAL] Logging Help Needed
> > Yup ;-). It's nice having the devel docs up there, but seems like they > > ought to be labeled or segregated or something. Vince, can we re-target the most-visible docs references to point at the 7.0 release docs? I would assume it is just a matter of making or changing a soft link or two... - Thomas
Re: [GENERAL] Logging Help Needed
On Tue, 18 Jul 2000, Thomas Lockhart wrote: > > > Yup ;-). It's nice having the devel docs up there, but seems like they > > > ought to be labeled or segregated or something. > > Vince, can we re-target the most-visible docs references to point at the > 7.0 release docs? I would assume it is just a matter of making or > changing a soft link or two... Should be able to make it happen in the next few days. I'm about to freeze the website. The tool is finally working that will maintain and create the site (haven't finished the cvs stuff yet, I'll hafta do them manually). The only thing that'll be in a frame is the docs, for all versions. There is a major problem tho. When I first started with the user's lounge I created two directories, 6.5 and 7.0. Under those were docs directories. I remember them being changed to docs/6.5 and docs/7.0 but don't remember why - but that's not the problem. Last month I updated the user's lounge even tho it's not ready for consumption so it'd point to the new locations. Today I find that they're now v6.5 and v7.0. I'm not sure what's going on, but for now I just symlinked it, but it can't keep playing musical chairs. Is this in a script somewhere for generating the older docs? Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [GENERAL] Mailing list archives?
On Mon, 17 Jul 2000, John McKown wrote: > Does an archive of the various pgsql- mailing lists exist? If so, > would you be so kind as to tell me how to access them? Go to the website. Choose Info Central then Mailing Lists. They all should be listed, but I haven't checked yet to make sure. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
[GENERAL] MOD
Hello,
I'm updating an existing postgres database, and using
perl with dbi to
access it.
Everything works fine,
I'm just not sure what this MOD command means.
Not asking you to figure it out in this context,
but just what does MOD do?
$sqh = $dbh->prepare("select
name,namelink,address,city,state,zip,email
from company where MOD(nextscreen,2)=1 order
by $sort_selection;");
$sqh->execute();
thank you,
Tyler Wood
[EMAIL PROTECTED]
__
Do You Yahoo!?
Get Yahoo! Mail Free email you can access from anywhere!
http://mail.yahoo.com/
[GENERAL] backing up database
I'm in the /usr/local/pgsql directory, as pgsql: [pgsql@host pgsql]$ whoami pgsql and it doesn't seem to work when i try to backup the database. this is what i type: [pgsql@host pgsql]$ pg_dump foodserver > foodserver_7_13_2000.pgdump and this is the error I get: getInherits(): SELECT failed anybody know something I'm doing wrong? Tyler Wood [EMAIL PROTECTED] __ Do You Yahoo!? Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/
Re: [GENERAL] Logging Help Needed
> Today I find that they're now v6.5 and v7.0. I know I was working in there a bit to post the 6.5 and 7.0 docs, and to get the auto-updating development docs to work. But I can't recall changing directory structure (though I *may* have done so). Should I feel guilty, or have you identified another culprit? Can anyone speak up who had an opinion (or who has dirty hands ;) on this so Vince can get back to being right-side-up and oriented? - Thomas
Re: [GENERAL] Logging Help Needed
On Tue, 18 Jul 2000, Thomas Lockhart wrote: > > Today I find that they're now v6.5 and v7.0. > > I know I was working in there a bit to post the 6.5 and 7.0 docs, and to > get the auto-updating development docs to work. But I can't recall > changing directory structure (though I *may* have done so). Should I > feel guilty, or have you identified another culprit? You may have done the original 6.5/docs to docs/6.5, no complaint there. But docs/6.5 to docs/v6.5 was a surprise. We need to make sure it's not going to change again unannounced. > Can anyone speak up who had an opinion (or who has dirty hands ;) on > this so Vince can get back to being right-side-up and oriented? Not necessary unless it happens again. Then I'm gonna be looking for a big stick! :) Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
[GENERAL] From timestamp to seconds since epoch?
I've read through all the documentation, and I can't find a function
that takes a timestamp and converts iit to seconds since epoch.
Here's what I need to do: I have pairs of timestamps ('2000-07-12
03:33:53+00'), and I want to find out how many seconds are in the
interval between them. I know I can do
select timestamp1 - timestamp2
and I get a result in days, hours, mins, and seconds, but is there a
way to get that whole thing in just seconds? This has to be pretty
efficient, because it's going to get called a lot.
Thanks,
e
Re: [GENERAL] From timestamp to seconds since epoch?
> I've read through all the documentation, and I can't find a function
> that takes a timestamp and converts iit to seconds since epoch.
That would be date_part('epoch', ts) ...
> Here's what I need to do: I have pairs of timestamps ('2000-07-12
> 03:33:53+00'), and I want to find out how many seconds are in the
> interval between them. I know I can do
> select timestamp1 - timestamp2
> and I get a result in days, hours, mins, and seconds, but is there a
> way to get that whole thing in just seconds? This has to be pretty
> efficient, because it's going to get called a lot.
... and that would be date_part('epoch', ts1 - ts2)
- Thomas
Re: [GENERAL] MOD
MOD is the remainder after division.
MOD(10, 3) = 1
MOD(11, 3) = 2
MOD(12, 3) = 0
MOD(13, 3) = 1
etc.
Tyler Wood wrote:
>
> Hello,
> I'm updating an existing postgres database, and using
> perl with dbi to
> access it.
>
> Everything works fine,
> I'm just not sure what this MOD command means.
> Not asking you to figure it out in this context,
> but just what does MOD do?
>
> $sqh = $dbh->prepare("select
> name,namelink,address,city,state,zip,email
> from company where MOD(nextscreen,2)=1 order
> by $sort_selection;");
> $sqh->execute();
>
> thank you,
>
> Tyler Wood
> [EMAIL PROTECTED]
>
> __
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
Re: [GENERAL] MOD
>Not asking you to figure it out in this context,
>but just what does MOD do?
>
>
>$sqh = $dbh->prepare("select
>name,namelink,address,city,state,zip,email
>from company where MOD(nextscreen,2)=1 order
>by $sort_selection;");
>$sqh->execute();
>
I believe it's just trying to figure out if "nextscreen" is odd or even. 1
would odd, 0 even.
len morgan
Re: [GENERAL] backing up database
Tyler Wood <[EMAIL PROTECTED]> writes: > getInherits(): SELECT failed I don't think you've given us the whole error message --- but I'm going to venture a wild guess that you're running a 6.5 pg_dump against a 7.0 database or vice versa. Check your PATH. regards, tom lane
Re: [GENERAL] Mailing list archives?
On Mon, 17 Jul 2000, Vince Vielhaber wrote: > On Mon, 17 Jul 2000, John McKown wrote: > > > Does an archive of the various pgsql- mailing lists exist? If so, > > would you be so kind as to tell me how to access them? > > Go to the website. Choose Info Central then Mailing Lists. They all > should be listed, but I haven't checked yet to make sure. > Thanks. They were staring me in the face. Somehow I read the "Archives" as "addresses" and thought they were just a list of the various lists available. Time for more medicine (or less) John
