Hello
I need to transfer a db form one to another server. I wanted to do this
with pg_dumpall and psql -e
I isolated the problem in a view. When I call a self defined function
(buildstring) the problem occurs and when I remove this call pg_dumpall
works. Calling the view with select * from
There are oh-so-many ways, as I am sure people will tell you. regular
expressions are the most wonderful things for such a task. I am comfortable
with tcl, so I would read the file into a tcl variable and use 'regsub -all
{\t700:00:00} $instring {} outstring'.
There are unbelievably simple,
Juerg,
I need to transfer a db form one to another server. I wanted to do
this
with pg_dumpall and psql -e
Have you tried just using pg_dump instead of pg_dumpall? I understand
that there were a few bugs in pg_dumpall, and pg_dump will mean less
data to transfer.
CREATE FUNCTION
Josh == Josh Berkus [EMAIL PROTECTED] writes:
Josh Folks, I need to strip certain columns out of my pgdump
Josh file. However, I can't figure out how to use any Unix-based
Josh tool to search-and-replace a specific value which includes a
Josh tab character (e.g. replace {TAB}7
Peter Eisentraut wrote:
Kyle writes:
> Peter Eisentraut wrote:
>
> > Kyle writes:
> >
> > > Is there a way to get this to work without granting update to
table b?
> >
> > Update to 7.1.]
>
> I'm on 7.1. Should an RI trigger under 7.1 run as the DBA or
as the current
> user?
Okay, we missed a few
I am sure someone already sent this reply and I missed it.
Anyway, if I understand the original problem correctly, you want to
find instances of \t\t00:00:00 and \t\t\t\t\t\t\t00:00:00, etc. and
remove them.
I hope this is generic enough so you can change it to fit your needs:
echo Start c
I have a problem concerning an University assignment
in SQL. I am running PostgreSQL. Below part of the E/R diagram
in ASCII art.
( #VisaExploitation )
|
//\\
| | // \\ | |
| 1|//
Kyle writes:
Shouldn't the select access to the view trickle down to subordinate select functions?
I would think not.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 4: Don't 'kill -9'
BOUCHPAN-LERUST-JUERY Lionel wrote:
In SQL I have the following tables
CREATE TABLE film(
VisaExploitation INTEGER NOT NULL,
DureeTournage INTEGER NOT NULL,
Titre VARCHAR( 50 ),
PRIMARY KEY ( VisaExploitation ) );
CREATE TABLE filmHistorique(
NbCostume INTEGER
) INHERITS (