> > I started to look at the triggers documentation and was immediately
> > dismayed to discover that I would have compile code to create a
> > trigger. I have been using the old "rules" mechanism to
> automatically
> > put a sequence number into a tuple when inserting new rows. Are my
> > choic
try:
pg_dump > tmp.sql
then edit tmp.sql to change the old_database name to new_database name.
then:
cat tmp.sql | psql template1
-DEJ
> -Original Message-
> From: James Olin Oden [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 09, 1998 11:45 AM
> To: Aleksey Dashevsky
> Cc:
Hi,
I wrote a user-defined function and inside the source make use of palloc.
Somebody from the novice mailing list told me that the "palloc" source is
included in libpq and therefore I have included "libpq-fe.h" as the
documentation says. The program compiled fine.
However, today I read in the FA
Hello
I am using Postgres for the first time. I tried to define a 'C' function
in Postgres using the CREATE FUNCTION command but encountered the
following:
ERROR: Only users with Postgres superuser privilege are permitted to
create a function in the 'C' language. Others may use the 'sql' lang
> B> PRIMARY KEY: home_team
> B> FOREIGN KEY: home_team JOIN TO baseball_team.team_name
> Take a look at .../contrib/spi/refint.example.
I don't suppose you could post the full URL for that? I checked the
examples I use frequently, and I'm not familiar with where that one might
be.
Bruce Tong
On Fri, 10 Jul 1998, Bruce Tong wrote:
> > How can I insure that for example "home_team_name" is one of
> > "baseball_team.team_name"?
> >
> > I have seen in books things like:
> >
> > PRIMARY KEY: home_team
> > FOREIGN KEY: home_team JOIN TO baseball_team.team_name
> >
> > is there anyway to
> How can I insure that for example "home_team_name" is one of
> "baseball_team.team_name"?
>
> I have seen in books things like:
>
> PRIMARY KEY: home_team
> FOREIGN KEY: home_team JOIN TO baseball_team.team_name
>
> is there anyway to do this in postgresql?
I asked the same question a week o
Hello Brian,
giovedì, 9 luglio 98, you wrote:
B> If I have two tables, which are like this:
B> baseball_team
B> -
B> team_name
B> number_of_players
B> games_played
B> total_runs
B> baseball_game
B> -
B> home_team_name
B> visitor_team_name
B> home_runs
B> visitor_runs
Hello Robin,
giovedì, 18 giugno 98, you wrote:
RT> At 12:03 PM 6/17/98 +, Jose' Soares Da Silva wrote:
>>> Jose' Soares Da Silva writes:
>>> > SELECT name,NVL(salary)+100 AS dream FROM emp;
>>> > name |dream
>>> > ---+-
>>> > Sam| 1300
>>> > Claire | 5100
>
On Thu, 9 Jul 1998, Jeffrey Napolitano wrote:
> I have two Postgresql databases - one on machine a, one on machine b.
> Both are currently running. I want to put a copy of the database on a
> onto machine b. I know I have to stop the postmaster (obviously) on
> database b, but what else is the
10 matches
Mail list logo
