retype IN (1040, 4001);
Sincerely,
Niklas Johansson
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ent DateStyle setting, so I had to change the input
format. I also added the 'AT TIME ZONE' statement, since my server's
in another time zone.)
Sincerely,
Niklas Johansson
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ay to get to know both your OS and
Postgres better.
Sincerely,
Niklas Johansson
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
deleting, you'd
have to call a function raising the error in the rule. A minor
drawback is that the table still isn't safe from TRUNCATE though.
Sincerely,
Niklas Johansson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
s on how
this
could be accomplished?
How about:
update set = null where = '';
You can also do the update and the column data type change in one
fell swoop like so:
ALTER TABLE table_name ALTER COLUMN column_name
SET DATA TYPE DATE USING NULLIF(column_name, '&#
info, see the docs: http://www.postgresql.org/docs/8.3/
interactive/ddl-constraints.html#DDL-CONSTRAINTS-FK
Sincerely,
Niklas Johansson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
ts, albeit somewhere else?
Sincerely,
Niklas Johansson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ts, albeit somewhere else?
Sincerely,
Niklas Johansson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d definately live in /usr/bin on a normal
Mac OS X install. What versions of Mac OS X and the developer tools
do you have? Did you make some non-standard choice during the
installation of the dev tools?
Sincerely,
Niklas Johansson
--
Sent via pgsql-general mailing list (pgsql-genera
placeholder for not knowing, isn't it?)
Sincerely,
Niklas Johansson
Phone: +46-322-108 18
Mobile: +46-708-55 86 90
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nom
client_id, this time through a function that can only return one
client_id.)
To conclude: one master schema, one mirrored customer schema that
adapts to the db role, one additional table in the master schema to
handle the rights.
Sincerely,
Niklas Johansson
Phone: +46-322-1
ble structure be
implemented in MS SQL or Oracle?
As far as I know, yes. (Quite some time since I last had anything to
do with either of those. Not that I lament the fact... :-)
Sincerely,
Niklas Johansson
Phone: +46-322-108 18
Mobile: +46-708-55 86 90
---(en
d vary, depending on the floating point
implementation of your system. This is what my implementation does.
Sincerely,
Niklas Johansson
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
new plan to be prepared.
http://www.postgresql.org/docs/8.1/interactive/plpgsql-
statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
Sincerely,
Niklas Johansson
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Is there anything else you need from the query as well?
Mvh,
Niklas Johansson
Tel: 0322-108 18
Mobil: 0708-55 86 90
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if yo
retype IN (1040, 4001);
Mvh,
Niklas Johansson
Tel: 0322-108 18
Mobil: 0708-55 86 90
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
her daemon users. /dev/null should be ok
though.
Sincerely,
Niklas Johansson
Phone: +46-322-108 18
Mobile: +46-708-55 86 90
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
17 matches
Mail list logo
