Re: [GENERAL] column names query

On Thu, Sep 7, 2017 at 3:28 PM wrote: > Example query > select a.col1, case when a.col2 > 0 then a.col3 else b.xcol1 end as mycol3 > from a left join b on > Expected response > col1 mycol3 > This may be overkill, but works: postgres=# \copy (select 1 as foo, 2 as bar

Re: [GENERAL] forcing a table (parent in inheritance) tor emain empty

On Tue, Oct 11, 2016 at 12:27 PM, Rémi Cura wrote: > Hey dear list, > I can't find a nice solution to enforce a necessary behaviour in my case : > I want a parent table to remain empty. > > Of course I could define a trigger and return NULL in any case, but I'd like > a more

Re: [GENERAL] foreign key with where clause

On Thu, Aug 18, 2016 at 1:10 PM, Mark Lybarger wrote: > I have two tables that i want to link with a FK where the child table record > is "active". > > some googling shows that i could use a function and a check constraint on > the function, but that only works for inserts,

Re: [GENERAL] FIRST_VALUE: need to group by argument?

On Tue, May 24, 2016 at 8:50 AM, David G. Johnston wrote: > SELECT x, sum(i), sum(sum(i)) OVER (PARTITION BY x) FROM ( VALUES (a,1), > (a,2), (b,3) ) val (x,i) GROUP BY x > yields > a, 3, 6 > b, 3, 6 Thank you for this enlightening explanation! I was, however, very

Re: [GENERAL] PG wire protocol question

On Tue, May 17, 2016 at 9:29 AM, Albe Laurenz wrote: > That blog post seems ill-informed - that has nothing to do with > two-phase commit. > > The problem - that the server may commit a transaction, but the client > never receives the server's response - is independent of

Re: [GENERAL] Skip trigger?

On Sat, Apr 30, 2016 at 1:38 AM, wrote: > I have a table with a row update trigger that is quite slow. > The trigger finction basically sets some bits in a "changed" column > depending on which values really changed. > For some bulk updates it can be determined in advance

Re: [GENERAL] Why are data files stored in /var/lib

On Fri, Apr 29, 2016 at 11:00 PM, Charles Clavadetscher wrote: > I had a discussion yesterday with some friends, who are sysadmins about the > location of database files. In a default installation > from a distribution (apt-get install) PostgreSQL creates a cluster

Re: [GENERAL] Proper relational database?

On Sat, Apr 23, 2016 at 12:05 AM, Thomas Munro wrote: > FWIW standard SQL may not allow it but Postgres does, and it's even > possible to exclude duplicates by using an expression that references > the whole row. Indeed, but its semantics can be rather wonky.

Re: [GENERAL] Proper relational database?

On Fri, Apr 22, 2016 at 3:07 PM, Paul Jungwirth wrote: > I'm surprised no one yet has mentioned Tutorial D by C. J. Date. His book > _Database in Depth_ is pretty much an extended argument for how superior it > is to SQL. RelDB is apparently an open source

Re: [GENERAL] Partitioning and ORM tools

NLY master WHERE id = NEW.id returning * into r; RETURN r; END; $$ LANGUAGE plpgsql; Returning the inserted row here also solves the problem that ORM often need auto increment values back. regards Manuel Kniep

Re: [GENERAL] Partitioning and ORM tools

NLY master WHERE id = NEW.id returning * into r; RETURN r; END; $$ LANGUAGE plpgsql; Returning the inserted row here also solves the problem that ORM often need auto increment values back. regards Manuel Kniep

[GENERAL] Question about the postgresql's certifications

Hello, i would like to know what is the difference between the postgresql CE 8 silver and postgresql associate certification which provides EnterpriseDB. Which one is the most recently and which of those is based in postgres 9.5? regards

[GENERAL] cached row type not invalidated after DDL change

for the open session after the first insert. Database sessions that didn’t issue an insert on the old structure don’t have that problem. I could reproduce this behavior in postgres 9.4.3, 9.4.1 and 9.4.0  regards Manuel Kniep

Re: [GENERAL] ALTER TYPE ADD SEND AND RECEIVE

On 11. Dezember 2014 at 00:08:52, Tom Lane (t...@sss.pgh.pa.us) wrote: Manuel Kniep writes: I have a custom type and want to add the yet missing SEND and RECEIVE functions is there anyway to alter the type definition without dropping and recreating it? There's no supported way

[GENERAL] ALTER TYPE ADD SEND AND RECEIVE

I have a custom type and want to add the yet missing  SEND and RECEIVE functions is there anyway to alter the type definition without dropping and recreating it? Manuel

[GENERAL] PG_RETURN_UINT16

Hi, I’m missing a PG_RETURN_UINT16 macro. As we have PG_RETURN_UINT32 and also PG_GETARG_UINT16 is there any reason why there is no PG_RETURN_UINT16 ? cheers Manuel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] Indices and Foreign Tables

I doing something wrong here, or is this not possible that the indices are used by the fdw? Any hints are appreciated. Cheers Manuel -- Kohler Manuel (ID SIS) Research Informatics, Scientific IT Services (ID ETHZ) Quantitative Genomics Facility (QGF), D-BSSE ETH Zurich, Mattenstr. 26 (1078 1.02

Re: [GENERAL] Indices and Foreign Tables

Removed by Filter: 35726596 Total runtime: 219438.925 ms (13 rows) Regards Manuel -- Kohler Manuel (ID SIS) Research Informatics, Scientific IT Services (ID ETHZ) Quantitative Genomics Facility (QGF), D-BSSE ETH Zurich, Mattenstr. 26 (1078 1.02), CH-4058 Basel, +41 61 387 3132 On 04 Apr 2014, at 17

[GENERAL] is there a way to dump the version of extensions

; Is there a way to do that? cheers Manuel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] JDBC driver for Postgres 9.3

Hi, we are developing a Java based software with Postgres as a DB. Could someone tell me if there will be a JDBC driver for 9.3 out soon or is it safe and recommended to use the latest JDBC driver available? Currently we are using: PostgreSQL 9.2-1000 JDBC4 (build 1000) Kind regards Manuel

[GENERAL] table inheritance and locks

Hi, If I aquire a lock on table B which is inherited from table A, Table A seems to be also locked (postgres 9.2). Is there a way to get around it ? I couldn't find any information about this behavior in the documentation. Thanks Manuel Kniep -- Sent via pgsql-general mailing list (pgsql

[GENERAL] unexpected external sort Disk

: 42999.882 ms (5 rows) Has anyone an idea what I'm missing ? Thanks Manuel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Using a function in different schemas

Hello everyone! This is the first time I post on this list. Until now, I was able to get a solution to all the problems I had, but now I am facing an issue I can't resolve, so I hope you can help me. The problem goes like this: I am using the same distribution of tables/functions into different

Re: [GENERAL] Using a function in different schemas

Thanks Adrian! That is exactly what I was looking for! =o) On Wed, Aug 31, 2011 at 3:35 PM, Adrian Klaver adrian.kla...@gmail.com wrote: On 08/31/2011 08:38 AM, Juan Manuel Alvarez wrote: Hello everyone! This is the first time I post on this list. Until now, I was able to get a solution

Re: [GENERAL] Encryption For Specific Column- Where to store the key

as his address, but an attacker can't do much with this data.) Thanks a lot! Kind Regards Manuel Gysin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Encryption For Specific Column- Where to store the key

-exchange.com/Database/PostgreSQL/Q_21934798.html (answers are not all the time displayed...) But there were no final solution at all. Kind regards Manuel Gysin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

[GENERAL] PG 9.0 32 bits bin under 64 bit arq

Could I install pg 9.0 binary 32 bits in SO of 64 bits ? with suse 11.3 thnks

[GENERAL] HELP with a query with blank fields

Hello, This is the current query I have: SELECT dominis.nom, dominis.extensio, dominis.creat, dominis.expira, titulars.first_name, titulars.last_name, contactes_admin_tec.first_name, contactes_admin_tec.last_name, dns1.nom, dns2.nom, dominis.redirec, contactes_fac.nom, grups.nom FROM dominis,

Re: [GENERAL] how to modify a view

Thank you Shane All beings be happy, _- manou Shane Ambler escribi: J. Manuel Velasco - UBILIBET wrote: Hello, The DB I am using has views. I need to modify the view adding one field to the QUERY that build the query. When I edit the VIEW and add the field, I

[GENERAL] how to modify a view

Hello, The DB I am using has views. I need to modify the view adding one field to the QUERY that build the query. When I edit the VIEW and add the field, I get the error that tells me "It's not possible to change columns number in a view" So, do I need to remove the complete VIEW and create

Re: [GENERAL] how can i get initdb

. Manuel Velasco - UBILIBET wrote: found it, thanks a lot tomorrow i will try set the encoding with initdb adn try to restore the database If you're using debian then check out pg_dropcluster and pg_createcluster commands. Have a nice day, --

Re: [GENERAL] change encoding

Hi Martijn, Thank you very much for reply. It has worked perfectly. Have a good life, All beings be happy Martijn van Oosterhout escribi: On Tue, May 13, 2008 at 05:37:27PM +0200, J. Manuel Velasco - UBILIBET wrote: I have the idea to create the database and the role

[GENERAL] change encoding

Hello, I have installed a new postgresql server and I need to recover an old database on it. The database I have to recover has LATIN2 as encoding and when i try to restore it into the new one I get error messages due to encoding. I have read that from pgsql8-3 is not possible to have

Re: [GENERAL] change encoding

of the server to LATIN2 Thanks in advance. Good luck! Martijn van Oosterhout escribi: On Tue, May 13, 2008 at 09:00:49AM +0200, J. Manuel Velasco - UBILIBET wrote: Hello, I have installed a new postgresql server and I need to recover an old database on it. The database I have to recover has

[GENERAL] how can i get initdb

Hello, I read that with initdb command I can specify the server encoding, but with my installation I don't hae initdb command. How can I install it? Please Thanks. PS: I installed postgresql-8.3 debian package and it's respectives dependencies. --

Re: [GENERAL] how can i get initdb

found it, thanks a lot tomorrow i will try set the encoding with initdb adn try to restore the database thanks a have a good end of the day ! salman escribi: J. Manuel Velasco - UBILIBET wrote: Hello, I read that with initdb command I can specify the server encoding

Re: [GENERAL] Cannot use a standalone backend to VACUUM in postgres

Alvaro Herrera [EMAIL PROTECTED] writes: Manuel Sugawara wrote: Hi Manuel, The funny thing is that there was no open transactions, even after restarting the cluster the same message was logged. Today, the database stopped working as expected: ERROR: database is shut down to avoid

Re: [GENERAL] Cannot use a standalone backend to VACUUM in postgres

= relnamespace) where nspname ~ '^pg_temp' and no temp tables showed in any database :-(. Any other idea?. Regards, Manuel. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Cannot use a standalone backend to VACUUM in postgres

Alvaro Herrera [EMAIL PROTECTED] writes: Manuel Sugawara wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Hmm, nope -- take away the relnamespace check, because there is a different namespace for each backend (pg_temp_2, pg_temp_3, etc). Still no luck, changed the query

Re: [GENERAL] Cannot use a standalone backend to VACUUM in postgres

Alvaro Herrera [EMAIL PROTECTED] writes: Manuel Sugawara wrote: A friend is doing the queries right now but it takes time :-(, mean time I was wondering if it will be safe to apply the following patch just to get the database up and be able to run pg_dumpall: Yes, it is safe. Just make

[GENERAL] Cannot use a standalone backend to VACUUM in postgres

: es_MX.ISO-8859-1 LC_CTYPE: es_MX.ISO-8859-1 Please let me know if there is more information needed. Regards, Manuel. backend SELECT relname, age(relfrozenxid) FROM pg_class WHERE relkind = 'r'; user=,db=WARNING: base de datos ╴postgres╴ debe ser limpiada

Re: [GENERAL] Cannot use a standalone backend to VACUUM in postgres

Alvaro Herrera [EMAIL PROTECTED] writes: Hi Manuel, Hi Alvaro! I suggest you look for temp tables that have not been reclaimed. We've had a couple of reports where leftover temp tables have stopped the frozen-xid counter from advancing. (They would have a very old relfrozenxid.) Thank

Re: [GENERAL] Cannot use a standalone backend to VACUUM in postgres

Manuel Sugawara [EMAIL PROTECTED] writes: Alvaro Herrera [EMAIL PROTECTED] writes: Hi Manuel, Hi Alvaro! I suggest you look for temp tables that have not been reclaimed. We've had a couple of reports where leftover temp tables have stopped the frozen-xid counter from advancing

Re: [GENERAL] Audit-trail engine inner-workings

-custom.html but haven't got to the details yet. Regards, Manuel. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] FInding corrupt values in UTF-8 tables (regexp question, I think)

] What am I missing? In a character class expression the dash has an special meaning. If you need to match a dash it has to be the first character. Regards, Manuel. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] permission denied for schema

security exception), not sure which release but the version was 8.1. Haven't seen the problem for some time now, currently running 8.1.8. Regards, Manuel. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

[GENERAL] /var/run/postgresql ??

the above description (i think so, but as i said i'm unexperienced in linux), but does any one know hot to fix it? Did i miss something during install?? I installed the client, the server and the libs were alredy installed... Thank you Manuel

Re: [GENERAL] /var/run/postgresql ??

Your a life saver :D Thank you for the super fast anser Manuel On 5/8/07, Zoltan Boszormenyi [EMAIL PROTECTED] wrote: Hi, Manuel Preliteiro írta: Hello, i have installed postgresql version 8.1.4-1.1 in Fedora 6 I have the same system. Since I'm very Linux unexperienced I used yum

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

Marcelo de Moraes Serpa [EMAIL PROTECTED] writes: I'm sorry Manuel, but after some time trying to fully understand your approach, I think I really don't have the required elements to do so. How do you pass your application's usename to this table? Or you don't keep the username at all

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

disposed to the pool. Regards, Manuel. ---(end of broadcast)--- TIP 1: 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

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

for the details. Regards, Manuel. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

Marcelo de Moraes Serpa [EMAIL PROTECTED] writes: Hi Manuel, each time the user sends a request I do more or less the following: Could a trigger be used to implement this ? Or are you doing this from the application layer? I'm doing it form the application layer and I don't think it can

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

) { if (! session_id_is_set) PG_RETURN_NULL(); PG_RETURN_INT32(session_id); } Datum reset_session_id(PG_FUNCTION_ARGS) { session_id_is_set = false; PG_RETURN_BOOL(1); } Hope that helps. Regards, Manuel. ---(end of broadcast)--- TIP 1: if posting

[GENERAL] Tsearch2 default locale on postgres 8.2

the query window and open a new one and then try the select show_curcfg(); again, it states ERROR: could not find tsearch config by locale Any idea why the configuration is not saved correctly? Best regards Manuel ... ---(end of broadcast

Re: [GENERAL] Tsearch2 default locale on postgres 8.2

Hi, right ... i had a typo in the locale, it was set to de_DE.UTF8 but should have been set to de_DE.UTF-8. After that change, the select set_curcfg('default'); worked fine. thanx a lot... Best regards Manuel Friday, December 22, 2006, 12:35:41 PM, you wrote: HD I think the best way

[GENERAL] PG 8.2.0 - TSearch2 Wrong affix file format

with 8.2.0 also? The files seem to be ok and are UTF-8 encoded. Best regards Manuel ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] PG 8.2.0 - TSearch2 Wrong affix file format

be setup correctly :-) I also tested the correct tsearch2 install by removing all lines from the .aff file and the error then vanishes and the search works, but without the .aff I guess a key feature is missing :-) Best regards Manuel german.aff Description: Binary data

Re: [bulk] Re: [GENERAL] PG 8.2.0 - TSearch2 Wrong affix file format

thanks, that fixed it :-) Best regards Manuel TS Affix file has artifact: TS PFX G N 1 TS . GE TS which is strange mix of openoffice format and ispell format. Just remove they. TS 8.2 Ispell code checks format strongly that in previous versions, even backported

[GENERAL] Slow query in 8.2.0

: ((outer.id = r.trayectoria_id) AND (r.grupo_id = 160940)) - Index Scan using persona_pkey on persona p (cost=0.00..4.10 rows=1 width=4) (never executed) Index Cond: (outer.persona_id = p.id) Total runtime: 1.465 ms (13 rows) Any ideas? Regards, Manuel. ---(end

Re: [GENERAL] Slow query in 8.2.0

predates Postgres support of JOINs, I guees we have been using Postgres for a very long time :-). Just out of curiosity, why the change? Regards, Manuel. ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Error with the odbc driver and the large objects

Hi, the problem is that i can insert, or I think that it is insert (it didn't show any error), well. But when I try to read the large object in the db, it didn't read nothing. The last var parameter of SQLbindCol, StrLen_or_IndPtr, ever return 0. I don't know where the error is. Any Idea to fix

[GENERAL] Last Commited Transaction

Hi, How I can determine information about the last committed transaction in postgresql? Thanks, Ricardo Vilaça ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Last Commited Transaction

Michael Fuhr wrote: On Tue, Apr 11, 2006 at 12:54:12PM +0100, Ricardo Manuel Pereira Vilaça wrote: How I can determine information about the last committed transaction in postgresql? What information are you looking for? What are you trying to do? When a server restarts

[GENERAL] Regular expressions w localization problem

:-(. Btw, this is PostgreSQL 8.0.4, running on Fedora Core 4. Best Regards, Manuel. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Regular expressions w localization problem

. So, what locale and encoding are you using? The locale is es_MX and encoding latin1. (UTF-8 doesn't play very well with regular expressions :-(). Regards, Manuel. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

[GENERAL] Can I catch sentences in SQL using triggers?

Hello Everybody, somebody knows if its possible to catch one sentences in full SQL using the triggers, or maybe somebody have any idea about to how do it? I am using postgreSQL 7.3 on fedora core 1 Thanks in advancedManuel

Re: [GENERAL] Can I catch sentences in SQL using triggers?

. Manuel - Original Message - From: Richard Huxton dev@archonet.com To: Manuel García [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Wednesday, June 01, 2005 9:38 AM Subject: Re: [GENERAL] Can I catch sentences in SQL using triggers? Manuel García wrote: Hello Everybody, somebody

[GENERAL] Can postgresql catch all the sentences applies to one table?

in advanced. Atte. Manuel

[GENERAL] Advice

Hi, I am Manuel and I want to catch the full sentence executed on one table, at the moment I have one function in C, that function is invoking by trigger, but I need to catch the full sentence, by example insert into tempo values (1,2,’x’) or update tempo set a=2, b=’x’ where a=3 or delete

Re: [GENERAL] PostgreSQL 7.4.1 and pgdb.py

As a user of PostgreSQL I totally agree with Gaetano Mendola. There is no reason to pull the python subpackage out of the main set, - Original Message - From: Gaetano Mendola [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 06, 2004 9:24 PM Subject: Re: [GENERAL] PostgreSQL

Re: [GENERAL] PostgreSQL 7.4.1 and pgdb.py

: comp.databases.postgresql.general Cc: Manuel Tejada [EMAIL PROTECTED] Sent: Sunday, February 01, 2004 4:48 PM Subject: Re: PostgreSQL 7.4.1 and pgdb.py Manuel Tejada wrote: import pgdb dbConnect = pgdb.connect(dsn='localhost:oracle', user='manuel', password='') cursor

Re: [GENERAL] I can't upgrade to PostgreSQL 7.4 in RedHat 9.0

] To: Lamar Owen [EMAIL PROTECTED] Cc: Manuel Tejada [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 10:55 AM Subject: Re: [GENERAL] I can't upgrade to PostgreSQL 7.4 in RedHat 9.0 We were able to use the RHEL3 under Red Hat 9 with no problems. Warmest regards, Ericson Smith

Re: [GENERAL] I can't upgrade to PostgreSQL 7.4 in RedHat 9.0

Where I can get the rpms for PostgreSQL 7.4.1? The ftp://ftp15.us.postgresql.org/binary/v7.4.1/redhat/ only has subdirectories for redhat-6.2, redhat-7.3, redhat-8.0, rhas-2.1, rhel3 - Original Message - From: Lamar Owen [EMAIL PROTECTED] To: Manuel Tejada [EMAIL PROTECTED]; [EMAIL

[GENERAL] I can't upgrade to PostgreSQL 7.4 in RedHat 9.0

Hello list This is my situation: My box: Pentium III, Red Hat 9.0 I was working fine with PostgreSQL 7.3.2. Recently I decided to upgrade it to PostgreSQL 7.4 installing the twelve rpms I downloaded from ftp://ftp15.us.postgresql.org/binar...dhat/refhat-9/. I followed the standar command to

[GENERAL] experiences with postgres in ia64 and linux

Hi all, I'm interesting to know about experiences of usign postgresql in ia64 under linux. * What about performance ? * What about stability ? * Which linux version ? At now, I usign debian in x86. * Any suggestion or recomendation ? * Better than alpha

Re: [GENERAL] [REPOST] Problem for dumping a 6.5.2 database

pg_dump and then restore that dump into the 7.3.3 database. Regards, Manuel. ---(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

Re: [GENERAL] 7.3.3 RPM build

it into packages in order to have working dependencies? Using the filter script is just a hack IMHO. Regards, Manuel. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere

[GENERAL] How to find out the weekday from a date???

this: select extract(dow from timestamp(day)), day, userid from bschft_days where date_part('month', day) = '3'; But it only tells me: ERROR: parser: parse error at or near dow :( Any ideas?? Thanks a lot in advance! Best Regards / Mit freundlichen Grüßen / Un saludo José Manuel lorenzo López

[GENERAL] postgresql on SuSE 7.1 with reiserfs

. The only way to insert data in the created table is to insert with admin user postgres. SuSE 7.1 ships with postgresql 7.0.2 Thanks in advance for your help! Best Regards José Manuel Lorenzo López ---(end of broadcast)--- TIP 5: Have you checked our

[GENERAL] About multiple access to a table

/ Mit freundlichen Grüßen / Cordiali saluti José Manuel Lorenzo López ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] [URGENT] How to generata a unique string id

Hi, I need to generate a unique four letters string (p.e ,AAAB) for any tuple I insert into a table, any idea ? How can I do this ? Thanks. -- Manuel Durán Aguete ALSERNET 2000 S.L http://www.alsernet.es Tlf: 902 187 187

[GENERAL] Re: Which Front End for Postgresql

working day and one for system (home made scripts and the like). http://www.bru.com/ -- Manuel Cano Muñoz -- SANYRES, S.A. Director Dpto. Sistemas [EMAIL PROTECTED] [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have

Re: [GENERAL] timestamp goober

is installed, instead of each time a tuple is inserted. HTH, Manuel.

[GENERAL] Problem creating pgsql_perl5 module

.2 Thanks a lot for your help! Jos Manuel Lorenzo Lpez -- ** ** Jos Manuel Lorenzo Lpez** ** ** ** ICA

[GENERAL] Error compiling postgres 7.0.3 for AIX 4.3.2

: *** [postgres.imp] Error 1 Does anyone know what is going on here? GNU Make version 3.78.1 GNU GCC version 2.95.2 Best Regards, Jos Manuel Lorenzo Lpez -- ** ** Jos Manuel Lorenzo Lpez

[GENERAL] Compiling postgresql 7.0.3 for WinNT

anybody guide me a bit or tell me where I can read docs for this? Thanks a lot in advance!!! :) Greetings / Un saludo José Manuel Lorenzo López -- ** ** José Manuel Lorenzo López

[GENERAL] PGresult deleted after PQfinish(PGconn)

to Postgresql. Thanks in advance José Manuel Lorenzo López -- ** ** José Manuel Lorenzo López** ** ** ** ICA

Re: [GENERAL] Can't put sub-queries values in queries results?

, especially when in past versions it worked with less shared memory. I wonder if isn't there a way to hack PostgreSQL source to make it work with less shared memory as in past versions. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com

Re: [GENERAL] Can't put sub-queries values in queries results?

. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --

RE: [GENERAL] Can't put sub-queries values in queries results?

) VALUES (1); SELECT f1, COUNT(f2) FROM t1, t2 WHERE f1=f2 GROUP BY f1; Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e

Re: [GENERAL] Can't put sub-queries values in queries results?

that last a column is not a NULL because that is what I get with joins. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net

[GENERAL] Can't put sub-queries values in queries results?

to understand this. I wonder if this is a limitation or I am doing something wrong. If I can't do what I want this way, I wonder if is there some other way to do it besides making two queries by passing the values from one to the other. Regards, Manuel Lemos Web Programming Components using PHP

Re: [GENERAL] International Address Format Standard

/addressformat Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --

Re: [GENERAL] Connecting website with SQL-database.....

Hello Ed, On 24-Apr-00 17:10:21, you wrote: Manuel Lemos wrote: Plus if you get a warning/error, Postgresql _requires_ you to rollback, whereas many other databases don't. That's what Metabase expects. When there is an error, you should rollback before exiting a transaction

Re: [GENERAL] Connecting website with SQL-database.....

g an error. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --

Re: [GENERAL] Connecting website with SQL-database.....

scripts, user manual and tutorial documents. http://phpclasses.UpperDesign.com/browse.html/package/20 Enjoy, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key

Re: [GENERAL] foriegn key...

Better try to install PostgreSQL version 7 and experiment on referential integrity... -- Manny C. Cabido e-mail:[EMAIL PROTECTED]

[GENERAL] Functions in postgres

Hi! I know that with \df you can see the functions available in postgres, but there must be others not documented just like getpgusername(). My question is if are there a more complete list of postgres' functions. To be more specific I'm looking for a crypt function. BTW How do I implement

Re: [GENERAL] Web-based PSQL?

to get you started quickly with Metabase and well all the drivers and other package classes. Enjoy, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http

Re: [GENERAL] RE: postgresql and web transactions

. For instance if you want to hold on a ticket reservation for a client before he decides to purchase it, you should not use transactions to lock the reservation. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail

  1   2   >