[GENERAL] Re: MySQLs Describe emulator!

> Boulat Khakimov <[EMAIL PROTECTED]> writes: > > Here is a nifty query I came up with > > that provides a detailed information on any row of any table. > > Something that is build into mySQL (DESC tablename fieldname) > > but not into PG. > > Er, what's wrong with psql's "\d table" ? Those witho

Re: [GENERAL] Re: RPMs for PHP accessing PostgreSQL via ODBC over RedHat

The case is really code compatibility. I have benn using PHP to access mSQL, MySQL and PostgreSQL natively for quite a while, *but* we need to port an apllication currently running on NT written in PHP and accessing MS Access using ODBC. We have already exported the database to PostgreSQL over Red

[GENERAL] Problem re Set Like Structures

Hi, Sorry if this is a duplicate post - I posted yesterday, but I'm pretty sure from the wrong account, and the Email hasn't shown on the list. Also there was an error in the original Email! Whilst I'm new to Postgresql, I have long experience in database work in general. I am currently beginn

[GENERAL] plperl woes

Hey folks, I've got quick question. Let's suppose that I'm running postgres on a machine that's behind a firewall, and have restricted access to the database server to the local networks. Let's further suppose I wanted to use plperl as a _complete_ interpreter, without using the Safe/Opcode stu

Re: [GENERAL] System V IPC semaphore configuration.

On Mon, 5 Mar 2001, Ted Gervais wrote: > I am new to this list and ran into a problem when trying to install the > latest postgresql, version 7.0.3. > Here is what I see when I try and bring postgresql up: > > postgres@ve1drg:~$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data > IpcMemory

Re: [GENERAL] Getting lengths of variable fields

> > Yup, indeed there is no such field in pg_class. > > Figure I can field this one in hopes of giving Tom more time for other > things :) > > It's a system column, so it doesn't show up in the > column list that you see from a select * query, but if you do a > select oid from pg_class; you'll

Re: [GENERAL] Getting lengths of variable fields

On Mon, 5 Mar 2001, Boulat Khakimov wrote: > Michelle Murrain wrote: > > > > On Monday 05 March 2001 07:05 pm, Tom Lane wrote: > > > Join attrelid against the OID column of pg_class ... > > > > Um, which column? When I look at that table, I see the following columns... > > > > relname

Re: [GENERAL] List of all system tables.

In psql, \dS. > Hi, > > How do I get the list of all system tables starting with "pg_" > > > Regards, > Boulat Khakimov > > -- > Nothing Like the Sun > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister

[GENERAL] interval question

Hello: Maybe somebody on the list can give me a hand with this. I have: id serial, start time, duration time (That is, ids have an start time and a duration). I want to know which ids are current, ie, which satisfy start<=now<=start+duration. The problem is that

Re: [GENERAL] Getting lengths of variable fields

Michelle Murrain wrote: > > On Monday 05 March 2001 07:05 pm, Tom Lane wrote: > > Join attrelid against the OID column of pg_class ... > > Um, which column? When I look at that table, I see the following columns... > > relname | reltype | relowner | relam | relpages | reltuples | >

[GENERAL] List of all system tables.

Hi, How do I get the list of all system tables starting with "pg_" Regards, Boulat Khakimov -- Nothing Like the Sun ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAdd

Re: [GENERAL] Getting lengths of variable fields

On Monday 05 March 2001 07:05 pm, Tom Lane wrote: > Join attrelid against the OID column of pg_class ... Um, which column? When I look at that table, I see the following columns... relname | reltype | relowner | relam | relpages | reltuples | rellongrelid | relhasindex | relisshare

Re: [GENERAL] Getting lengths of variable fields

On Monday 05 March 2001 05:55 pm, Tom Lane wrote: > > This info is stored in the 'atttypmod' field of pg_attribute, but I > don't know whether DBD::Pg provides any handy interface to that. You > might have to get down-and-dirty enough to select it directly out of > pg_attribute ... Ah, I got it.

Re: [GENERAL] Re: pgsql for Python

On Friday, March, 2001-03-02 at 14:16:02, Joel Burton wrote: > On Wed, 28 Feb 2001, [iso-8859-2] Marek Pętlicki wrote: > > > Has anybody used http://sourceforge.net/projects/pgsql ? > > I maintain production system based on Python and PostgreSQL. > > > > I currently use PoPy, but for a few reaso

Re: [GENERAL] Getting lengths of variable fields

Join attrelid against the OID column of pg_class ... regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Re: Daily Digest V1 #377

> > I'm writing a very robust validation script in perl for database entry. One > of the things I'd like to do is check how large a field is, and make sure > that the entry into that field isn't too big. Problem is, for variable length > fields, DBD::Pg returns a -1 size, using the pg_size attribu

Re: [GENERAL] Getting lengths of variable fields

Tom Lane wrote: > > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Michelle Murrain writes: > >> Is there something I am missing? Is there a way to get the size of variable > >> length types using DBI/DBD::Pg, in particular, char() and varchar()? > > > Normally, you'd use LENGTH or OCTET_LENGT

Re: [GENERAL] Unknown Response Type???

--- chris markiewicz <[EMAIL PROTECTED]> wrote: > Unknown Response Type  > at org.postgresql.Connection.ExecSQL(Connection.java:420) > at org.postgresql.jdbc2.Statement.execute(Statement.java:273) > at > org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54) > > does a

[GENERAL] System V IPC semaphore configuration.

I am new to this list and ran into a problem when trying to install the latest postgresql, version 7.0.3. Here is what I see when I try and bring postgresql up: postgres@ve1drg:~$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data IpcMemoryCreate: shmget failed (Invalid argument) key=54320

Re: [GENERAL] Re: RPMs for PHP accessing PostgreSQL via ODBC over RedHat

> > >Is it really necessary to use PHP and ODBC? PHP has a native postgresql > > >interface I believe... > > > > It sounds like the postgres server is a different machine to the web > > server, so ODBC is needed to communicate between the 2.. > >No it isn't. Postgres should be accessible via PHP

Re: [GENERAL] Getting lengths of variable fields

On Monday 05 March 2001 05:55 pm, Tom Lane wrote: > What Michelle seems to want is the declared limit on field width, not > the actual width of any particular value. Yes, that's exactly what I want. > This info is stored in the 'atttypmod' field of pg_attribute, but I > don't know whether DBD::

Re: [GENERAL] Re: RPMs for PHP accessing PostgreSQL via ODBC over RedHat

i´m using different machines to the web server and postgres server and i haven´t got odbc drivers, it is not necesary. It works very good!! Mensaje original De: Chris Fecha: Mon 3/5/01 19:38 Para: [EMAIL PROTECTED] Tema: [GENERAL] Re: RPMs for PHP acce

Re: [GENERAL] function overloading / ambigous functions

Kyle <[EMAIL PROTECTED]> writes: > CREATE FUNCTION my_search(int2, int2, int2, int2) > RETURNS int4 AS '/home/kaf/lib/my_search.so', > 'my_search' LANGUAGE 'c'; > CREATE FUNCTION my_search(float8, float8, float8, float8) > RETURNS int4 AS '/home/kaf/lib/my_search.so', > 'my_search_flo

Re: [GENERAL] upper() vs. lower()

I know that if you move towards unicode, you'll probably do better by going to lowercase since I understand that there are more lowercase letters than uppercase (for some odd reason!). I think it's related to the fact that some languages have multiple lowercase letters that will map to a single u

Re: [GENERAL] Re: RPMs for PHP accessing PostgreSQL via ODBC overRedHat

On Tue, 6 Mar 2001, Chris wrote: > >Is it really necessary to use PHP and ODBC? PHP has a native postgresql > >interface I believe... > > It sounds like the postgres server is a different machine to the web > server, so ODBC is needed to communicate between the 2.. No it isn't. Postgres should

Re: [GENERAL] Re: INSERT ... RETURNING as Oracle

"Martin A. Marques" <[EMAIL PROTECTED]> writes: > If I have a client INSERT a value in a table (all happens inside a BEGIN > WORK COMMIT WORK), which has a SERIAL column, and I want to > reference that serial value on another INT column which is a foreign key > of that SERIAL. Using currval()

[GENERAL] 'Unknown Result Type' - JDBC Driver

Hi, I am using the JDBC interface. Does anybody know what could lead to the following two errors I ran into - 1. Cannot handle multiple result groups. at org.postgresql.Connection.ExecSQL(Connection.java, Compiled Code) at org.postgresql.jdbc2.Statement.execute(Statement.ja

Re: [GENERAL] How to automatically start postmastrer with TCP/IPsupport (-i option) ???

Paulo Parola writes: > I am trying to configure PostgreSQL 7.1 over RedHat 7.0 (according to > Lamar Owen the RPM's for 7.1 were built on RedHat 6.2 and not 7.0 - > does that implies any possible problems?). Always rebuild from the source RPM. Never trust binary RPMs unless you have the exact s

[GENERAL] Re: Does PostgreSQL support Constant Expression (Alias Name)?

Thank you very much to all helped me. You save me a lot of time. (*^_^*) begin:vcard n:Chui;Raymond tel;fax:(301)713-0963 tel;work:(301)713-0624 Ext. 168 x-mozilla-html:TRUE url:http://members.xoom.com/rchui/ org:NWS, NOAA version:2.1 email;internet:[EMAIL PROTECTED] title:SA, DBA note:ICQ #:

[GENERAL] Re: postmaster confiugration and hardware configuration

On Sat, 06 Feb 1999 04:00:26 KoPra Workshop wrote: >I'm newbie, and confuse on configuration Your system clock is not correct. -- Anthony E. Greene <[EMAIL PROTECTED]> PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D Chat: AOL/Yahoo: T

RE: [GENERAL] [PHP] How to connect to PostgreSQL with phpPgAdmi

hi, the only think you need to do is create a user(ej: phppgadmin) and grand permition (only select) to table pg_users. Then in the config.inc.php file you need to put:   $cfgServers[1]['local']  = false; $cfgServers[1]['host']  = 'hostname;$cfgServers[1]['port']  = '5432';$cfgServers[1]['a

[GENERAL] [PHP] How to connect to PostgreSQL with phpPgAdmi

For the phpPgAdmin users, if you might help!!!   I am running PostgreSQL 7.1 over RedHat.   When trying to connect through the web everything goes right. A script that is currently working:         $link = pg_Connect("host=localhost port=5432 dbname=teste")  or die ("Could not con

Re: [GENERAL] How to automatically start postmastrer with TCP/IPsupport (-i option) ???

Hi, On Sun, 4 Mar 2001, Paulo Parola wrote: > Date: Sun, 4 Mar 2001 18:38:04 -0300 > From: Paulo Parola <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: [GENERAL] How to automatically start postmastrer with TCP/IP > support (-i option) ??? > > nohup /usr/bin/postmaster -i -D /var/lib/p

Re: [GENERAL] postmaster confiugration and hardware configuration

Eko, On Sat, 6 Feb 1999, KoPra Workshop wrote: > Any suggestion to increase performance of my postgresqlat least great > configuration for postmaster and hardware...? > Pleasse :-) It is hard to tell with the information you are giving, but perhaps you are hitting the default limit for

[GENERAL] postmaster confiugration and hardware configuration

Hi... I'm newbie, and confuse on configuration I already installed postgresql 7.0.3 on Compaq Proliant ML 350 - Intel Pentium III 600 - RAM 128 MB. Operating system is linux on distribution SuSE 6.4 This server only running database itself. Directory '/data' is independent partition and size