Chris Dunlop <[EMAIL PROTECTED]> writes:
> E.g. using the script below, the 'bar.f1' column in the 'new'
> database ends up with a 'not null' constraint that isn't present
> in the 'orig' database.
> create table foo (f1 integer not null);
> create table bar () inherits(foo);
> alter table b
Ramzi M. Zeid wrote:
Hello all,
Is the any way or command to make a restore for a single table from a TAR
file that contains many table to another DB.
pg_restore -t will work if it's a dump in the correct
format. See the manuals for details.
If it's just a bunch of INSERTS in a file you'v
Tomasz Kliczak wrote:
CONSTRAINT sy_task_priority FOREIGN KEY (sy_b_id)
REFERENCES sy_b (id) MATCH SIMPLE
When i try to add something into table dt_a I get error :
ERROR: permission denied for relation sy_task_priority
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."sy_b" x WHER
KarunaiMohamed KA. wrote:
Dear Supporter,
This is Karunai Mohamed, working as a Oracle Database Administrator.
From the last one year am working in PostGres Database. I need a help
for encrypt all the PLpgSQL files.
I have tried some of the ways' to encrypt PLpgSQL files, but I could not
fin
Dear
Supporter,
This is Karunai
Mohamed, working as a Oracle Database Administrator.
From the last one
year am working in PostGres Database. I need a help for encrypt all the PLpgSQL
files.
I have tried some of
the ways' to encrypt PLpgSQL files, but I could not find. Could you please
h
Hi All,
Im not quite sure where the most appropriate place to post this question is.
I had posted it to the novice list yesterday however I think this list may
be better suited to addressing the issue. Ive copied the msg below.
...
I did two upgrades from 8.1.0 to 8.1.3 on two servers that are pre
The following bug has been logged online:
Bug reference: 2278
Logged by: Tomasz Kliczak
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: RedHat
Description:problem with grants
Details:
example of database structure :
CREATE TABLE dt_a
(
G'day all,
PG version: 8.1.0 (also 7.4.9)
OS: Linux (debian/testing)
Restoring a database with inherited tables can result in an
incorrect schema (and therefore inability to restore data).
E.g. using the script below, the 'bar.f1' column in the 'new'
database ends up with a 'not null' constrain
Hello all,
Is the any way or command to make a restore for a single
table from a TAR file that contains many table to another DB.
Regards
Ramzi
