[BUGS] BUG #5940: Creating a foreign key on an empty table locks table

2011-03-22 Thread Adriaan
The following bug has been logged online: Bug reference: 5940 Logged by: Adriaan Email address: adriaa...@gmail.com PostgreSQL version: 8.4 / 9.0 Operating system: Ubuntu Description:Creating a foreign key on an empty table locks table Details: I am using creation

[BUGS] Join/table alias bug

2000-04-20 Thread Adriaan Joubert
at_map m, ip_item ip, fund_class f where cat.cat_table='fund_class' and cat.cat_id=it.cat_id and it.el_id=f.fc_id and m.c_id=it.c_id and m.ip_id=ip.ip_id; fc_id | el_id | ip_id | c_id | ip_id ---+---+---+--+--- 6 | 6 | 6 |9 | 6 (1 row) Adriaan

[BUGS] BUG #2906: slow windows network performance

2007-01-18 Thread Adriaan van Os
The following bug has been logged online: Bug reference: 2906 Logged by: Adriaan van Os Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows XP Description:slow windows network performance Details: Somehow, native Windows networking

[BUGS] BUG #2905: min and max return incorrect text type

2007-01-18 Thread Adriaan van Os
The following bug has been logged online: Bug reference: 2905 Logged by: Adriaan van Os Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Mac OS X 10.4.6, intel Description:min and max return incorrect text type Details: Table 9-37

[BUGS] BUG #2907: pg_get_serial_sequence quoting

2007-01-19 Thread Adriaan van Os
The following bug has been logged online: Bug reference: 2907 Logged by: Adriaan van Os Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Mac OS X 10.4.6, intel Description:pg_get_serial_sequence quoting Details: In order to work with

Re: [BUGS] BUG #2906: slow windows network performance

2007-01-19 Thread Adriaan van Os
jose fuenmayor wrote: Use linux mac or any other unix like operating system, it performs better in every aspect. Thank you for your wonderful advice, but this is really a bug report. Adriaan van Os ---(end of broadcast)--- TIP 3: Have you

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-19 Thread Adriaan van Os
Bruce Momjian wrote: Adriaan van Os wrote: The following bug has been logged online: Bug reference: 2905 Logged by: Adriaan van Os Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Mac OS X 10.4.6, intel Description:min and max return

Re: [BUGS] BUG #2907: pg_get_serial_sequence quoting

2007-01-22 Thread Adriaan van Os
Bruce Momjian wrote: Strangely, this was reported before, but not until November of 2006: http://archives.postgresql.org/pgsql-general/2006-11/msg0.php That was a follow up on this thread <http://archives.postgresql.org/pgsql-hackers/2004-10/msg00964.php>. Regards, A

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-22 Thread Adriaan van Os
Peter Eisentraut wrote: Adriaan van Os wrote: However, min(VARCHAROID) and max(VARCHAROID) return TEXTOID as a result type. Yea, they are internally treated as very similar types. But "internally treated as very similar" is still not "same as argument type". Computin

Re: [HACKERS] [BUGS] BUG #2907: pg_get_serial_sequence quoting

2007-01-22 Thread Adriaan van Os
t it takes two parameters rather than one (a fully qualified doublequoted columnname path) or three (optionally empty schema, tablename, columnname, all three literal). Regards, Adriaan van Os ---(end of broadcast)--- TIP 4: Have

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-23 Thread Adriaan van Os
e casting, then the fact that there is no max(varchar) function is exactly the bug. Adriaan van Os ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[BUGS] BUG #2977: dow doesn't conform to ISO-8601

2007-02-07 Thread Adriaan van Os
The following bug has been logged online: Bug reference: 2977 Logged by: Adriaan van Os Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Mac OS X 10.4.6, intel Description:dow doesn't conform to ISO-8601 Details: Section 9.9.1 o

[BUGS] not sorted clustered index (8.2)

2007-11-05 Thread Adriaan van Kekem
iid in (1,2,3) we suspect that we get the result based on the iid, but sometimes this is not happening. Is this a known issue? our configuration is postgresql 8.2 on ubuntu greetings, Adriaan ---(end of broadcast)--- TIP 4: Have you searched our

[BUGS] BUG #3811: Getting multiple values from a sequence generator

2007-12-09 Thread Adriaan van Os
The following bug has been logged online: Bug reference: 3811 Logged by: Adriaan van Os Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Mac OS X 10.5 Description:Getting multiple values from a sequence generator Details: The following

[BUGS] BUG #3891: Multiple UPDATE doesn't handle UNIQUE constraint correctly

2008-01-21 Thread Adriaan van Os
The following bug has been logged online: Bug reference: 3891 Logged by: Adriaan van Os Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Mac OS X 10.5 Description:Multiple UPDATE doesn't handle UNIQUE constraint correctly De

[BUGS] BUG #4097: can join + where query be optimized?

2008-04-07 Thread Adriaan van Kekem
The following bug has been logged online: Bug reference: 4097 Logged by: Adriaan van Kekem Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Ubuntu 7.04 Description:can join + where query be optimized? Details: In the following query you

[BUGS] BUG #2292: Calling conventions in docs

2006-03-01 Thread Adriaan van Os
The following bug has been logged online: Bug reference: 2292 Logged by: Adriaan van Os Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Mac OS X Description:Calling conventions in docs Details: Section 32.9.5. Writing Code of the 8.1

Re: [BUGS] BUG #2292: Calling conventions in docs

2006-03-02 Thread Adriaan van Os
Bruno Wolff III wrote: Adriaan van Os <[EMAIL PROTECTED]> wrote: Section 32.9.5. Writing Code of the 8.1 docs says: While it may be possible to load functions written in languages other than C into PostgreSQL, this is usually difficult (when it is possible at all) because other lan

Re: [BUGS] BUG #2292: Calling conventions in docs

2006-03-04 Thread Adriaan van Os
Tom Lane wrote: Adriaan van Os <[EMAIL PROTECTED]> writes: The manual is simply taking an old prejudice as a fact. No, it is stating a fact as as fact. The existence of one counterexample does not disprove the generalization. Keep dreaming. Ignorance rules the world. Adriaan