Hi Jeremy,
It sounds like what you're saying is that you have data in Table A, and
you also have data in Table B, but you want one of the fields in Table B
to really be from a field in Table A at all times (transparently). Is
that right?
You could create a VIEW using the "CREATE VIEW" command
(
I'm trying to do some more advanced things in sql to make my tables more
efficient. I'd like to do a link, or perhaps it's a join, although
everything I've looked at relating to a join makes me think that it's not
what I'm looking for.
What I would like to do is have a field in a table retrieve
Hi Todd,
There's an ODBC specific part of the PostgreSQL group of sites at :
http://odbc.postgresql.org
That might have information you'll find useful.
There's also a list of ODBC related PostgreSQL material at :
http://techdocs.postgresql.org/oresources.php#odbc
And there's always the psqlo
Hi Steve,
Have you considered using a PostgreSQL ODBC driver
(http://odbc.postgresql.org) and allowing Access to connect to the
PostgreSQL database directly?
Additionally, there's a listing of PostgreSQL related resources at :
http://techdocs.postgresql.org/oresources.php
In the "Administratio
On Wednesday 18 July 2001 10:42 pm, Tom Lane wrote:
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > While I understand Oliver's reasons for having the Debian stuff on the
> > debian server, I believe it would be appropriate to have the patchfile
> > and the various Debian README's available on the ma
pl/pgsql can give a real boost if you need to aggregate values in a
way that doesn't have an existing SQL function. For instance, there
is an SQL function which will take an average. However, what if you
need some other statistical type of average which isn't supported in
SQL? For the sake of
Debra LaVille <[EMAIL PROTECTED]> writes:
> I'm using the script file included with the postgresql distribution:
Hmm, is this from an RPM? It's certainly not part of what *I* consider
the Postgres distribution ...
> #all systems go -- remove any stale lock files
> rm
When would pl/sql be of any real benifit to boost performance?
Or is it really only usefull for seperating code.
e.g. would it be of a better performance using pl/sql instead of
creating a view.
so rather then queiring multiple tables we create a view or use pl/sql.
-
The current PostgreSQL documentation is does not discuss the bytea type at
all.
Does anyone have indepth examples of using this type in SQL?
I know expressing BLOb data in SQL is awkward and would generate huge text
files, but is there a standard method of using escape sequences to express
b
I'm using the script file included with the postgresql distribution:
***
# PGVERSION is:
PGVERSION=7.1.2
# Source function library.
INITD=/etc/rc.d/init.d
. $INITD/functions
# Get function listing for cross-distribution logic.
Hi Fran,
You might want to check out the PostgreSQL replication solutions linked
to from :
http://techdocs.postgresql.org/oresources.php#replication
PostgreSQL Replicator seems to be the most complete, but I'm not sure
(haven't yet gotten around to testing them properly).
:-)
Regards and best
will trillich <[EMAIL PROTECTED]> writes:
>> Nope. You're just watching VACUUM notify the other backends that it's
>> moving system catalog entries around.
> this seems to be new in 7.1 (i don't recall seeing any such
> messages in 7.0.3 or earlier).
You weren't looking closely, then, or weren'
Hi,
from: http://www.postgresql.org/idocs/index.php?backup.html :
"pg_dump -h host1 dbname | psql -h host2 dbname"
You could run this out of cron on your internal DB server (host1)
And use a firewall rule like:
# Allow internal DB server to use TCP for DB dumps
pass in quick proto tcp from
I need to check whether a particular row exists in a postgresql database
and, if it does not, INSERT it. Furthermore, if it does exist, I want to
get its key for use in other SQL statements. I would like to do this in
the most portable way possible, i.e. a series of pure SQL statements or,
baring
Updated RPMs are released for RedHat 7.1. As I no longer have a Red Hat 6.2
or 7.0 machine to rebuild on, this is the only distribution for which I am
packaging binaries. The source RPM should build on RH 6.2 just fine, though.
This is a minor bugfix release related to RPM packaging bugs _onl
http://www.greatbridge.org/genpage?replication_top
All you could ever want to know about pgsql replication.
God Luck!
-r
At 04:31 PM 7/18/01 -0400, Fran Fabrizio wrote:
>Does postgres support replication? I think this is the feature I need.
>I have a table in one db that I need to use from
What query plans are you getting for these various combinations?
regards, tom lane
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
Does postgres support replication? I think this is the feature I need.
I have a table in one db that I need to use from another db on another
machine. The first db is behind two firewalls (for a good reason =) and
the second needs to be hung out on the internet, so I can't really use
the same d
There may be some errors in the script that's loads postgres at
startup. Look in the "/etc/rc.d/init/" directory and see if there is an
executable named postgres or something similar. If so, post the source of
this file to the group so we can take a look.
Good Luck!
-Ryan Mahoney
At 10:22
On Wed, Jul 18, 2001 at 09:36:38AM -0700, Pete Leonard wrote:
> chmod 777 /tmp fixed everything.
That should be 1777.
mrc
--
Mike Castle [EMAIL PROTECTED] www.netcom.com/~dalgoda/
We are all of us living in the shadow of Manhattan. -- Watchmen
fatal ("You are in a maze of t
I will be migrating a Tango app on Windows with a SQL Server backend
over to Linux, Apache, and Postgresql. What do I need to be on the
lookout for in regards to the odbc portion of this migration. Some hints
and links to help pages would be appreciated.
---(end of broad
On Wed, 18 Jul 2001, Pavel Fryc wrote:
> Is there a way to find out for given row and column what other tables/rows
> reference this row/column by means of reference integrity. I need this when
> user deletes number of rows from a table and there is integrity violation I
> want to get a list of t
It looks like the backend (I'd assume this one) crashed
with a segmentation fault.
This should leave a core file (I believe in your db data
directory). Can you use a debugger to get a back trace
from the core file?
On Wed, 18 Jul 2001, Ben-Nes Michael wrote:
> Hi
>
> I use 7.1.2 compiled with
On Wed, Jul 18, 2001 at 12:06:33PM -0400, Tom Lane wrote:
> Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> > Seems to usually happen during vacuums. Should I be worried?
>
> Nope. You're just watching VACUUM notify the other backends that it's
> moving system catalog entries around.
this
> this way i have to implement my businees logic twice. inside the
> database and in the middleware. I dont think that this is very good.
Sometimes implenting the business logic twice is the right thing to
do. For instance, let's say we have a financial application, and we
need to calculate ac
Subject: Cron <[EMAIL PROTECTED]> [ -x /usr/lib/postgresql/bin/do.maintenance ] &&
/usr/lib/postgresql/bin/do.maintenance -a
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
Sender: CronDaemon <[EMAIL PROTECTED]>
Date: Wed, 18 Jul 2001 04:00:33 -0500
NOTICE: RegisterSharedInvalid: SI buffer
Hi,
I have a fairly large table (1 million records) with the following
structure...
sampleid int4
unitid int4
datetimestamp timestamp
data1 float8
data2 float8
btree indexes on sampleid, unitid, and datetimestamp.
I want to be able to pull out the most recent record for a certain unit.
the qu
will trillich <[EMAIL PROTECTED]> writes:
> $ psql -V
> No database specified
This seems awfully fishy, since (a) there is no such error message
anywhere in 7.1, and (b) I don't get that behavior out of 7.1:
$ ~postgres/version71/bin/psql -V
psql (PostgreSQL) 7.1.2
contains readline, history sup
On Wed, Jul 18, 2001 at 11:57:35AM -0400, Tom Lane wrote:
> will trillich <[EMAIL PROTECTED]> writes:
> > $ psql -V
> > No database specified
>
> This seems awfully fishy, since (a) there is no such error message
> anywhere in 7.1, and (b) I don't get that behavior out of 7.1:
>
> $ ~postgres/ve
From: "Liz Pelletier" <[EMAIL PROTECTED]>
> If I have a dump of myDB, and I want to restore only two tables from
> this dump, is there a way to do this? Or do I have to restore the entire
> db?
>
> (BTW, using 7.1 on a Debian box.)
Try pg_restore if you used pg_dump's new option (never tried it
Sorry for posting HTML... Could you just tell me where can I find certain
standard Bar-Code Fonts to be downloaded in Windows...
Kapil
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
Postgres 7.1.2, FreeBSD 3.4
Box got sick, had to bounce it. Postgres wasn't brought down in a
graceful fashion..
restart didn't bring the DB back properly, so as the postgres user, did
the following:
/usr/local/pgsql/bin/postmaster -d5 start
it dumps the initial environment variables, and th
For the life of me, I can't seem to get logging to a file or syslog going
on the rpms of the latest postgres. Can someone let me know what I need
to do.
Thanks
-jeremy
--
salad.
---(end of broadcast)---
TIP 3: if posting/reading through Usene
$ pg_restore --help
.
.
.
-t, --table[=TABLE] restore this table only
.
.
.
cheers,
thalis
On Wed, 18 Jul 2001, Liz Pelletier wrote:
> If I have a dump of myDB, and I want to restore only two tables from
> this dump, is there a way to do this? Or do I have to restore the entire
> db?
If you
already have the information on the labels, all you need is to set the font on
the text box to a "Bar Code Font". If you dont have a barcode font, try "elfring
soft fonts" http://64.21.138.30/. Hope that
helps.. If you have any question email me directly and i wil see if i can
help.
35 matches
Mail list logo
