[BUGS] BUG #2287: Probably a translation error

2006-02-27 Thread Tanguy MOAL
The following bug has been logged online: Bug reference: 2287 Logged by: Tanguy MOAL Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.7 Operating system: Linux Fedora Core 4 Description:Probably a translation error Details: When using the interactive mode :

Re: [BUGS] has_table/schema_privilige() returns incorrect info on temp tables

2006-02-27 Thread Tom Lane
Frank van Vugt <[EMAIL PROTECTED]> writes: >> After you've created at least one temp table, you can look at the result >> of "current_schemas(true)". There's no guarantee that the schema even >> exists before you've created something... > Is there a guaranteed order of the resulting array, i.e. i

Re: [BUGS] has_table/schema_privilige() returns incorrect info on temp tables

2006-02-27 Thread Frank van Vugt
Hi, > In the first place, you are evidently running as superuser, which means > that has_foo_privilege will ALWAYS say 't' Ok, seems reasonable ;) > (except possibly if the > target object doesn't exist, in which case I think you get an error). Yep, one does. > In the second place, trying to

Re: [BUGS] has_table/schema_privilige() returns incorrect info on temp tables

2006-02-27 Thread Tom Lane
Frank van Vugt <[EMAIL PROTECTED]> writes: > While running 2 sessions in different terminals for the same user, what > happens in the second session here looks a bit weird: In the first place, you are evidently running as superuser, which means that has_foo_privilege will ALWAYS say 't' (except p

[BUGS] has_table/schema_privilige() returns incorrect info on temp tables

2006-02-27 Thread Frank van Vugt
Hi, While running 2 sessions in different terminals for the same user, what happens in the second session here looks a bit weird: = = db=# create temp table t_test (id int); CREATE TABLE db=# select table_schema from information_schema.tables where table_name = 't_test

Re: [BUGS] BUG #2285: Can not access database after successful PITR - file naming problems

2006-02-27 Thread Tom Lane
"Nicholas Vinen" <[EMAIL PROTECTED]> writes: > Now, when I try to use PITR to restore the database on my test server, the > PITR succeeds as normal, but I can not access the database with an error > like: > psql: FATAL: could not open relation 1663/16385/605464: No such file or > directory This

Re: [BUGS] BUG #2286: Wrong index creation with cs_CZ locales and HYPHEN

2006-02-27 Thread Tom Lane
"David Sauer" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 8.1.2, 8.1.3 > Operating system: Linux (libc6), debian > Description:Wrong index creation with cs_CZ locales and HYPHEN You've probably gotten bit by the 8.1.2 changes in locale-dependent sorting. Try REINDEXing the affecte

Re: [BUGS] BUG #2284: missing sequence number

2006-02-27 Thread Michael Fuhr
On Mon, Feb 27, 2006 at 11:52:19AM +, [EMAIL PROTECTED] wrote: > if the server shuts down abrupotly because of power failuar or any other > cause then the sequences tend to skip few numbers. > After restarting the postgresql server the nextval of sequence doest match > with the last number. ht

Re: [BUGS] BUG #2284: missing sequence number

2006-02-27 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: > if the server shuts down abrupotly because of power failuar or any other > cause then the sequences tend to skip few numbers. > After restarting the postgresql server the nextval of sequence doest match > with the last number. This is per design, i.e. not a bug. -- Al

[BUGS] BUG #2285: Can not access database after successful PITR - file naming problems

2006-02-27 Thread Nicholas Vinen
The following bug has been logged online: Bug reference: 2285 Logged by: Nicholas Vinen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Gentoo Linux x86 Description:Can not access database after successful PITR - file naming problems Detai

[BUGS] BUG #2283: VS .NET 2003 connection problem

2006-02-27 Thread
The following bug has been logged online: Bug reference: 2283 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows XP Home Edition SP2 Description:VS .NET 2003 connection problem Details: Hello, In Visual Studio .NET 2003,

[BUGS] BUG #2286: Wrong index creation with cs_CZ locales and HYPHEN

2006-02-27 Thread David Sauer
The following bug has been logged online: Bug reference: 2286 Logged by: David Sauer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2, 8.1.3 Operating system: Linux (libc6), debian Description:Wrong index creation with cs_CZ locales and HYPHEN Details: I h

[BUGS] BUG #2284: missing sequence number

2006-02-27 Thread
The following bug has been logged online: Bug reference: 2284 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2 Operating system: linux Description:missing sequence number Details: if the server shuts down abrupotly because of power failuar or a