[SQL] special caracters??

Hi all! I have problems when I store non-english caracters like ñ, á, é, etc. when I got that caracters stored in the DB with select statement and build a page I have substitutions, instead of the data that I put appear something different, there is a way to handle this?? thank you, Rocael.

Re: [SQL] Persistent Connects (pg_pconnect)

On Tue, 21 Nov 2000 12:34:19 +, Colleen Williams <[EMAIL PROTECTED]> wrote: > Each time one of us uses the CMS, a new > persistent connection process owned by postgres is started up. With 3 > people accessing the CMS sporadically, 32 persistent connections are > in existence and then Linux te

Re: [SQL] Permissions Broken in 7.0.x?

Tom, Thank you for the reply. I have found another issue that I am curious about: I have a table with foreign key constraint to itself (a parent_id field). I have a view to the table with permissions for a user to insert into the view (of course, a rule exists to insert into the real table).

Re: [SQL] Blob Upload

Keith, Thank you. Your answer solved part of my problem. Damn me. Only remains how to upload a file from web interface(apache/php). I´ll keep working on it. Best Regards. Aristeu Gil Alves Junior<[EMAIL PROTECTED]> Consultor em Tecnologia de

Re: [SQL] Permissions Broken in 7.0.x?

Brian Powell <[EMAIL PROTECTED]> writes: > % psql bobdb > psql => create table test ( > name char(32) not null, > ageint4 > ); > psql => revoke all on test from tester; > CHANGE > psql => select * from test; > ERROR: test: Permission denied. Yeah, that's a bug --- confusi

[SQL] Permissions Broken in 7.0.x?

Greetings, I am having problem with table permissions and view permissions. Say I am user bob and I own a database, bobdb. Let us also assume a user, tester has been added to the db, via create user... % psql bobdb psql => create table test ( name char(32) not null, ageint

[SQL] CREATE OR REPLACE VIEW

Hi all, Is CREATE OR REPLACE VIEW available in any way, in PostgreSQL 7.0.2? I am building a PHP/PostgreSQL application, and want to CREATE a VIEW if it doesn't existe or REPLACE it with a new one, if it already exists. I was hoping that I didn't have to DROP the VIEW so I don't get error messag

Re: [SQL] Problem with subquery joined to a view

Kyle <[EMAIL PROTECTED]> writes: > The fourth "select" uses a regular subquery. It gives the error: > psql:datbug.sql:44: ERROR: Sub-SELECT uses un-GROUPed attribute > pay_req.wdate from outer query This appears to work correctly in current sources. In 7.0.* and before grouped views do not wor

[SQL] Problem with subquery joined to a view

I assume this is a bug of some kind.  Here's a neat little example to demonstrate it.  If it helps make 7.1 better, great. If I've done something wrong, I'd like to figure that out too if anyone can help. This forms a bunch of hypothetical payroll entries and then makes a view which aggregates th

Re: [SQL] Postgres 7.0.X and arrow keys

Antti Linno writes: > I installed new Mandrake 7.2 and was eager to try new postgres. So I > installed it and used pgsql. What surprised me was that the arrow keys > wouldn't work anymore as history, instead I get those ascii codes. You need to install the readline-devel RPM. -- Peter Eisentra

Re: [SQL] Blob Upload

Do you mean VARCHAR[30] or VARCHAR(30)?? I think you're creating an array of chars... but what you want is just a VARCHAR type with 30 characters... It may explain the array error you are getting. Keith At 11:07 AM 21/11/2000 -0200, Aristeu Gil Alves Junior wrote: >I´m trying to upload a gif im

Re: [SQL] Persistent Connects (pg_pconnect)

Just looked at the Php documentation... according to that.. it goes... "An 'identical' connection is a connection that was opened to the same host, with the same username and the same password (where applicable)." Perhaps that means you need to specify the host for this to work. Let me know on

Re: [SQL] Persistent Connects (pg_pconnect)

Hi Colleen, When you use specify a host parameter... Php will attempt to connect to your postgres server using TCP/IP... if you are not running the postgres backend with the -i option, then these connections won't happen. When you don't specify a host name then Php will use a local Unix socket.

[SQL] Blob Upload

I´m trying to upload a gif image from a web interface (apache/php) without success. I´m using the input type ="file". Have someone already made this work? And even when I try to upload from the SQL interface of Tkl PgAccess... : The table: CREATE TABLEimages (name VARCHAR[30] , img OID); SQ

[SQL] Persistent Connects (pg_pconnect)

Hello all, I am having some problems with persistent connections. The PHP scripts in my content management system (CMS) are connecting using pg_pconnect(" dbname='MYDB' user='user' password='password'' port='5432' "). I have not been able to connect to the PostgreSQL database when I include