Hi there,
I'd like to use WAL, but I need some clarifications about the
backup/recovery procedure.
In Postgresql v8.2.3 documentation, I found I have to make backup between
pg_start_backup/pg_stop_backup executions, using tar/cpio tools.
May I use pg_dumpall instead ? Is it enough to restore t
On the destination box:
#\dD+ valid_user
List of domains
Schema |Name| Type | Modifier |
Check
++--+--+
--
BTW creating domain didn't throw any error on the destination server
(8.2.3), but I found that after migration permissions are not
consistent:
...
COMMENT
CREATE DOMAIN valid_user AS name DEFAULT "session_user"()
CONSTRAINT user_exists CHECK (has_table_privilege(VALUE,
'pg_user'::text, 'SE
"hubert depesz lubaczewski" <[EMAIL PROTECTED]> writes:
> On 3/19/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>>> ERROR: WITH CHECK OPTION is not implemented
>> It seems perfectly clear to me ...
> errors is clear, but maybe the information about check option should
> be removed from docs to 8.2?
The
"Anton Pikhteryev" <[EMAIL PROTECTED]> writes:
> I created valid_user domain on the old system (8.0.3) a long time ago
> as:
> CREATE DOMAIN valid_user
> AS name -- pg_catalog.pg_user.usename%TYPE
> DEFAULT SESSION_USER
> CONSTRAINT user_exists
> CHECK (has_table_privilege(
"Anton Pikhteryev" <[EMAIL PROTECTED]> writes:
> ... but I found that after migration permissions are not
> consistent:
Again, you have not provided enough information to let someone else
replicate the problem.
regards, tom lane
---(end of broadcas
Karthikeyan Sundaram wrote:
> Hi Everybody,
>
>I have 2 versions of postgres 8.1.0 is my production version and
> 8.2.1 is my development version.
>
> I am trying to create a view in my development version (8.2.3)
>
> create view chnl_vw as select * from channel with check option;
>
>
Hi everybody,
I have implemented in a different way as advised in the manual. I
thought this will be useful for everbody.
We don't have check option in the view. Instead we can create a rule to
make the view as insertable, updatable or delete.
Here is the script.
create table test_t
Ted Byers wrote:
[snip]
> It is outrageously unethical, IMHO, for a programmer, or group thereof,
> to refuse to fix a problem that has arisen from how their targetted
> users use their application.
Let's save the determination of outrageous behavior for others and see
if we can help the user fi
Hi everyone,
I'm looking to convert a lot of data from Sybase to Postgres. As this will
be a painful process, I was wondering if there are any utilities and
programs to ease the conversion process. Specifically, I'm looking for help
in 3 areas.
1. Recreation of the schema, especially converting
Okey, Mr Radlowski and Mr. Drake
thank for your comment
Regards,
Nyoman/Bali
- Original Message -
From: "Adam Radlowski" <[EMAIL PROTECTED]>
To: "gunartha.nyoman" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, March 16, 2007 8:50 PM
Subject: Re: [ADMIN] how to add oids field
gunartha.nyoman
Dear All,
I am trying to create table which have one field auto increas value like
autonumber in ms access.
My question is how to create this auto increas field.
Thank a lot for your attention
Regards,
Nyoman/Bali
Look at the "serial" data type in the documentation.
~p
On Tue, 2007-03-20 at 09:49 +0700, gunartha.nyoman wrote:
> Dear All,
>
> I am trying to create table which have one field auto increas value
> like autonumber in ms access.
> My question is how to create this auto increas field.
>
> Than
gunartha.nyoman wrote:
> Dear All,
>
> I am trying to create table which have one field auto increas value like
> autonumber in ms access.
> My question is how to create this auto increas field.
create table foo (id serial);
also see currval(), nextval()
Sincerely,
Joshua D. Drake
>
> Thank
have you try a Sybase manneger ?
http://www.sqlmanager.net/
they use to have a lite version maybe can help..
Peter Koczan wrote:
Hi everyone,
I'm looking to convert a lot of data from Sybase to Postgres. As this
will be a painful process, I was wondering if there are any utilities
and progr
The world rejoiced as [EMAIL PROTECTED] (August Zajonc) wrote:
> Ted Byers wrote:
>
> [snip]
>> It is outrageously unethical, IMHO, for a programmer, or group thereof,
>> to refuse to fix a problem that has arisen from how their targetted
>> users use their application.
>
> Let's save the determin
16 matches
Mail list logo
