Tom Lane wrote:
>
> Renaud Thonnart <[EMAIL PROTECTED]> writes:
> > Which is the SQL norm of PostgreSQL?
> > I suppose it is SQL3 ?
>
> AFAIK, SQL3 is not a recognized standard. We are converging (slowly)
> on full support for SQL92, and we have some SQL99 features (and will
> have more over t
Steve Wampler wrote:
>
> I just upgraded from 7.0.3 to 7.1 (using the RH rpms) with no
> major problems. Nice!
>
> However, I'm getting some strange behaviour from the init
> script (/etc/rc.d/init.d/postgresql). In particular, a
> restart when the database is running fails because the
> "sle
Jonas Bengtsson wrote:
>
> Can't you do a dump with the oid's?
>
> But when I want to know the primary key of the inserted row
> I have to do an extra select query. If I use oid I just use
> pg_getlastoid() in php.
> And it is redundant data to store another integer.
>
> Comments?
I have often
s
PostgreSQL/FS"
It's not earth shattering, and sure there are other solutions. But it's
cute and could be useful. Add some bugs and a few security compromises,
and it almost looks like M$.
--
Karl DeBisschop [EMAIL PROTECTED]
Learning Network/Information Pleas
wrong -- you need to fetch the salt from the database first.
But even so, if you then transmit this ENCRYPTED password, it can be
sniffed, and the results of that sniff are all that are needed to
access the system.
--
Karl DeBisschop [EMAIL PROTECTED]
Learning Network/
001016.12:36:23.343 [4533] DEBUG: Data Base System was interrupted being in
production at Mon Oct 16 12:35:44 2000
001016.12:36:23.365 [4533] DEBUG: Data Base System is in production state at Mon Oct
16 12:36:23 2000
001016.12:36:23.365 [4533] proc_exit(0)
001016.12:36:23.365 [4533] sh
ons in UML. Worked for me.
--
Karl DeBisschop [EMAIL PROTECTED]
Family Education Network/Information Please http://www.infoplease.com
Netsaint Plugin Developer [EMAIL PROTECTED]
nd we found dia
to handle the task easily. And for no $$$.
I second the recommendation.
--
Karl DeBisschop [EMAIL PROTECTED]
Family Education Network/Information Please http://www.infoplease.com
Netsaint Plugin Developer [EMAIL PROTECTED]
nclude
some similar form of active acknowlegement. Otherwise you will never be
able to distribute source, and it won't be open source anymore.
--
Karl DeBisschop
0/redhat-RPM/RPMS/redhat-6.x/
--
Karl DeBisschop
www.infoplease.com
ose any Perl modules you may have installed
> > > that don't come with the source distribution.
or 'ar -a libperl.a' into a directory then gcc the resulting .o files
into a single libperl.so
You will have to run ldconfig and tweak the makefile because perl
won't know that .so is available, but I've used this just fine on
RedHat, which also doesn't include a shared libperl.
Karl DeBisschop
www.infoplease.com
Tom Lane wrote:
> Karl DeBisschop <[EMAIL PROTECTED]> writes:
> > or 'ar -a libperl.a' into a directory then gcc the resulting .o
files into a
> > single libperl.so
>
> That will only work on platforms where code is compiled
> position-independent by defau
Thomas Lockhart wrote:
> > > 7.0RC5 is database-compatible with the final, earlier betas are *not*.
> > > You can use pg_upgrade to update from any 6.5-or-later version if you
> > > are feeling adventurous, but I'd definitely suggest making a backup
> > > first in case things go wrong and you hav
u should be able to do that without a dump/restore cycle, which was my
prime concern.
Karl DeBisschop
> From: "Keith G. Murphy" <[EMAIL PROTECTED]>
>
> Karl DeBisschop wrote:
> >
> > To summarize, I stated that the following does not work with
> > postgresql:
> >
> > > $dbh->{AutoCommit} = 0;
> >
> From: <[EMAIL PROTECTED]>
> On Fri, 25 Feb 2000, Karl DeBisschop wrote:
>
> >
> > >>To summarize, I stated that the following does not work with
> > >>postgresql:
> > >>
> > >>> $dbh->
esopnsibility to cehck for valid
data.
The usefulness of the idion is that in a mutli-user environment, this
is a basic way to update data that may or may not already have a key
in the table. You can't do a "SELECT COUNT" because in the time
between when you SELECT and INSERT (assumi
out
a year of use for important (maybe even 'mission-critical') purposes,
we have only had one problem that was not easily solved ourselves.
And Postgresql, Inc. solved that one for us. With alot less
aggravation than most of our 'mainstream' vendors when we have a
problem in
local machine)
Compiler used (example: gcc 2.8.0) :
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
I would appreciate any suggestions on additional possibilities for
diagnosis or repair.
--
Karl DeBisschop <[EMAIL PROTECTED]>
617.832.0332 (Fax: 617.956.2696)
> > By the way, I know about using pg_dump to backup the database and I do
> > that. Is there a good way to maintain a second identical copy of the
> > database on another machine? Will simply copying the dump over and
> > restoring it with psql do the trick? Would I need to delete an old
machine, use it only for redirects to the
pages that call postgres (assuming this is not your whole site). Then
throttle the second server back as described above (we haven't
actually done this - but it seems it should work).
--
Karl DeBisschop <[EMAIL PROTECTED]>
617.832.0332 (Fax:
Not sure that you can drop/create system indexes (I didn't notice that
when I posted earlier - sorry). But the the same idea may apply - can
you dump and recreate the database tables.
$ pg_dump existing > existing.dump
$ psql -e secondtry < exidting.dump
BTW, do you need to cross-post to all t
the
insert, or an error code (a negative number). But the OID can be
obtained by $oid = sth->{'pg_oid_status'};
--
Karl DeBisschop <[EMAIL PROTECTED]>
617.832.0332 (Fax: 617.956.2696)
Information Please - your source for FREE online reference
http://www.infoplease.com - Your Ultimate Fact Finder
http://kids.infoplease.com - The Great Homework Helper
Oops - Stupid mistake.
I thought i had filtered put all of the nulls and blank entries
from the source table, but I hadn't. Of course the match doesn't work
on a blank entry.
the user-defined aggregate functions do work properly, and as
expected. Sorry to trouble everyone.
pr $num + $a * 1000]
' LANGUAGE 'pltcl';
The function works fine in the statement
=> SELECT uid2int(uid),ipd from rhd;
but fails in
=> SELECT uid2int(uid),uid2int(ipd) from rhd;
ERROR: pltcl: can't read "pre": no such variable
where both uid and ip
> How can you
>
> if(update row fails because doesn't exist, ie. returns 0)then(insert row)
Depends on what interface you are using.
In perl DBI, the return value of the a $dbh->do("update...") should be
the nomber of rows inserted. Same with doing a sequence of
$sth=$dbh->prepare("update
are you doing this in psql?
Or perl, php, or some other?
perl and php both have methods for getting the oid of the last
inserted row (use "$oid = $sth->{'pg_oid_status'};"
in perl and "$oid = pg_GetLastOid($result_id);" in php )
Look at the php documentation, or do 'perldoc DBD::Pg'
to see mor
odify pghba.conf, to revoke access to databases
> for every user/domain; delete smth, whatever you want and restore access.
> I'm not sure if it break current connections, rollback transactions etc.
> - you should test it ;)
>
> At 13:57 99-03-19 -0500, Karl DeBisschop wrote:
Does anyone know a way to lock a database under postgres while
leaving available the other databases managed by postmaster?
We are running postgreSQL 6.4.2 on our web site for content serving
and for registration information. There are 4 separate databases
served by postmatser to support these
29 matches
Mail list logo
