is.
Using PostgreSQL 8.2.7 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2
20061115 (prerelease) (Debian 4.1.1-21)
Should I install some contribs to 8.2 or is it better to upgrade server ?
Where to find step by step instructions making this work ?
Andrus.
'%red%' then 1 else 0 end
+case when productname ilike '%cat%' then 1.7 else 0 end
+case when productdescription ilike '%cat%' then 0.7 else 0 end
from products
order by 1 desc
limit 100
This allows to define relevance.
Is my solution reasonable ?
Andrus
--
Peter,
You probably want et_EE. (Language and country codes are not always
consistent.)
I don't understand this.
Command line which I posted uses et_EE
What is the exact command line ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
How to create cluster with et_EE locale ?
Command below causes error.
Andrus.
mail:/var/lib/postgresql# pg_createcluster --locale=et_EE.UTF8 8.3 main
Creating new cluster (configuration: /etc/postgresql/8.3/main, data:
/var/lib/postgresql/8.3/main)...
initdb: invalid locale name "et_EE
HINT: You will need to rewrite or cast the expression.
** Error **
ERROR: column "id" is of type integer but expression is of type character
SQL state: 42804
Hint: You will need to rewrite or cast the expression.
How to fix ?
Andrus.
--
Sent via pgsql-general mailing
list instead of *
How to force PostgreSql to match columns by name, not by position so that
this command will work ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Sql to match columns by name.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
INTO t1 ( id, c1, c2, ..., cn )
SELECT DEFAULT, c1,c2, , cn
FROM t2;
in this case id column is populated automatically from sequence.
This is very ugly solution since requires dynamic script creation from pg
metadata instead of writing simple query.
Andrus.
--
Sent via pgsql-general mailing
column in table.
In this case drop column id drops last columns and insert should work.
Any idea how to force id to be last column in table ?
Is it possible to create updatable view where id is last column ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
nteger. Then run a before trigger for each row. That
> trigger will assign a value to the column based on the value given for
> the type.
Russell,
thank you.
I'm a new to Postgres.
Is there any sample how to write such trigger ?
Before inserting each row it should set document id from s
Reply from Bruno Wolff III, re-posted from mail:
> >>I have 120 concurrent users inserting documents. Mostly they are using
> >>10
> >>different document types. Each type should have separate numbering.
> >>They
> >>insert 30 documents per minute in peak hours.
> >
> >You really should think abou
d
document rows.
They are same for same document. Sequnece numbers are generated by document
header insertion trigger.
There is no primary key required in row table.
Andrus.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
oul I implement SCAN FOR ALL childs RECORDS in client or is it possible
to write this in stored procedure ?
4. What is the format of the two selects which select data from postgres
system tables ?
5. What are actual names for tables pg_referentialinfo and pg_tables used
?
Andrus.
-
sent email to them but havent got any responce.
I'm intrested about real ERP database dump for Postgres.
Any idea where to download such thing ?
Andrus.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
:char(1) as category, code from classifier_2 ;
I want to insert, update and delete using classifier view for max
compatibility with existing shema from other DBMC which contains real
classifier table.
Which is the best way to make view changeable ?
Is it possible to
It can be used in
comparisons.
In contract, NULL date means that date is not entered.
Andrus Moor
"Richard Huxton" wrote in message
news:[EMAIL PROTECTED]
> Szmutku Zoltán wrote:
>> Hi ,
>>
>> Thanks your previous help. I have a new question : how to store
>
( dokumnr INTEGER );
CREATE INDEX rid_dokumnr_idx ON rid (dokumnr);
Andrus
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
"Patrik Kudo" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi and thanks for your reply!
>
> Martijn van Oosterhout wrote:
>>>Now to the problem. We want to merge rows with id = 2 and id = 4 into id
>>>= 1 in the asdf table with the qwert table beeing updated to reflect the
>>>ch
ot;, database
"mydb", SSL off
How to enable connection from LAN ?
Andrus
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
should allow access from my application only. Is it possible to
use authentication method which allows access from my application only ?
Users connect to 5432 port from internet.
I'm using Postgres 8 in Windows from Windows ODBC clients.
Any idea how to implement this ?
Andrus.
able and primary key value which blocks
record deletion.
I looked to the ODBC log, but this does'nt contain more information
about error !?
Andrus.
---(end of broadcast)---
TIP 8: explain analyze is your friend
"Michael Fuhr" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Fri, Jul 01, 2005 at 01:56:41PM +0300, Andrus wrote:
>>
>> I want to restrict access to this table based on the user name, document
>> type and access level. I have 3 levels: no
I have the following column in all my tables which contains data of last
update of this row:
updated timestamp without time zone DEFAULT now() NOT NULL,
Hor to force Postgres to update this column automatically with now() value
every time when row is updated ?
I have about 100 tables and don'
I try to convert code from other database to Postgres.
CREATE TABLE test(test BOOLEAN);
SELECT MAX(test) FROM test;
causes error
ERROR: function max(boolean) does not exist
HINT: No function matches the given name and argument types. You may need
to add explicit type casts.
I tried
SELECT MA
I created Postgres 8 database in Windows XP using
CREATE DATABASE mydb ENCODING='UNICODE';
and upsized data to it.
The query
SELECT name FROM customer ORDER BY UPPER(name);
returns error
ERROR: invalid multibyte character for locale
HINT: The server's LC_CTYPE locale is probably incompati
characters.
The correct sort order (by using character code values) shoud be
B
C
C.
Õ
Ä
Ö
Ü
How to force the correct sort order or at least move accented characters
ÕÄÖÜ to end of sorted list ?
Andrus.
---(end of broadcast)---
TIP 3: Have you
uot;
accented charactes must be at the end of alphabet.
Why Postgres uses VERY stange sort order ? I do'nt believe that this order
exists in any locale.
Also, UPPER() function causes error
ERROR: invalid multibyte character for locale
HINT: The server's LC_CTYPE locale is probably i
a, meybe it is possible configure or modify odbc driver. I
looked into odbc drivers sources but havent found place which converts
chars>0x80 to question marks.
Any idea ?
When fixed unicode version (8.1?) will be available ?
Andrus.
---
so that NULL values are treated equal and second
insert is rejected ?
Andrus.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
I created a backup of Postgres database using pgAdmin II in Windows by
default options with
(*) COMPRESS
radio button checked.
How to unpack the created compressed file in windows manually ?
---(end of broadcast)---
TIP 4: Have you searched ou
How I should rethink this data design to be implemented in CREATE TABLE
statement ?
Andrus.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
#x27; to denote that they have access to all
> departments. Null, in this case, would mean you don't know which
> departments they have access to, and this is not really the case.
Using department ALL breaks the department_id reference to department table.
Inserting department_id
use null as unrestricted department
access.
Is it reasonable to create unique constraint using
CREATE UNIQUE INDEX user_id_permission_id_department_id_unique_idx
ON permission (user_id, permission_id, COALESCE(department_id,'ALL'))
Andrus.
---(end of br
ess to all
departments and add nw rows to permission table automatically.
It seems more reasonable to use NULL department value as "do'nt know, all
departments allowed"
Andrus.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I read the DELETE command docs but havent found any function.
Any idea ?
Andrus.
---(end of broadcast)---
TIP 3: Have you
Use 127.0.0.1 instead of localhost
In this case DNS is not used.
Andrus.
""Scott cox"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I am running PostgreSQL 8.0 on WinXP
> When I try to connect
>
> psql.exe" -h localhost -p 5432 t
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
>
> [EMAIL PROTECTED] wrote on 07/15/2005 02:49:09 PM:
>
>> On Fri, Jul 15, 2005 at 20:08:32 +0300,
>> Andrus <[EMAIL PROTECTED]> wrote:
>> >
>> > So I'll think still co
pp.
Michael,
thank you.
This is not working in my case. Uniquenes sis not sufficient: I need
referential integrity with uniqueness. If I add department, this must
be added into department table also and pollutes this table.
Andrus.
---(end
o have two types of users: one user ("super department
user") has access to all existing and all departments to be added in future.
Second type of user can have access to all currently existing departments
but NOT in new departments.
Using non-null departments both of those users have exactly the same records
in permission table.
So those users are not distinguished.
Using NULL as meaning of "don'nt know, allow access to all" distinguishes
both tohse users.
Andrus.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
this ? Can I use default
isolation level?
Andrus.
> At least, you can do a "select count(*) from ..." just before the delete,
> better if inside a transaction, if the query itself is not too much
> expensive
>
>>I ran DELETE command from my ODBC client application.
&
>> If I add ALL to department table, I must restrict all other tables of
>> having
>> ALL department. This is a big work and cannot be done nicely in Postgres.
>
> Not true. :) You simply need to add CHECK (departament_id <> 0) (assuming
> 0 is the ID of ALL departaments. You can even CREATE DOM
roup has only 5 messages in the whole this year. None of
them has got any replies.
I posted this question also pgsql.interfaces.odbc newgroup some days ago but
havent got
any reply.
pgsql.interfaces.odbc has lower traffic. 50% on messages get replies.
pgsql.general has much higher traffic. 80% o
t command. So I can execute
SELECT rowcount();
in Postgres.
I can retrieve the connection handle value but I donät know hot to get the
row count from it.
Any idea ?
Andrus.
"Greg Patnude" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> After an application
quired ?
It would be better to create unique constraint on
(user_id,permission_id,department_id) instead on explicity creating index.
Andrus.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
beginning of porting huge application to Postgres in Windows.
There are number of other problems which seems to be more critical.
So I think I will not try to struggle to implement referential integrity of
those tables in Postgres.
Or will I post referential integrity implementation problem with
of deleted rows in pg/SQL ?
How to create stored procedure which wraps delete command and returns number
of deleted rows as table column?
So I instead of delete I can use
SELECT delete_return_deleted_rows('DELETE FROM mytable WHERE mycondition');
Andrus.
Is it possible to use psql-odbc usenet news via news server ?
Are there also messages missing from pgsql.general newsgroup from
news.postgresql.org ?
How I can read and reply to all messages without receiving them all to my
e-mail mailbox ?
Andrus.
---(end of broadcast)
I have Postgres 8 running on Windows XP
The size of data subdirectory is 326 MB
Today morning suddenly one table in one database, firma1.klient is
corrupted. When trying to backup it using pgAdmin III I get the log below
and backup is not created.
I have:
1. Compressed backup of the whole dat
problem and dump all the data either side of it. However, if your backup
> is good, then I'd just restore that.
I have up-to date backup of firma1 schema only. Whole backup is a bit old.
Is it possible to dump the corrupted table, truncate it and re-load it? I
thin
It seems that corrupted table klient contains data from some other table.
select * from firma1.klient limit 3686;
Seems to return all data from table.
Starting at row 3687 table contains data from other table.
VACUUM command returns:
INFO: vacuuming "firma1.klient"
ERROR: invalid page heade
klient table has oid 66079
file 66079 size is 13 MB
in correct copy klient table file size is 5MB
it seems that other table, nomenkla oid=65783 is added to the end of
klient table.
How to repair file 66079 so that it contains only 3686 rows from beginning ?
---(end
of "show wal_sync_method"?
"open_datasync"
> Finally, go into device manager, find your disk, get properties, look
> under Policies, is the box for "Enable write caching on the disk"
> checked?
It is checked.
Does Postgres require this to be unchec
>> "open_datasync"
>
> This setting is only safe if you disable write cache.
Thanks you for explanation.
I expected that default installation does not cause data loss in any
maschine configuration.
I don't remember was write cache enabling Windows default setting or
is in event log:
Event Type: Error
Event Source: PostgreSQL
Event Category: None
Event ID: 0
Date: 21.07.2005
Time: 10:22:32
User: N/A
Computer: ANDRUS
Description:
LOG: invalid primary checkpoint record
Event Type: Error
Event Source: PostgreSQL
Event Category: None
Event ID: 0
Date
For table replication, I need to know the date and time when particular
table is last changed by insert, update or delete command.
This information is required for most tables in database (about 100 tables).
How to obtain this information without creating 100 triggers ?
Andrus
want that transaction commit fails if invoice header is inserted without
any row in invoice rows table.
How to prevent inserting invoice headers without rows ?
Andrus.
---(end of broadcast)---
TIP 5: don't forget to increase your free spac
ICT;
Unfortunately, this does not work since TG_SCHEMA is not valid in PL/pgSQL
How to determine schema name where table TG_RELNAME belongs in trigger
function ?
Andrus.
table structure is:
CREATE TABLE serverti (
schemaname CHARACTER(7),
tablename CHARACTER(8) ,
lastchange time
turns only first line.
How to retrieve DETAIL line (key name and value) which violates referential
integrity from Postgres after receiving this error ?
Andrus.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
I want to disable dupplicate customer names in a database regardless to
case.
I tried
CREATE TABLE customer ( id SERIAL, name CHARACTER(70));
ALTER TABLE customer
ADD constraint customer_name_unique UNIQUE (UPPER(name));
but this is not allowed in Postgres
Any idea ?
Andrus
> You could use upper() similarly - lower() is better for Unicode data, like
> mine.
John,
thank you. Excellent.
I have database encoding UNICODE. Why lower() is better than upper()?
Andrus.
---(end of broadcast)---
TIP 9: In versions
rows)?
pgAdmin allows to edit data in table form but I havent found any such
possibility in SQL Manager.
Andrus.
---(end of broadcast)---
TIP 6: explain analyze is your friend
unning Windows 98 .
So I must switch to a Firebird, am I right ?
Andrus.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
s to run in Windows 98, displays that it is compiled with
unicode support.
Where to find binary version of pgAdmin for Windows 98 ?
2. I use unicode encoding in databases. Are you sure that pgAdmin allows to
display accented charaters in Win 98 ?
Andrus.
--
correctly
even in XP.
Another open source project, EMULE, has excellent unicode support in Windows
98. It requires to load unicode support package from Microsoft for Windows
98.
Why this cannot be impemented in pgAdmin ?
Andrus.
---(end of broadcast)---
TIP 6: explain analyze is your friend
"Douglas McNaught" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Andrus" <[EMAIL PROTECTED]> writes:
>
>> Apache runs well in Windows 98. Why this is so difficult in native
>> Windows
>> Postgres?
>
> I *think* it
"Robert Treat" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Friday 07 October 2005 04:22, Andrus wrote:
>> > PostgreSQL does not run in Windows 98
>> > You can run PostgreSQL on Cygwin on Win98, I think.
>> > But ifyou're r
I have a database of e-mail addresses.
I want to select the email addresses which are not valid:
do not contain exactly one @ character,
contain ; > < " ' , characters or spaces etc.
What is the WHERE clause for this ?
Andrus.
---(
""Guy Rouillier"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Andrus wrote:
>> I have a database of e-mail addresses.
>>
>> I want to select the email addresses which are not valid:
>>
>> do not contain exactly one @
ession in night.
How to write a WHERE clause which selects e-mail addresses which
are surely wrong ?
Andrus.
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
&g
klmnortvyz]|t[cdfghjkmnoprtvwz]|u[agkmsyz]|v[aceginu]|w[fs]|y[etu]|z[amw]|edu|com|net|org|gov|mil|info|biz|coop|museum|aero|name|pro)$/'
but got an error
ERROR: invalid regular expression: invalid character range
I'm using
"PostgreSQL 8.0.2 on i686-pc-mingw32, compiled by
!
Why postgres uses Error category for NOTICES ? Is'nt it reasonable to
use Information type ?
Andrus.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
efgilopruz]|om|p[aefghklmnrtwy]|qa|r[eouw]|s[abcdeghijklmnortvyz]|t[cdfghjkmnoprtvwz]|u[agkmsyz]|v[aceginu]|w[fs]|y[etu]|z[amw]|edu|com|net|org|gov|mil|info|biz|coop|museum|aero|name|pro|mobi|arpa)$
$$
but this classifies e-mail address [EMAIL PROTECTED] as invalid (select
returns it). The same resu
http://www.paulmcnett.com/articles.php
has a white paper
White
Paper: Running Visual FoxPro on Linux Using Wine (October 2003)
which describes using ODBC drivers from Linux.
Andrus.
<[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]...I know that there ar
Is it possible to create zero config installation by using connecton string
and simply including odbc dll files (odbc32.dll, odbcint.dll, odbccp32.dll )
with application ?
This is a lot simpler for end user, no manual config required.
"William Yu" <[EMAIL PROTECTED]> wrote in message
news:[EM
emory structures to log.
Can you apply a patch which disables
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index messages at
all or at least for temporary tables, please ?
Andrus.
---(end of broadcast)---
TIP 3: Have you checke
I'm afraid that using VARCHAR instead on CHAR may cause some parts of my
application to stop working. So I used TRIM function.
This regex allows email addresses containing two dots without any letters,
like [EMAIL PROTECTED]
I havent seen any email of such kind.
Andrus.
create temp table cu
tentID=2
but this needs to be converted to Postgres. It causes the famuous ERROR:
invalid regular expression: invalid character range.
Since text editor find/replace cannot be used to convert it it is probably
not reasonable to waste time trying to make the following code to work in
Postgres.
Andr
only some Windows environment variables to pg_dump, maybe some
critical is missing.
Any idea how to make Alt key to work in my application immediately after
calling pg_dump ?
Andrus.
---(end of broadcast)---
TIP 4: Have you searched our lis
g_dump
> specific. It'd be interesting to know both about flags above, and also
> what happens if you just call a bat-file that does nothing and then
> exits.
Specifiing empty .bat file directly as CreateProcess() command line causes
Createprocess to return error.
I tried to run chcp.com (rand
Can you use Postgres savepoints from VFP ?
sqlexec('ROLLBACK TO mysavepoint') and even sqlexec('ROLLBACK') cause C5
error.
Andrus.
"William Yu" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Here's what I do. Once I get a go
sing PostgreSQL 8.0.2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)
Why the corruption occurs ? How to avoid data corruption?
Will NTFS file system prevent all corruptions ? If yes, how to convert FAT32
to NTFS without losing data in drive ?
Andrus.
two logical disks in single drive.
Is this prevents data corruption for Postgres, is there some utility which
can convert C: drive to NTFS ?
Can Partition Magic help ?
Andrus
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will
buy
SCSI drives nor upses for each desktop computer.
Can Firebird or SQLLite automatically recover from power failure?
Andrus.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ftware (Windows XP) works according to vendor
specifications.
If I turn power off by breaking power cord when Postgres server is busy, is
it possible that
after that SELECT * FROM anytable does not work ?
Andrus.
---(end of broadcast)---
TIP 3: Ha
s much data as possible.
Then I can import this data to empty correct database and discard all rows
which violate database rules.
Andrus.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
I:\051027 DEMO
backup.backup" -F c -h andrus -U postgres mydb
exit
Alt+F does not work.
So it seems that pg_dump.exe code causes Alt+F not working.
Andrus.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ig
els before buying is huge step forward for perventing
database corruption in desktop computers.
Andrus.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I have found that using SPT to send a simple rollback like
SQLEXEC('ROLLBACK')
causes C5 error in VFP.
"William Yu" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Andrus wrote:
>> Can you use Postgres savepoints from VFP ?
>>
>>
ie about write
> completion.
Magnus,
thank you.
Is it reasonable to turn IDE write caching OFF for speed if
wal_sync_method=fsync_writethrough ?
Andrus.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
; and 'fo'+CHR(255)
WHERE col1 BETWEEN 'foo' and 'foo'+CHR(255)
All those queries can use same index automatically in all locales. CHR(255)
is last character in any lc_collate sequence. CHR(255) is not used in col1
data.
How to get same func
SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY IMMEDIATE
) ;
CREATE TRIGGER foo_trig
BEFORE INSERT OR UPDATE OR DELETE ON foo
FOR EACH STATEMENT
EXECUTE PROCEDURE setlastchange();
insert into klient values (1);
-- Next line causes execution
BETWEEN comparison by concatenating character greater
than all other characters in locale. Since CHR(255) does not work this is
not possible.
So
CREATE INDEX i1 ON foo(col1);
cannot be used to optimize queries of type "get all rows where first n
charaters of col1 are known" in Postgr
re no rows to
update,
but BEFORE DELETE ROW trigger IS executed when there are no rows to delete!
Why is this behaviour inconsistent ?
Andrus.
---(end of broadcast)---
TIP 6: explain analyze is your friend
oo(col1);
Creates btree structure. In other dbm system btree structure can be used for
searches where only some first characters in index key are known.
So I see no reason to create second index using text_pattern_ops for this
purpose.
I'm searching a way to use Postgres re
oo where first two characters of bar are BC
4. Select records from foo where first three characters of bar are ABC
etc.
Can you write sample WHERE clause which can use existing primary key index
for those queries ?
Andrus.
---(end of broadcast)---
res 8.1 when I use non-C locale.
If I switch to C locale, they will not work.
My current database, Microsoft Visual Foxpro implements this functionality.
How to implement this functionality in Postgres if I switch to C locale ?
Andrus.
---(end of broadcast)--
key without duplicate index on bar column ?
Andrus.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
n you confirm that in this case Postgres 8.1 can use index created by
CREATE TABLE foo ( bar CHAR(10) PRIMARY KEY );
even on non-C locale ?
Andrus.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
>> > How to create primary key without duplicate index on bar column ?
>> >
>> > Andrus.
>> >
>> >
>>
>> you can't.
>> postgresql implements primary keys creating unique indexes and not
>> null constraints on the pk
e index
CREATE UNIQUE INDEX foo_bar ON foo(bar bpchar_pattern_ops);
in usual WHERE expressions just like regular index ?
I.e can
SELECT * FROM foo WHERE bar='123'
use index foo_bar ?
Andrus.
---(end of broadcast)---
TIP 6: explain analyze is your friend
301 - 400 of 586 matches
Mail list logo
