Please:
I'm trying to use jobs. I installed the service as
manual saids but i saw no node on view.
Can anybody tell me what i'm doing
wrong.
PD: Sorry, i'm not so good in english.
George
Would there be a way to set up the 2 databases - one with the tables and data and the other that connects to the first with views into the second database?Actually I am interested because I will soon need to set up a way to feed data to multiple databases and would love to have a stored procedure o
Also, and I know this sounds stupid, you may check to see if the database really restarted. I recently got a new server and for some reason when I use the restart script found in /etc/init.d/postgres it doesn't actually restart the server (the shutdown fails) but when I go to the control panel ins
By its definition, GUID ( http://en.wikipedia.org/wiki/GUID ) is not guaranteed to be unique. As a result, it could cause problems in tables that have a large number of rows - actually this could result in hard to reproduce, seemingly random errors in your systems that use the database. How does
Their online documentation says it uses MySQL so my guess is no.Of course it is an open source project so you could create a PostgreSQL port if you wanted.I would suggest posting questions like this to Joomla though as they know how to answer these questions better.
-AaronOn 6/26/06, Sistemas C.M.P
unsubscribe
On 6/26/06, Carlos H. Reimer <[EMAIL PROTECTED]> wrote:
Maybe the question should be reformulted to: is there a way to hide
pg_catalog schema? I think it can?t not be done because all metadata are
there, but maybe somebody can see a solution.
You could use a set returning function and a view to
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes:
> Maybe the question should be reformulted to: is there a way to hide
> pg_catalog schema?
There is not. My advice would be to put clients in separate databases
if you need that much isolation between them.
regards, tom lane
"Chris Hoover" <[EMAIL PROTECTED]> writes:
> I turned on autovacuum on one of my database servers over the weekend. I
> have been looking at the logs trying to see what it is doing. However, all
> I see are lines like this:
> ,7674,,2006-06-26 16:31:37.650 EDT,,1LOG: autovacuum: processing
>
Chris Hoover wrote:
> I turned on autovacuum on one of my database servers over the weekend. I
> have been looking at the logs trying to see what it is doing. However, all
> I see are lines like this:
> ,7674,,2006-06-26 16:31:37.650 EDT,,1LOG: autovacuum: processing
> database "postgres"
>
Yes, a but even so, if the client uses a tool like pgAdmin, he can see all
the database structure. It?s because this kind of tool uses data from the
pg_catalog schema.
Maybe the question should be reformulted to: is there a way to hide
pg_catalog schema? I think it can?t not be done because all me
In addition to what Rodrigo said so eloquently
in Portuguese (no fallu prtugues! ), the only issue you will
experience is a performance hit.
It is not a good idea to have 2 separate
database servers running on the same set of drive spindles. I usually deploy
them in different servers. Th
I turned on autovacuum on one of my database servers over the weekend. I have been looking at the logs trying to see what it is doing. However, all I see are lines like this:,7674,,2006-06-26 16:31:37.650 EDT,,1LOG: autovacuum: processing database "postgres"
Is there a way to tell if autovac
I think you have to use a view! You create a view on this table specifying
only the columns the user may have access, and then you give privileges on
this view instead of giving privileges on the table!
-Mensagem original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Em nome de Carlos
Cara amiga brasileira! Como já
respondido pelo Magnus, não tem absolutamente nenhum problema! Mas veja que se
for um ambiente em produção isso pode gerar problemas futuros em relação ao
desempenho!
Abraços!
De:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Em nome de Érica
[EMAIL PROTECTED] writes:
> I don't have a pg_stat_activity on this 7.4.6, so using ps gives me:
> [EMAIL PROTECTED] ~ 4 > ps -ef | grep postmaster
> postgres 4499 4498 0 08:59:18 ? 0:04
> /usr/local/pgsql/bin/postmaster -i -p 5356 -o -e
What platform is that? If it's Solaris, see
>Thomas Mack <[EMAIL PROTECTED]> writes:
>> Is there any chance to monitor the current transactions and abort them,
>> in case of need?
>
>Sure, just SIGINT whichever backend you want to cancel its query.
>Use "ps" or pg_stat_activity to figure out the right PID to kill.
>
I don't have a pg_stat_ac
Hello,
Is there a way to hide the table definition structure from an user, even if
the user has privileges to select data from that table?
Reimer
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
On Mon, 2006-06-26 at 10:15, Andy wrote:
> Steps:
> 1.
> show datestyle
> DateStyle
> ISO, DMY
>
>
> 2.
> set datestyle to 'SQL, DMY';
> show datestyle;
> DateStyle
> SQL, DMY
>
> >> this should be the good result.
>
> Now the tries:
> Edit the postgresql.conf. S
Thomas Mack <[EMAIL PROTECTED]> writes:
> Is there any chance to monitor the current transactions and abort them,
> in case of need?
Sure, just SIGINT whichever backend you want to cancel its query.
Use "ps" or pg_stat_activity to figure out the right PID to kill.
regards,
Andy wrote:
> Now the tries:
> Edit the postgresql.conf. Set datestyle = 'SQL, DMY' parameter. Restart the
> DB server.
> show datestyle
> DateStyle
> ISO, DMY
Perhaps you edited the wrong postgresql.conf file, or restarted the
wrong server, or forgot to uncomment the line.
--
Alva
Hi,
we use postgres for student's education and others.
Now we had an issue with some SQL statement in connection with some
triggers, that probably caused an infinite loop in processing for at
least 10 hours or so on some two to ten line tables.
Unfortunately, the students used the phpPgAdmin we
Steps:
1.
show datestyle
DateStyle
ISO, DMY
2.
set datestyle to 'SQL, DMY';
show datestyle;
DateStyle
SQL, DMY
this should be the good result.
Now the tries:
Edit the postgresql.conf. Set datestyle = 'SQL, DMY' parameter. Restart the
DB server.
show datestyle
DateS
"Andy" <[EMAIL PROTECTED]> writes:
> I tried to modify it in postgres.conf >>> datestyle = 'European' or
> datestyle = 'SQL, DMY'
> and I tried to make
> alter database test5 SET DateStyle='SQL, DMY';
> none of these worked.
They work for me. Perhaps you should show us exactly what you did
Hi list!
I'm currently thinking about using GUIDs as primary keys. To be more
precise: On *some* of the tables in my structure I *will* need GUIDs (or
UUIDs or whatever format may proove usefull). Now, this implies that
using a bigserial-field for readability and the uids is redundand, so
I'm
I want to have the DD/MM/ date format in my
database without to specify it with:
SET DateStyle='SQL, DMY' at every query.
I tried to modify it in postgres.conf >>>
datestyle = 'European' or datestyle = 'SQL, DMY'
and I tried to make
alter database test5 SET DateStyle='SQL,
DMY';
..
Does someone had used PostgreSQL with
Joomla.?
It's posible?
> Dear colleagues,
>
> Good morning and greetings from Brazil!!
> May anyone help me with a question...
>
> I'm working on a project and we are supposed to use
> Microsoft SQLServer and PostgreSQL on the same server. There
> was any problem or risk on this? Anyone has worked o
Dear colleagues,
Good morning and greetings from Brazil!!
May anyone help me with a question...
I'm working on a project and we are supposed to use Microsoft SQLServer and PostgreSQL on the same server. There was any problem or risk on this? Anyone has worked on the same situati
29 matches
Mail list logo
