lection and compiled postgres7.2.2 against the sources in the ports
directory. Any ideas? I would greatly appreciate help on
this!
Josh Goldberg
my goodness that didn't even brush past my mind! thanks much for the
assist! :)
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Josh Goldberg" <[EMAIL PROTECTED]>
Cc: "postgres-admin" <[EMAIL PROTECTED]>
Sent: Tuesday, O
It was listed in the ldconfig hints file, but adding LD_LIBRARY_PATH to the
postmaster's login environment explicitly did the trick.
- Original Message -
From: "Chad R. Larson" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]>; "Josh Goldber
I have just done this. There are three things I have found necessary:
1. Only one backend can use the postmaster.pid file. You must edit the
sourcecode for the other backends before you compile it.
2. If you have backends A,B,C and A makes a modification to the data, B and
C need to be restart
that would be excellent if you were allowed to release your work...save some
of us from reinventing the wheel ;) What do you use from CPAN, anything
special beside Pg or DBI?
- Original Message -
From: "Jeff Boes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 16, 20
\d pg_
and tab to get the list of system tables.
- Original Message -
From: "zhaoyong wu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 18, 2002 1:06 PM
Subject: [ADMIN] How to get user names and passwords
> Hi,
> I created a database and create some users and passwo
http://www.postgresql.org/idocs/index.php?functions-math.html
(B
(Bis this what you're after?
(B
(BSELECT 1 WHERE B'1010' & B'0110' > B'0001';
(Breturns 1
(BSELECT 1 WHERE B'1010' & B'0100' > B'0001';
(Breturns null
(B
(B- Original Message -
(BFrom: "Ericson Smith" <[EMAIL PROTEC
I'm using blobs for ease of management in a high
volume, distribuited content distribution system. My last version of the
application used the filesystem to manage the content, and now that I've moved
everything to the database my code (php, perl) is much more compact and
easier to manage,
thanks for the reply. There are a few tables I did this to, here's one of
(Bthem:
(Bcms3=# select oid,* from pg_class where relname='view_log';
(B oid | relname | reltype | relowner | relam | relfilenode | relpages |
(Breltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared |
to get the last record inserted just
select * from row order by autoincId desc limit 1;
if you have several clients doing this you might want to put your insert and
the select inside a transaction.
- Original Message -
From: "Michael Kovalcik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
S
form the NEXTVAL is surely less expensive than
> a query on the table after the insert to get the ID.
>
> Josh Goldberg wrote:
> >
> > to get the last record inserted just
> > select * from row order by autoincId desc limit 1;
> >
> > if you have several client
n 26, 2003 at 14:00:33 -0700,
> Josh Goldberg <[EMAIL PROTECTED]> wrote:
> > to get the last record inserted just
> > select * from row order by autoincId desc limit 1;
> >
> > if you have several clients doing this you might want to put your insert
and
> >
om now on, just to play it safe :-)
- Original Message -
From: "Bruno Wolff III" <[EMAIL PROTECTED]>
To: "Josh Goldberg" <[EMAIL PROTECTED]>
Cc: "Michael Kovalcik" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003
Concatenating a null value makes the string null. try:
SELECT 'foo'||NULL||'bar';
Just add a condition to check rivi.suoritus for null before making an
assignment.
Mauri Sahlberg wrote:
returns nothing - bush becomes null and everything fails. I do not
undestand why bush becomes null when the
I was experimenting with moving some of my case logic out of the
application and into sql and found a strange EXPLAIN result with one of
my COALESCE statements. Why is each subselect listed twice? This is in
7.3.4 on freebsd 4.8.
cms3=# explain analyze select coalesce ((sELECT thumb FROM con
15 matches
Mail list logo
