On Nov 17, 2006, at 5:31 AM, Arnaud Lesauvage wrote:
Richard Huxton a écrit :
Arnaud Lesauvage wrote:
Richard Huxton a écrit :
Arnaud Lesauvage wrote:
Hi all !
I am trying to exclude just one schema of my dump.
pg_dump -N myschema
or
pg_dump --exclude-schema=myschema
both tell me that the o
On Nov 17, 2006, at 10:13 AM, cupa wrote:
how to make UDF visible on cluster (for all databases)?
You can't. Most database objects (including UDFs) are per-database,
not per-cluster. You'll have to add it to each database.
--
Jim Nasby [EMAIL PROTECTED]
Enterpri
On Nov 17, 2006, at 4:26 PM, Matt Miller wrote:
I'd like SYSDATE to work syntactically and semantically the same as
CURRENT_TIMESTAMP (or CURRENT_TIME, or whatever). I can create a
function called "sysdate" that does the trick, but then it seems I
have
to reference the function as "sysdate (),
On Nov 21, 2006, at 4:20 AM, Arnaud Lesauvage wrote:
ERROR: invalid byte sequence for encoding "UTF8": 0xff
État SQL :22021
Astuce : This error can also happen if the byte sequence does not
match the encoding expected by the server, which is controlled by
"client_encoding".
Contexte : COPY m
On Nov 19, 2006, at 4:05 PM, [EMAIL PROTECTED] wrote:
I use DRUID to design postgreSQL databases. Anyone know if I can
export
to MS Access format from DRUID? I see options for MySQL in DRUID's
Generator, but not Access.
Sorry, not the best forum for this question, but I figured many people
out
On Nov 22, 2006, at 12:19 PM, Wim Bertels wrote:
version 7.4.7
i first grant a group some privileges,
then i take those privileges away from a user in this group,
somehow this doens't work (no errors, but the rights aren't revoked)
eg:
GRANT ALL ON TABLE test TO GROUP groep;
--the user jimmy i
On Nov 22, 2006, at 1:51 PM, John D. Burger wrote:
However, Cluster might work for you, but you need to re-cluster after
every updates or inserts, so it will probably be fine for static
data.
This reminds me of a (somewhat off-topic) question I have had:
I have a static database, and most of
Hi,
I am maintaining such an application and it is neither bulky nor slow.
It's all
a matter of implementation.
Can I have a link to the application or more info on that? I would be
interested to take a look into it.
Sure: http://www.sql-workbench.net
I have nothing against JDBC or JAVA (
On fös, 2006-11-24 at 16:14 -0800, [EMAIL PROTECTED] wrote:
>
> Well.. you are correct!
> After studying the contents of "/etc/init.d/postfresql", I put
> "PGDATA=/home3/mylargedisk/data" in "/etc/sysconfig/pgsql/postgresql"
> and it now works.
>
> So what the . is this PGDATA!! It must b
i'm trying to have pg_restore create a new db and load the data.
unfortunately, pg_restore always uses the database name specified in the dump.
"--create" and "--dbname=newdb" does not seem to have any effect (pg_restore
yells about database being non-existant).
what is the proper method to re
"Thomas H." <[EMAIL PROTECTED]> writes:
> what is the proper method to restore data from a previous named database =
> "olddb" into a fresh database named "newdb"? the old database still =
> exists and i don't want to overwrite the data.
Create newdb by hand and then specify it as the connection t
"Thomas H." <[EMAIL PROTECTED]> writes:
what is the proper method to restore data from a previous named database
=
"olddb" into a fresh database named "newdb"? the old database still =
exists and i don't want to overwrite the data.
Create newdb by hand and then specify it as the connection tar
"Thomas H." <[EMAIL PROTECTED]> writes:
> how can i create an *empty* database?
Clone it from template0, not template1.
regards, tom lane
---(end of broadcast)---
TIP 4: Have you searched our list archives?
h
Hello
On 11/26/06, Thomas Kellerer <[EMAIL PROTECTED]> wrote:
Hi,
>> I am maintaining such an application and it is neither bulky nor slow.
>> It's all
>> a matter of implementation.
>>
> Can I have a link to the application or more info on that? I would be
> interested to take a look into it.
On Sun, 26 Nov 2006, Ritesh Nadhani wrote:
>
> Well, sorry if my words were confusing. I was thinking of an MS SQL
> Query Analyzer, SQLyog, PGAdmin kind of tool to start with which will
> provide a basic admin tool initially. And based upon that
> layer/architecture we will provide more advanced
I've set up a little test to find out how much permissions users have in
PostGreSQL.
It seems that the CONNECT privilege cannot be assigned or is not
recognized by postgresql 8.1.
When using pgAdmin-III it does not display the granted CONNECT
priviledge.
Also when doing GRANT CONNECT FOR DATABASE
Joris Dobbelsteen wrote:
When using pgAdmin-III it does not display the granted CONNECT priviledge.
Also when doing GRANT CONNECT FOR DATABASE TO it
succeeds, but I fail to observe its effects: i.e. users are not allowed
to a database.
Have you modified pg_hba.conf to allow the new use
"Joris Dobbelsteen" <[EMAIL PROTECTED]> writes:
> It seems that the CONNECT privilege cannot be assigned or is not
> recognized by postgresql 8.1.
That was added in 8.2, as even minimal perusal of the documentation
would have shown you.
regards, tom lane
-
I've upgraded from PostgreSQL 8.0 to version 8.1 running on Win XP.
I have an interface developed in Delphi 6 that now won't connect to PostgreSQL.
I get an "error connecting to libpq.dll".
Are there any thoughts on where the problem may be - the .dll file, the
connection or Delphi? I am using
On Sun, 2006-11-26 at 15:08 -0800, Bob Pawley wrote:
> I've upgraded from PostgreSQL 8.0 to version 8.1 running on Win XP.
>
> I have an interface developed in Delphi 6 that now won't connect to
> PostgreSQL. I get an "error connecting to libpq.dll".
>
> Are there any thoughts on where the prob
I don't know - but it sounds like a good place to start.
Bob
- Original Message -
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Sunday, November 26, 2006 3:17 PM
Subject: Re: [GENERAL] Upgrade
On Sun, 2006-11-26 at 15:08 -08
I have thee primary tables: comments, events and users. There's a
join table events_comments tying comments to events. There are B-tree
indexes on every column involved, and the tables are freshly vacuumed
and analyzed;
A simple select to retrieve all comments for a given event, with an
o
> The outer join seems unnecessarily slow. Is there anything I can do
> to speed it up?
>
> PostgreSQL 8.1.3 on OS X (MacPorts).
This is just a guess on my part, but would it help if you preformed the inner
join first to filter
out the most of the unwated rows that then preform the outer join
Alexander Staubo <[EMAIL PROTECTED]> writes:
> select comments.*, users.*
> from comments
> left outer join users on
>users.id = comments.creator_id
> inner join events_comments on
>comments.id = events_comments.comment_id
>and events_comments.event_id = 9244
> The outer join seems unn
On Nov 23, 2006, at 8:37 AM, Sefer Tov wrote:
oddities. Clearly the caching algorithm favors caching the indices
to data (since they are more frequently accessed) but there is
another case where *recently written* entries are often requested
shortly after and I am not sure that they get prio
Richard Troy wrote:
> Let me put it this way; Right now I have to support (at least) five
> RDBMSes: Postgres, Informix, Sybase, DB2, Oracle - and we're
> considering ANTS. The idea of a cross-dbms admin tool sounds great
> but is USELESS - not worth my time - if it doesn't address these
> every-da
Tom:
Thanks for the reply. I've installed the patch and, as you predicted, it
had no effect.
I did a google search on AIX + getaddrinfo and found
http://lists.samba.org/archive/rsync/2002-April/002063.html
In that context the author says that adding the port number in
etc/services solved his
27 matches
Mail list logo