Craig Ringer writes:
> I'm finding a few areas where PostgreSQL's refusal to implicitly cast
> from 'text' to another type is causing real problems, particularly when
> using the PgJDBC driver. I'd like to propose a couple of relaxations of
> the implicit cast rules for certain text-like types:
>
On Mon, Dec 6, 2010 at 7:49 PM, Craig Ringer
wrote:
> Hi all
>
> I'm finding a few areas where PostgreSQL's refusal to implicitly cast
> from 'text' to another type is causing real problems, particularly when
> using the PgJDBC driver. I'd like to propose a couple of relaxations of
> the implicit
Hi all
I'm finding a few areas where PostgreSQL's refusal to implicitly cast
from 'text' to another type is causing real problems, particularly when
using the PgJDBC driver. I'd like to propose a couple of relaxations of
the implicit cast rules for certain text-like types:
- user-defined enums; a
>From the 8.3 docs...
"Be aware that COPY ignores rules. ... COPY does fire triggers, so you can
use it normally if you use the trigger approach."
HTH,
Brent Wood
All,
I have a rule written on a temp table which will copy the valuesinserted into
it to another table applying a fu
"Daniel Verite" writes:
> Michael C Rosenstein wrote:
>> Oracle "schema" == Postgres "database": a collection of objects
>> (tables, functions, triggers, views, etc) owned by a user.
> That definition applies to an Oracle schema, but not to a postgres database.
> Objects inside a postgres datab
Michael C Rosenstein wrote:
> > What is "schema" in this context?
>
> Oracle "schema" == Postgres "database": a collection of objects
> (tables, functions, triggers, views, etc) owned by a user.
That definition applies to an Oracle schema, but not to a postgres database.
Objects inside
All,
I have a rule written on a temp table which will copy the values
inserted into it to another table applying a function. The temp table
will be discarded then. The rules I have written works when I use
"Insert into" the temp table. But when I use bulk copy "COPY FROM", the
rule doesn't ge
Andy Colson writes:
> Can someone post what the synonyms will do? And what will be synonym'able?
> (cuz JD said: SYNONYMS work for things that aren't a table.
> then tgl said: synonyms for non-table things was pretty much rejected.
Well, to clarify: what was shot down IMO was the proposed imple
[ shrug... ] Beauty is in the eye of the beholder, I guess. To me the
search_path change seems like the natural way to do that, and flipping a
mess of synonyms the hack. What happens when you miss one synonym?
Changing Oracle synonyms is completely scriptable using the data
dictionary, so we
I would appreciate some pointers on using database encoding and locale.
This is the error message I get from initdb, on Sun Solaris 5.10:
initdb: encoding mismatch
The encoding you selected (UTF8) and the encoding that the
selected locale uses (LATIN1) do not match. This would lead to
misbehavior
Not multiple databases, multiple sites looking at the same DB, each using a
somewhat different naming system. And then apps/scripts from one site (using
that venacular) are shared with others at other sites (using a different
venacular). So even within a site you have multiple ways of querying
On 12/6/2010 3:41 PM, Andy Colson wrote:
On 12/6/2010 3:30 PM, Michael C Rosenstein wrote:
Here's a short overview of what Oracle synonyms provide:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/schema.htm#i5669
/m
Hum... can we move away from what oracle supports? Cuz PG i
On 12/6/2010 3:30 PM, Michael C Rosenstein wrote:
Here's a short overview of what Oracle synonyms provide:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/schema.htm#i5669
/m
Hum... can we move away from what oracle supports? Cuz PG is not going
to support anything like it.
Michael C Rosenstein writes:
> For example webAppUser sometimes needs to access the
> public1.get_customer_name() function, the public1.order table and the
> edit.account table. After a new data load of the public2 database, the
> webAppUser would need to access the public2.get_customer_name()
2010/12/7 Michael C Rosenstein
> On 12/6/10 4:09 PM, Tom Lane wrote:
>
>> Michael C Rosenstein writes:
>>
>>> What is "schema" in this context?
>>>
>> Oracle "schema" == Postgres "database": a collection of objects
>>> (tables, functions, triggers, views, etc) owned by a user.
>>>
>>
>> T
Here's a short overview of what Oracle synonyms provide:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/schema.htm#i5669
/m
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 06 Dec 2010 15:09:04 -0600, Tom Lane wrote:
though I think it is possible to do
in Oracle.
I'm not a DBA but the DBA I closely worked with at my last job had me do
maintenance on a VPN that went to another company -- basically we had
synonyms on both ends that let our databases b
On 12/6/10 4:09 PM, Tom Lane wrote:
Michael C Rosenstein writes:
What is "schema" in this context?
Oracle "schema" == Postgres "database": a collection of objects
(tables, functions, triggers, views, etc) owned by a user.
That seems like a pretty unlikely equivalence. What I'm afraid
you
2010/12/7 Dmitriy Igrishin
>
>
> 2010/12/7 Gauthier, Dave
>
> I think aliasing non-table/view was mixed by Tom, but just as FYI, aliasing
>> column names would be very helpful in my apps. Aliasing "last_name",
>> "lastname", "surname" together in a people table for example. We have many
>> desi
2010/12/7 Gauthier, Dave
> I think aliasing non-table/view was mixed by Tom, but just as FYI, aliasing
> column names would be very helpful in my apps. Aliasing "last_name",
> "lastname", "surname" together in a people table for example. We have many
> design sites that have identical data conce
I think aliasing non-table/view was mixed by Tom, but just as FYI, aliasing
column names would be very helpful in my apps. Aliasing "last_name",
"lastname", "surname" together in a people table for example. We have many
design sites that have identical data concepts but with different names for
Michael C Rosenstein writes:
>> What is "schema" in this context?
> Oracle "schema" == Postgres "database": a collection of objects
> (tables, functions, triggers, views, etc) owned by a user.
That seems like a pretty unlikely equivalence. What I'm afraid
you are really saying you want is cro
"Joshua D. Drake" writes:
> On Mon, 2010-12-06 at 15:27 -0500, Tom Lane wrote:
>> "Joshua D. Drake" writes:
> On Mon, 2010-12-06 at 13:57 -0600, Andy Colson wrote:
I dont understand the need for it. Dont view's do the exact same thing
(plus even more)? What does a synonym offer that
On Mon, Dec 06, 2010 at 07:03:59PM +0100, Rados?aw Smogura wrote:
- Try with configuration parameter
- conn_max_pending (number of connections waiting for processing thread)
- conn_max_auth (same, but for authenticated)
ok sounds good, i'll give that a shot!
- If you are using anonymous auth then
Ahh, catalog :-)
But PostgreSQL has a templates. If I understood you correctly,
the problem is to let the application works with same object names
of the objects in a different databases?
2010/12/6 Michael C Rosenstein
> What is "schema" in this context?
>>
>
> Oracle "schema" == Postgres "datab
What is "schema" in this context?
Oracle "schema" == Postgres "database": a collection of objects
(tables, functions, triggers, views, etc) owned by a user.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/
SYNONYMS work for things that aren't a table.
The idea of synonyms for non-table things was pretty much rejected
already on the -hackers thread.
Again, in Oracle, we found synonyms on stored procedures and functions
as well as tables to be key.
/m
--
Sent via pgsql-general mailing list (
On Mon, 2010-12-06 at 15:27 -0500, Tom Lane wrote:
> "Joshua D. Drake" writes:
> > On Mon, 2010-12-06 at 13:57 -0600, Andy Colson wrote:
> >> I dont understand the need for it. Dont view's do the exact same thing
> >> (plus even more)? What does a synonym offer that a view does not?
>
> > SYNO
"Joshua D. Drake" writes:
> On Mon, 2010-12-06 at 13:57 -0600, Andy Colson wrote:
>> I dont understand the need for it. Dont view's do the exact same thing
>> (plus even more)? What does a synonym offer that a view does not?
> SYNONYMS work for things that aren't a table.
The idea of synonyms
Hey Michael,
2010/12/6 Michael C Rosenstein
> Synonyms would be very helpful to us. We just migrated our application from
> Oracle, where we used synonyms to toggle between between two schemas: one
> schema could be loaded with new data, while synonyms pointed the web
> application to the live
What is synonym? Is it a reference? Can I dump DDL of the object
by synonym? If no, I personally don't see how it can be used.
Maybe it can be used to create 7 synonyms for some table and let
application use different synonym depends on day of the week... :-)
I don't see how it can be used...
2010
Synonyms would be very helpful to us. We just migrated our application
from Oracle, where we used synonyms to toggle between between two
schemas: one schema could be loaded with new data, while synonyms
pointed the web application to the live schema. Once the data load was
done, we switched th
On Mon, 2010-12-06 at 13:57 -0600, Andy Colson wrote:
> On 12/6/2010 1:31 PM, Joshua D. Drake wrote:
> > Hey -general,
> >
> > Command Prompt is currently considering writing a patch to provide
> > synonyms to PostgreSQL. Is this something the community is interested
> > in? Do we have use cases fo
On 12/6/2010 1:31 PM, Joshua D. Drake wrote:
Hey -general,
Command Prompt is currently considering writing a patch to provide
synonyms to PostgreSQL. Is this something the community is interested
in? Do we have use cases for it? MSSQL, DB2 and Oracle support them.
Reference thread:
http://arch
Hey, Joshua, -general,
If the user create a schema for placing synonyms for all functions
of all schemas in the database then will it be possible to make dump
of this schema but not only with CREATE synonyms clauses, but with
functions definitions also ? :-) It would be nice.
2010/12/6 Joshua D.
Hey -general,
Command Prompt is currently considering writing a patch to provide
synonyms to PostgreSQL. Is this something the community is interested
in? Do we have use cases for it? MSSQL, DB2 and Oracle support them.
Reference thread:
http://archives.postgresql.org/pgsql-hackers/2010-11/msg02
On Mon, December 6, 2010 13:29, James B. Byrne wrote:
>>
>
> The problem was an expired pki certificate. When we first used ssl
> for pg we did not have our private CA set up. So we generated a
> self-signed certificate. That certificate expired this past July
> and I infer that while 8.1 did n
Try with configuration parameter
conn_max_pending (number of connections waiting for processing thread)
conn_max_auth (same, but for authenticated)
If you are using anonymous auth then, by default you have
conn_max_pending=100. In your configuration I don't see need to increase
threads to 32?
D
On Mon, December 6, 2010 00:47, Greg Smith wrote:
>
> That looks to be the str_copy routine from conf_def.c in the OpenSSL
> code, i.e. line 624 of the version at:
>
> http://code.google.com/p/commitmonitor/source/browse/trunk/common/openssl/crypto/conf/conf_def.c
>
> So guessing something in the
I've recently configured Postgres (8.3) to authenticate against OpenLDAP
this is my pg_hba.conf entry:
host all all 0.0.0.0/0 ldap
"ldap://ldapserver/dc=mydomain,dc=com;uid=;,ou=postgresql,dc=mydomain,dc=com";
Things are working fine most of the time.
However, every once in a while i'm getting
* Tom Lane:
> Florian Weimer writes:
>> Put differently, I think it's rather odd that in 9.0, both
>> encode(bytea_value, 'escape') and encode(bytea_value, 'hex') output
>> hexadecimal values.
>
> I don't believe that; encode produces text not bytea, so its result
> is not affected by this settin
Florian Weimer writes:
> Put differently, I think it's rather odd that in 9.0, both
> encode(bytea_value, 'escape') and encode(bytea_value, 'hex') output
> hexadecimal values.
I don't believe that; encode produces text not bytea, so its result
is not affected by this setting.
On Mon, 2010-12-06 at 09:18 +0300, Allan Kamau wrote:
> [r...@fc12-macbookpro ~]# yum -y install pgadmin3;
Package is there:
http://yum.pgrpms.org/9.0/fedora/fedora-12-x86_64/repoview/pgadmin3_90.html
Please run
yum install pgadmin3_90
You may need to remove the old one before that.
Regards,
* Tom Lane:
> Florian Weimer writes:
>> The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty
>> helpful for getting human-readable strings in psql. It seems this
>> functionality was removed in PostgreSQL 9.0. Was this an accident or
>> a deliberate decision? Could we get it b
44 matches
Mail list logo
