Arun Gananathan wrote:
Could any one let me know is there a way to findout the rules previously created in the database .
thanks
ganesh
http://www.postgresql.org/docs/7.4/static/view-pg-rules.html#AEN51975
--
Ci-git une signature avortee.
** RIP **
---(end of
Hi all,
I am experimenting with a few OS's for my new hardware. I plan to have a
software RAID5 device for my pgsql data directory.
I have been experimenting with FreeBSD and with Linux, does anyone have any
thoughts on whether vinum RAID devices are better than Linux software RAID?
Or vice
Rich Cullingford wrote:
Well, I was gonna use pg_dumpall to avoid the tedium of individual
dumps, but (gotcha!) pg_dumpall doesn't accept
--use-set-session-authorization (tho' it does run pg_dump!).
It supplies that option automatically.
If I use
pg_dumpall, will pg_restore (with
On Sun, Dec 14, 2003 at 01:25:11PM -, Arun Gananathan wrote:
Could any one let me know is there a way to findout the rules previously created in
the database .
Try this:
SELECT * FROM pg_rules;
--
Michael Fuhr
---(end of broadcast)---
On Tue, 16 Dec 2003, Adam Witney wrote:
Hi all,
I am experimenting with a few OS's for my new hardware. I plan to have a
software RAID5 device for my pgsql data directory.
I have been experimenting with FreeBSD and with Linux, does anyone have any
thoughts on whether vinum RAID devices
Can I alter a column from character varying(128) to text without having
to create a temp table? I am running 7.3.3.
Thanks
--
___
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
On Tue, Dec 16, 2003 at 12:32:05PM -0500, Jodi Kanter wrote:
Can I alter a column from character varying(128) to text without having
to create a temp table? I am running 7.3.3.
The FAQ has a question entitled How do you remove a column from a
table, or change its data type?:
Existing table column data types cannot be altered in any stable version
of postgres(7.4 or previous). I don't know if it is available in a beta
release.
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Jodi
KanterSent: Tuesday, December 16,
This is another discuttion about this
problem.
Please read these mails.
I cannot write here all the syntax:I'll give an example: you have a
table called "person" and you have a columncalled "name" varchar(10) and you
want to change it into varchar(25).alter person add column name_temp
I am experimenting with a few OS's for my new hardware. I plan to have a
software RAID5 device for my pgsql data directory.
I have been experimenting with FreeBSD and with Linux, does anyone have any
thoughts on whether vinum RAID devices are better than Linux software RAID?
Or vice versa...
On Tue, 16 Dec 2003 [EMAIL PROTECTED] wrote:
I am experimenting with a few OS's for my new hardware. I plan to have a
software RAID5 device for my pgsql data directory.
I have been experimenting with FreeBSD and with Linux, does anyone have any
thoughts on whether vinum RAID devices are
Hi Bruno,
Thanks for the reply. Still my questions were unanswered. Pl could
anyone give a solution.
1. Is there any way I can generate archive log in postgres
2. Is it possible to run the postgres in standby mode (like Oracle stnd
by server) and apply the archive logs
Thanks and regards,
Adam Witney wrote:
Hi all,
I am experimenting with a few OS's for my new hardware. I plan to have a
software RAID5 device for my pgsql data directory.
I have been experimenting with FreeBSD and with Linux, does anyone have any
thoughts on whether vinum RAID devices are better than Linux software
Your pardon, but I submit that the responder did answer your question.
Unfortunately, your question may be meaningless in the context asked.
Specifically, you are asking for an Oracle specific feature, which may
not have any direct comparison in another system. Instead, it is better
to ask
When grilled further on (Tue, 16 Dec 2003 22:30:04 -0600),
Patrick Spinler [EMAIL PROTECTED] confessed:
According to the theory they expound, a database with any significant
write activity whatsoever should never be on raid 5, but instead be on
raid 0+1.
Kind of related and a point of
Patrick Spinler wrote:
Adam Witney wrote:
Hi all,
I am experimenting with a few OS's for my new hardware. I plan to have a
software RAID5 device for my pgsql data directory.
I have been experimenting with FreeBSD and with Linux, does anyone have any
thoughts on whether vinum RAID
16 matches
Mail list logo