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
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]>
"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
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.
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
"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
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'
"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,
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
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
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
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
--
> 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
13 matches
Mail list logo
