Re: [SQL] Question about GUI

Hş, On Tue, 2007-01-09 at 17:45 -0600, Judith wrote: > I just want to know if there is some GUI with postgreSQL for Fedore Core 3?? There is pgadmin 1.2.0 (old release, but it works) for Fedora Core 3: http://www.postgresql.org/ftp/pgadmin3/release/v1.2.0/fc3/ Recent versions of pgadmin3 won't

Re: [SQL] Can we convert from Postgres to Oracle !!???

On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: > Can we convert from Postgres to Oracle !!??? Yes!!??? -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hos

Re: [SQL] Modifying postgresql.org file

Hi, On Wed, 2006-02-15 at 08:15 -0800, Ken Hill wrote: > It has been suggested to me to increase my work_mem to make queries > preform faster. I believe I do this in the 'postgresql.org' file. I > seem to have two of these files: > > /etc/postgresql/7.4/main/postgresql.org > /usr/share/postgresq

Re: [SQL] PRIMARY KEY and INDEX

ot; CREATE TABLE Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBNzLFtl86P3SPfQ4RAuOZAKDoE5NFtu7B3Dg356+CH5P9CGp7cgCfaBQm 33nie6C/x2PIfA0D1z

Re: [SQL] Datetime

and a TIME, but with 2 decimal cases on the :cc and > not .c as the TIME format. Is this what you are asking? test=> SELECT now()::timestamp(1); now 2004-08-03 13:58:48.60 (1 row) Regards, -- Devrim GUNDUZ devrim~gunduz.org

Re: [SQL] Question re: serial

table to it. How do I do that in Postgresql? I > know that I can define a sequence and insert the value manually, but is there > a way to query the value of the most recently inserted serial column of a > row? See currval() and nextval() functions: Regards, - -- Devrim GUNDUZ

Re: [SQL] psql: FATAL 1: IDENT authentication failed for user error

. Also, a reload is required after a change in pg_hba.conf. Regards, - -- Devrim GUNDUZ [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.TDMSoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuP

Re: [SQL] PgSQL Down

Below is the log file just after Postgresql database server is started > manually. Log can't record the cause of this problem. Could be something with hardware or power failure? Also, could you please increase logging level (log_min_messages in postgresql.conf)? Regards, - -- Devri

Re: [SQL] What am I doing wrong in here?

> ...(run as an appropriate user) will grant the user such permission. Hmm, that solved the problem, thanks. But I still could not understand why the lack of createuser permission caused the error above... Regards, - -- Devrim GUNDUZ [EMAIL PROTECTED]

[SQL] What am I doing wrong in here?

permission denied for schema pg_catalog Google'd a bit; but could not find a solution for that. Is is something with schemas? Regards, - -- Devrim GUNDUZ [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.TDMSoft.com

Re: [SQL] Error with DROP column

* Maybe you should upgrade your PostgreSQL. Regards, - -- Devrim GUNDUZ [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Lin

Re: [SQL] CREATE table1 FROM table2

Hi, On 17 Jun 2003, Rado Petrik wrote: > How I create table1 from other table2 . CREATE TABLE table1 AS SELECT * FROM table2; will work. Regards, -- Devrim GUNDUZ [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.tdmsoft.

[SQL] performance comparison: DISTINCT and GROUP BY

regards. -- Devrim GUNDUZ [EMAIL PROTECTED] Tel : (312) 295 9318 [EMAIL PROTECTED] Faks : (312) 295 9494 Web : http://devrim.oper.metu.edu.tr - ---(end of broadcast

[SQL] A SQL Training

e list this family tree in "tree" formt by only using SQL? Best regards. -- Devrim GUNDUZ [EMAIL PROTECTED] [EMAIL PROTECTED] Web : http://devrim.oper.metu.edu.tr - ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Select + min question

ot think of using subselects :-( Anyway, thanks. Best regards. -- Devrim GUNDUZ [EMAIL PROTECTED] [EMAIL PROTECTED] Web : http://devrim.oper.metu.edu.tr - ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Select + min question

clause What should I do? ANy suggestions? Best regards. -- Devrim GUNDUZ [EMAIL PROTECTED] [EMAIL PROTECTED] Web : http://devrim.oper.metu.edu.tr - ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Stupid Question

<<< No Message Collected >>> ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[SQL] Entering data in serial column

Hi all, Let's say I have a table named "info" having the following fields: name char(40), surname char(40), address char(40), id serial Now, since id is a serial, while inserting data into info I write: INSERT INTO info (name,surname,address) VALUES ('$name','$surname', '#address'); Is there