[BUGS] Bug #849: pg_restore bug on views with union, PostgreSQL 7.2.3

2002-12-17 Thread pgsql-bugs
Dariusz KnociƱski ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_restore bug on views with union, PostgreSQL 7.2.3 Long Description I have problem with restoring views with union and without attribute names in select, withou

[BUGS] Bug #849: pg_restore bug on views with union, PostgreSQL 7.2.3

2002-12-17 Thread pgsql-bugs
Dariusz KnociƱski ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_restore bug on views with union, PostgreSQL 7.2.3 Long Description I have problem with restoring views with union and without attribute names in select, withou

Re: [BUGS] Bug #849: pg_restore bug on views with union, PostgreSQL 7.2.3

2002-12-17 Thread Tom Lane
[EMAIL PROTECTED] writes: > pg_restore bug on views with union, PostgreSQL 7.2.3 This is fixed in 7.3. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] odd behavior: function not atomic/not seeing it's own

2002-12-17 Thread Robert Treat
On Mon, 2002-12-16 at 18:53, Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > > "this is broken on so many levels..." > > The issue here is that the second transaction has already set its > snapshot when it enters the function body; so even though its LOCK > command faithfully waits fo

[BUGS] int4out(lo) does not exist (create type)

2002-12-17 Thread bullshark
At http://gborg.postgresql.org/project/psqlodbc/faq/faq.php?faq_id=52 a method is presented for creating a type: 'lo', for handling large data objects that may be imported from other DBs such as MS Access. create type lo ( internallength=4, externallength=10, input=int4in, output=int4