[BUGS] Bug #702: NULLs order by bug in 7.2.1

2002-07-02 Thread pgsql-bugs
John Liu ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description NULLs order by bug in 7.2.1 Long Description select date_fld from my_table order by date_fld desc; The above query put NULLs on top of normal values in stead of bottom

Re: [BUGS] psql 7.2.1: \d (alone) missing from \?

2002-07-02 Thread Tom Lane
Jay Berkenbilt <[EMAIL PROTECTED]> writes: >> I see it in psql 7.2.1 with \?: >> >> \d [NAME] describe table (or view, index, sequence) >> >> Don't you have that line? > No. I have > \d TABLE describe table (or view, index, sequence) The brackets exist in current sources, but not

Re: [BUGS] psql 7.2.1: \d (alone) missing from \?

2002-07-02 Thread Jay Berkenbilt
> Jay Berkenbilt wrote: > > > > This problem is so simple, the subject pretty much says it all. For > > the sake of completeness, I'm running PostgreSQL 7.2.1 as supplied by > > RedHat in their 7.3 release for i386. This bug report pertains only > > to the psql front end. > > >

[BUGS] bug in numeric locale

2002-07-02 Thread Alvaro Herrera
Hello: I'm having a problem with to_char(numeric, text) in certain locales (mine, at least). I have configured with --enable-locale and initdb'd with LC_ variables set to es_CL. testing=# SELECT to_char(2000.5, '9G999D9'); to_char -- 2,000,5 (1 row) My locale specifies $ locale -k

[BUGS] Problem

2002-07-02 Thread Ram
Sir, I dont know whether this is a right place to ask this question,but I hope you guys will still help me out. I'm in a serious problem,we are using Postgres having 2-3 databases,today when i started the server I couldnot find a single database,also it is not allowing me to create a new one.Its s

[BUGS] pqReadData() -- backend closed the channel unexpectedly.

2002-07-02 Thread Amit Mishra
i have to call one c function users() present in one c file which is as follows: #include #include "pgsql/postgres.h" void users(); int main() { users(); } void users() { FILE *fp; fp = fopen("/home/suresh/trigger/test.txt","w"); fputs("Hello this is c function",fp)