Graham Leggett wrote:
Jan Wieck wrote:
You won't get any rounding errors in NUMERIC either. What people should
be concerned of is to find an arbitrary precision package for the
frontend programming language they're using.
What is the definition of a numeric number? I understand (from studying
n
Hunter Hillegas <[EMAIL PROTECTED]> writes:
> Here's the serverlog entry:
> LOG: recycled transaction log file "0028"
> FATAL: lock file "/usr/local/pgsql/data/postmaster.pid" already exists
> HINT: Is another postmaster (PID 1010) running in data directory
> "/usr/local/pgsql/data"?
> In fact, I only need to decide whether a table (the whole) has been updated
> since last query. I have some pulldown menus in a VB app which extract data
> from a remote site with slow connection. And the data in those tables for
> pulldowns changes rarely. So if the pulldown has to extract the d
pg wrote:
> In fact, I only need to decide whether a table (the whole) has been updated
> since last query. I have some pulldown menus in a VB app which extract data
> from a remote site with slow connection. And the data in those tables for
> pulldowns changes rarely. So if the pulldown has to ex
I read thru your info, thanks a lot.
In fact, I only need to decide whether a table (the whole) has been updated
since last query. I have some pulldown menus in a VB app which extract data
from a remote site with slow connection. And the data in those tables for
pulldowns changes rarely. So if the
SHOW ALL shows TimeZone is 'unknown'. postgres.conf
says 'TZ' is used for default. Where should TZ be set
(it doesn't appear to be set on my RH9 system)?
Thanks,
CSN
--- CSN <[EMAIL PROTECTED]> wrote:
>
> Does Postgres use the system's timezone
> (/etc/localzone) at all? Or does "SET TIME ZONE
Does Postgres use the system's timezone
(/etc/localzone) at all? Or does "SET TIME ZONE 'MST'"
need to be placed in postgres.conf to make it always
used (I set it via psql, but it appears to only be set
for that connection)?
Thanks,
CSN
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROT
Well, using the -E option to psql, \df expands to:
SELECT CASE WHEN p.proretset THEN 'setof ' ELSE '' END ||
pg_catalog.format_type(p.prorettype, NULL) as "Result data type",
n.nspname as "Schema",
p.proname as "Name",
pg_catalog.oidvectortypes(p.proargtypes) as "Argument data types"
FROM
select * from pg_proc where proname = ''
Sincerely,
Joshua D. Drake
Rich Hall wrote:
Thanks for the psql response.
But, I seldom use psql. I find PG Manager much more useful. Even PG
Admin was better.
I am looking to write some stored functions to query the database to
automatically create
> "LR" == Larry Rosenman <[EMAIL PROTECTED]> writes:
LR> PORTNAME?= postgresql
LR> PORTVERSION?= 7.4
LR> PORTREVISION?= 0
LR> I did :-0)
I stand outdated ;-)
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choos
Thanks for the psql response.
But, I seldom use psql. I find PG Manager much more useful. Even PG
Admin was better.
I am looking to write some stored functions to query the database to
automatically create the repotrs I now generate by hand.
So I was trying to find my Stored Functions in the da
> "LR" == Larry Rosenman <[EMAIL PROTECTED]> writes:
LR> --On Friday, December 05, 2003 12:43:24 -0800 "Gregory S. Williamson"
LR> <[EMAIL PROTECTED]> wrote:
>> If anyone has any advice on building Postgres 7.4 for a freeBSD box it
>> sure would be welcome.
LR> cvsup your ports tree, cd /usr/
--On Friday, December 05, 2003 17:29:06 -0500 Vivek Khera
<[EMAIL PROTECTED]> wrote:
"LR" == Larry Rosenman <[EMAIL PROTECTED]> writes:
LR> --On Friday, December 05, 2003 12:43:24 -0800 "Gregory S. Williamson"
LR> <[EMAIL PROTECTED]> wrote:
If anyone has any advice on building Postgres 7.4 for
On Fri, Dec 05, 2003 at 02:22:26PM -0500, Rich Hall wrote:
> Can somebody tell me how Stored Functions are kept in the database? I've
> gone through the catalog several times. I've found many interesting
> things but NOT the 300-odd functions I've created.
>
> Rick
\df
--
Martijn van Oosterho
--On Friday, December 05, 2003 12:43:24 -0800 "Gregory S. Williamson"
<[EMAIL PROTECTED]> wrote:
If anyone has any advice on building Postgres 7.4 for a freeBSD box it
sure would be welcome.
cvsup your ports tree, cd /usr/ports/databases/postgresql7; make; make
install
TIA,
Greg Williamson
If anyone has any advice on building Postgres 7.4 for a freeBSD box it sure would be
welcome.
TIA,
Greg Williamson
DBA
GlobeXplorer LLC
--
well, it takes gmake to build Postgres..
having trouble installing 'gmake' on the BSD box; it started to do its BSD autoinstall
thing
Quoting Alvaro Herrera <[EMAIL PROTECTED]>:
> On Fri, Dec 05, 2003 at 05:06:34PM +0100, Alvar Freude wrote:
>
> > - -- Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> >
> > > Someone pointed out on this list some time ago that you can work around
> > > the performance issue of starting a Perl interp
Can somebody tell me how Stored Functions are kept in the database? I've
gone through the catalog several times. I've found many interesting
things but NOT the 300-odd functions I've created.
Rick
--
---(end of broadcast)---
TIP 3: if posting/r
> On Fri, Dec 05, 2003 at 13:20:27 -0500,
> Bob Powell <[EMAIL PROTECTED]> wrote:
>
> > SELECT * FROM addresses LEFT OUTER JOIN contacts ON
> > contacts.participant_id = addresses.participant_id;
> >
> > Running the select obviously works fine, it's just when I try to create a
> > table when I
On Fri, Dec 05, 2003 at 13:20:27 -0500,
Bob Powell <[EMAIL PROTECTED]> wrote:
> To whom it may concern,
>
> The following select works fine until I use the CREATE TEMP TABLE AS command because
> of the matching participant_id's in each table.
>
> SELECT * FROM addresses LEFT OUTER JOIN contac
To whom it may concern,
The following select works fine until I use the CREATE TEMP TABLE AS command because
of the matching participant_id's in each table.
SELECT * FROM addresses LEFT OUTER JOIN contacts ON
contacts.participant_id = addresses.participant_id;
Running the select obviously work
I was glad to see this topic come up on the list as I was about to start
asking about some of these issues myself. I would like to discuss each of
the methods I have researched so far for doing trees in sql and see if
anyone has some experience or insite into the topic that could help me.
That be
22 matches
Mail list logo
