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 document
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, yo
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
* 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 tar
> "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 want
> 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 A
--
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
>> >
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
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
>
[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
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
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 doc
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?
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] Addi
* 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]|[
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 th
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 a
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
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 l
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
> > 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...
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 ju
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
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,stat
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 fa
> 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
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
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
> 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 s
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 mean
>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 figur
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 lan
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
33 matches
Mail list logo
