> Bug reference: 1478
> Logged by: Tiago Magalhães Vieira
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.0.0-rc5
> Operating system: Windows XP
> Description:Upper function does not work
> Details:
>
> I have been experiencing some problems with the upperc
If I don't specify time zone either in config or using "SET TimeZone"
first, "SET TimeZone" inside a transaction isn't rolled back. System
time zone is actually Europe/Moscow. Here's an example:
[EMAIL PROTECTED] SELECT current_setting('TimeZone'), now();
current_setting | now
--
The following bug has been logged online:
Bug reference: 1480
Logged by: Glen
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Fedora Core 1
Description:A wildcard for the listen address doesn't work
Details:
If I go with this in my postg
The following bug has been logged online:
Bug reference: 1481
Logged by: alagu madhu
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Redhat
Description:ERROR: type tablename does not exist
Details:
CREATE FUNCTION merge_fields(t_row table
Hi ! I've the same problem. How can i solve it ?
This is the log :
FATAL: could not reattach to shared memory (key=5432001, addr=012F): Invalid argumentFATAL: could not reattach to shared memory (key=5432001, addr=012F): Invalid argument2005-02-14 11:17:16 LOG: background writer process
"Alexander M. Pravking" <[EMAIL PROTECTED]> writes:
> If I don't specify time zone either in config or using "SET TimeZone"
> first, "SET TimeZone" inside a transaction isn't rolled back.
This should work OK in 8.0. Pre-8.0 it's fundamentally unfixable:
if we cannot see a TZ environment setting,
Adrian Plohn <[EMAIL PROTECTED]> writes:
> Hi ! I've the same problem. How can i solve it ?
> This is the log :
> FATAL: could not reattach to shared memory (key=5432001, addr=012F):
> Invalid argument
If this is Postgres 8.0, try 8.0.1. If it's 8.0.1, we'll need more
information --- what'
"Glen" <[EMAIL PROTECTED]> writes:
> If I go with this in my postgresql.conf file, then postgresql doesn't listen
> on anything but localhost:
> listen_addresses = '*'
You sure it's broken? It only needs to create one socket for that case,
not one per NIC.
If it indeed doesn't work then there's
On Mon, Feb 14, 2005 at 10:21:08AM +, alagu madhu wrote:
>
> Description:ERROR: type tablename does not exist
> Details:
>
> CREATE FUNCTION merge_fields(t_row tablename) RETURNS text AS $$
Do you have a table or composite type named "tablename"? Your
example works for me in 8.0.1
Patch applied by Tom. Thanks.
---
Sergey N. Yatskevich wrote:
> RenameLanguage procedure in src/backend/commands/proclang.c open
> and update pg_catalog.pg_shadow table instead pg_catalog.pg_language.
>
> --
> Sergey N.
"Sergey N. Yatskevich" <[EMAIL PROTECTED]> writes:
> ÷ ðÎÄ, 14/02/2005 × 01:52 -0500, Tom Lane ÐÉÛÅÔ:
>> BTW, is there a security issue here?
> I think this is not good but not so bad because:
> 1) ALTER LANGUAGE can be used only users with superuser privilegies
Right --- that check is made befor
This has been saved for the 8.1 release:
http://momjian.postgresql.org/cgi-bin/pgpatches2
---
Andrew - Supernews wrote:
> On 2005-01-25, Tom Lane <[EMAIL PROTECTED]> wrote:
> > Andrew - Supernews <[EMAIL PROTECTED]>
Hi,
I have a view defined as :
create view calling_view as
(
select d.*,c.patient_id as id_m,c.result as r_m from
(select a.*,b.patient_id as id_f,b.result as r_f from
( select substr(a.family_id,1,4) as fid,b.* from denver_person a,
luminex b
where a.id=b.patient_id and b.project='Denv
13 matches
Mail list logo
