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, unv
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. rep
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
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
>)
